dice4real Posted November 22, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 45 Reputation: 1 Joined: 10/18/12 Last Seen: October 29, 2024 Share Posted November 22, 2012 please help me to configure this problem. im using heliohost.org. and this one shows up to my logserver. : User eaglero already has more than 'max_user_connections' active connectons[Debug]: at ..\src\login\ipban_sql.c:79Login-Server has terminated abnormally.Restarting in 15 seconds, press Ctrl+C to cancel.[/color]************************************************************************************************************************************************[b]and this one.[/b][color=#ff0000][[sql]: DB error - Table 'eaglero_ragnarok.loginlog' doesn't exist[Debug]: at ..\src\login\loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login server started')[sql]: DB error - Table 'eaglero_logs.ipbanlist' doesn't exist[Debug]: at ..\src\login\ipban_sql.c:255 - DELETE FROM `ipbanlist` WHERE `rtime`<= NOW()[/color][size=4][b]Im using heliohost please guide me.[/b][/size] Quote Link to comment Share on other sites More sharing options...
Mystery Posted November 22, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 253 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted November 22, 2012 1) Did you put any custom modifications in your source file? Did you make sure to read proper guides? http://rathena.org/wiki/Connecting http://rathena.org/wiki/Getting_Started <-- Installation Guides 2) The answer states itself: [[ : DB error - Table 'eaglero_ragnarok.loginlog' doesn't exist[/font][/color]] [[color=#FF0000][font=helvetica, arial, sans-serif]SQL]: DB error - Table 'eaglero_logs.ipbanlist' doesn't exist[/font][/color]]. Basically, it's telling you you're missing tables. You need to install your tables properly.Especially since HelioHost is not Ragnarok based, you'll have little to no support from them whatsoever. 1 Quote Link to comment Share on other sites More sharing options...
dice4real Posted November 24, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 45 Reputation: 1 Joined: 10/18/12 Last Seen: October 29, 2024 Author Share Posted November 24, 2012 (edited) Thank you For The Reply Mysterious Im gonna Try The info You put. I will Update it here if what will be the next problem. Im Still a noob. But a Fast Learner. And My question is: Where I could Find Those Tables?. P.S: whats the problem of saying max user connection. in Heliohost. **************************************************************************************************************************************** Still getting this Error : User eaglero already has more than 'max_user_connections' active connectons[Debug]: at ..\src\login\ipban_sql.c:79[/color] Edited November 24, 2012 by dice4real Quote Link to comment Share on other sites More sharing options...
Mystery Posted November 24, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 253 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted November 24, 2012 The Loginlog table is found in your /trunk/sql-files/logs.sql #Database: ragnarok #Table: loginlog CREATE TABLE `loginlog` ( `time` datetime NOT NULL default '0000-00-00 00:00:00', `ip` varchar(15) NOT NULL default '', `user` varchar(23) NOT NULL default '', `rcode` tinyint(4) NOT NULL default '0', `log` varchar(255) NOT NULL default '', INDEX (`ip`) ) ENGINE=MyISAM ; And your ipbanlist table is found in /sql-files/main.sql. -- -- Table structure for table `ipbanlist` -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` varchar(255) NOT NULL default '', `btime` datetime NOT NULL default '0000-00-00 00:00:00', `rtime` datetime NOT NULL default '0000-00-00 00:00:00', `reason` varchar(255) NOT NULL default '', KEY (`list`) ) ENGINE=MyISAM; If you don't know how to install tables properly, view over the guides xD Quote Link to comment Share on other sites More sharing options...
dice4real Posted November 25, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 45 Reputation: 1 Joined: 10/18/12 Last Seen: October 29, 2024 Author Share Posted November 25, 2012 Sir ive already done that. do you have a teamviewer and ill show you so you would see the problem Quote Link to comment Share on other sites More sharing options...
Asura Posted November 25, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted November 25, 2012 Hi dice4real, Don't use a free webhost to host your RO SQL database; don't use any webhosting-based MySQL server to host your RO SQL database. HeliosHost.org probably has limitations on their my.cnf, which is why it is rejecting any additional MySQL connections than it's set limit. Quote Link to comment Share on other sites More sharing options...
dice4real Posted November 26, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 45 Reputation: 1 Joined: 10/18/12 Last Seen: October 29, 2024 Author Share Posted November 26, 2012 so thats why. im getting the server max user. Thanks for the info. Quote Link to comment Share on other sites More sharing options...
Question
dice4real
please help me to configure this problem.
im using heliohost.org.
and this one shows up to my logserver.
ons
[Debug]: at ..\src\login\ipban_sql.c:79
Login-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.[/color]
************************************************************************************************************************************************
[b]and this one.[/b]
[color=#ff0000][[sql]: DB error - Table 'eaglero_ragnarok.loginlog' doesn't exist
[Debug]: at ..\src\login\loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,
`user`,`rcode`,`log`) VALUES (NOW(), '0.0.0.0', 'login server', '100', 'login se
rver started')
[sql]: DB error - Table 'eaglero_logs.ipbanlist' doesn't exist
[Debug]: at ..\src\login\ipban_sql.c:255 - DELETE FROM `ipbanlist` WHERE `rtime`
<= NOW()[/color]
[size=4][b]Im using heliohost please guide me.[/b][/size]
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.