I would appreciate any assistance

Drunia · #1 02-18-2003, 03:20 AM

I am getting a 1017 error using Minilogin. Can use other severs just fine, any help would be appreciated. I think I got all the pertinent data, if I missed something I'd be happy to post it. Firewall isn't on. At the bottom is posted what happens when I do what the sticky suggests to make a 200 flagged account.

EQEmu Version 4.2

Windows XP Home version, regularly updated.

LoginServer.ini

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

[WorldServer]
Defaultstatus=
Unavailzone=

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

Boot5zones.bat

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

db.ini

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

MiniLoginAccounts.ini

yourlanip1 user1 password1
yourlanip2 user2 password2
yourlanip3 user3 password3
yourlanip4 user4 password4

MiniLogin.exe

LoginServer.ini read.
Error in MiniLoginConfig.ini on line #1: 'yourlanip1' isnt a recognizable ip or
hostname.
Error in MiniLoginConfig.ini on line #2: 'yourlanip2' isnt a recognizable ip or
hostname.
Error in MiniLoginConfig.ini on line #3: 'yourlanip3' isnt a recognizable ip or
hostname.
Error in MiniLoginConfig.ini on line #4: 'yourlanip4' isnt a recognizable ip or
hostname.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
New TCP connection: 127.0.0.1:3762
26641 New client from ip: 127.0.0.1 port: 3773
Client disconnected (eqnc->GetState()=102)
Removing client from ip: 127.0.0.1, port: 3773
31000 New client from ip: 127.0.0.1 port: 3777
Client disconnected (eqnc->GetState()=102)
Removing client from ip: 127.0.0.1, port: 3777

World.Exe

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day...Reading time file failed, bytes read: 0
failed.
Formatting drive C:
World server listening on: localhost:9000
Connected to LoginServer: localhost:5999
New TCP connection: 127.0.0.1:3768
New zoneserver: #1 127.0.0.1:3768
Zoneserver SetConnectInfo: 127.0.0.1:3768: localhost:7999
New TCP connection: 127.0.0.1:3769
New zoneserver: #2 127.0.0.1:3769
New TCP connection: 127.0.0.1:3770
Zoneserver SetConnectInfo: 127.0.0.1:3769: localhost:7995
New zoneserver: #3 127.0.0.1:3770
New TCP connection: 127.0.0.1:3771
New zoneserver: #4 127.0.0.1:3771
Zoneserver SetConnectInfo: 127.0.0.1:3770: localhost:7997
New TCP connection: 127.0.0.1:3772
New zoneserver: #5 127.0.0.1:3772
Zoneserver SetConnectInfo: 127.0.0.1:3771: localhost:7996
Zoneserver SetConnectInfo: 127.0.0.1:3772: localhost:7998
26047 New client from ip: 127.0.0.1 port: 3775
Error in CheckLogin query 'SELECT id FROM account WHERE name='eqemu' AND passwor
d='eqemu'' #1146: Table 'eq.account' doesn't exist
127.0.0.1: Wrong name/pass: name='eqemu'
Removing client from ip:127.0.0.1 port:3775

Boot5zones.bat

7995

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names, items, loottables & NPCs...
EMuShareMem.dll loaded.
...done.
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

7996

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names, items, loottables & NPCs...
EMuShareMem.dll loaded.
...done.
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

7997

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names, items, loottables & NPCs...
EMuShareMem.dll loaded.
...done.
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

7998

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names, items, loottables & NPCs...
EMuShareMem.dll loaded.
...done.
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

7999

Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Loading Variables, zone names, items, loottables & NPCs...
EMuShareMem.dll loaded.
Loading NPCTypes from database...
...done.
Loading Doors from database...
done.
If this is the last message you see, you forgot to move spells_en.txt from your
EQ dir to this dir.
Spells loaded.
Loading guild ranks...done.
Loading faction data...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode

Command run. Didn't look like it worked to well.

C:\EQemu>world adduser eqemu eqemu 200
Using database 'eq' at localhost
EQEMu 0.4.2 eRAMNotes Sucks!
Account Attempting to be created:eqemu eqemu 200
Error in CreateAccount query 'INSERT INTO account SET name='eqemu', password='eq
emu', status=200, lsaccount_id=0;' #1146: Table 'eq.account' doesn't exist
database.CreateAccount failed.

C:\EQemu>

So then I tried the other suggestion, and did it directly from the /bin file. Below is the result.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 140 to server version: 3.23.55-nt

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

mysql> use eq INSERT INTO account SET name='eqemu', password='eqemu', status=200
;
Database changed
mysql>

So it isn't working, is something wrong with any or all of the above? I really want to fool around on the emulator, I would thank anyone for any help they could give.

Trumpcard · #2 02-18-2003, 04:34 AM

There are more problems than I can shake a stick at..

1) yourlanid is meant to be replaced by the machines IP ADDRESS.

2) Error in CheckLogin query 'SELECT id FROM account WHERE name='eqemu' AND password='eqemu'' #1146: Table 'eq.account' doesn't exist

127.0.0.1: Wrong name/pass: name='eqemu'
Removing client from ip:127.0.0.1 port:3775

First, it doesnt even look like your database is there. Read the readme careful in the part about creating the mysql database, and make sure you follow the instructions carefully.

Drunia · #3 02-18-2003, 05:31 AM

I changed the YourlanIP to my IP address, though that was silly, heh. I deleted and redid the database carefully by the walkthrough, still didn't work, so I did it again, nada.

Create database eq;
use eq
source db.sql

those are the exact commands I use, and then I got the running lines of text and exited out. Was there something else I need to do for the database to work? I didn't see anything in the walkthrough.

deeque · #4 02-18-2003, 02:45 PM

yes you would need to goto worldbuilding section and find the stuff to populate it with such as the 4.1 addon ... just running dq.sql just makes the tables for you to source in all the rest of the junk

imasianman · #5 02-18-2003, 03:37 PM

Quote:

Originally Posted by Drunia

So then I tried the other suggestion, and did it directly from the /bin file. Below is the result.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 140 to server version: 3.23.55-nt

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

mysql> use eq INSERT INTO account SET name='eqemu', password='eqemu', status=200
;
Database changed
mysql>

i think it's supposed to be 2 separate lines like

use eq;
INSERT INTO account SET etc...

cuz the line that follows what you typed just says database changed... i think it's supposed to say something along the lines of 'rows affected blah blah blah' if you do it right