Minilogin working but no server to log in to...

[Minena]

I can login fine but there are no servers shown. Mysql is running and shows server as being "up". I run Minilogin, World then Boot5 then run eqgame thru eqw. I'm not real sure what all info you need as I am not getting an error message. I am running all on one machine, not trying to login from another (that comes later after I get this figured out)


Thank you for any assistance

Minena

"Lifes to short...party naked."

[Mauritius]

hello all, i'll try to help you :P

probably your loginserver.ini is messed up :oops:
:idea: can you post here the the .ini and .bat files,
erasing username and pw :wink:

[Minena]

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=Lanfear
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[Database]
host=localhost
user=xxxxx
password=xxxxx
database=eq
compression=off

bootzone:

start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1
exit
cls

[Minena]

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=Lanfear
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[Database]
host=localhost
user=xxxxx
password=xxxxx
database=eq
compression=off

bootzone:

start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1
exit
cls

[Minena]

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=Lanfear
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[Database]
host=localhost
user=xxxxx
password=xxxxx
database=eq
compression=off

bootzone:

start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1
exit
cls

[IAKrash]

just to ask, are you running EQemu AND EQ on the same box? I assume you are, and have you set the eqhost.txt file correctly in your EQ directory? If all else fails, post the contents of ALL dos windows (especially minilogin and world)...

[Minena]

First i appologize for the multiple posts. I get an errror when replying so try again.

ok here's what I am getting on Minilogin after I log in and see no servers:

Loginserver.ini read.
MiniloginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
136328 New client from ip: 127.0.0.1 port:1166

I am at server select but no servers are listed.

another fix not working:

C:\eqemu>world.exe flag minena 200
Failed to connect to database: Error: #1045: Access denied for user: 'YourMysqlU
sername@127.0.0.1' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Account being GM Flagged:minena, Level: 200
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
database.SetGMFlag failed.

this may be why I can't post what world.exe says since it denies me access =/ and i don't seem to be able to get any permissions set without access.

Thank you for the assistance

[Bybydj]

have u edit the file db.ini, looks like the problem ?

db.ini
[Database]
host=localhost
user=YourMySQLLogin
password=YourMySQLPass
database=eq
compression=off

[Mauritius]

yup, the problem should be in your db.ini.

[Minena]

db.ini looks like this now and still no "server" to choose from after I login:

[Database]
host=localhost
user=xxxxx
password=xxxxx
database=eq
compression=off

[Minena]

Ok..can get to server select and actually see a server now, but its locked. Getting the following error in world.exe

Using database 'eq' at 127.0.0.1
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Loading Variables, zone names & items...
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1054: Unknown column 'ts' in 'where clause'

EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
minstatus, rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title,
rank4, rank4title, rank5, rank5title from guilds' #1054: Unknown column 'minstat
us' in 'field list'
done.
Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version
is 0; EQTime version is 1000 - failed.
Deleted -1 stale player corpses from database.
Deleted -1 stale player backups from database.
Warning: Pants may change during online play.
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1054: Unknown column 'ts' i
n 'where clause''

If the database is bad or the wrong one can you please link to where I may obtain a good/correct version please, along with the name of the database.

I appreciate all the assistance.

Minena

"Life is too short.....party naked."

[tcsmyworld]

Easy to set up, just source the DB , add accts and play.

http://forums.eqemu.net/viewtopic.php?t=6717

DB and EXEs there , make sure you set up your loginserver.ini and db.ini, if you're running locally , make sure you add account info into the miniloginaccounts.ini too.
Hope this helps :)

[demen_03]

It would be nice if you would say how you figured out how to get server to show. This is the only post I could find with this problem :? I have checked and rechecked everything 6 times and cannot figure out the problem... would like to know what you did. My brain is completely frizzled right now :cry:

[tcsmyworld]

This looks like a combination of mis-matched EXEs/DLL , and an outdated DB.

[demen_03]

hmm I did GRANT ALL PRIVILEGES... blah blah blah
but forgot to do "world.exe adduser eqemu eqemu 200"
when I did do this I got:

Failed to connect to database: Error: #1045: Access denied for user: 'eqemu@127.0.0.1' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Account Attempting to be created:eqemu 200
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in CreateAccount query 'INSERT INTO account SET name='eqemu', password='eqemu', status=200, lsaccount_id=0;' #2006: MySQL server has gone away
database.CreateAccount failed.

any idea why I get access denied? I did the GRANT ALL PRIVILEGES and seemed to work fine until I tried adduser /shrug

[Trumpcard]

did you use eqemu@127.0.0.1 ? And are you sure you set the password right?

login in manually to mysql

mysql -u eqemu -P <password>

[Minena]

Ok, all fixed now. At first it was because I didn't have access to the world, and doing the "mysql -u root msql" command got me access. Then it was a bad database. Thank you for the links, they worked great. Now to work on letting others on my LAN login. They see the server but get 1017 when they hit playEQ. Thier account is active as I can login locally from my machine with thier user/pass. I'm thinking it's because I am behind a router with 192* series of IP, which I am reading here and there EQEmu doesn't care for.

Thanks for the help folks .. I am having fun with this.

Minena

"Life is too short...party naked"

[Minena]

flipping double posts

Minena

"Life is too short.....party naked."