Jump to content
The Web Section is Now Read-Only
  • 0

Xantara-rACP problems

Feistz

Asked by Feistz,

 Share

Question

Feistz Poring

Feistz

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  
Posted (edited)

Ok so i have two servers that share 1 login server that is ragnarok1 and ragnarok2. I use this guide [media=]http://www.paradox924x.com/stuff/screencasts/multiple_charmap_servers.swf[/media] to make it work but it have a little problem in that. If i choose to view characters from ragnarok1 database, there is no problem but if i choose to view characters from ragnarok2 database the site show unauthorized access. It means i cant view it, cant modify it, i cant use the reset look function and so on. On admin level, it says no such character was found although it has the list and the char ID was correct. So, anyone has experience on this kind of problem?

p/s: my login table was in ragnarok1 database.

here is my servers.php:-

<?php
return array(
// Example server configuration. You may have more arrays like this one to
// specify multiple server groups (however they should share the same login
// server whilst they are allowed to have multiple char/map pairs).
array(
 'ServerName'	 => 'NirvanaRO',
 // Global database configuration (excludes logs database configuration).
 'DbConfig'	   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  //'Encoding'   => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'ragnarok',
  'Password'   => 'ragnarok',
  'Database'   => 'ragnarok1',
  'Persistent' => true,
  'Timezone'   => null // Example: '+0:00' is UTC.
  // The possible values of 'Timezone' is as documented from the MySQL website:
  // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
  // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
  // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
 ),
 // This is kept separate because many people choose to have their logs
 // database accessible under different credentials, and often on a
 // different server entirely to ensure the reliability of the log data.
 'LogsDbConfig'   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  //'Encoding'   => null, // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'ragnarok',
  'Password'   => 'ragnarok',
  'Database'   => 'log',
  'Persistent' => true,
  'Timezone'   => null // Possible values is as described in the comment in DbConfig.
 ),
 // Login server configuration.
 'LoginServer'	=> array(
  'Address'  => '127.0.0.1',
  'Port'	 => 7024,
  'UseMD5'   => false,
  'NoCase'   => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
  'GroupID'  => 0,	// Default account group ID during registration.
  'Database' => 'ragnarok1'
 ),
 'CharMapServers' => array(
  array(
'ServerName'	=> 'ragnarok1',
'BaseExpRates'  => 200,
'JobExpRates'   => 200,
'MvpExpRates'   => 200,
'DropRates'	 => 25,
'MvpDropRates'  => 25,
'CardDropRates' => 25,
'MaxCharSlots'  => 9,
'DateTimezone'  => null,	   // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
//'ResetDenyMaps' => 'sec_pri',  // Defaults to 'sec_pri'. This value can be an array of map names.
'Database'	  => 'ragnarok1', // Defaults to DbConfig.Database
'CharServer'	=> array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7025
),
'MapServer'	 => array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7026
)
  ),
  array(
'ServerName'	=> 'ragnarok2',
'BaseExpRates'  => 200,
'JobExpRates'   => 200,
'MvpExpRates'   => 200,
'DropRates'	 => 25,
'MvpDropRates'  => 25,
'CardDropRates' => 25,
'MaxCharSlots'  => 9,
'DateTimezone'  => null,	   // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
//'ResetDenyMaps' => 'sec_pri',  // Defaults to 'sec_pri'. This value can be an array of map names.
'Database'	  => 'ragnarok2', // Defaults to DbConfig.Database
'CharServer'	=> array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7028
),
'MapServer'	 => array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7029
),
// -- WoE days and times --
// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
// Second parameter: Starting hour in 24-hr format.
// Third paramter: Ending day (possible value is same as starting day).
// Fourth (final) parameter: Ending hour in 24-hr format.
// ** (Note, invalid times are ignored silently.)
'WoeDayTimes'   => array(
 //array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
 //array(3, '14:00', 3, '15:00')  // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
),
// Modules and/or actions to disallow access to during WoE.
'WoeDisallow'   => array(
 array('module' => 'character', 'action' => 'online'),  // Disallow access to "Who's Online" page during WoE.
 array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
)
  )
 )
)
);
?>

I dunno why the video shows up like that so here is the link:-

http://www.paradox924x.com/stuff/screencasts/multiple_charmap_servers.swf

Edited by Emistry
Use CODEBOX for long contents.
Link to comment
Share on other sites

6 answers to this question

Recommended Posts

Brynner Metaling

Brynner

Posted
  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  
Posted

Ok so i have two servers that share 1 login server that is ragnarok1 and ragnarok2. I use this guide [media=]http://www.paradox924x.com/stuff/screencasts/multiple_charmap_servers.swf[/media] to make it work but it have a little problem in that. If i choose to view characters from ragnarok1 database, there is no problem but if i choose to view characters from ragnarok2 database the site show unauthorized access. It means i cant view it, cant modify it, i cant use the reset look function and so on. On admin level, it says no such character was found although it has the list and the char ID was correct. So, anyone has experience on this kind of problem?

p/s: my login table was in ragnarok1 database.

here is my servers.php:-

<?php
return array(
// Example server configuration. You may have more arrays like this one to
// specify multiple server groups (however they should share the same login
// server whilst they are allowed to have multiple char/map pairs).
array(
 'ServerName'	 => 'NirvanaRO',
 // Global database configuration (excludes logs database configuration).
 'DbConfig'	   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  //'Encoding'   => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'ragnarok',
  'Password'   => 'ragnarok',
  'Database'   => 'ragnarok1',
  'Persistent' => true,
  'Timezone'   => null // Example: '+0:00' is UTC.
  // The possible values of 'Timezone' is as documented from the MySQL website:
  // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
  // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
  // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
 ),
 // This is kept separate because many people choose to have their logs
 // database accessible under different credentials, and often on a
 // different server entirely to ensure the reliability of the log data.
 'LogsDbConfig'   => array(
  //'Socket'	 => '/tmp/mysql.sock',
  //'Port'	   => 3306,
  //'Encoding'   => null, // Connection encoding -- use whatever here your MySQL tables collation is.
  'Convert'	=> 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
  'Hostname'   => 'localhost',
  'Username'   => 'ragnarok',
  'Password'   => 'ragnarok',
  'Database'   => 'log',
  'Persistent' => true,
  'Timezone'   => null // Possible values is as described in the comment in DbConfig.
 ),
 // Login server configuration.
 'LoginServer'	=> array(
  'Address'  => '127.0.0.1',
  'Port'	 => 7024,
  'UseMD5'   => false,
  'NoCase'   => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
  'GroupID'  => 0,	// Default account group ID during registration.
  'Database' => 'ragnarok1'
 ),
 'CharMapServers' => array(
  array(
'ServerName'	=> 'ragnarok1',
'BaseExpRates'  => 200,
'JobExpRates'   => 200,
'MvpExpRates'   => 200,
'DropRates'	 => 25,
'MvpDropRates'  => 25,
'CardDropRates' => 25,
'MaxCharSlots'  => 9,
'DateTimezone'  => null,	   // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
//'ResetDenyMaps' => 'sec_pri',  // Defaults to 'sec_pri'. This value can be an array of map names.
'Database'	  => 'ragnarok1', // Defaults to DbConfig.Database
'CharServer'	=> array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7025
),
'MapServer'	 => array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7026
)
  ),
  array(
'ServerName'	=> 'ragnarok2',
'BaseExpRates'  => 200,
'JobExpRates'   => 200,
'MvpExpRates'   => 200,
'DropRates'	 => 25,
'MvpDropRates'  => 25,
'CardDropRates' => 25,
'MaxCharSlots'  => 9,
'DateTimezone'  => null,	   // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
//'ResetDenyMaps' => 'sec_pri',  // Defaults to 'sec_pri'. This value can be an array of map names.
'Database'	  => 'ragnarok2', // Defaults to DbConfig.Database
'CharServer'	=> array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7028
),
'MapServer'	 => array(
 'Address'   => '127.0.0.1',
 'Port'	  => 7029
),
// -- WoE days and times --
// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
// Second parameter: Starting hour in 24-hr format.
// Third paramter: Ending day (possible value is same as starting day).
// Fourth (final) parameter: Ending hour in 24-hr format.
// ** (Note, invalid times are ignored silently.)
'WoeDayTimes'   => array(
 //array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
 //array(3, '14:00', 3, '15:00')  // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
),
// Modules and/or actions to disallow access to during WoE.
'WoeDisallow'   => array(
 array('module' => 'character', 'action' => 'online'),  // Disallow access to "Who's Online" page during WoE.
 array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
)
  )
 )
)
);
?>

I dunno why the video shows up like that so here is the link:-

http://www.paradox924x.com/stuff/screencasts/multiple_charmap_servers.swf

what do you want to do?one login but 2 charmap just like this?

post-1381-0-66103700-1344687259_thumb.jpg

post-1381-0-88733600-1344687266_thumb.jpg

Link to comment
Share on other sites
Feistz Poring

Feistz

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  
  • Author
Posted

@Brynner

Yes, exactly and it worked but when I tried to view the character on the second server, it wont show up. It says unauthorized access.

Link to comment
Share on other sites
Brynner Metaling

Brynner

Posted
  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  
Posted

maybe it was a database problem?

'Database' => 'ragnarok1'

make sure you put your 2nd database.

Link to comment
Share on other sites
Feistz Poring

Feistz

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  
  • Author
Posted

Can you specify where to put that?

Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

Hmm.. I can't reproduce - it works fine for me. Looking at your configuration, it should be fine as well o_o;

Link to comment
Share on other sites
Feistz Poring

Feistz

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  
  • Author
Posted

Didnt work even after i tried re-install everything cleanly :( Help please!

SOLVED! Thanks Xantara for the help. It seems like i must import item_db and mob_db sql in both databases :)

Link to comment
Share on other sites
 Share
Go to question listing
×
×
  • Create New...