Akka's server repack suddenly not working anymore

[BreakKickYou]

I'm talking about the one located on this page : http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer

[Akkadius]

I'll have to check into it here, there is some migration that I did with PEQ which is that database used in this.

I'm on vacation so it will be a bit before I can look into this

[BreakKickYou]

Oh, so you think the problem is not on my side ?
Well, anyway, thanks for your time, and enjoy your vacations

[Maze_EQ]

http://www.eqemulator.org/forums/sho...=40299&page=18


The installer is not correctly pulling the weekly from PEQ.

Akka will fix it whenever he's off vacation I bet.

But download this one: http://edit.peqtgc.com/weekly/peqbeta_2017-02-22-02:01.tar.gz

1. Copy data_tables_2017-02-22-02:01.sql, Peqbeta_2017-02-22-02:01.sql, player_tables_2017-02-22-02:01.sql to C:\Program Files\MariaDB 10.0\bin.

2. Rename data_tables_2017-02-22-02:01.sq to data_tables.sql, Rename Peqbeta_2017-02-22-02:01.sql to peqbeta.sql, rename player_tables_2017-02-22-02:01.sql to player_tables.sql.

3. run->cmd.exe

4. cd C:\Program Files\MariaDB 10.0\bin

5. mysql -u root -peqemu

6. DROP DATABASE peq;

7. CREATE DATABASE peq;

8. USE peq;

9. source peqbeta.sql

10. source player_tables.sql

11. source data_tables.sql

Should work now.

[BreakKickYou]

Thanks a lot for your help, and for your time.

So, now setting up a public server is working perfectly, no more errors or anything, but whenever i start the login server, i get a lot of errors, then this when i try to join ( i replaced my real ip with "thisismyip") :

[Login Server] Logging System Init.
[Login Server] Config System Init.
[Login Server] MySQL Database Init.
[Login Server] Encryption Initialize.
[Login Server] Encryption Loaded Successfully.
[Login Server] Server Manager Initialize.
[Login Server] ServerManager listening on port 5999
[Login Server] Client Manager Initialize.
[Login Server] ClientManager listening on Titanium stream.
[Login Server] ClientManager listening on SoD stream.
[Login Server] Server Started.
[Login Server] New world server connection from thisismyip:52883
[Login Server] New world server connection from thisismyip:52884
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] New world server connection from thisismyip:52906
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] New SoD client connection from thisismyip:56265
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 36)
[Login Server] Login received from client.
[Error] Mysql query failed: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'Admin'
[Error] Mysql query failed: INSERT INTO loginserver_server_accounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 'local_creation', NOW(), '127.0.0.1');
[Error] Error logging in, user Admin does not exist in the database.
[Login Server] New world server connection from thisismyip:52907
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] Client disconnected from the server, removing client.
[Login Server] New world server connection from thisismyip:52908
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'Thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0

[Maze_EQ]

If you read closely, that's saying the user Admin doesn't exist for your loginserver.

I assume you're trying to have a private loginserver as well as joining the public?

[BreakKickYou]

I don't know exactly what's happening, just trying to join a local login server ( that i made myself ), i followed the instructions on the Akka's server repack page, but it's not working like it used to do some days ago :\