Is user "ssa" log in enabled in sql
How do I know if the user is properly activated for the SQL connection? I created two other users to do the tests and it doesn't change anything.
I connect without problem with sql management from the user "sa"
Did you encrypt the .opt files and create a new .eop file?
I encrypt the .opt files well so that it changes to .eop format
This works because when I change the sql user there is indeed the nickname change in the error, however the connection is not working, maybe I should use a php script to see if the connection is working.
Are the database ports set correctly?
the connection ports, I have configured sql on port 1433
Here are the opt files, for the password I tested them with the encrypted password and the unencrypted password
Auth :
Quote:
S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:PASSWORD_MD5_SA_AND_USER_SESSION
S db.auth.port:1433
S app.name:auth
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
S db.auth.thread:350
S db.thread:350
S db.auth.md5_key:2011
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0
S console._password:PASSWORD_MD5_SA_AND_USER_SESSION
|
GameServer:
Quote:
S app.name:Insult Removed
S auth.server_idx:3
S auth.server_name:Insult Removed
S db.game.ip:127.0.0.1
S db.c._password:PASSWORD_MD5_SA_AND_USER_SESSION
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:PASSWORD_MD5_SA_AND_USER_SESSION
S db.user.account:sa
S db.user.name:Telecaster
S db.user.server:127.0.0.1
S game.iocp.active:1
S game.console.port:4502
S io.port:4418
S io.ip_address:127.0.0.1
S blank.io.port:4502
S io.auth.ip:127.0.0.1
S game.exp_rate:10
S game.server_screenshot_url:Removed
S game.item_drop_rate:10
S game.gold_drop_rate:10
S game.chaos_drop_rate:10
S game.party_drop_rate:10
T game.use_login_logout_debug:0
T game.max_level:170
S working_dir:\upload
S io.upload.ip:127.0.0.1
S io.upload.port:4616
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:1
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
N game.logout_timer:0
S memory.player_heap_size:760
T game.mem_usage_info_save_interval:60
T game.PKServer:0
N game.item_hold_time:1800
S game.cash_item_dropable:0
T game.disable_dungeon_raid_siege:0
T game.limit_dungeon_enterable_level:0
T game.max_storage_item_count:400
T set_user_limit:1000
N game.skip_loading_attribute:1
S game.url_list:guild.url|
|
For the password I tested like this
PASSWORD_No_CRYPT = Error
PAssword_Crypt = error
Salt_Pssword_Crypted = error
