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?

[sdtuasrt, MD]

It seems to be so, yes.

Since the only part of the installation that went wrong was my inability to acquire the PERL mysql interface, due to the fact that the Guide provided is out of date, and since using updated versions of PERL and the mysql related interfaces do not work, I can only assume that the problem lies with PERL, or, more specifically, that it seems PERL is required for EQEmu to connect to a mysql database. There is no actual database problem, as my database works, and I am able to connect to it, and other programs are able to use it just fine.

[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

[Fridgecritter]

you have to run it with the user name in the query that you use to access your database. If it's root, then change it to root, etc..

[audioblivious]

Originally Posted by Fridgecritter

you have to run it with the user name in the query that you use to access your database. If it's root, then change it to root, etc..

thats what did