Dynaverse.net

Taldrenites => General Starfleet Command Forum => Topic started by: Homer on March 06, 2003, 09:28:38 am

Title: Problem with MySQL and new server kit
Post by: Homer on March 06, 2003, 09:28:38 am

Question for all the server admin gurus.. i'm hoping someone has encountered this before:

1) MySQL is setup and connected, ODBC DSN is created and the test connection is successful.

2) I run the server for the first time, it runs for a bit (I can even see it create the sqllog folder in the background) then completely shuts down. I know data has transfered, because I can do a select out of maphex table and get results. However, not all the tables are filled with data at this point

3) Every other time I try to run the server kit after that, it hangs, never starts up. If I switch it back to flat file it works fine.

I even tried running the flat file first, then doing a 'transfer' to SQL, but it does the exact same thing. Could it be a MySQL script problem? Has anyone had success with MySQL?

Thanks!  

Title: Re: Problem with MySQL and new server kit
Post by: MrCue on March 06, 2003, 09:48:08 am

there is a known bug with connection pooling, not reusing threads etc. I you send an e-mail to steveg@battleclinic.com i will give you the link to the Dynaverse Admins Group. Lots of people to help you there

Title: Re: Problem with MySQL and new server kit
Post by: Praxis on March 07, 2003, 01:44:27 am

It runs for a bit as it tries to turn on the server, but it doesn't fully get finished.  I know because thats what my problem was.  For MyOBCD...what version are you running?  Make sure ALL the options are UNCHECKED except Allow BIG Results...and make sure it is a system DSN, not a user DSN.  Even if the test connection is successful, the SQL server doesn't like those options and will mess up when you connect.

Also did you run the CreateTables.sql file?

Tell me if this stuff helps.

Title: Re: Problem with MySQL and new server kit
Post by: Homer on March 07, 2003, 11:49:02 am

I'm using the latest 'production' version of MyODBC (3.51?) but I do know for a fact that those options you mentioned are different than what I used.. I had allow big results unchecked, and a couple of others checked... i'll try changing that and see what happens

Fingers crossed...  

Title: Re: Problem with MySQL and new server kit
Post by: Homer on March 07, 2003, 07:25:35 pm

You are a bloody genius.... that did it

Thanks for the help!!!  

Title: Re: Problem with MySQL and new server kit
Post by: Praxis on March 08, 2003, 04:17:55 am

lol

np
Thank Castrin, if it wasn't for him i wouldn't have gotten it working myself...

 

Title: Problem with MySQL and new server kit
Post by: Homer on March 06, 2003, 09:28:38 am

Question for all the server admin gurus.. i'm hoping someone has encountered this before:

1) MySQL is setup and connected, ODBC DSN is created and the test connection is successful.

2) I run the server for the first time, it runs for a bit (I can even see it create the sqllog folder in the background) then completely shuts down. I know data has transfered, because I can do a select out of maphex table and get results. However, not all the tables are filled with data at this point

3) Every other time I try to run the server kit after that, it hangs, never starts up. If I switch it back to flat file it works fine.

I even tried running the flat file first, then doing a 'transfer' to SQL, but it does the exact same thing. Could it be a MySQL script problem? Has anyone had success with MySQL?

Thanks!  

Title: Re: Problem with MySQL and new server kit
Post by: MrCue on March 06, 2003, 09:48:08 am

there is a known bug with connection pooling, not reusing threads etc. I you send an e-mail to steveg@battleclinic.com i will give you the link to the Dynaverse Admins Group. Lots of people to help you there

Title: Re: Problem with MySQL and new server kit
Post by: Praxis on March 07, 2003, 01:44:27 am

It runs for a bit as it tries to turn on the server, but it doesn't fully get finished.  I know because thats what my problem was.  For MyOBCD...what version are you running?  Make sure ALL the options are UNCHECKED except Allow BIG Results...and make sure it is a system DSN, not a user DSN.  Even if the test connection is successful, the SQL server doesn't like those options and will mess up when you connect.

Also did you run the CreateTables.sql file?

Tell me if this stuff helps.

Title: Re: Problem with MySQL and new server kit
Post by: Homer on March 07, 2003, 11:49:02 am

I'm using the latest 'production' version of MyODBC (3.51?) but I do know for a fact that those options you mentioned are different than what I used.. I had allow big results unchecked, and a couple of others checked... i'll try changing that and see what happens

Fingers crossed...  

Title: Re: Problem with MySQL and new server kit
Post by: Homer on March 07, 2003, 07:25:35 pm

You are a bloody genius.... that did it

Thanks for the help!!!  

Title: Re: Problem with MySQL and new server kit
Post by: Praxis on March 08, 2003, 04:17:55 am

lol

np
Thank Castrin, if it wasn't for him i wouldn't have gotten it working myself...