bgamez23 - Jul 4, 2013 21:39
[code=auto:0][Debug]: at \src\login\account_sql.c:153 [Fatal Error]: do_init: Failed to initialize account engine 'sql'.[/code]
there are no compilation problem. after i run the run-server.bat the the login-server gave me that error.
This post has been edited by
bgamez23
on Jul 4, 2013 22:32
mkbu95 - Jul 4, 2013 22:51
ossi0110 on IRC had the same problem.
He says:[code=auto:0]<ossi0110> okay found the problem you commit works like a charm
<ossi0110> my SQL Server crashed and windows didnt dropped a msg about this[/code]Make sure your compilation is clean, recompile and retry please.
bgamez23 - Jul 4, 2013 23:05
why i get that [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)
i configure correctly the char-server.conf and map-server.conf sameway on the 5th image.
[img]http://s24.postimg.org/fwo13dun9/image.jpg[/img][img]http://s24.postimg.org/ertyy086d/image.jpg[/img][img]http://s24.postimg.org/rztcqy5ph/image.jpg[/img]
[img]http://s18.postimg.org/urjkdbf9l/image.jpg[/img]
but on Git Hash: '6ced266cc8d41ce6a3c5323c22f295e37b3f5684'
there is no problem.
[img]http://s24.postimg.org/gq589qq1x/image.jpg[/img]
This post has been edited by
bgamez23
on Jul 4, 2013 23:11
ossi0110 - Jul 4, 2013 23:06
And btw ' be sure when updating the server to resolve the conflicts in the inter.conf ' because mkbu changed the names for the sql dbs vars
This post has been edited by
ossi0110
on Jul 4, 2013 23:10
bgamez23 - Jul 4, 2013 23:12
[quote name="ossi0110" timestamp="1372979205"]
And btw ' be sure when updating the server to resolve the conflicts in the inter.conf ' because mkbu changed the names for the sql dbs vars[/quote]
there are no conflicts. its a clean server files. on the 4th image. i only modified the char-server.conf, inter-server.conf and map-server.conf
ossi0110 - Jul 4, 2013 23:18
show me your inter.conf
or just come into IRC its easyer
bgamez23 - Jul 4, 2013 23:28
[quote name="ossi0110" timestamp="1372979895"]
show me your inter.conf
or just come into IRC its easyer[/quote]
[code=auto:0]
// Hercules InterServer (settings shared/used by more than 1 server) configuration.
// Options for both versions
// Log Inter Connections, etc.?
log_inter: 1
// Inter Log Filename
inter_log_filename: log/inter.log
// Level range for sharing within a party
party_share_level: 15
// SQL version options only
// You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage:
// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1
// Under windows, you want to use 127.0.0.1. If you see a message like
// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
// and you have localhost, switch it to 127.0.0.1
// Global SQL settings
// overridden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: ragnarok
sql.codepage:
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog
// == MySQL Reconnect Settings
// ===========================
// - mysql_reconnect_type
// - 1: when mysql disconnects during runtime, the server tries to reconnect mysql_reconnect_count times and,
// -- if unsuccessful, the server is shut down
// - 2: when mysql disconnects during runtime it tries to reconnect indefinitely
mysql_reconnect_type:2
// - mysql_reconnect_count
// - number of reconnect attempts the server should do when the database disconnects during runtime
// - only used when mysql_reconnect_type is 1
mysql_reconnect_count:1
// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
// this is meant for people who KNOW their stuff, and for some reason want to change their
// database layout. [CLOWNISIUS]
// ALL MySQL Database Table names
//Shared
interreg_db: interreg
// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
storage_db: storage
reg_db: global_reg_value
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
ragsrvinfo_db: ragsrvinfo
// Map Database Tables
item_db_db: item_db
item_db_re_db: item_db_re
item_db2_db: item_db2
mob_db_db: mob_db
mob_db2_db: mob_db2
mob_skill_db_db: mob_skill_db
mob_skill_db2_db: mob_skill_db2
mapreg_db: mapreg
// Use SQL for item_db?
use_sql_item_db: no
// Use SQL for mob_db?
use_sql_mob_db: no
// Use SQL for mob_skill_db?
use_sql_mob_skill_db: no
import: conf/import/inter_conf.txt
[/code]
mkbu95 - Jul 4, 2013 23:31
Try restarting your mysql server. Exit and start it again.
ossi0110 - Jul 4, 2013 23:31
this is the inter.conf from Pic 4 the clean server right? , because on your 3rd pic you got a error
bgamez23 - Jul 4, 2013 23:43
@[url="http://herc.ws/board/user/49-mkbu95/"]mkbu95[/url] still not working. i try to download a fresh svn and i only change the char,inter and map server still not working.
bgamez23 - Jul 4, 2013 23:45
[quote name="ossi0110" timestamp="1372980699"]
this is the inter.conf from Pic 4 the clean server right? , because on your 3rd pic you got a error[/quote]
it is the latest inter.conf that i'm using right now. i didn't put the database info only i put the default one.
bgamez23 - Jul 4, 2013 23:46
am confuse if it is a mysql problem. since on the 5th image. the server is working normally without any error.
ossi0110 - Jul 4, 2013 23:48
the 5th image is BEFOR the sql split commit from mkbu or?
bgamez23 - Jul 4, 2013 23:48
[quote name="ossi0110" timestamp="1372981693"]
the 5th image is BEFOR the sql split commit from mkbu or?[/quote]
yup
ossi0110 - Jul 4, 2013 23:50
yeah then applie the commit again to your server , and then post the inter.conf from it
bgamez23 - Jul 4, 2013 23:53
i think the image 5 was on this revision.
[url="https://github.com/HerculesWS/Hercules/commit/6ced266cc8d41ce6a3c5323c22f295e37b3f5684"]https://github.com/HerculesWS/Hercules/commit/6ced266cc8d41ce6a3c5323c22f295e37b3f5684[/url]
last check before the login-server failed to start was on this.
[url="https://github.com/HerculesWS/Hercules/commit/aefa8d6bd88e5056080f45ed89f86258f1bf81d7"]https://github.com/HerculesWS/Hercules/commit/aefa8d6bd88e5056080f45ed89f86258f1bf81d7[/url]
[url="http://herc.ws/board/tracker/issue-7473-compile-error-and-warning-on-pre-re-part2/"]http://herc.ws/board/tracker/issue-7473-compile-error-and-warning-on-pre-re-part2/[/url]
bgamez23 - Jul 4, 2013 23:55
[quote name="ossi0110" timestamp="1372981800"]
yeah then applie the commit again to your server , and then post the inter.conf from it[/quote]
on the 4th image. i configure it by default. that copy is a fresh copy. check the 4th reply i already mention it.
bgamez23 - Jul 4, 2013 23:56
@Ind thanks for the confirmed.
Ind - Jul 4, 2013 23:59
Fixed in [url="https://github.com/HerculesWS/Hercules/commit/88da261c4cf6f984252adb46a1b780a9aeeb8ccc"]https://github.com/HerculesWS/Hercules/commit/88da261c4cf6f984252adb46a1b780a9aeeb8ccc[/url]
Thanks!
mkbu95 - Jul 5, 2013 0:09
OH F*CKING SHIT
SORRY GUYS :/
THANKS IND!!!