Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Mizou on October 28, 2003, 07:24:59 AM

Title: SQL Connection using EMS SQL Manager
Post by: Mizou on October 28, 2003, 07:24:59 AM

I am using sme 5.6 with xp clients installed with EMS SQL manager.

I don't have a problem accessing MYSQL via putty and I also use phpmyadmin without any probs.

I found the EMS SQL Manager to be a very useful tool for what I am working on, but I cannot get it to connect to my sme box / host.

I have used 'mydomain.com.au' , my server IP Address of '192.168.89.1' as well as 'localhost' to try to connect to mysql, but I keep getting a "can't connect to mysql server on 'localhost' 10061" message. I have used various user name of root, admin etc... with and without password and still no luck....

Is anyone else using this EMS SQL Manager and have you got an idea of what I am doing wrong...

Cheers

Mizou

Title: Re: SQL Connection using EMS SQL Manager
Post by: Jan Rozema on October 28, 2003, 09:59:20 PM

Did you check port 3306, is it open, some provider block 3306, the standard port which MySql is using to connect over a tcp/ip network.

Jan R/

Title: Re: SQL Connection using EMS SQL Manager
Post by: Kobus Bensch on October 29, 2003, 04:01:13 AM

I have a similar problem trying to use DBManager and ODBC.

Get the following errors
Lost connection to MySql Server during connection

and another error of

Loading Server fsl@10.10.10.2 (MySQL): Lost connection to MySQL server during query.

Help would be greatly appreciated.

Title: Re: SQL Connection using EMS SQL Manager
Post by: Boris on October 29, 2003, 06:11:39 AM

Two thinks to check:
1. make sure glibc and glibc-common updated to the latest available for RH7.3
2.Using phpmyadmin or command line create the database user with permissions to login from your workstation's IP. By default root allowed to connect only from server itself, hence phpmyadmin works.

Title: Re: SQL Connection using EMS SQL Manager
Post by: Hugo on November 05, 2003, 07:32:57 PM

My problem is identical to Mizou's. Only I use SQLyog as sql applic.
No problem connecting to the 5.5 box. The 5.6 installation is updated SR5 ...
Should I still check glibc and glibc-common?
TIA
Hugo

Title: Re: SQL Connection using EMS SQL Manager
Post by: Boris on November 06, 2003, 01:29:58 AM

glibc update for SME 5.6 solves network mySQL connections problems.