Stuck - Installing MySQL database

[sf631]

I am trying to create a MySQL database on my DS212+ and am stuck at a pretty early point.

I have installed the appropriate packages (phpMyAdmin) and have activated Web Station and MySQL from within the Web Services icon. The phpMyAdmin icon shows up in my program icon drop down so I know that service is running, and when I go to System Information I can see that Web Services and phpMyAdmin are all enabled. When I click to open either Web Services or phpMyAdmin it launches a browser tab for 192.168.1.136/phpmyadmin/ but just hangs. same for Web Services which also doesn't access any sort of menu, just goes blank.

I've rebooted several times following the config change and no luck. I've also upgraded from 3.2 to 4.0 and the problem is unchanged.

My config is ethernet connected via 5 port switch between the NAS and the workstation so I don't think there should be any port forwarding to be done.

Any ideas? I'm stuck before even getting to the good stuff

[HarryPotter]

There is no menu for Web Station. You have to create a valid index.htm or index.php file into the web share. If this file is missing, you should be redirected to the DSM management login page.

Anyway, that doesnt solve the phpmyadmin problem.

It seems that the user apache is not running. You ould try to start it manualy on the command line (telnet/SSH) with the following command:

Code: Select all

/usr/syno/etc/rc.d/S97apache-user.sh start

[sf631]

Thanks for the suggestion. I've tried this (admittedly, I'm not familiar with telnet access to the device, so just following instructions) and get the following error msg:

Code: Select all

DiskStation login: XXXXX
Password:
login: can't chdir to home directory '/var/services/homes/admin'

...

BusyBox v1.16.1 (2012-06-06 04:34:01 CST) built-in shell (ash)
Enter 'help' for a list of built-in commands.

DiskStation> /usr/syno/etc/rc.d/S97apache-user.sh start
mv: can't create '/usr/syno/etc/php.ini.31741': Permission denied
rm: can't remove '/var/spool/php': Permission denied
chmod: /var/spool/php: Operation not permitted
chmod: /var/spool/php/apc: Operation not permitted
chown: /var/services/blog/: Operation not permitted
chown: /var/services/blog/: Operation not permitted
chmod: /var/services/blog/: Operation not permitted
cp: can't create '/usr/syno/apache/conf/httpd.conf': Permission denied
/usr/syno/etc/rc.d/S97apache-user.sh: line 240: can't create /usr/syno/apache/co
nf/httpd.conf: Permission denied
/usr/syno/etc/rc.d/S97apache-user.sh: line 240: can't create /usr/syno/apache/co
nf/httpd.conf: Permission denied
/usr/syno/etc/rc.d/S97apache-user.sh: line 240: can't create /usr/syno/apache/co
nf/extra/httpd-ssl.conf.31741: Permission denied
/usr/syno/etc/rc.d/S97apache-user.sh: line 240: can't create /usr/syno/apache/co
nf/extra/httpd-ssl.conf.31741: Permission denied
/usr/syno/etc/rc.d/S97apache-user.sh: line 240: can't create /usr/syno/apache/co
nf/httpd.conf: Permission denied
Start User Apache Server .....
(13)Permission denied: make_sock: could not bind to address [::]:80
(13)Permission denied: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
/usr/syno/etc/rc.d/S97apache-user.sh: user httpd could not be started
DiskStation>

Is the user Apache something that needs to be configured? If so, that does not exist in my users directory. I assume it's something included by default?

Thanks for any other ideas or suggestions - I'd REALLY like to move the MySQL database to NAS and away from my workstation

[HarryPotter]

You have to login as "root" (with same password as "admin") to get permissions to run the script.

[sf631]

Got it. I think my problem may have actually been that the firewall ports for 80, 8000, and 443 were not open, not sure why. I opened those and have gotten to the authentication screen that says

The server says 192.168.1.136:80 requires a username and password. The server says: phpMyAdmin localhost.

All combinations I can think of (Admin, Guest, root) fail. I've verified the password in Users control panel, no luck. Any suggestions on what credentials *should* work at this authentication step? Thanks for your continued help

[sf631]

Also (and I don't know if this is related) in the "Application Privileges" control, I only have choice of FTP, File Station, Network Backup, and WebDAV as applications to which I can assign privileges. Should phpMyAdmin be there?

[HarryPotter]

Also (and I don't know if this is related) in the "Application Privileges" control, I only have choice of FTP, File Station, Network Backup, and WebDAV as applications to which I can assign privileges. Should phpMyAdmin be there?

No.

[HarryPotter]

All combinations I can think of (Admin, Guest, root) fail. I've verified the password in Users control panel, no luck. Any suggestions on what credentials *should* work at this authentication step? Thanks for your continued help

Synology FAQ: How do I reset the password of MySQL database?
The user is "root"

[sf631]

Wow, root + blank was one combo I didn't try - worked like a treat.

Many thanks HarryPotter, that was a great help!