[DiscordArchive] Meat, after changing the realmlist table and data to try and have it reachable externally...I can't
[DiscordArchive] Meat, after changing the realmlist table and data to try and have it reachable externally...I can't
Original source
Meat, after changing the realmlist table and data to try and have it reachable externally...I can't even get it to connect via lan. I don't even understand what is happening, I set address and local to both LAN IP, didn't work, LAN IP and 127.0.0.1, didn't work. I cant seem to reach the authentication server anymore for some reason....are you not supposed to edit the realmlist table and just edit the data portion?
rektbyfaith
10-21-2023, 02:34 PM #1Archived author: Zeraphicus • Posted: 2023-10-21T14:34:42.928000+00:00
Original source
Meat, after changing the realmlist table and data to try and have it reachable externally...I can't even get it to connect via lan. I don't even understand what is happening, I set address and local to both LAN IP, didn't work, LAN IP and 127.0.0.1, didn't work. I cant seem to reach the authentication server anymore for some reason....are you not supposed to edit the realmlist table and just edit the data portion?
Original source
Before I changed those entries to external ip/dns I was able to connect via lan just fine. Now with address/local address set to LAN IP it is hanging on connecting (not even getting to the realmlist)
rektbyfaith
10-21-2023, 02:36 PM #2Archived author: Zeraphicus • Posted: 2023-10-21T14:36:07.395000+00:00
Original source
Before I changed those entries to external ip/dns I was able to connect via lan just fine. Now with address/local address set to LAN IP it is hanging on connecting (not even getting to the realmlist)
Original source
the easiest way? copy the sql files from their path in the module source (`modules/sql/world/foo.sql`) to the appropriate dir under `data/sql` (`data/sql/custom/db_world/foo.sql`). Will need to rebuild the db import container (`docker compose build ac-db-import`) but that shouldnt take long
If you're using a tool like heidisql, you can import a file with the `Upload SQL File` Option in the `File` Menu.
I personally just use the mysql command line, `mysql -h IP_OF_SERVER -P DATABASE_PORT -u DATABASE_USER -p db_DATABASE_TO_EDIT < PATH_TO_SQL`
The manual process for docker is identical to the non-docker process.
rektbyfaith
10-21-2023, 02:36 PM #3Archived author: mynameismeat • Posted: 2023-10-21T14:36:19.460000+00:00
Original source
the easiest way? copy the sql files from their path in the module source (`modules/sql/world/foo.sql`) to the appropriate dir under `data/sql` (`data/sql/custom/db_world/foo.sql`). Will need to rebuild the db import container (`docker compose build ac-db-import`) but that shouldnt take long
If you're using a tool like heidisql, you can import a file with the `Upload SQL File` Option in the `File` Menu.
I personally just use the mysql command line, `mysql -h IP_OF_SERVER -P DATABASE_PORT -u DATABASE_USER -p db_DATABASE_TO_EDIT < PATH_TO_SQL`
The manual process for docker is identical to the non-docker process.
Original source
yes, dist over .conf.dist
rektbyfaith
10-21-2023, 02:36 PM #4Archived author: mynameismeat • Posted: 2023-10-21T14:36:37.614000+00:00
Original source
yes, dist over .conf.dist
Original source
if you feel you've completely busted it, you can always drop the table and execute the SQL (`data/sql/base/db_auth/realmlist.sql`) to re-create it
You should just be editing the data portion. In the address, you can also set DNS names.
mine looks like this
```console
$ mysql -h HOST -P PORT -uUSER -pPASSWORD acore_auth -e "select * from realmlist;"
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
| id | name | address | localAddress | localSubnetMask | port | icon | flag | timezone | allowedSecurityLevel | population | gamebuild |
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
| 1 | AzerothCore | x.x.x.x | 192.168.x.x | 255.255.252.0 | 8085 | 0 | 0 | 1 | 0 | 0 | 12340 |
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
```
the address is the tailscale IP for the physical server, and the local Address is the lan ip for the server. Note the local subnet mask, since my home network is a /22 (but most people probably wouldn't need to set this)
rektbyfaith
10-21-2023, 02:53 PM #5Archived author: mynameismeat • Posted: 2023-10-21T14:53:11.191000+00:00
Original source
if you feel you've completely busted it, you can always drop the table and execute the SQL (`data/sql/base/db_auth/realmlist.sql`) to re-create it
You should just be editing the data portion. In the address, you can also set DNS names.
mine looks like this
```console
$ mysql -h HOST -P PORT -uUSER -pPASSWORD acore_auth -e "select * from realmlist;"
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
| id | name | address | localAddress | localSubnetMask | port | icon | flag | timezone | allowedSecurityLevel | population | gamebuild |
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
| 1 | AzerothCore | x.x.x.x | 192.168.x.x | 255.255.252.0 | 8085 | 0 | 0 | 1 | 0 | 0 | 12340 |
+----+-------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+
```
the address is the tailscale IP for the physical server, and the local Address is the lan ip for the server. Note the local subnet mask, since my home network is a /22 (but most people probably wouldn't need to set this)
Original source
![[Image: image.png?ex=690c0df1&is=690abc71&hm=677...264a23011&]](https://cdn.discordapp.com/attachments/535208956449128490/1165302143918555217/image.png?ex=690c0df1&is=690abc71&hm=6774c56573c0d63795979b45f2e46a73afac126b8e1d1a4aa7405b0264a23011&)
rektbyfaith
10-21-2023, 02:54 PM #6Archived author: Zeraphicus • Posted: 2023-10-21T14:54:41.441000+00:00
Original source
Original source
I've only edited the default entries, but I will do that.
rektbyfaith
10-21-2023, 02:56 PM #7Archived author: Zeraphicus • Posted: 2023-10-21T14:56:02.379000+00:00
Original source
I've only edited the default entries, but I will do that.
Original source
Yeah, default entries aren't the actual data in the database.
rektbyfaith
10-21-2023, 03:24 PM #8Archived author: mynameismeat • Posted: 2023-10-21T15:24:08.125000+00:00
Original source
Yeah, default entries aren't the actual data in the database.
Original source
A little defeated, dropped the table, left the table default, edited data for the realm, very bizarre. I had it working yesterday on the lan, I guess as a last resort I'll reboot the host server. Do you have any idea what is going on when it is spinning up the docker containers and it creates the network? I'm assuming that is jsut some kind of LAN on the device so the containers can all communicate. I noticed in the diagram that michael crilly posted the auth server had its own IP
![[Image: image.png?ex=690c16da&is=690ac55a&hm=cc8...9f0c53292&]](https://cdn.discordapp.com/attachments/535208956449128490/1165311712669466685/image.png?ex=690c16da&is=690ac55a&hm=cc8cad4857dcec754f57ebc976f7d2f897fc0b2aa02f194a67384859f0c53292&)
![[Image: image.png?ex=690c16da&is=690ac55a&hm=1c9...75a28c53c&]](https://cdn.discordapp.com/attachments/535208956449128490/1165311712916934666/image.png?ex=690c16da&is=690ac55a&hm=1c99bf12e44ece69f0053f07212f3292a64bce1b1bfb5c9480181d875a28c53c&)
![[Image: image.png?ex=690c16da&is=690ac55a&hm=ac6...869a915d0&]](https://cdn.discordapp.com/attachments/535208956449128490/1165311713290240000/image.png?ex=690c16da&is=690ac55a&hm=ac64640a27ed72fc7b70c93bef8132ad4a58c1d7970d15c4f3cbb5b869a915d0&)
![[Image: image.png?ex=690c16da&is=690ac55a&hm=931...a070eefd4&]](https://cdn.discordapp.com/attachments/535208956449128490/1165311713613185085/image.png?ex=690c16da&is=690ac55a&hm=931aaaa9d3269caaedd71b6847396dc16c6647f63484f782d0395ffa070eefd4&)
![[Image: image.png?ex=690c16db&is=690ac55b&hm=d21...448ce5777&]](https://cdn.discordapp.com/attachments/535208956449128490/1165311713936162946/image.png?ex=690c16db&is=690ac55b&hm=d216e31ae27bf9f04b0e68a10122830fb504b5fb484985c7bf2a71b448ce5777&)
rektbyfaith
10-21-2023, 03:32 PM #9Archived author: Zeraphicus • Posted: 2023-10-21T15:32:43.125000+00:00
Original source
A little defeated, dropped the table, left the table default, edited data for the realm, very bizarre. I had it working yesterday on the lan, I guess as a last resort I'll reboot the host server. Do you have any idea what is going on when it is spinning up the docker containers and it creates the network? I'm assuming that is jsut some kind of LAN on the device so the containers can all communicate. I noticed in the diagram that michael crilly posted the auth server had its own IP
Original source
apparently it was the firewall.........I had rules but I just turned it completely off to verify
rektbyfaith
10-21-2023, 04:12 PM #10Archived author: Zeraphicus • Posted: 2023-10-21T16:12:23.012000+00:00
Original source
apparently it was the firewall.........I had rules but I just turned it completely off to verify
1 Guest(s)
1 Guest(s)