Issue information

Issue ID
#7476
Status
Fixed
Severity
None
Started
bgamez23
Jul 4, 2013 21:39
Last Post
mkbu95
Jul 5, 2013 0:09
Confirmation
N/A

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!!!