Installing on CentOS problem

[ragexe]

Im newbie on centos, i already try

https://github.com/rathena/rathena/wiki/Install-on-Centos#compile-source-code

but my import & import-tmpl folder file is empty

i already setup char_athena.conf , map_athena.conf ,inter_athena.conf

my gcc version 4.8

and want to ask, if i want edit /src, can i just replace file with my Visual studio file compile? 

can i after replace recompile with this commands?

cd trunk

./configure

make clean

make sql

make server

 

./athena-start start

 

access denied for user 'ragnarok'@'localhost' (using password : YES)

[error] Couldn't connect with uname='ragnarok',passwd='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

i dont know why got error like that, i already change inter_athena.conf user,pass & db + recompile 

inter_athena.conf

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: TeRO
login_server_pw: TeRO
login_server_db: TeRO
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: TeRO
ipban_db_pw: TeRO
ipban_db_db: TeRO
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: TeRO
char_server_pw: TeRO
char_server_db: TeRO

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: TeRO
map_server_pw: TeRO
map_server_db: TeRO

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: TeRO
log_db_pw: TeRO
log_db_db: logs
log_codepage:
log_login_db: loginlog

Edited June 16, 2017 by ragexe

[ragexe]

bump

[Cyro]

Give write and read permissions to MySQL user ragnarok on your db table

[ragexe]

15 minutes ago, Cyro said:

Give write and read permissions to MySQL user ragnarok on your db table

Thanks for reply! yea i already give write and read permission but still same

access denied for user 'ragnarok'@'localhost' (using password : YES)

[error] Couldn't connect with uname='ragnarok',passwd='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'

[Cyro]

Try creating new user and give global privileges  in wild card entry 

[ragexe]

10 minutes ago, Cyro said:

Try creating new user and give global privileges  in wild card entry 

still same sir

[sikiro]

is your sql database on a remote vps or is it installed locally?

 

if they exist on a remote vps you want to change the default host 127.0.0.1 to YOUR_SQL_VPS_IP and it should resolve the problem.

 

if not then from your error it seems that its more related to your passwords are incorrect and not that youre missing a database. if this is a new server and you don't have anything on it yet  would suggest you follow the guide here and read it carefully ive used it countless times and it never fails.

https://github.com/rathena/rathena/wiki/Install-on-Centos

 

or shoot me a pm and we can chat on discord and I can help you set it up.

[ragexe]

11 hours ago, sikiro said:

is your sql database on a remote vps or is it installed locally?

 

if they exist on a remote vps you want to change the default host 127.0.0.1 to YOUR_SQL_VPS_IP and it should resolve the problem.

 

if not then from your error it seems that its more related to your passwords are incorrect and not that youre missing a database. if this is a new server and you don't have anything on it yet  would suggest you follow the guide here and read it carefully ive used it countless times and it never fails.

https://github.com/rathena/rathena/wiki/Install-on-Centos

 

or shoot me a pm and we can chat on discord and I can help you set it up.

please check pm sir thank you