Topic: Problem with MySQL and new server kit (Read 2017 times)

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!

MrCue · « **Reply #1 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

Praxis · « **Reply #2 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.

Homer · « **Reply #3 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...

Homer · « **Reply #4 on:** March 07, 2003, 07:25:35 pm »

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

Thanks for the help!!!

Praxis · « **Reply #5 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...

Homer · « **Reply #6 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!

MrCue · « **Reply #7 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

Praxis · « **Reply #8 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.

Homer · « **Reply #9 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...

Homer · « **Reply #10 on:** March 07, 2003, 07:25:35 pm »

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

Thanks for the help!!!

Praxis · « **Reply #11 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...

News: