Need Some Help please...

[Chicomalo]

Hi, I need some help in trying to figure out a problem that I have. Ok right now I have a server fully set and understand alot of from it since I been messing with it around alot for the pass month. Anyways, I have it set public on my own. I can log easy on my server using Minilogin and I get no problems at all. My friend on the other end by via internet can connect as well showing in Minilogin Window that he successfuly got notice by it.

Now the problem is this, once he try to log into the server fully I get the following error.

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Screwing up windows compiles...
TCP listening on: 67.175.68.37:9000
World server listening on: 67.175.68.37:9000
Connected to LoginServer: 67.175.68.37:5999
9641 New TCP connection: 67.175.68.37:4498
9641 New TCP connection: 67.175.68.37:4499
New zoneserver: #1 67.175.68.37:4499
New zoneserver: #2 67.175.68.37:4498
Zoneserver SetConnectInfo: 67.175.68.37:4498: 67.175.68.37:7998
Zoneserver SetConnectInfo: 67.175.68.37:4499: 67.175.68.37:7996
9719 New TCP connection: 67.175.68.37:4500
9719 New TCP connection: 67.175.68.37:4501
9719 New TCP connection: 67.175.68.37:4502
New zoneserver: #3 67.175.68.37:4502
New zoneserver: #4 67.175.68.37:4501
New zoneserver: #5 67.175.68.37:4500
Zoneserver SetConnectInfo: 67.175.68.37:4500: 67.175.68.37:7997
Zoneserver SetConnectInfo: 67.175.68.37:4501: 67.175.68.37:7995
Zoneserver SetConnectInfo: 67.175.68.37:4502: 67.175.68.37:7999
138750 New client from ip: 68.69.169.175 port: 4163
68.69.169.175: Wrong name/pass: name='arkilian'
Removing client from ip:68.69.169.175 port:4163
820829 New client from ip: 67.175.68.37 port: 4515
Logged in: Local: chicomalo
Received unknown opcode: 0x00f0 size:0 bytes
898750 New client from ip: 68.69.169.175 port: 4235
68.69.169.175: Wrong name/pass: name='arkilian'
Removing client from ip:68.69.169.175 port:4235
Client disconnected
Removing client from ip:67.175.68.37 port:4515

Please note that The IP Addresses in this were change for my own and his own protection.

Here is what Minilogin Looks like;

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
Matched 68.69.169.175 to 'Arkilian'
Matched 68.69.169.175 to 'Arkilian'
Matched 67.175.68.37 to 'Chicomalo'
Matched 68.69.169.175 to 'Arkilian'
Matched 68.69.169.175 to 'Arkilian'
Matched 67.175.68.37 to 'Chicomalo'

So, as you can see he is the only one that got an error about wrong name and password. I did a EQ Patch update yesterda which work find with me, he did as well today. So, what is the problem here? Not to sure, but I will provide my configuration to see if anyone here can help me with this problem.

Settings are as follow;

[LoginServer]
loginserver=67.175.68.37
loginport=5999
worldname=CelestialWorld
worldaddress=67.175.68.37
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

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

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

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

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line
# reported in error messages
68.69.169.175 Arkilian *******
67.175.68.37 Chicomalo *******

So there is my setup all done on Windows XP Pro, using SQL-3.23.58-Win also using EQEmu-0.5.3-DR3, and the lastest Minilogin.

I am not running a firewall during EQ, and I have no router installed. Hope this info helps determin what is that I have wrong.

I think I saw a post somewere around here about needing to add ports 4000+ for peoples who log into my server beside the ports for the zones which are 7000+ around there. Is that true?

Thanks In Advance! for any tip, advice, and help that ya can give me.

[wize_one]

have you set him up an account in the database?

[Timco]

http://www.eqemulator.net/forums/vie...bfc5bec403a8d0

This fixed my problem.

[Chicomalo]

I have try a few ways but not sure if i didn't doit right or what. Cause the thing is that he had play with me on my server and log in from Eqemulator.net but since I change everything now is kind of different i guess for him.

If you don't mind me asking, how should I set him up? Just to see if i haven't try a different way or a better way. I know I had kind of the same problem for my self before until i fix something in the account database but kind of forgot. =/ cause I had the same kind of error before until i figure it out. However silly me I didn't write down the notes like i normaly would.

Updated 2:16pm Pacific Time.

I notice something about this, could it be that I have interent sharing with my labtop on my system? Cause I have two modem and I have internet sharing on the main modem. now also i got a few errors trying a few things from there like this one here.

C:\eqemu>world adduser Arkilian ******* 175
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
Account Attempting to be created:Arkilian 175
Error in CreateAccount query 'INSERT INTO account SET name='Arkilian', password=
'*******', status=175, lsaccount_id=0;' #1062: Duplicate entry 'Arkilian' for ke
y 2
database.CreateAccount failed.

C:\eqemu>

Also try the other way around here;

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 127 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql>
mysql> INSERT INTO account SET name='Arkilian', password='*******', status=175;
ERROR 1062: Duplicate entry 'Arkilian' for key 2
mysql>

and final one i try doing it this way and this is what i got;

mysql> use eq;
Database changed
mysql> INSERT INTO account SET name='Arkilian', password='*******', status 175,l
saccount_id=0;
ERROR 1064: You have an error in your SQL syntax near '175,lsaccount_id=0' at li
ne 1
mysql>

Hmmm still trying to figure this out here.

[samandhi]

68.69.169.175: Wrong name/pass: name='arkilian'

You will have to find a way to enter the correct info into the database.

ERROR 1062: Duplicate entry 'Arkilian' for key 2

This is your problem. You need to get MySQLFront (becaue this is the easiest way plus you can see it graphically, for people like me this makes it easier hehe), and delete the problem fields, and try and re-enter it again. This same thing happened to me. In MySQLFront just go to the account table then click the data tab, right click on the field in question and click on drop or delete (cant remember which it says) field, and bam you have no Arkilian, and can re-do the command. Hope that helps some. Also, in your miniloginaccounts.ini make sure there is a space at the end of the passwords, but after you type the last pw, DONT hit return, that will put in another line and will cause errors.

[Scorpious2k]

Sounds like the account is already on the db. Try this:

use eq

update account set password=******,status=175 where name like 'arkilian';

[Chicomalo]

Oh ok thanks Scorpion. I try that command there and I got the following error.

ERROR 1054: Unknown column '*******' in 'field list'

Hmm what was that about? any idea?

[wize_one]

try downloading and useing something like http://www.mysql-front.com that way you can look right at the tables and add/edit/fix things..

[Chicomalo]

Cool thanks bro, I have that and I set up the account from there. From some strage reason it was not working during that time. However, do you know what button to press for update? Any how, I will continue ready on it and learning it to make my editing much more easier.

[Scorpious2k]

Originally Posted by Chicomalo

ERROR 1054: Unknown column '*******' in 'field list'

What I meant was for you to put the password (in quotes) where the ****** was. So if the password is fubar you would type:

use eq 

update account set password='fubar',status=175 where name like 'arkilian';

notice that fubar is between quotes (')

This is a method to change a record using mysql

[Chicomalo]

On ok, Cool thanks, I was not adding that, so it works now. Hehehe thanks man in a million. Going to see if this helps when next time I run the server again.