I got really far..really

[Tals]

Ok, well, maybe not that far, but considering my experience I am pretty sure I'm doing well.

So, I am not asking for "THE" answer to this, more like, a nudge in the right direction... Do I need to go smack my php.ini around a bit, or is it that my database was created wrong. Heres the proplem:

Step 4 i put in all the required information....

localhost
lotgadmin
xxxxxxxx
lotgd

...respectively

after selecting Test this connection, it pops me back to 1, if I click back on Database Information I get:

Testing the Database Connection
Trying to establish a connection with the database:
Yahoo, I was able to connect to the database server! This means that the database server address, database username, and database password you provided were probably accurate, and that your database server is running and accepting connections.

I'm now going to attempt to connect to the LoGD database you provided.
Rats! I was not able to connect to the database. This is probably because the username and password you provided doesn't have permission to connect to the database.

The exact error returned from the database server was:
No database selected

When i first saw that i figured i screwed up the database creation sooooo

...of to the command propmt i went and typed in mysql -u lotgdadmin -pxxxxxxxxx lotgd and to my suprise i got no errors. Well it was time to walk away for a bit. When I tried again, I thought I might downgrade from php5 to php4 due to the numerous problems in general people seem to be having with 5. But that didnt do it..

So Newest Version of LOTGD from this site
mysql-5.0.18-win32 from mysql.com
php-4.4.1-Win32 from php.net

I am sure its gonna end up being the php.ini, but i figured I would shout out here real quick, go have some coffee then begin beathing the php.ini with a 5 pounder.


Thanks
Gene

[XChrisX]

Step 4 i put in all the required information....

localhost
lotgadmin
xxxxxxxx
lotgd

...of to the command propmt i went and typed in mysql -u lotgdadmin -pxxxxxxxxx lotgd and to my suprise i got no errors.

Maybe, just maybe it's because of the two different database names you provided?

[Tals]

My typo here on the boards was with the user name not the data base isnt it?

[XChrisX]

oh, eh ... yes...

[Elessa]

hmmmm... i may be wrong, but perhaps the issue is with thy host.  i didn't think yahoo supported databases.

[Tals]

yahoo? no this is on a static ip through comcast on my local system

[Dannic]

I know it works fine with easyphp.  It more than likely has something to do with your current php.ini settings but that is a bit more than I am able to help with.

[Mindbender]

Is logd working with mysql 5?

did you upgrade your mysql installation or was it a clean new installation?
Is my assumption correct that you are using a linux system?
Can you please provide some more background information about your setup please?

[Tals]

This is a fresh install of mysql and php.
This is running on winxp pro sp2
I am using a non standard web server"Fastream Netfile Web server. It seems to function pretty well.


I've noticed that simple php's used to access mysql will only work with root and no other username can access mysql. I even cloned root to create the lotgdadmin account and that wont get into mysql either...

So, i thought i'd try getting lotgd to work using root.

Got the same error. I am definatly leaning towards php.ini I only changed one setting in it:

-uncommented out
;cgi.force_redirect = 1

-and changed it to
cgi.force_redirect = 0


Any hints as to what other changes need to be made or am I trying to bake a cake and asking if I need an oven?

Thanks

Gene

[Mindbender]

Is there a special reason why you are using the netstream webserver?
Not that ist's a bad software, I cust don't know it...

But I know that there are pretty good program compilations like easyphp which can be installed like..1..2.. on every windows box

I had my baaaad dfiifculties with mysql and the accessrights after upgrading from 3.2 to 4.1 .. but I guess thats a different mug of Ale..

[Zanzaras]

I decided back before Christmas to upgrade MySQL on my test server to version 5. I still haven't been able to get it to work, even after  removing the whole kit and kaboodle and starting from scratch. I've never had any troubles with previous installations using earlier versions MySQL, so I think there might be an issue with installing the game on MySQL 5... you may try dropping back to MySQL 4.1 or so and see if you have the same trouble.

Just my 2 cents worth. Good luck!

[Tals]

ok sounds like a good next step... gonna go get an earlier version of mysql..


stay tuned..

Gene

[Tals]

Well it was worth a shot.. exact same problem with 4.1. for what ever reason php can't connect properly to mysql. The root can get to mysql in simple php but any user i create cant get to it. Oddly, using root wont let logd connect though.

Any ideas as to what other changes need to be made in the php.ini?

[Zanzaras]

Forgive me for asking the obvious... but when you created your lotgdadmin user, did you assign them rights to the greendragon db? Since it's on your local computer, i'd go ahead and assign it full rights.

Just a shot. I've forgotten to do it before so... why not.

[Tals]

No worries, at this point obvious is relative.

select
insert
update
delete
create
drop
grant
references
index
alter
create_tmp_table
lock_table

all assisgned to the logtdadmin account
for database lotgd