OK, banged my head against this long enough...

klinzhai · #1 04-22-2006, 02:00 AM

Followed the instructions for db setup (including the minilogin stuff) at:

http://www.eqemulator.net/wiki/wikka...kka=MySQLSetup

My eqemu_config.xml looks like this (copy/paste, so it's exact):

<?xml version="1.0">
<server>
<world>
<shortname>Korancia2</shortname>
<longname>Matt's Korancia Server</longname>


<address>wendy</address>



<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>eq</account>
<password>klinzhai</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>eq</username>
<password>klinzhai</password>
<db>eqemudata</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

My minilogin LoginServer.ini looks like:

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=Korancia2
worldaddress=192.168.1.101
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=minilogin
ServerPort=5999

Yet every time I try to start world.exe, it just pops up the error:

[Debug] [WORLD__LS_ERR] Could not connect to login server: TCPConnection::Connect(): connect() failed. Error: 10061

If anyone has any ideas, I can be reached on Yahoo messenger as solinear.

klinzhai · #2 04-22-2006, 02:50 AM

Just an FYI. When I connect to the minilogin server from a client, it says "904344 New client from ip: 127.0.0.1 port: 4884"

At least something is working...

klinzhai · #3 04-22-2006, 03:43 AM

Went and hunted down Cavedude's installer, seems to be working, only I'm not seeming to be able to login from my EQ client. I'm sure that it's something stupid (more PEBCAK) like I haven't added in the user/password for the client.

Edit: Yep, went into the db and inserted the record with a password (Yay for MysqlCC!!) and everything and *bam*! I got in. Now all I have to do is figure out how to get my server onto the server list

Kirgothi · #4 04-22-2006, 03:49 AM

I am having the same problem as you. Where are you stuck at? The "Logging into the server. Please wait..." screen? Or the server selection screen.

Cavedude told me that his installer takes care of adding a default user/passcode for you. I think it's mini/mini, but I am not positive.

Kir

klinzhai · #5 04-22-2006, 04:02 AM

I'm at the server screen.

His installer does not install default user/password into the account table (if you go get MysqlCC from the good MySQL folks, you can view the table and there's nothing in it). Just right-click on the account table, select "Open Table > Return all rows" and it will actually return you all the data in the table. If there isn't anything in there, right-click again in the open area where it appears that the data is and select "Insert record". Now you can go through and set all those wonderful settings that you'll need so that you can create new users. As soon as you click on the "name" field, it will autocreate a new master key (the "id" field for the table... never change this, it's only important for the db itself and it autoincrements) for the record.

Kirgothi · #6 04-22-2006, 04:24 AM

I am trying to use access to open the table, but I can't seem to find anything to open. What are you using to look at the database?

**cavedude** · #7 04-22-2006, 04:29 AM

Installer Pack 3.5 is out and should work for you.

klinzhai · #8 04-22-2006, 04:40 AM

You can find MysqlCC here:

http://downloads.mysql.com/archives....ysqlcc&v=0.9.2

It's a control center. If you load it on your db server (like probably most of us do), your settings should be:

Name: (doesn't matter, I just put down 'localhost')
Host Name: localhost
User Name: root (unless you want to use your EQ user)
Password: (your password

)

You can actually do all the database admin type stuff through this... it's a lot easier than trying to do it through the command line version. However, you can't run really large (20+MB) .sql files in it, you have to do those through the command line version (*sniff*). I create all my users in that, since it's easier to just insert record and give it a name, password, status, ip, etc...

P.S.: Cavedude. I used 3.5 it does work way better than everything else, but for some odd reason it did not create an entry into the account table for a user.

Kirgothi · #9 04-22-2006, 05:06 AM

Um ok, completely lost here. I have actually had a class on SQL and Oracle, but this all seems totally different than any of that. We were able to use Access to look at any of our databases.

I downloaded the control center. I entered the information you mentioned. How do I like do anything in here? How do you find the tables? They don't seem to be listed anywhere. When I try to connect to the database it just says:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

Kirgothi · #10 04-22-2006, 05:22 AM

Ok, now I am trying to add the account using the command line method. I am trying to follow the incredibly cryptic guide here:
http://www.eqemulator.net/wiki/wikka...MiniLoginSetup

I am trying to just open a command prompt and typing in the code:
INSERT INTO account(name, STATUS, minilogin_ip) VALUES('mini',250,'127.0.0.1');

In the first set of parenthensis, do I type in "name", "STATUS", "minilogin_ip" as it says in the guide? Or am I supposed to substitute some other value? What is 250 for? I thought it was for GM or admin level access. Where do you find that information?

It just replies by telling me that INSERT is not a recognized command.

klinzhai · #11 04-22-2006, 05:25 AM

It's not going to look like Access, you can probably use Access to edit your database and tables if you like. I'm just used to doing more db design type stuff, where having the database view is more easy for me to do stuff with.

It's possible that one of the problems that you're having is one of the problems that I was having... my password for the eq user (inside MySQL) was not set the same as what the 3.5 installer set it for by default (user: eq - password: eq). I changed that in the database and it worked fine.

That being said, the connection error could be that you're entering the wrong password for root. Or it's possible that you need the odbc driver (I always forget that I have it installed).

If you want to use Access, it's not that different and you should be able to view the data in the tables easier than with MySQLCC

Maus · #12 04-22-2006, 05:27 AM

No such luck, cavedude. :(

Kirgothi · #13 04-22-2006, 05:34 AM

Ok, now I am connected to the server in mysqlcc. I have an emusp3 and an eq database. They look pretty similar. Which one do I want to use to insert into the account table?

How does one do this insert?

klinzhai · #14 04-22-2006, 05:42 AM

Oh the beauties... they're possibly both the same thing, you probably just installed again, so it created another db. Check and see which one was created most recently (look at the tables and see which ones were created more recently) and that's probably the more recent of the two.

That being said, I tried out 'mini' and 'mini' and while they aren't in the db, they do still seem to work. Maybe this is a minilogin feature that I didn't know about.

Either way though, if you want anyone else to be able to connect to your game, you'll need to be able to add more users.

BTW, I've reinstalled about 3 times and I think that my problem is related to whatever is causing my one command session to eventually switch over to saying "0: sleeping". If I can figure out what's going on with that, I think it will start working (redownloaded 3.5 about a 1/2 hour ago and reinstalled and it just kind of keeps doing the same thing).

Kirgothi · #15 04-22-2006, 05:50 AM

ok, but how do you actually insert a record? I can open the table now and I see an "insert record" button, but when I click it, it just turns gray. Is there room on that wall for me to bang my head on it too? Together we can probably knock it down.