Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: funfrock on June 21, 2006, 08:33:43 PM

Title: Mysql
Post by: funfrock on June 21, 2006, 08:33:43 PM

how do i connect to mysql server from a remote host (mysqlfront) please sombody help me!!

Title: Mysql
Post by: Mjohnson on June 21, 2006, 08:39:22 PM

Hi Funfrock,

Take a look at this message thread:  http://forums.contribs.org/index.php?topic=30945.0

Title: already read it
Post by: funfrock on June 22, 2006, 04:12:31 AM

i already read it but i still cant conect from mysql front im getting error 2003 and i cant even conect from telnet to port 3306

please give me some direction

Title: Mysql
Post by: Mjohnson on June 22, 2006, 04:20:08 AM

Is your port 3306 being forwarded properly to the SME Server?

You need to solve the port issue first.  

How is your network layed out?  Router?

Are you trying to connect from inside the lan?  Outside the lan?

Did you open the ports on the SME server?  

Just some things to try.

Title: Mysql
Post by: funfrock on June 22, 2006, 04:30:59 AM

im using the sme on server only mode
do i need to open 3306port ?? how can i do that??
i can connect to all other ports from inside and outside my lan (110, 25, 22 ftp etc)
do i need to do someting especial for port 3306??
im lost please help me!!!

Title: Mysql
Post by: Mjohnson on June 22, 2006, 04:41:23 AM

Have you done this:  (From the post link listed above)

In a terminal window (command line) enter the following:

config setprop mysqld LocalNetworkingOnly no
signal-event post-upgrade
signal-event reboot
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot

If you have telnet, I assume you know how to SSH access your SME server.

Title: Mysql
Post by: funfrock on June 22, 2006, 04:43:34 AM

already done that!! and im still cant conect
any other suggestions???

please !!!!

Title: Mysql
Post by: Mjohnson on June 22, 2006, 04:46:36 AM

Can you ping the SME Server??

Title: Mysql
Post by: funfrock on June 22, 2006, 05:02:26 AM

now is working!!!
thank you very very much!! for your help !!!!!!!!!!