1711_account_restricted_aa.sql

[Dekt]

Hello, I seem to be stuck at a common problem however the fix that is on the forums is not working for me. I am trying to source 1711 and up into db 1751, I have managed to get everything in sourced in but this.

After deleting the first line of the file like this Huppy's guide explains and the forum; I am still getting this error
--------------------------------------------------
[Err] 1146 - Table 'peq.account' doesn't exist
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I just cant seem to get it working right, if anyone might have another solution or be able to point out to me what I may be doing wrong, it would be much appreceated!

Thanks!

[Dekt]

Ok! So, I did some more sniffing on my own. And should anyone come accrose this problem. Back track your steps to sourceing load_player.sql..
Make SURE you sourced it properly, I did not. and re sourceing it fixed the issue instantly!

[Dekt]

Ok, so I managed to resolve the last one. And now amd stuck on getting the world to boot. I beleive i have everything properly done, and am useing rev 1751. have minilogin set up, batch file and everything else set up from what I can find on the forums. This iwas what im getting when I launch the batch,
[05.02. - 22:39:23] Starting Log: logs/eqemu_debug_world_3924.log
[05.02. - 22:39:23] [WORLD__INIT] Loading server configuration..
[05.02. - 22:39:23] [WORLD__INIT_ERR] Loading server configuration failed.

This is my eqhost.txt
[LoginServer]
Host=localhost:5999

This is my minilogin set up
[LoginServer]
loginserver=localhost
loginport=5999
worldname=WARDS
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=StandAlone
ServerPort=5999

And here is my eqemu_config.xml

<?xml version="1.0">
<server>
<world>
<!-- Set the shortname to ONE word. The longname is what shows up on server list -->
<shortname>WARD</shortname>
<longname>♦W♦A♦R♦D♦▓In Development!</longname>

<!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION -->
<!-- <address>do.not.edit</address> -->
<!-- <localaddress>do.not.edit</localaddress> -->

<!-- Loginserver information. DO NOT EDIT -->
<loginserver>
<host>localhost</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. DO NOT EDIT -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>somelongrandomstring12345</key>

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

<!-- Chatserver (channels) information. DO NOT EDIT -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. DO NOT EDIT -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<!-- The defaultstatus is what status the new toons will have on your server -->
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW-->
<ports low="7000" high="7100"/>
</zones>

<!-- Set username to root and password is your MySQL password and db to peq -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password></password>
<db>peq</db>
</database>

<!-- Launcher Configuration DO NOT EDIT-->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. DO NOT EDIT -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. DO NOT EDIT -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>


-------
Im nor seeing anything painfully obvious that I am missing, Would love to let you guys comb over it to see what you might fight, Thanks again!

[Zothen]

First of all, I am using EQEmuLoginServer instead of MiniLogin, so I cant say if theres anything wrong with your ML config.

1. From the log I would assume that world.exe isnt able to find eqemu_config.xml. Are they really in the same directory on your server?.

2. Another thing that strikes me is that you didnt enter a login/password for your server. In the database there is a server registration table with login info. I needed to use that info in my config to make it work.

3. I dont know if the emulator works without a database password.

[Dekt]

I have actually gotten past this part not, but yeah, eqemu_config.xml is in the same dir as server. And as far as login/PW, I do have that set but removed it for posting purposes.

However the part im stuck on now, I actually upd it to rev 1887, extracted to eqemu folder (Server Folder) and now im getting it to start loading world but it hangs up on the connection part?

im getting WordlConnection connect: Connecting to the server 127.0.0.1
:9000 faild: TCPConnection:: Connect <>: Connect <> faild. Error 10061

[Dekt]

Ok! So looks like I solved that problem! lol, I was typeing an actual username iof an account in the XML file, when root was needed. So it appears the server is up and running, however I am not able to see it on the eqemu server select?

[Zothen]

That seems to be a common problem...

From my limited experience it could be...

1. client / port issue ( titanium -> 5998, sof+ -> 5999 )

2. Missing address/localaddress part in emu_config.xml

3. MiniLogin issue I have no idea about