DSM-G600, DNS-3xx and NSA-220 Hack Forum

Unfortunately no one can be told what fun_plug is - you have to see it for yourself.

You are not logged in.

Announcement

#1 2012-05-28 04:28:39

joazito
Member
Registered: 2012-05-28
Posts: 6

Can't access mysql remotely

I installed mysql on my DNS-320 using slacker-a. I then executed these commands:

Code:

# cp /ffp/etc/examples/mysql/my-medium.cnf /ffp/etc/my.cnf
# mkdir -p /ffp/opt/srv/mysql 
# /ffp/bin/mysql_install_db
# sh /ffp/start/mysqld.sh start

# /ffp/bin/mysql_secure_installation
# chmod a+x /ffp/start/mysqld.sh

I can work locally with mysql, but can't access it remotely.  Doing "nmap -sS -p 3306 -Pn 192.168.1.79" on my laptop says that the port is closed. Also, I can't access it using mysql workbench.

The only reason I'm installing mysql is to have XBMC accessing the library remotely. Digging on the XBMC forums I found that the configuration "bind-address" is important so I added "bind-address = 192.168.1.79" to /ffp/etc/my.cnf, but that changed nothing.

I need help I searched for something I might have missed but I'm clueless at this point.

Offline

 

#2 2012-05-28 21:30:18

Mijzelf
Member / Developer
Registered: 2008-07-05
Posts: 709

Re: Can't access mysql remotely

You could run a

Code:

netstat -lpt

on the NAS to see where it's actually listening.

Offline

 

#3 2012-05-28 22:25:06

joazito
Member
Registered: 2012-05-28
Posts: 6

Re: Can't access mysql remotely

Mijzelf wrote:

You could run a

Code:

netstat -lpt

on the NAS to see where it's actually listening.

Thanks, here's the result:

Code:

root@dns-320:/ffp# netstat -lpt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:9091            0.0.0.0:*               LISTEN      9113/transmission-d
tcp        0      0 0.0.0.0:515             0.0.0.0:*               LISTEN      1568/lpd Waiting
tcp        0      0 0.0.0.0:139             0.0.0.0:*               LISTEN      1611/smbd
tcp        0      0 0.0.0.0:http            0.0.0.0:*               LISTEN      1790/lighttpd
tcp        0      0 localhost.localdomain:5555 0.0.0.0:*               LISTEN      1791/php-cgi
tcp        0      0 0.0.0.0:51413           0.0.0.0:*               LISTEN      9113/transmission-d
tcp        0      0 0.0.0.0:ftp             0.0.0.0:*               LISTEN      1626/pure-ftpd (SER
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      4063/sshd
tcp        0      0 0.0.0.0:telnet          0.0.0.0:*               LISTEN      4008/telnetd
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      1790/lighttpd
tcp        0      0 0.0.0.0:445             0.0.0.0:*               LISTEN      1611/smbd
netstat: /proc/net/tcp6: No such file or directory

So I guess something is missing, hm? Any ideas?

Offline

 

#4 2012-05-29 10:27:46

Mijzelf
Member / Developer
Registered: 2008-07-05
Posts: 709

Re: Can't access mysql remotely

This proves that mysql doesn't have a listening tcp socket at all. So I suppose the local connections go domain sockets, or something like that.

Any ideas?

No, apart from sifting the configuration files, not. Unfortunately I don't know anything from mysql.

Offline

 

Board footer

Powered by PunBB
© Copyright 2002–2010 PunBB