Jump to content
  • 0

Heliohost problem. Please help


dice4real

Question


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   1
  • Joined:  10/18/12
  • Last Seen:  

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 connect

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] /kis2

Link to comment
Share on other sites

6 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  94
  • Topics Per Day:  0.02
  • Content Count:  2192
  • Reputation:   253
  • Joined:  11/11/11
  • Last Seen:  

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.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   1
  • Joined:  10/18/12
  • Last Seen:  

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. /kis2

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 connect

ons

[Debug]: at ..\src\login\ipban_sql.c:79[/color]

Edited by dice4real
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  94
  • Topics Per Day:  0.02
  • Content Count:  2192
  • Reputation:   253
  • Joined:  11/11/11
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   1
  • Joined:  10/18/12
  • Last Seen:  

Sir ive already done that. do you have a teamviewer and ill show you so you would see the problem

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   1
  • Joined:  10/18/12
  • Last Seen:  

so thats why. im getting the server max user. Thanks for the info. /no1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...