read.py not working as expected #31

New Issue

DSRLIN · 2023-08-14T06:25:21Z

DSRLIN commented

2023-08-14 06:25:21 +00:00

I'm using read.py to import infos from my local files to my server's database(mariadb 10.10).
I'm sure i've already configured everything in the core.yaml, including database.host/ database.username etc.
But when the script starts running, it tells me access denied from the local public ip, not the ip I configured in the core.yaml.

I'm using read.py to import infos from my local files to my server's database(mariadb 10.10). I'm sure i've already configured everything in the core.yaml, including database.host/ database.username etc. But when the script starts running, it tells me access denied from the local public ip, not the ip I configured in the core.yaml.

Dniel97 commented

2023-08-14 10:47:25 +00:00

If you get an "Acces Denied" from your database, that means, you also cannot launch ARTEMiS properly as well and is not a problem of the read.py script. Make sure your password is set correctly in core.yaml and if the database is running on the same PC/Server make sure to use lcoalhost for the database as well.

If you get an "Acces Denied" from your database, that means, you also cannot launch ARTEMiS properly as well and is not a problem of the `read.py` script. Make sure your password is set correctly in `core.yaml` and if the database is running on the same PC/Server make sure to use lcoalhost for the database as well.

DSRLIN commented

2023-08-14 10:54:41 +00:00

ARTEMiS has already been launched on the server side.
I double checked the config between the server and the client, the only difference between them is the host of the database.
I've configured the read.py to use database on the server but it uses the database on my local machine.
![IRQ2)Q3DGJBSG%RAZRLX]1V](/attachments/97d8dc7f-9633-4848-a159-3a558a0509d7)
The database host in my config is my server ip.
![`%T9{4MMDY~9FA905~Y7XE
And the error read.py claims is my local machine ip.

ARTEMiS has already been launched on the server side. I double checked the config between the server and the client, the only difference between them is the host of the database. I've configured the read.py to use database on the server but it uses the database on my local machine. ![IRQ2)Q3DGJBSG%RAZRLX]1V](/attachments/97d8dc7f-9633-4848-a159-3a558a0509d7) The database host in my config is my server ip. ![`%T9{4MMDY~9FA9[05~Y7XE](/attachments/00417af2-562f-4e7b-a6a7-984bb2213c40) And the error read.py claims is my local machine ip.

IRQ2)Q3DGJBSG%RAZRLX]1V.png

11 KiB

`%T9{4MMDY~9FA9[05~Y7XE.png

31 KiB

DSRLIN commented

2023-08-14 11:16:29 +00:00

And the artemis is seperatedly deployed on server so I cannot import the datas to localhost.

Dniel97 commented

2023-08-14 12:28:15 +00:00

Yes you can launch ARTEMiS with a broken database conenction but you cannot use

python dbutils.py create

to create the database schema or let a game conenct to it. Make sure your port, ip, database, username and password is indeed correct and that your MariaDB server accepts non localhost requests as well. Maybe that helps Configuring MariaDB for Remote Client Access.

Yes you can launch ARTEMiS with a broken database conenction but you cannot use ``` python dbutils.py create ``` to create the database schema or let a game conenct to it. Make sure your port, ip, database, username and password is indeed correct and that your MariaDB server accepts non localhost requests as well. Maybe that helps [Configuring MariaDB for Remote Client Access](https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/#granting-user-connections-from-remote-hosts).

DSRLIN commented

2023-08-15 00:47:58 +00:00

I've tested a lot and found out while i'm using "aime" as database user, the artemis acts fine but the read.py acts abnormal. But when I using "root" as database user, the read.py acts fine.
I've tested the script and found out all of the modules in artemis are normal, the problem occurs while passing the database host to the mysqldb lib(which cannot be debug in python, written in c), the database host will be replaced and cause this problem.
So it's more like a library side problem. I'm closing this issue.

I've tested a lot and found out while i'm using "aime" as database user, the artemis acts fine but the read.py acts abnormal. But when I using "root" as database user, the read.py acts fine. I've tested the script and found out all of the modules in artemis are normal, the problem occurs while passing the database host to the mysqldb lib(which cannot be debug in python, written in c), the database host will be replaced and cause this problem. So it's more like a library side problem. I'm closing this issue.

DSRLIN closed this issue

2023-08-15 00:47:58 +00:00

Sign in to join this conversation.