[HELP]Ceres Control Panel.

[sanasuke]

Can some 1 tell me what is my problem with thad pic ?

 

[RO Pwner]

Well he can't find your status table make sure you assign everything correctly

 

[Kenshinous]

You did not install the MySQL script properly. Table 'ragnarok.status' does not exist.

How to solve?

Install the control panel again. Overwrite every existing file.

If problem still occurs, the installation script might have some problem. Download the original CeresCP from the original hoster and install again rewriting every existing file.

 

[bond]

Setting your database properly...make sure db username have access to cp db and ragnarok db....
anyways ur Mysql client is to OLD..here the link for full guide to install RO with ROCP

You must be registered to see links

!!!!!!!

You must be registered to see links

<--download your ea here...
or this one

You must be registered to see links

 

[sanasuke]

Haiz i got this problem it empty page =.=??? why??

 

[princ3dan]

Query (SELECT * FROM cp.status) failed: Access denied for user 'cp'@'%' to database 'ragnarok'

Whats that? can anyone tell me what am i missing o.o

 

[Innovative]

Can some 1 tell me what is my problem with thad pic ?

(This "mini - tut" only works if you are trying to configure ROCP (Ragnarok Online Control Panel))

Okays, it took me a while to figure this out too with my own server.
If you are using Abyss Web Server then find your way to:
"C:\Program Files\Abyss Web Server\htdocs"
And if you have created a folder for your Control Panel, then go into there as well.
Open up your "config.php"
The first few lines should be the following :
$CONFIG['db_host'] = 'localhost'; // SQL Host
$CONFIG['db_username'] = ''; // SQL User
$CONFIG['db_password'] = ''; // SQL Password
$CONFIG['cp_db_name'] = ''; // SQL CP Database name
$CONFIG['db_name'] = 'Ragnarok'; // SQL Ragnarok Database name


Dont touch this for now, open up MySql Query Browser.
Then go to File->Open Script and browse your way to:
"C:\Program Files\Abyss Web Server\htdocs\(If you have put your files into a folder)\Install\Athena & Freya"
And open up "install.sql" , then execute it in MySql Query Browser.
This should run the script and automatically create a new schema called "cp" so long as you didnt edit any part of the Sql Script.
Then go to MySql Administrator, and go to User administration.
If an account with the name "cp" has already been created, delete it and create a new one with the name "cp" but with a password of your desire.
Apply all changes and close both the MySql Administrator and Query Browser.

Go back to your "config.php" and enter the following.
$CONFIG['db_host'] = 'localhost'; // SQL Host
$CONFIG['db_username'] = 'cp'; // SQL User
$CONFIG['db_password'] = '100193'; // SQL Password
$CONFIG['cp_db_name'] = 'cp'; // SQL CP Database name
$CONFIG['db_name'] = 'Ragnarok'; // SQL Ragnarok Database name

Save this and try it again
Hope this helps, my first helpful post.
__________________________________________________________________________________________________________________

Haiz i got this problem it empty page =.=??? why??

ImageShack - Hosting :: 83293636zp8.jpg

Open up "index.php" and replace the first few lines with these. ( I wish I had the place i got this from, but i lost the link)

<?php
ini_set("display_errors", "On");
error_reporting(E_ALL);
// Accessed when the user goes to the home page
require 'memory.php'; // calls memory functions
require 'header.inc'; // brings in header
check_auth($_SERVER['PHP_SELF']); // checks for required access

It should work afterwards

__________________________________________________________________________________________________________________

Query (SELECT * FROM cp.status) failed: Access denied for user 'cp'@'%' to database 'ragnarok'

Whats that? can anyone tell me what am i missing o.o

Make sure in your "config.php" you have set the correct password to your "cp" database.
Example:
$CONFIG['db_username'] = 'cp'; // SQL User
$CONFIG['db_password'] = '100193'; // SQL Password

Here, in MySql Administrator i must have an user account with the username "cp" using the password "100193"
So make sure you configure your User settings correctly

*To all the above, if you still encounter problems, feel free to PM me or to email me

 

[Kenshinous]

Haiz i got this problem it empty page =.=??? why??

Did you even take the effort to do what I posted?

If you do, there won't be any other problems if you have configured them correctly.

 

[princ3dan]

$CONFIG['db_host'] = 'localhost'; // SQL Host
$CONFIG['db_username'] = 'cp'; // SQL User
$CONFIG['db_password'] = 'cp'; // SQL Password
$CONFIG['cp_db_name'] = 'cp'; // SQL CP Database name
$CONFIG['db_name'] = 'ragnarok'; // SQL Ragnarok Database name (Athena Only)
$CONFIG['db_logs'] = 'log'; // SQL Log Database name (Athena SVN only)

this is how it looks like for me.. i think its all correct. i got my username called "cp" password "cp" but still i ogt that error.. im using XAMPP

 

[princ3dan]

#1 k i got the thing working registration but how come the status said its offline

when my server is online. AND!

#2 When i'm in game how come Server name --> Server selection --> When i create my chracter they said "Please try again after 24 Hours"

Huh? how do i fix that? Thats after when i create my char.

::EDIT : I got 2 Problem Currently If i can fix those 2. it will run purely o.o need help guys

 

[Kenshinous]

#1 k i got the thing working registration but how come the status said its offline

when my server is online. AND!

#2 When i'm in game how come Server name --> Server selection --> When i create my chracter they said "Please try again after 24 Hours"

Huh? how do i fix that? Thats after when i create my char.

::EDIT : I got 2 Problem Currently If i can fix those 2. it will run purely o.o need help guys

As for your server status, you will have to put the local IP of your computer.

For the character creation, the maximum character creation is 3 per account by default. You can set the limit at the char_athena.

 

[princ3dan]

Thanks ken,

Bout the server status.. where do i find this "Local IP FILE" You were talking bout.. Dont get mess up i meant the file which i have to put my IP in..

Clap'
Princ3dan

:::EDIT::::

Kenshinous I've edited the character creation 3 the previous one i put in 6 . Currently : 3 now and i still can't connect >.> Help pl0x =)

 

[Kenshinous]

Theres no local IP file. What I mean is to enter your Local IP in the configuration file of the Control Panel.

You still can't login? I need more information about your configs, weather if you are on a router or not and have you forwarded the ports.

 

[princ3dan]

Control panal everything good NO STATUS only.

You still can't login? I need more information about your configs, weather if you are on a router or not and have you forwarded the ports.

Router = Yes I have. Port Foward 6900 5121 6121 everythiung already -.-

The Problem now is status checker.. i work on that later thats not the problem.

The main problem is the Please try again 24 hours later

if u want my CONFIG ill give u 1 sec.

Oh yes bout the website im using XAMPP not Abyss & PHP thingy.

login info:

bind_ip: 192.168.0.13

// Login Server Port
login_port: 6900


CHAR INFO ::

login_ip: 222.164.115.156
bind_ip: 192.168.0.13
char_ip: 222.164.115.156


MAP INFO:::

char_ip: 222.164.115.156
bind_ip: 192.168.0.13
map_ip: 222.164.115.156

So what now o.o

 

[Kenshinous]

Control panal everything good NO STATUS only.

You still can't login? I need more information about your configs, weather if you are on a router or not and have you forwarded the ports.

Router = Yes I have. Port Foward 6900 5121 6121 everythiung already -.-

The Problem now is status checker.. i work on that later thats not the problem.

The main problem is the Please try again 24 hours later

if u want my CONFIG ill give u 1 sec.

Oh yes bout the website im using XAMPP not Abyss & PHP thingy.

login info:

bind_ip: 192.168.0.13

// Login Server Port
login_port: 6900


CHAR INFO ::

login_ip: 222.164.115.156
bind_ip: 192.168.0.13
char_ip: 222.164.115.156


MAP INFO:::

char_ip: 222.164.115.156
bind_ip: 192.168.0.13
map_ip: 222.164.115.156

So what now o.o

To solve the server status at the Control Panel, at your control panel config, change them to local IP. If your under a router, your IP should be something like this, 192.168.xxx.xxx.

As for the message 'Please try again 24 hours later', that to create character is not allowed or has reached its maximum. Try other slots or you can change the limit of the character creation to a maximum of nine at the 'char_athena.conf'.

 

[jhaysan]

Query (SELECT * FROM cp.status) failed: Access denied for user 'cp'@'%' to database 'ragnarok'

Whats that? can anyone tell me what am i missing o.o


>>>>>>> ive read dis but i did not see your solution for that.. actually im encountering the same problem as that.. would you mind sharing the solution??

.. and uhmm.. can i ask if ever i fix this would my friends can register now into my homepage to thru my server??.. thanx ^_^

 

[jhaysan]

Query (SELECT * FROM cp.status) failed: Access denied for user 'cp'@'%' to database 'ragnarok'

Whats that? can anyone tell me what am i missing o.o

how did you resolve this?? would you mind to share.. pls.. ^_^

 

[yosif]

erorr when i put it on webspace

# Basic Syntax:
# GRANT SELECT,UPDATE,DELETE,INSERT ON [db name].* TO 'login'@[host] IDENTIFIED BY 'password';
# CREATE DATABASE [your cp database name];
# USE [your cp database name];
# If you want another login, change 'cp' to 'your new_login'
# Be sure to change default_password to the password that you defined in config.php
# If you are running the CP on a webhost, and hosting SQL yourself, make sure that you change 'cp'@localhost to
# 'cp'@host_ip
GRANT SELECT ,
UPDATE ,
DELETE ,
INSERT ON ragnarok . *
TO 'cp'@localhost
IDENTIFIED BY 'cp';

MySQL قال: مستندات وثائقيه
#1044 - Access denied for user 'theghost'@'localhost' to database 'ragnarok

 

[shappy23]

NEED ragnarok developer add me james_alcantara_101@yahoo.com always online