Problem connecting to DB (using old credentials)

[Prikster]

Hello everyone!

I'm kind of new to rAthena. I've read about it before but never used it. Now I'm trying to set my server at localhost using Ubuntu.

I'm having a strange issue when running ./athena-start start. This is the error I get:
 

[Error]: Couldn't connect with username = 'rathena', password = 'rathena123', host = '127.0.0.1', port = '3306', database = 'rathena'

The problem is that those are not the username and password I set to conf/import/inter_conf.txt. I used them in my first try but changed it after that. I deleted rAthena folder and cloned it again (did this twice) to have a clean start but I'm still getting this error message with those old username and password.

This is my conf/import/inter_conf.txt:

login_server_id: rathenaid
login_server_pw: admin123456
login_server_db: rathena

ipban_db_id: rathenaid
ipban_db_pw: admin123456
ipban_db_db: rathena

char_server_id: rathenaid
char_server_pw: admin123456
char_server_db: rathena

map_server_id: rathenaid
map_server_pw: admin123456
map_server_db: rathena

This is my conf/import/char_conf.txt:

// Server Communication username and password.
userid: rathenagm
passwd: gm123456

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 127.0.0.1

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
// char_ip: 127.0.0.1
char_ip: [my wan ip]

This is my conf/import/inter_conf.txt:

// Server Communication username and password.
userid: rathenagm
passwd: gm123456

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 127.0.0.1

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
// map_ip: 127.0.0.1
map_ip: [my wan ip]

I also made all the necessary changes to the database, creating a new user and giving it ALL privileges and editing the login table.

I followed rAthena's wiki pages: Install on Ubuntu and Connecting.

The strangest thing is that the error shows username and password that aren't the ones I set in the configuration files and are not the default ones. I don't know where it's getting that from. Cache, hidden files?

I have no idea why this is happening and need help!
Thanks!

Edited April 28, 2020 by Prikster

[Chaos92]

4 minutes ago, Prikster said:

Hello everyone!

I'm kind of new to rAthena. I've read about it before but never used it. Now I'm trying to set my server at localhost using Ubuntu.

I'm having a strange issue when running ./athena-start start. This is the error I get:
 

[Error]: Couldn't connect with username = 'rathena', password = 'rathena123', host = '127.0.0.1', port = '3306', database = 'rathena'

The problem is that those are not the username and password I set to conf/import/inter_conf.txt. I used them in my first try but changed it after that. I deleted rAthena folder and cloned it again (did this twice) to have a clean start but I'm still getting this error message with those old username and password.

This is my conf/import/inter_conf.txt:

login_server_id: rathenaid
login_server_pw: admin123456
login_server_db: rathena

ipban_db_id: rathenaid
ipban_db_pw: admin123456
ipban_db_db: rathena

char_server_id: rathenaid
char_server_pw: admin123456
char_server_db: rathena

map_server_id: rathenaid
map_server_pw: admin123456
map_server_db: rathena

This is my conf/import/char_conf.txt:

// Server Communication username and password.
userid: rathenagm
passwd: gm123456

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 127.0.0.1

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
// char_ip: 127.0.0.1
char_ip: [my wan ip]

This is my conf/import/inter_conf.txt:

// Server Communication username and password.
userid: rathenagm
passwd: gm123456

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 127.0.0.1

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
// map_ip: 127.0.0.1
map_ip: [my wan ip]

I have no idea why this is happening and need help!
Thanks!

u should change in your login database too. the default one is s1 and p1. find it in your database and change it to what you need as your setup.

[Prikster]

5 hours ago, Chaos92 said:

u should change in your login database too. the default one is s1 and p1. find it in your database and change it to what you need as your setup.

Sorry for not adding this to my post but I changed everything in the database.

I created a user with username = 'rathena' with password 'rathena123' and give it ALL privileges.
I also updated the user in the login table that comes after importing the SQL files. It's now userid = 'rathenaid' and user_pass = 'admin123456'.

I will add that to the main post.

But the main problem here wouldn't be that the credentials are different from the database. It's in the fact that it's using credentials that I didn't configure. There is no place in my configuration files that sets username to 'rathena' and password to 'rathena123' like it shows in the error message.

Edited April 28, 2020 by Prikster

[Chaos92]

have you check throughly either at conf/ folder or conf/import folder ?

[Prikster]

On 4/29/2020 at 7:02 AM, Chaos92 said:

have you check throughly either at conf/ folder or conf/import folder ?

Yes, I used the Find in Files tool from Sublime Text and grep from Linux to look in the entire rAthena folder and nothing.
This is really strange.

 

I searched for those credentials in the bash history and other folders but couldn't find it.

I couldn't find the problem so since I'm working with Virtual Machine I built a new VM and configured rAthena all over again and it worked. I guess the issue in the first VM was cache or something like that.

[Chaos92]

or maybe your VM clock / PC clock having issue so the editing of it in 'future' wont affect the changes.