Fresh Install and minilogin_ip errors

[iggi]

This is a fresh install, I am using the most recent source files from PEQ as of Sunday morning. I have already tried dropping and re sourcing the database. I still get this error:

[Debug] [WORLD__CLIENT] New client from 68.61.14.238:2409
Account Attempting to be created:iggi10389 0
Error in CreateAccount query 'INSERT INTO account SET name='iggi10389', status=0
, lsaccount_id=76150;' #1364: Field 'minilogin_ip' doesn't have a default value
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'iggi10
389', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '76150'

I tried setting minilogin_ip to null or 0 and I had no success ether way.

[Aramid]

Are you trying to use minilogin? The login you show in your log is from the public server login? Do you have your Logintype set to public or minilogin? For Public Logins, minilogin can be blank, but for minilogin you have to manually enter the ip address from the cpu they are logging in from.

[Theeper]

Set the minilogin_ip field to your client's IP address.

[iggi]

I am not doing a minilogin, I copied my config from my old server (not really old it was still 0.70) into my new server and setup the databases and sourced the latest files from PEQ.

here is my config:

<?xml version="1.0">
<server>
<world>
<shortname>poh</shortname>
<longname>Portal of Hate</longname>

<!-- Only specify these two if you really think you need to. -->
<!--<address>Serving Machines IP</address>-->
<!--<localaddress>127.0.0.1</localaddress>-->

<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>
<locked/>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>********</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>*******</password>
<db>eq</db>
</database>
</server>

[trevius]

Is your database named "eq" this time? I suspect it is named either "peq" or "ax" depending on what setup you used. Unless you just named it "eq" since it is your old custom database or something. Other than that, it looks fine to me.

Other than that, it looks like you may have set it up for mini login in the past. I would recommend redownloading the emu code and installing it fresh. You can still try keeping your database and stuff in place, just replace the eqemu directory.

[iggi]

I have since then dropped the eq db and resourced it and renamed it peq and still getting the same thing. As for my old server, it was non-minilogin and worked, not sure what happened this time.

[Aramid]

[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'iggi10
389', duplicate name?

Try removing your existing LS Account info on your Account in your DB and see if it will go in after that.

[iggi]

Theres the thing, my accounts table is completely empty and set to null...

[iggi]

I just manually entered the mysql query and set minilogin_ip to 0 and now it works.

[Lupinedreams]

Sorry, I haven't used SQL before and I'm setting up a server for the first time, had the same problem as you Iggi. When you say you fixed it by running a mysql query, could you be more specific? I literally have no experience with SQL prior to this so any more information would be greatly appreciated.

[iggi]

For those new to mysql use this syntax:

alter table <table name> alter column <coulmn name> set default <default value>

cheers!