Newbie question for you pros - Page 2

Tharkun · #16 09-30-2009, 01:00 PM

the build you have of the server requires Perl5.8. Remove Perl5.10 and Re-install 5.8

The only way I have gotten Perl 5.10 to work is to compile my own binaries

Lladail · #17 09-30-2009, 06:08 PM

I unstilled all of perl 5.10 and installed perl 5.8.9 build 826 and still getting the same error =\

Sylaei · #18 10-01-2009, 12:39 AM

You are way past this but, for future knowledge or for searchers, when you get a dos window that just closes, you are getting an error in that window. In order for it not to close you need to open a cmd prompt and manually run each command until you find the one with the error.

That said it seems like you now have two problems, the first was the connection issue which had nothing to do with perl. The second is that you now have a perl issue. Make sure that the perl/bin folder is in the path statement. Your path statement may have gotten messed up with the uninstall/install of perl.

I also found this entry by cavedude http://www.eqemulator.net/forums/sho...14&postcount=1
Basically it says to run version 5.8.8 build 822 and reboot after installing it. I have had this (perl) issue before and I am not sure what I did to fix it, but I am running perl 5.8.8 build 822. Please read the entire post above as there are some links to files that might help.

Once the perl issue is fixed open a cmd prompt and change to your eq server folder and run

Code:

world.exe

wait for it to finish, then open another and run

Code:

eqlaunch.exe zone

This should give you an error you can see and we can proceed from there.

HTH

DDude11 · #19 10-06-2009, 04:20 PM

it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

pfyon · #20 10-06-2009, 06:48 PM

Quote:

Originally Posted by DDude11

it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

That means the credentials you used for the database are not correct.

Sylaei · #21 10-06-2009, 09:29 PM

Make sure you can log into your mysql database with the command from a dos prompt:

Code:

mysql -u eq -p

After you hit enter it will ask for a password. If this works make sure your eqemu_config.xml file has the same user 'eq' and password you used here. Also make sure your database name is set correctly.

Your eqemu_config.xml file should look like this, with the appropriate changes of course.

Code:

                <database>
                    <host>localhost</host>
                    <port>3306</port>
                    <username>eq</username>
                    <password>newpwd</password>
                    <db>peq</db>
                </database>

pfyon is correct your credentials are messed up.

DDude11 · #22 10-07-2009, 12:55 AM

its letting me login fine to mysql when i start command prompt then type mysql -u root -p then it asks for my PW and i enter it and it says welcome to mysql yada yada yada. what i found interesting is you are saying to type mysql -u eq -p and i am typeing mysql -u root -p and it is allowing me access. did i do something wrong?

Sylaei · #23 10-07-2009, 01:15 AM

Quote:

Originally Posted by DDude11

it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

I chose to use 'eq' because that is the account that you are trying to login into the mysql server with based on the error message. The line that says 'Access denied for user 'eq'@'localhost'. This means that your eqemu_config.xml file has eq as the user to log into the mysql database. Change the user to root and it should connect. Make sure the password is correct also.

It doesn't matter what the username is as long as it is setup in the database and the eqemu_config.xml file.

Code:

                         <database>
                           <host>localhost</host>
                           <port>3306</port>
 Change this line here ->  <username>eq</username>
                           <password>newpwd</password>
                           <db>peq</db>
                         </database>

DDude11 · #24 10-07-2009, 01:43 AM

well see thats whats strange about this. when the error message comes after trying world.exe it says in it access denied for user 'eq'@'localhost' but here is my entire eqemu_config.xml and you can see that my username is set as root not eq. (password is starred out but ive triple checked that its correct by logging into mysql with it.) o and scrutinize my config file as much as possible to see if i screwed up anywhere else.

<?xml version="1.0">
<server>
<world>
<shortname>LEGITEST NON LEGIT</shortname>
<longname>DT'S LEGITEST NON LEGIT SERVER</longname>






<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>*****</password>
<db>peq</db>
</database>
</server>

Theeper · #25 10-07-2009, 07:43 PM

Are you sure you have the config file in the correct place?

'eq' is the username used in the default config file.

DDude11 · #26 10-08-2009, 04:24 PM

where should my eqemu_config.xml file be? in the same folder that has the folders for quests maps the start.bat i created etc right??

Sylaei · #27 10-08-2009, 08:06 PM

Thats where it should be in the same folder with start.bat, world.exe, zone.exe and the others.

Can you post your entire eqemu_config.xml file? Don't know that that'll help but......

DDude11 · #28 10-08-2009, 08:50 PM

yea i posted my entire config file 2 or 3 posts up but i did a search of my drive and found another eqemu_config.xml but for some reason it was in my /installanywhere/documents folder insted of my eqemu server folder so i moved it in and moved the old one out just to try and here it is. (again starred out pw is my actual pw which ive verifyed in mysql.)

<?xml version="1.0">
<server>
<world>
<shortname>DTs</shortname>
<longname>DT's legitest nonlegit</longname>






<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>****</password>
<db>peq</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Sylaei · #29 10-10-2009, 12:47 AM

Sorry DDude11, I didn't realize the post above was there. Shoulda looked.

I don't see anything in the latest eqemu_config.xml that is wrong. I have these lines uncommented in mine but I don't think this has anything to do with your issue.

Code:

<!-- Only specify these two if you really think you need to.  (read: You don't) -->
        <!-- <address>192.168.1.100</address> -->
        <!-- <localaddress>127.0.0.1</localaddress> -->

You said that you found another copy of the eqemu_config.xml file on your drive, is it possible that you have multiple world.exe files and for some reason one is located in your path and windows is trying that one?

I am at at a loss, can we see some more of the log file around the error?

DDude11 · #30 10-10-2009, 02:02 AM

i truely appriciate all your help it was the weirdest thing i figured it out today and now everything works great and im the proud owner of a server haha all i had to do was take out the password in my eqemu_config file and try and run the start.bat and when i did that it would not let me connect but at least it recognized me as root and not eq so then i went back to the config file and put my password back in and it worked great lol. just a weird problem of trial and error i suppose lol but hey if you are well versed in running a server and the things you can do as a gm take a look at my latest sad thread haha
http://www.eqemulator.net/forums/showthread.php?t=29756
thanks again