[HOW-TO] Setup 9.1

[simpbro]

Originally Posted by SilentWisdom

You leave the S:io_auth.ip as 127.0.0.1, no reason for the gs to connect to as externally. Only change the S:io.ip_address

okay i have done that now, i can start the server. i can join. but my friend cant connect. (its definatly over lan) is my friends launch.bat file still wrong? i have just left it the same as above


Could it be a setting in my common.opt file? i noticed in my launch.bat file it mentioned port 58422 and i fount this in my common.opt

 Spoiler

#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:58422
auth.clients.des_key:MERONG

[SilentWisdom]

1) Leave AS opt @ 0.0.0.0 (this listens on all interfaces)
2) Set GS to External IP ()
3) Open Windows Firewall and create inbound port exception for w.e port is your S:io.port: name it GS-PORT
4) Create another inbound port exception for 58422 name it AS-PORT
5) Create a Port Forward in any router you may be using for your S:io.port: (TCP) name it GS-PORT
6) Create another Port forward in any router you may be using for 58422 (TCP) name it AS-PORT
7) Put your External IP and Auth Port (58422) in Launcher.BAT arguments
8) Have fun?

[simpbro]

I don't have access to the router. Its password has been changed from the default password. Is there a hamatchi way to do it?

does it matter if im on windows 10?

[ThunderNikk]

If you are doing this on a LAN there is no need for external IP or router port forwarding.

Just make sure you have your LAN server address in the S:io.ip_address:LAN Address Here

And in Windows advanced firewall open port connections inbound and outbound for 58442, 15574, and 32214

If you need to open it to the public put your external IP in for S:io.ip_address:External Address Here

And press that factory reset on the router and reconfigure it so you can port forward through your router.

[dervish7]

Originally Posted by thndr

Did you configure port 1433 for your SQL server or not?

The following step...

TCP/IP Enabled (In SQL Configuration Manager under protocols) enabled

Caution: It is advised to not only firewall lock 1433 but if you MUST have external use to use a custom port and change it often couple with strict permission based database accounts.

sorry Yes I have configured ports + they have already opened in the brand Mauser now just can't understand where incorrectly put passwords just understand that the translation is not very precise and some moments I can't understand
well if he studied to be a programmer and I'm trying to understand something)



and runs but for some reason with this auth ) but writes here such error(


Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:derbish


#MD5 salt
auth.db.salt:5dd23
#The password is in plain text for auth.db.password if you have one
#auth.db.password:
Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:45560000030003ef2a13d8ed6a 1093f8bb4bef17ef6f6f6f6805200f6f

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:4500

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" folder for guild icons
upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=4617
#Use port 5000 for the guild icon mini webserver
upload.iconserver.ip=0.0.0.0
upload.iconserver.port:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM account WITH(NOLOCK) WHERE account = ? AND password = ?;

#Configure security password query. If this query return at least one row, the security password is accepted
#sql.db_securitynocheck.query:SELECT securty_no FROM account WHERE account = ? AND securty_no = ?;
#You can also use a stored procedure
#sql.db_securitynocheck.query:{CALL smp_new_check_security(?, ?)}

#Logging level
core.log.level:debug
core.log.consolelevel:info




2015-08-13 14:46:42 Info ConfigInfo0: N*upload.iconserver.idletimeout:31
2015-08-13 14:46:42 Info ConfigInfo0: S upload.iconserver.ip:0.0.0.0
2015-08-13 14:46:42 Info ConfigInfo0: N upload.iconserver.port:5000
2015-08-13 14:46:42 Info DbConnectionPool0: Checking connection to database
2015-08-13 14:46:42 Debug DbConnectionPool0: Connecting to database
2015-08-13 14:46:43 Info ODBC: SQLDriverConnect: additional info:
2015-08-13 14:46:43 Info ODBC: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Контекст базы данных изменен на "Auth".
2015-08-13 14:46:43 Info ODBC: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Параметры языка изменены на "русский".
2015-08-13 14:46:43 Info DbConnectionPool0: Connection ok
2015-08-13 14:46:43 Info SessionServer<AuthServer::ClientSession>: Starting server auth.clients on 0.0.0.0:4500
2015-08-13 14:46:43 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-13 14:46:43 Info SessionServer<AuthServer::BillingInterface>: Starting server auth.billing on 127.0.0.1:4503
2015-08-13 14:46:43 Info SessionServer<AuthServer::GameServerSession>: Starting server auth.gameserver on 127.0.0.1:4502
2015-08-13 14:46:43 Info SessionServer<UploadServer::GameServerSession>: Starting server upload.gameserver on 127.0.0.1:4616
2015-08-13 14:46:43 Info SessionServer<UploadServer::ClientSession>: Starting server upload.clients on 0.0.0.0:4617
2015-08-13 14:46:43 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-13 14:46:43 Info SessionServer<UploadServer::IconServerSession>: Starting server upload.iconserver on 0.0.0.0:5000
2015-08-13 14:46:43 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-13 14:46:43 Info SessionServer<AdminServer::AdminInterface>: Starting server admin.telnet on 127.0.0.1:4501
2015-08-13 14:46:44 ERROR Socket[:0 <> 127.0.0.1:4516]: onConnected: connection refused
2015-08-13 14:46:44 Info SocketSession0: Disconnected from Log server 127.0.0.1:4516
2015-08-13 14:46:46 Info SessionServer<AuthServer::ClientSession>: Stopping server auth.clients
2015-08-13 14:46:46 Info SessionServer<AuthServer::BillingInterface>: Stopping server auth.billing
2015-08-13 14:46:46 Info SessionServer<AuthServer::GameServerSession>: Stopping server auth.gameserver
2015-08-13 14:46:46 Info SessionServer<UploadServer::GameServerSession>: Stopping server upload.gameserver
2015-08-13 14:46:46 Info SessionServer<UploadServer::ClientSession>: Stopping server upload.clients
2015-08-13 14:46:46 Info SessionServer<UploadServer::IconServerSession>: Stopping server upload.iconserver
2015-08-13 14:46:46 Info SessionServer<AdminServer::AdminInterface>: Stopping server admin.telnet
2015-08-13 14:46:46 Info Log0: Log thread stopped

awesome deal from where it displays an error about the port 4516

[ThunderNikk]

You may have port 4516 being used for something else other than the log server?

Are you sure you are running the Auth emulator and not the original princess aurora that comes with the release?

[glandu2]

the auth can't connect to the port 4516 probably because you don't run the LogServer (which listen on 4516).

You can ignore this error, the auth will work as expected even without a LogServer running.

[dervish7]

Originally Posted by thndr

You may have port 4516 being used for something else other than the log server?

Are you sure you are running the Auth emulator and not the original princess aurora that comes with the release?

Yes just use a different emulator but now error captain goes here such

S:app.name:REvvvvv
T:auth.server_idx:1
S:auth.server_name:91Server
S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:Arcadia
S:db.c._password:45560000030002ef2b13d7ed6a1091f8b d4bef17ef6f6f6f6805200f6f
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:telecaster
S:db.user._password:4556000003000338fdc201ef01f901 a557167bfe848181818605260f81
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24 T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:256
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:45560000030003ef2a13d8ed6a1093 f8bb4bef17ef6f6f6f6805200f6f
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url|
S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4




2015-08-13 23:13:24 cannot connect log server: ip: 127.0.0.1, port: 4516

2015-08-13 23:17:34 Network initialize... ok

2015-08-13 23:17:34 IOCP initialize... ok

2015-08-13 23:17:34 Starting IOCP thread pool... ok

2015-08-13 23:17:34 LUA initialize... ok

2015-08-13 23:17:34 Launching ARCADIA... ok

2015-08-13 23:17:34 Start loading...


2015-08-13 23:17:34 ERROR: GAME DB INIT ERROR : Недопустимая спецификация авторизации


2015-08-13 23:17:53 cannot connect log server: ip: 127.0.0.1, port: 4516

[ThunderNikk]

2015-08-13 23:17:34 ERROR: GAME DB INIT ERROR : Недопустимая спецификация авторизации

Says "Invalid Authorization Specification"

So either it does not have administrative privileges or there is somethings wrong with one of your listed SQL user accounts or passwords.

[Pushkin90]

Help please what could be the problem?

[ThunderNikk]

That really doesn't look like there is a problem.

I think you just need to run a client now.

[dervish7]

Hello explain me the fool please why I can not start the server
I have already knocked down the Windows on a new set of sql auth is going well and then trouble running captain the password from Arcadia and then he takes login failed for user Telecaster everything is done through purok in short, he writes database error 2015-08-17 16:47:32 ERROR: GAME DB INIT ERROR : login failed for user "ss3". what to do passwords changed 4 times and don't care

[ThunderNikk]

Check and make sure you are compressing the .opt files and creating new eop files.

To do that remove the .eop file from your game bin folder and compress the .opt file with the compressor it should create a new .eop file.

Make sure you are running as an administrator. Make sure you are compressing on C: drive and not a partition.

If it does not then that may be one of your problems.

You know the password should be in plain text in the database configuration right?

They should only be compressed with pyroks compressor for the gameserver.opt

[Pushkin90]

Подскажите как включить пробуждения вещей?

Tell me how to enable Wake-up things?


S db.preset_00:Test|127.0.0.1|1433|Arcadia|sa|0127bf 376aecfb6865797b449b42ed78


how to fix it?

Sorry for my English))

[dervish7]

Thank you all figured out

and where to get the id only