一 服务器硬件环境
1. 至少需要5台linux服务器与1台Windows Server 2003 服务器才能达到环境要求
配置为CPU PD 2.8双核 2G内存以上(最低要求).
2. 服务器需要安装2张网卡,一张网卡接入外网.一张网卡与内网连通.内网均接到同一交换机下.
3. 关于对硬盘的要求.如果玩家上线超过千人.建议更换SCSI 万转硬盘.以防数据交互时丢失导致回挡.
4.架设请注明版权：稀有私服吧www.xy458.com（不要脸的请勿架设）
二 服务器及配置
1. Linux服务器安装Redhat5 X86.安装所有开发包关联与中文支持.Windows 2003服务器安装企业版就可以.没什么特别的要求.
2.Linux服务器分别命名为tlbb-gameserver tlbb-gameserver1 tlbb-gameserver2 tlbb-worldserver tlbb-billserver 内网IP分别设置为172.16.1.2 172.16.1.3 172.16.1.4 172.16.1.5 172.16.1.6 并将SSH端口监听到内网网卡上. tlbb-gameserver----worldserver 需要安装如下软件:
mysql-connector-odbc-3.51.12-1
mysqlclient10-3.23.58-4
MySQL-client-standard-5.0.27
UnixOdbc
Tlbb-billserver 需要安装如下软件:
Oracle10g-Client
MySQL-server-standard-5.0.27
Windows 服务器安装Mssql2000 Oracle10g mysql-connector-odbc-3.51
内网IP设置为172.16.1.1
三 服务端的架设及配置
1. 将tlbbfiles.tar.gz分别传到172.16.1.2~172.16.1.6 Billing.tar.gz 传到172.16.1.6
2. 先将tlbb.dmp 与tl_gameuser.dmp 还原到oracle数据库.在还原数据库之前.先在oracle创建3个帐户.
--创建用户
create user tlbb IDENTIFIED BY JC4KQO1EJP;
create user tl_gameuser IDENTIFIED BY S0DHRFZVZ5;
create user tlbb_read IDENTIFIED BY JC4KQO1EJP;
--设置角色权限与系统权限
-- Grant/Revoke role privileges
grant connect to TLBB;
grant resource to TLBB;
-- Grant/Revoke system privileges
grant alter session to TLBB;
grant create cluster to TLBB;
grant create database link to TLBB;
grant create sequence to TLBB;
grant create session to TLBB;
grant create synonym to TLBB;
grant create table to TLBB;
grant create view to TLBB;
另外两个帐户也是同样的设置
Imp tlbb/JC4KQO1EJP@ora10g file=G:\tlbb\files\Db\tlbb.dmp ignore=y --导入tlbb.dmp
Imp tl_gameuser/S0DHRFZVZ5@ora10g file=G:\tlbb\files\Db\tl_gameuser.dmp ignore=y --导入tl_gameuser.dmp
导入完成之后用pl/sql以system用户登陆上去.将tl_gameuser.userbasic授予tlbb用户的访问.如图1
然后设置tlbb用户的对象权限.如图2
并将tlbb用户Procedures下带有红X的储存过程重新编译一下.如图3
帐户数据库弄好后.开始导入游戏数据库及统计数据库.用SQLyog以root连接,建立tlbbdb.将DBInit_0_9_0020_mysql.sql导入此库即可.然后设置帐户及拥有的权限.tlbbdb_stat.sql操作和上面一样.
--建立帐户tlbb tlbbtools
use mysql;
insert into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) value (172.16.%.%, tlbb, *C6F4E3C4123F5707129F96C63E488D268C89C1CA, Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,,,,,0,0,0,0);
insert into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) value (172.16.%.%, tlbbtools, *70851F21ECE641B52D5B9946950566EB08C935DA, Y,Y,Y,Y,N,Y,N,N,N,N,N,Y,Y,N,N,N,Y,N,Y,N,N,Y,Y,N,N,N,,,,,0,0,0,0);
--设置访问权限
insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( 172.16.%.%, tlbbdb,tlbb, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y);
insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( 172.16.%.%, tlbbdb,tlbbtools, Y, Y, Y, Y, N, Y, N, Y, Y, N, Y, N, Y, Y, N, N, Y);
insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( 172.16.%.%, tlbbdb_stat,tlbb, Y, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N);
3. 在tlbb-billserver /home 目录建立tlbb文件夹.并将billing.tar.gz解压到此文件里.
4. 更改/home/tlbb/etc下gbs.conf db_hash.conf host.lst这三个文件里的IP,及oracle连接信息.需要更改的项如下
db_hash.conf 文件
#散列数量：
HASHING_NUM = 1
#散列表0：
MAXDBCONNS0 = 5
DBUSER_DB0 = tlbb
DBPASS_DB0 = JC4KQO1EJP
DBTNS_DB0 = ora10g ;这里为oracle的TNSname,在tnsnames.Ora文件里查找.
gbs.conf 文件
MAXDBCONNS_BILL = 20
DBUSER_GAMEBILL = tlbb
DBPASS_GAMEBILL = JC4KQO1EJP
DBTNS_GAMEBILL = ora10g
#
MAXDBCONNS_AUTH = 20
DBUSER_GAMEAUTH = tl_gameuser # for userbasic
DBPASS_GAMEAUTH = S0DHRFZVZ5
DBTNS_GAMEAUTH = ora10g
host.lst 文件
x.x.x.x --world服务的外网IP
172.16.1.5 --world服务的内网IP
4. 设置oracle客户端的tnsnames.ora 将oracle服务名改为ora10g host改为172.16.1.1 更改后如下
ORA10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
)
)
5. 启动billing服务 ./tlbb start 如果出现**************draw information end************ 的字样就表示启动成功了
返回网站首页 返回文章列表
