6.1.5 and MySQL app

if you do systemctl start mysqlr6 ?

Hi SP

root@StudioReadyNAS:/lib/systemd/system# systemctl start mysqlr6
Failed to issue method call: Unit mysqlr6.service failed to load: No such file or directory. See system logs and 'systemctl status mysqlr6.service' for details.
root@StudioReadyNAS:/lib/systemd/system# systemctl status mysqlr6.service
mysqlr6.service
	  Loaded: error (Reason: No such file or directory)
	  Active: inactive (dead)

There is stuff in /var/lib/mysql :

root@StudioReadyNAS:/var/lib/mysql# ls -al
total 61444
drwx------ 1 mysql mysql      290 Jan  2 11:56 .
drwxr-xr-x 1 root  root       324 Jan  2 10:54 ..
drwx------ 1 mysql mysql      414 Nov 25 06:29 baika
-rw-r--r-- 1 root  root         0 Nov 24 21:02 debian-5.5.flag
drwx------ 1 mysql mysql    30120 Nov 25 00:26 glpi
-rw-rw---- 1 mysql mysql 52428800 Jan  2 11:56 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Jan  2 11:56 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Jan  2 11:56 ib_logfile1
drwx------ 1 mysql mysql       28 Dec  2 15:46 instaxmas
drwx------ 1 mysql root      2094 Nov 24 21:02 mysql
-rw------- 1 root  root         6 Nov 24 21:02 mysql_upgrade_info
drwx------ 1 mysql mysql     5926 Nov 24 23:58 orangehrm_mysql
drwx------ 1 mysql mysql      868 Nov 24 21:02 performance_schema
drwx------ 1 mysql mysql       96 Dec  2 18:27 Syslog
drwx------ 1 mysql root         0 Nov 24 21:02 test
drwx------ 1 mysql mysql       42 Dec  2 15:46 twitter_christmas

perhaps you can try to download it from http://apps.readynas.com and install it again

Ran journalctl while trying to start up mysql to see what I got. The IP of the machine has changed since the install of the app:

Jan 02 16:07:52 StudioReadyNAS mysqld_safe[13078]: Starting mysqld daemon with databases from /var/lib/mysql
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 [Note] Plugin 'FEDERATED' is disabled.
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: The InnoDB memory heap is disabled
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Compressed tables use zlib 1.2.7
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Using Linux native AIO
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Initializing buffer pool, size = 128.0M
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Completed initialization of buffer pool
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: highest supported file format is Barracuda.
Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52  InnoDB: Waiting for the background threads to start
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 InnoDB: 5.5.31 started; log sequence number 58284487
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note] Server hostname (bind-address): '192.168.0.... 3306
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note]   - '192.168.0.23' resolves to '192.168.0.23';
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note] Server socket created on IP: '192.168.0.23'.
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Can't start server: Bind on TCP/IP port: C...dress
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Do you already have another mysqld server ...306 ?
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Aborting
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 
Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53  InnoDB: Starting shutdown...
Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: 140102 16:07:54  InnoDB: Shutdown completed; log sequence number 58284487
Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: 140102 16:07:54 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: 
Jan 02 16:07:54 StudioReadyNAS mysqld_safe[13129]: mysqld from pid file /var/run/mysqld/mysqld.pid ended

It was on a reserved DHCP address but the DHCP server seems to have started giving the MAC address 192.168.0.30 instead of 192.168.0.23. I'm using both network interfaces in a bonded pair in adaptive load balancing mode.

I rebooted the DHCP server and renewed the DHCP lease and everything is back to normal - but why is the installation tied to the IP that was assigned at the time of installing the app?

One other question: MySQL doesn't seem to start automatically on a reboot - how do I get it to do that?

It should use 127.0.0.1 not the 192.x address

Did you install the MySQL addon or does it come with another addon ?

Happy New Year Super-Poussin,
Very nice new avatar! Liked the old one also. But, this one is telling. Are you a Piper?
Wondering?

NASNoob wrote:
Happy New Year Super-Poussin, Very nice new avatar! Liked the old one also. But, this one is telling. Are you a Piper? Wondering?

yep I'm playing "Biniou Kozh" which is Brittany's typical instrument (also playing low whistle)

Super_Poussin,
OUT-Freaking-Standing :D Please maintain your plan. I come from a Scottish background. and I cry every time I hear a rendition of "Amazing Grace" done on a cadre of bagpipes. The pipes seem to run in my blood. :oops:

Agree with you also when hearing the red hot chili pipers and also Scotland the brave or Loch Lomond or Carlos Nunez