perl problem

[audioblivious]

im have a time with this perl it doesnt have the dbd-mysql in the list and to top it off the server says perl isnt install what do i do?

[audioblivious]

ok i got the perl out the way now it wont connect to the db ... its there and in xml but server dont see it and port is open

[Derision]

Originally Posted by audioblivious

ok i got the perl out the way now it wont connect to the db ... its there and in xml but server dont see it and port is open

You need to post your eqemu_config.xml and the world & zone logs showing the error messages you are getting.

[sdtuasrt, MD]

I am having this exact same problem. I used to have a private EQEMU server some time ago, and now that I have a new computer, I attempted to reinstall EQEMU.

I have Perl Installed. However, EQEMU cannot connect to the Database. The only error message in the Log File is the following:
[02.29. - 23:02:06] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

world.exe dies after that.

[sdtuasrt, MD]

Apologies for double-post. This is exactly what world.exe outputs when run.

C:\>cd EQEmu-0.7.0-1102

C:\EQEmu-0.7.0-1102>world.exe
[Debug] Starting Log: logs/eqemu_debug_world_11816.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Error] Starting Log: logs/eqemu_error_world_11816.log
[Error] Failed to connect to database: Error: #1251: Client does not support aut
hentication protocol requested by server; consider upgrading MySQL client
[Debug] [WORLD__INIT_ERR] Cannot continue without a database connection.

C:\EQEmu-0.7.0-1102>

[sdtuasrt, MD]

Oops. Ignore above two posts. Upon further investigation, I have determined that the problem is due to the version of ActivePerl which is recommended by the guide no longer offering downloads of the required Perl files -- particularly DBD::mysql and DBI.

I would suggest that someone alter the guide to remove reference to an outdated, non-functional distribution.

[sdtuasrt, MD]

Downloaded C++ compiler and attempted to install the required modules with CPAN. No luck. They will not compile.

Can anyone suggest an alternative to ActiveState perl? Or can anyone offer the required perl parts precompiled for x86 Windows?

[audioblivious]

so its the perl causing this error?

[Derision]

Originally Posted by sdtuasrt, MD

I am having this exact same problem. I used to have a private EQEMU server some time ago, and now that I have a new computer, I attempted to reinstall EQEMU.

I have Perl Installed. However, EQEMU cannot connect to the Database. The only error message in the Log File is the following:
[02.29. - 23:02:06] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

world.exe dies after that.

For this problem I think you need to run the SQL command provided by Angelox in this thread:

http://www.eqemulator.net/forums/showthread.php?t=24233

I don't think it's anything to do with Perl.

[audioblivious]

tried that with all users including root says cant find any matching row in the user table

[Fridgecritter]

Ok, Here's the deal. I am running Mysql 5xx and the newest Perl distro with the GUI PPM on mine, and it works just fine. The mySQL component you need is called something different in the new GUI based PPM. It's called DBIx-MySQLSequence. The other two components (the IO stringy and the other) are still called the same thing. Once you make sure those three are installed, you are done with perl and it works.

The password fix in the post WORKS. You CAN use MySQL 5xx because I am using it now with no problems. Run that query and you should have no problems. If that doesn't work, then the problem is something else, or you are not running the query correctly. Hope that helps.

[audioblivious]

ok i have dbix mysql the problem im having now is sql when i try that command user not found

[audioblivious]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' an' at line 1

is what i get

[audioblivious]

when i use :


SET PASSWORD FOR 'eqemu'@'localhost' = OLD_PASSWORD('hire');
i get this :#1133 - Can't find any matching row in the user table


when i use :mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' and User='eqemu';

i get this :#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' an' at line 1
now what??

[kiirdiir]

Originally Posted by audioblivious

when i use :

SET PASSWORD FOR 'eqemu'@'localhost' = OLD_PASSWORD('hire');
i get this :#1133 - Can't find any matching row in the user table


when i use :mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' and User='eqemu';

i get this :#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' an' at line 1
now what??

Error #1133: No such user, eqemu, is about all I can see for that.

Error #1064: Syntax. Note the difference in single quotes surrounding user vs hire/localhost/eqemu. (` vs '. Use '.)