Please help with private Loginserver on public IP

[The_Beast]

Assuming that BOTH your database and server are on that remote host, look at these edits in RED (both config files)
I am also going to assume you have the tbl login tables in your database and you've set a user/pass in the tblworldregistration table ?

/home/eqemu/server # cat eqemu_config.xml
<?xml version="1.0">
<server>
        <world>
                <shortname>AAA Test Server</shortname>
                <longname>AAA Test Server</longname>


                <loginserver1>
                        <legacy>1</legacy>
                        <host>login.eqemulator.net</host>
                        <port>5998</port>
                        <account></account>
                        <password></password>
                </loginserver1>


                <address>136.243.xxx.xxx</address>
                <!-- <localaddress>127.0.0.1</localaddress> (leave this commented out) -->
                
                <loginserver2>
                        <host>136.243.xxx.xxx</host>
                        <port>5998</port>
                        <account>Admin</account>
                        <password>Password</password>
                </loginserver2>



                <tcp ip="136.243.xxx.xxx" port="9001"/>
                <telnet ip="136.243.xxx.xxx" port="9000" enabled="true"/>

                <key>mykey</key>

                <http port="9080" enabled="true" mimefile="mime.types" />
        </world>

        <chatserver>
                <host>136.243.xxx.xxx</host>
                <port>7500</port>
        </chatserver>

        <mailserver>
                <host>136.243.xxx.xxx</host>
                <port>7500</port>
        </mailserver>

        <zones>
        <defaultstatus>0</defaultstatus>

        <ports low="7000" high="7400"/>
        </zones>

        <database>
           <host>127.0.0.1</host>
           <port>3306</port>
           <username>eqone_sys</username>
           <password>mydbpassword</password>
           <db>eqone</db>
        </database>

        <qsdatabase>
           <host>127.0.0.1</host>
           <port>3306</port>
           <username>eqone_sys</username>
           <password>mydbpassword</password>
           <db>eqone</db>
        </qsdatabase>

        <webinterface>
                <port>9081</port>
        </webinterface>

        <launcher>
        </launcher>

        <files>
        </files>
        <directories>
        </directories>
</server>

Login.ini

cat login.ini
[database]
host = 127.0.0.1
port = 3306
db = eqone
user = eqone_sys
password = mydbpassword
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 136.243.xxx.  (Leave the last set of numbers out, but keep the period)
auto_create_accounts = FALSE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[Thalix]

Thank you again. But still no progress. If I login, I see the following SQL's executed and not more:

[Login Server] New SoD client connection from 178.202.xx.xx:57446
[Login Server] Application packet received from client (size 14)
   0: 02 00 00 00 00 00 00 00 - 00 00 0B 00              | ............
[Login Server] Session ready received from client.
   0: 02 00 00 00 00 00 00 00 - 00 00 01 65 00 00 00 00  | ...........e....
  16: 00                                                 | .
[Login Server] Application packet received from client (size 36)
   0: 03 00 00 00 00 02 00 00 - 00 00 24 37 8D 72 75 DA  | ..........$7.ru.
  16: 04 C9 1F C1 42 BF 8E C4 - 90 4F 57 44 FA 1D 07 BE  | ....B....OWD....
  32: 04 C9                                              | ..
[Login Server] Login received from client.
170806 13:37:52   240 Query     SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName                                                                                     = 'Admin'
                  240 Query     UPDATE loginserver_server_accounts SET LastIPAddress = '178.202.xx.xx', LastLoginDate =                                                                                     now() where LoginServerID = 1
   0: 03 00 00 00 00 02 00 00 - 00 00 0D 9F 27 9B A5 D8  | ............'...
  16: 72 60 DB 33 91 26 CB F2 - E6 F1 E0 D0 2B DA BE 35  | r`.3.&......+..5
  32: 61 CE 95 CD EA 39 73 1A - 34 AD F4 55 79 A2 61 4F  | a....9s.4..Uy.aO
  48: 40 96 8C 8F 1B 47 66 E8 - CE 6C 60 87 0F 29 FD 9C  | @....Gf..l`..)..
  64: 23 F8 DB 86 31 7A 77 3A - 85 BB 60 87 0F 4A FD 9C  | #...1zw:..`..J..
  80: 23 F9 DB 86 31 7A 77 3A - 85 BB                    | #...1zw:..
[Login Server] Application packet received from client (size 12)
   0: 04 00 00 00 00 00 00 00 - 00 00                    | ..........
[Login Server] Server list request received from client.
   0: 04 00 00 00 00 00 00 00 - 00 00 65 01 00 00 00 00  | ..........e.....
  16: 00 00 00 00                                        | ....
[Login Server] Application packet received from client (size 12)
   0: 05 00 00 00 00 00 00 00 - 00 00                    | ..........
[Login Server] Client disconnected from the server, removing client.

So the server is never asked for the Server-List but the database connection clearly works.


Edit:
I found an old backup from 04.2016, replaced the binaries and the Server shows up. Because of incompatible databases, it stops after that. For me it looks like a code issue and I can't work it out (I'm not a coder).