Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Gary Chernipeski on April 29, 2003, 07:36:17 PM

Title: Using MySQL for My Projects
Post by: Gary Chernipeski on April 29, 2003, 07:36:17 PM

I can add databases to the MySQL install, but when trying to connect to them, the server appears to automatically disconnect me almost immediately.

Bug or Feature?

Title: Re: Using MySQL for My Projects
Post by: Prezes on May 01, 2003, 02:05:39 AM

No-one seems to be replying to this thread, so I'll put forward my question (and as I'm new to lynux.....)

Are you sure you are actually connecting to the DB????
How are you connecting to it??? PHP??? or what???

Title: Re: Using MySQL for My Projects
Post by: Gary Chernipeski on May 01, 2003, 04:22:06 AM

The error you get is the same as a time-out, but its instantaneous, as if MySQL under e-smith is ignoring the time-out setting.  

I wonder if this is on purpose -- as in the e-smith team didn't want these things used as SQL servers?  (I found a thread somewhere to that effect).  If so, just post that fact to this thread so I can wipe e-smith off one of my servers (reluctantly) and get on with life...

Title: Re: Using MySQL for My Projects
Post by: Prezes on May 01, 2003, 04:24:56 AM

Well,

The only thin I can say is renstall (as I'm new to lynux).

I'm running 5.6 and don't have any problems with MySQL

Title: Re: Using MySQL for My Projects
Post by: Gary Chernipeski on May 01, 2003, 04:25:34 AM

Sorry didn't really answer your question, connecting to it from Windows box using the MySQL ODBC connector (the goal), but during testing also used the MySQL Control Center with the exact same connect error.

[SLIM on SCOTT09] ERROR 2013: Lost connection to MySQL server during query

Here is a "real" connect error.

[SLIM on SCOTT02] ERROR 2003: Can't connect to MySQL server on '10.0.0.202' (10061)

Title: Re: Using MySQL for My Projects
Post by: Prezes on May 01, 2003, 06:52:41 PM

You can check if your SQL server is actually running by trying to execute the script on the server it self. If that works, the it seems to me that you don't have the stting enable to allow remote connections