NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Gonella
Dec 20, 2014Aspirant
Mysql user doesn't exist RN102
Hi,
This is my first post and I do so because I have an issue with MYSQL @ ReadyNAS 102.
At the begininig, I installed MYSQL with no problems, but after a reset of the NAS, I had to reinstall it again. Every thing seamed to be fine, but now MYSQL doesn't want to start. I have reinstalled from the frontend with the app of Poussin but even it seems that it's correctly installed, nevertheless it doesn't want to start and give me the 22002010000 error. I have googled it and have found journalctl could help me because I couldn't find the error log of MYSQL. Journalctl says "Dec 21 00:19:07 ReadyNAS mysql[2235]: Starting MySQL database server: mysqldinstall: invalid user `mysql'". I haven't found mysql user in /etc/passwd:
And here is where I think the problem starts, because I've got too :
Here mysql folder and mysql_upgrade_info belongs to root instead of mysql.
Is this correct? Do I have to do something more?
I have ReadyNas 102 v6.2.1
Thank you in advance,
Gonella.
This is my first post and I do so because I have an issue with MYSQL @ ReadyNAS 102.
At the begininig, I installed MYSQL with no problems, but after a reset of the NAS, I had to reinstall it again. Every thing seamed to be fine, but now MYSQL doesn't want to start. I have reinstalled from the frontend with the app of Poussin but even it seems that it's correctly installed, nevertheless it doesn't want to start and give me the 22002010000 error. I have googled it and have found journalctl could help me because I couldn't find the error log of MYSQL. Journalctl says "Dec 21 00:19:07 ReadyNAS mysql[2235]: Starting MySQL database server: mysqldinstall: invalid user `mysql'". I haven't found mysql user in /etc/passwd:
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/bin/sh
bin:x:2:2:bin:/bin:/bin/sh
sys:x:3:3:sys:/dev:/bin/sh
sync:x:4:99:sync:/bin:/bin/sync
games:x:5:60:games:/usr/games:/bin/sh
man:x:6:12:man:/var/cache/man:/bin/sh
lp:x:7:7:lp:/var/spool/lpd:/bin/sh
mail:x:8:8:mail:/var/mail:/bin/sh
news:x:9:9:news:/var/spool/news:/bin/sh
uucp:x:10:10:uucp:/var/spool/uucp:/bin/sh
proxy:x:13:13:proxy:/bin:/bin/sh
www-data:x:33:33:www-data:/var/www:/bin/sh
backup:x:34:34:backup:/var/backups:/bin/sh
list:x:38:38:Mailing List Manager:/var/list:/bin/sh
irc:x:39:39:ircd:/var/run/ircd:/bin/sh
gnats:x:41:41:Gnats Bug-Reporting System (admin):/var/lib/gnats:/bin/sh
media:x:71:99::/var/cache/forked-daapd:/bin/false
statd:x:79:99::/var/lib/nfs:/bin/false
libuuid:x:80:80::/var/lib/libuuid:/bin/sh
sshd:x:82:99::/var/run/sshd:/usr/sbin/nologin
messagebus:x:83:83::/var/run/dbus:/bin/false
avahi:x:84:84::/var/run/avahi-daemon:/bin/false
nut:x:85:85::/var/lib/nut:/bin/false
snmp:x:86:86::/var/lib/snmp:/bin/false
klog:x:89:89::/home/klog:/bin/false
syslog:x:91:91::/home/syslog:/bin/false
ReadyNAS:x:96:96::/var/lib/timemachine:/bin/false
ftp:x:97:97::/var/ftp:/bin/false
admin:x:98:98::/home/admin:/bin/false
guest:x:99:99:nobody:/nonexistent:/bin/false
nobody:x:99:99:nobody:/nonexistent:/bin/false
transmission:x:1000:100::/home/transmission:/bin/sh
And here is where I think the problem starts, because I've got too :
root@ReadyNAS:/var/lib/mysql# ls -l
total 61464
-rw-r--r-- 1 root root 0 Dec 3 23:50 debian-5.5.flag
-rw-rw---- 1 40 mysql 52428800 Dec 15 15:30 ibdata1
-rw-rw---- 1 40 mysql 5242880 Dec 15 15:30 ib_logfile0
-rw-rw---- 1 40 mysql 5242880 Dec 12 14:23 ib_logfile1
drwx------ 2 40 mysql 4096 Dec 12 17:06 MyMusic46
drwx------ 2 40 root 4096 Dec 3 23:51 mysql
-rw------- 1 root root 6 Dec 3 23:51 mysql_upgrade_info
drwx------ 2 40 mysql 4096 Dec 12 17:06 MyVideos78
drwx------ 2 40 mysql 4096 Dec 12 13:13 owncloud
drwx------ 2 40 mysql 4096 Dec 3 23:51 performance_schema
Here mysql folder and mysql_upgrade_info belongs to root instead of mysql.
Is this correct? Do I have to do something more?
I have ReadyNas 102 v6.2.1
Thank you in advance,
Gonella.
No RepliesBe the first to reply
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!