mysql -u debian-sys-maint -p
In another terminal run the following to get password
cat /etc/mysql/debian.cnf
Jira password reset 7.4
https://confluence.atlassian.com/jirakb/accessing-jira-s-h2-embedded-database-776818136.html
Raspberry PI enable ssh without a monitor
I spent a dozens of minutes today to learn, how to enable ssh to Raspberry Pi without a monitor. SSH is disable by default after October 2016. Here is a one minute solution.
Attach the sd card to your computer and add an empty file SSH on the root of the sd card partition.
React – events.js:182 throw er; // Unhandled ‘error’ event
It means you are running another instance of dev server. Stop that and rerun this one.
How to assign a friendly url to facebook group
Click the ellipses (…) near button Share and then click Edit Group Settings. Scroll down to Web and Email address.
No need to have any likes or followers or days since created.
Ubuntu 16.04 – PhpStorm – configure xdebug with PHP 7.0
Today I spent a couple of hours to figure out that ONLY the following configuration works. It is not covered in any video/tutorial.
This is the settings that MUST be added to all the files:
[xDebug] zend_extension=/usr/lib/php/20160303/xdebug.so
xdebug.default_enable=1
xdebug.idekey=PHPSTORM
xdebug.remote_port=9000
xdebug.remote_enable=1
xdebug.remote_handler=dbgp
xdebug.remote_autostart = on
xdebug.remote_start = on
xdebug.profiler_enable=1
xdebug.profiler_output_dir=/dev/null
xdebug.remote_host=localhost
The files are :
/etc/php/7.0/apache2/php.ini
/etc/php/7.0/phpdbg/php.ini
/etc/php/7.0/cli/php.ini
MySql change part of the field or column
If you have a table with column that contains eg file names with extension and want to replace the extension of all those file names.
Eg we have a table named menu with column icon. The icon column contains image file names with extension .png eg dress.png , shoes.png and we want to replace only .png by .svg leaving the filename (without extension) intact. we can use the following command in SQL:
UPDATE menus SET icon = replace(icon, RIGHT(icon, 3), ‘svg’)
WHERE id > 0 AND icon <> ”;
Symfony set index page
Add the following to routing.yml
homepage:
pattern: /
defaults: { _controller: AppBundle:Controller:action }
symfony sessions not working on production
I fixed it by adding the following to config.yml
session:
cookie_domain: yourdomain.se
Web developement in 2016/17
The learning tree for web development. These tools, packages and techniques will be highly useful to any web developer in the future.
Yii 2 – Start built in server
To Start PHP builtin web server for advanced yii template:
./yii serve --docroot=frontend/web/
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
Run the mysql instance as:
/usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
Install node js – ubuntu
sudo apt-get --purge remove node sudo apt-get --purge remove nodejs sudo apt-get install nodejs sudo ln -s /usr/bin/nodejs /usr/bin/node
Change Widnows Password from Ubuntu in dual boot – chntpwd
Follow the following simple steps to change windows password from within ubunut.
1. Install chntpw
sudo apt-get install chntpw
2. Mount your windows partition (change sda3)
mkdir win7 sudo mount /dev/sda3 win7/
3. Apply chntpw to change password. Change directory to win7/Windows/System32/config.
List windows users
cd win7/Windows/System32/config sudo chntpw -l SAM
Change password
sudo chntpw -u alex SAM
From the options select (1) Clear password and then save file (y). Now restart system and boot to windows with blank password.