Information about Server TLBB Soho

[cabalviet]

Tianlongbabu game set up documentation
A server hardware environment

1. Need at least 5 linux server and a Taiwan Windows Server 2003 servers to achieve the environmental requirements
Configured to dual-core CPU PD 2.8 more than 2 G memory (minimum).
2. Server need to install two card, a card access, network. And a card within the network connectivity. Within the network have received under the same switch.
With regard to the requirements of the hard drive. If more than 1,000 players on the line. SCSI million proposal to replace the hard drive. To prevent data loss caused to cross at the block.
The server and configuration

1. Linux server installation Redhat5 X86. Install all packages associated with the development of Chinese language support. Windows 2003 Server Enterprise Edition can be installed. Nothing special requirements.
2.Linux servers were named tlbb-gameserver tlbb-gameserver1 tlbb-gameserver2 tlbb-worldserver tlbb-billserver within the IP network were set to 172.16.1.2 172.16.1.3 172.16.1.4 172.16.1.5 172.16.1.6 and SSH port to monitor On the network card. Tlbb-gameserver ---- worldserver need to install the software are as follows:


mysql-connector-odbc-3.51.12-1
mysqlclient10-3.23.58-4
MySQL-client-standard-5.0.27
UnixOdbc

Tlbb-billserver need to install the software are as follows:

Oracle10g-Client
MySQL-server-standard-5.0.27

Windows server installation Mssql2000 Oracle10g mysql-connector-odbc-3.51
Within the IP network is set to 172.16.1.1

3 services side of the building and configuration

1. Tlbbfiles.tar.gz will be conveyed to the respective 172.16.1.2 ~ 172.16.1.6 Billing.tar.gz reached 172.16.1.6
2. Tl_gameuser.dmp first tlbb.dmp and revert to oracle database. Reduction in the database before. Oracle created in the first three accounts.
-- Create user
create user tlbb IDENTIFIED BY JC4KQO1EJP;
create user tl_gameuser IDENTIFIED BY S0DHRFZVZ5;
create user tlbb_read IDENTIFIED BY JC4KQO1EJP;
-- Settings and roles that allow access system
-- 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;

The other two are the same account set up

Imp tlbb/JC4KQO1EJP @ ora10g file = G: \ tlbb \ files \ Db \ tlbb.dmp ignore = y - Import tlbb.dmp

Imp tl_gameuser/S0DHRFZVZ5 @ ora10g file = G: \ tlbb \ files \ Db \ tl_gameuser.dmp ignore = y - Import tl_gameuser.dmp

After the import is complete with pl / sql to boost landing system users. Tl_gameuser.userbasic will be granted tlbb users visit. Figure 1



Tlbb users and set the target of competence. Figure 2

Procedures and tlbb users with a red X under the process of compiling the store. Figure 3


After the account database Nonghao. Games begin importing the database and statistical databases. SQLyog to root connection with the establishment tlbbdb. DBInit_0_9_0020_mysql.sql import this library will be. And then set up an account owned by the authority. Tlbbdb_stat.sql operation and Like the above.

-- Create an account 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);

-- Set up access
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 directory of the establishment of tlbb folder. Billing.tar.gz and extract this document.
4. Change / home / tlbb / etc under gbs.conf db_hash.conf host.lst these three documents in the IP, and oracle connection information. Need to change the items are as follows

db_hash.conf documents
# Hash:
HASHING_NUM = 1

# 0 casual list:
MAXDBCONNS0 = 5
DBUSER_DB0 = tlbb
DBPASS_DB0 = JC4KQO1EJP
DBTNS_DB0 = ora10g; here for the oracle of TNSname, in tnsnames.Ora document View.
gbs.conf documents
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 documents
x.x.x.x - world IP network services,
172.16.1.5 - world of services within the IP network

4. Settings oracle client tnsnames.ora oracle will be ora10g host of services to 172.16.1.1 changes are as follows

ORA10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.1.1) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
)
)
5. Activated billing services. / Tlbb start if there is ************** draw information end ************ on the words that launched successful, in Figure 4



6. Server configuration world. Tlbbfiles.tar.gz to be / home changes / home / tlbb / Server / Config under the ServerInfo.ini ShareMemInfo.ini LoginInfo.ini this three documents.

ServerInfo.ini

[System]
Desc0 = function: server-side configuration of the relevant procedures;
Desc1 = IP0, Port0 refers to the network address and port;
Desc2 = IP1, Port1 refers to the network address and port;
Desc3 = Type: Game = 0; Login = 1;

; Current server ID, (0,1,3,0 According to the server)
CurrentServerID = 0
; Current game world the number of server-side program
ServerNumber = 4

[Mother]
IP = x.x.x.x; set up to the windows server, IP network
Port = 1014

[World]
IP = x.x.x.x; set to the outside world IP network
Port = 777

[Billing]
; Configuration can try to connect the number of billing
Number = 1
; The default connection billing of IP
IP0 = x.x.x.x; set to billing services, IP network
; The default connection billing the ports
Port0 = 15680
IP1 = 0.0.0.0
Port1 = 10101
IP2 = 0.0.0.0
Port2 = 10101
IP3 = 0.0.0.0
Port3 = 10101
IP4 = 0.0.0.0
Port4 = 10101

[Proxy]
; Responsible for Netcom subscribers to its telecommunications network within the proxy server IP (exposed to the game server's IP)
Proxy0ForCncUser = x.x.x.x
; Proxy1ForCncUser = 0.0.0.0
; Responsible for telecommunications users access Netcom's proxy server, network IP (exposed to the game server's IP)
Proxy0ForCtcUser = 0.0.0.0
; Proxy1ForCtcUser = 0.0.0.0
; Education network from the proxy server from the article to a telecommunications link export agent
Proxy0ForEduUser = x.x.x.x
; Proxy1ForEduUser = 0.0.0.0

[Server0]
; Game server side,
ServerID = 0
; This game server side of the server,
MachineID = 0
; Outside the network IP addresses, and with client
IP0 = x.x.x.x; tlbb-gameserver the IP network,
; Outside the network port
Port0 = 3731
; Within the network IP addresses, use and inter-connected server side
IP1 = 172.16.1.2
; Within the network port
Port1 = 8880
; Types of server-side procedures, such as: GameServer, LoginServer
Type = 0
; Netcom's proxy server IP, the agent filled out OUT-IP connection is the agent of IP audience
IP (CNC) = x.x.x.x
; Netcom's proxy server port
Port (CNC) = 1000
; Telecom's proxy server IP
IP (CTC) = 0.0.0.0
; Telecom's proxy server port
Port (CTC) = 0
Education Network proxy server IP
IP (EDU) = x.x.x.x
Education Network proxy server port
Port (EDU) = 1000
; ShareMemory shared Key
HumanSMKey = 1001
; Stores sharing Key players
PlayShopSMKey = 4001
; Item serial number
ItemSerialKey = 7001
CommisionShopKey = 6001
EnableShareMem = 1

[Server1]
ServerID = 1
MachineID = 1
IP0 = x.x.x.x; tlbb-gameserver1 the IP network,
Port0 = 3732
IP1 = 172.16.1.3
Port1 = 8881
Type = 0
IP (CNC) = x.x.x.x
Port (CNC) = 1000
IP (CTC) = 0.0.0.0
Port (CTC) = 0
IP (EDU) = x.x.x.x
Port (EDU) = 1000
HumanSMKey = 1002
PlayShopSMKey = 4002
ItemSerialKey = 7002
CommisionShopKey = 6002
EnableShareMem = 1

[Server2]
ServerID = 2
MachineID = 3
IP0 = xxxx; Login services outside the network IP. And the world the same IP
Port0 = 7377
IP1 = x.x.x.x; Ibid.
Port1 = 8882
Type = 1
IP (CNC) = x.x.x.x
Port (CNC) = 1000
IP (CTC) = 0.0.0.0
Port (CTC) = 0
IP (EDU) = x.x.x.x
Port (EDU) = 1000
HumanSMKey = 1003
PlayShopSMKey = 4003
ItemSerialKey = 7003
CommisionShopKey = 6003
EnableShareMem = 0

[Server3]
ServerID = 3
MachineID = 2
IP0 = x.x.x.x; tlbb-gameserver2 the IP network,
Port0 = 3734
IP1 = 172.16.1.4
Port1 = 8883
Type = 0
IP (CNC) = x.x.x.x
Port (CNC) = 1000
IP (CTC) = 0.0.0.0
Port (CTC) = 0
IP (EDU) = x.x.x.x
Port (EDU) = 1000
HumanSMKey = 1003
PlayShopSMKey = 4003
ItemSerialKey = 7003
CommisionShopKey = 6003
EnableShareMem = 1


ShareMemInfo.ini
[System]
DBIP = 172.16.1.6; database ip
DBPort = 3306; database port
DBName = tlbbdb; database name
DBUser = tlbb; user name
DBPassword = t! Lbb; password
SMUInterval = 1200000; world data archiving time (ms)
DATAInterval = 900000; Human data archiving time (ms)
CryptPwd = 0; password encryption, is an encryption, is not encrypted 0

[ShareMem]
KeyCount = 5; ShareObj number
Key0 = 2001; a key section of the code
Type0 = 2; HumanSMU type 1
Key1 = 3001
Type1 = 3
Key2 = 8001
Type2 = 8
Key3 = 9001
Type3 = 9
Key4 = 5001
Type4 = 5

LoginInfo.ini


[System]
LoginID = 2; current Login server side of the LoginID
DBIP = 172.16.1.6
DBPort = 3306
DBName = tlbbdb
DBUser = tlbb
DBPassword = t! Lbb
ClientVersion = 1005
DBConnectCount = 10
TurnPlayerCount = 100
CryptPwd = 0; password plus »
EnableProxyConnect = 0


7. Configuration odbc.ini and odbcinst.ini, here is very important. Please follow the allocation of reference are as follows

odbc.ini
[tlbbdb]
Driver = / usr/lib/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = 172.16.1.6
PORT = 3306
USER = tlbb
Password = t! Lbb
Database = tlbbdb
OPTION = 3
SOCKET =

odbcinst.ini
# Example driver definitinions
#
#

# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = / usr / lib / libodbcpsql.so
Setup = / usr / lib / libodbcpsqlS.so
FileUsage = 1


# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = / usr/lib/libmyodbc3.so
Setup = / usr / lib / libodbcmyS.so
FileUsage = 1

After the preservation OK. Settings $ LD_LIBRARY_PATH.
export LD_LIBRARY_PATH = / home / tlbb / Server: $ LD_LIBRARY_PATH
And edit / etc / profile into the preservation of the above.

8. Testing services start normal, cd / home / tlbb / Server. / Shm start if the mistakes of the service will be automatically suspended. Log, please see the log files to debug.
9. Shm start no problem and it will run.sh stop.sh reached the root folder. To start. Activated upon completion. Ps-ex to see whether there is a process. Figure 5



In order to determine the successful launch services, telnet 172.16.1.5 777 7377 even if the OK on that. This time should check whether the billing services to receive Login service response. Server to the bill. / Tlbb list

If you do not show the Login IP services and the number of services that World host.lst configuration problems. Please check log folder gbs-xx.log debugging.

10. World server configuration is next after the completion of Game server configuration. Configuration is basically configured with almost the World. ServerInfo.ini ShareMemInfo.ini need to change the two documents. Server directly to the World copies of two documents from coverage. Then a few of the changes are as follows

ServerInfo.ini
This document do not have to change. If it is tlbb-gameserver1 on the need to change.
; Current server ID, (0,1,3,0 According to the server)
CurrentServerID = 0; unchanged here. If it is tlbb-gameserver1, on the need to set to 1, according to ServerID = X may be.

ShareMemInfo.ini

[ShareMem]
KeyCount = 4; ShareObj number
Key0 = 1001; a key section of the code
Type0 = 1; HumanSMU type 1
Key1 = 4001
Type1 = 4
Key2 = 7001
Type2 = 7
Key3 = 6001
Type3 = 6
This is in accordance with ServerInfo.ini settings.

odbc.ini and odbcinst.ini such as the above-mentioned settings, not repeat them.

First start. / Shm start to see if normal.'s Remarks on the normal. / Shm stop and run.sh and stop.sh reached ROOT folder running. / Run.sh unless they re-ps-ex process, in Figure 8



Telnet port services to the game. Can even prove that nothing on the issue. Another two servers set up and this almost. The only difference is that ServerInfo.ini ShareMemInfo.ini document settings. Above have already said that the method set up. Will not repeat .
11. WINDOWS on the Sohu in this folder to extract the C-. Restore the database. GTOOL to those under the folder configuration information. Were initiated it.

[kenjidraw]

bác dùng language tool của google để dịch hả?

天龙八部游戏架设说明文档
一服务器硬件环境

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-gameservertlbb-gameserver1tlbb-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
[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif[/IMG]


然后设置tlbb用户的对象权限.如图2
[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image004.gif[/IMG]
并将tlbb用户Procedures下带有红X的储存过程重新编译一下.如图3
[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image006.gif[/IMG]

帐户数据库弄好后.开始导入游戏数据库及统计数据库.用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.1WIN机IP 更改后如下

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************ 的字样就表示启动成功了,如图4

[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image008.gif[/IMG]

6. 配置world服务器.将tlbbfiles.tar.gz到/home 更改/home/tlbb/Server/Config下的ServerInfo.ini ShareMemInfo.ini LoginInfo.ini 这3个文件.

ServerInfo.ini

[System]
Desc0=功能：配置服务器端程序的相关情况� �
Desc1=IP0、Port0指外网的地址和端口；
Desc2=IP1、Port1指内网的地址和端口；
Desc3=Type：Game=0；Login=1；

;当前服务器ID，（0，1，3，0根据服务器定）
CurrentServerID=0
;当前游戏世界的服务器端程序数量
ServerNumber=4

[Mother]
IP=x.x.x.x ;设置为windows服务器的外网IP
Port=1014

[World]
IP=x.x.x.x ;设置为world的外网IP
Port=777

[Billing]
;配置可以尝试连接的billing数量
Number=1
;默认的连接billing的IP
IP0=x.x.x.x ;设置为billing服务的外网IP
;默认的连接billing的连接端口
Port0=15680
IP1=0.0.0.0
Port1=10101
IP2=0.0.0.0
Port2=10101
IP3=0.0.0.0
Port3=10101
IP4=0.0.0.0
Port4=10101

[Proxy]
;负责网通用户接入电信的代理服务器� �网IP（暴露给游戏服务器的IP）
Proxy0ForCncUser= x.x.x.x
;Proxy1ForCncUser=0.0.0.0
;负责电信用户接入网通的代理服务器� �网IP（暴露给游戏服务器的IP）
Proxy0ForCtcUser=0.0.0.0
;Proxy1ForCtcUser=0.0.0.0
;从教育网代理服务器过来的连接转发� �电信代理出口
Proxy0ForEduUser= x.x.x.x
;Proxy1ForEduUser=0.0.0.0

[Server0]
;游戏服务器端程序号
ServerID=0
;此游戏服务器端程序所在的服务器号
MachineID=0
;外网IP地址，用与客户端连接
IP0=x.x.x.x ;tlbb-gameserver 的外网IP
;外网端口
Port0=3731
;内网IP地址，用与服务器端程序间连接
IP1=172.16.1.2
;内网端口
Port1=8880
;服务器端程序类型，如：GameServer，LoginServer
Type=0
;网通的代理服务器IP，这个填写代理OUT-IP就是玩家连接的代理IP
IP(CNC)= x.x.x.x
;网通的代理服务器端口
Port(CNC)=1000
;电信的代理服务器IP
IP(CTC)=0.0.0.0
;电信的代理服务器端口
Port(CTC)=0
;教育网的代理服务器IP
IP(EDU)= x.x.x.x
;教育网的代理服务器端口
Port(EDU)=1000
;ShareMemory共享Key
HumanSMKey=1001
;玩家商店共享Key
PlayShopSMKey=4001
;物品序号
ItemSerialKey=7001
CommisionShopKey=6001
EnableShareMem=1

[Server1]
ServerID=1
MachineID=1
IP0=x.x.x.x ;tlbb-gameserver1 的外网IP
Port0=3732
IP1=172.16.1.3
Port1=8881
Type=0
IP(CNC)= x.x.x.x
Port(CNC)=1000
IP(CTC)=0.0.0.0
Port(CTC)=0
IP(EDU)= x.x.x.x
Port(EDU)=1000
HumanSMKey=1002
PlayShopSMKey=4002
ItemSerialKey=7002
CommisionShopKey=6002
EnableShareMem=1

[Server2]
ServerID=2
MachineID=3
IP0=x.x.x.x ;Login服务的外网IP.与world的IP相同
Port0=7377
IP1=x.x.x.x ;同上
Port1=8882
Type=1
IP(CNC)= x.x.x.x
Port(CNC)=1000
IP(CTC)=0.0.0.0
Port(CTC)=0
IP(EDU)= x.x.x.x
Port(EDU)=1000
HumanSMKey=1003
PlayShopSMKey=4003
ItemSerialKey=7003
CommisionShopKey=6003
EnableShareMem=0

[Server3]
ServerID=3
MachineID=2
IP0=x.x.x.x ;tlbb-gameserver2 的外网IP
Port0=3734
IP1=172.16.1.4
Port1=8883
Type=0
IP(CNC)= x.x.x.x
Port(CNC)=1000
IP(CTC)=0.0.0.0
Port(CTC)=0
IP(EDU)= x.x.x.x
Port(EDU)=1000
HumanSMKey=1003
PlayShopSMKey=4003
ItemSerialKey=7003
CommisionShopKey=6003
EnableShareMem=1


ShareMemInfo.ini
[System]
DBIP=172.16.1.6 ;数据库ip
DBPort=3306 ;数据库端口
DBName=tlbbdb ;数据库名称
DBUser=tlbb ;用户名
DBPassword=t!lbb ;密码
SMUInterval=1200000 ;world数据存盘时间（毫秒）
DATAInterval=900000 ;Human数据存盘时间(毫秒）
CryptPwd=0 ;密码是否加密,1是加密,0是不加密

[ShareMem]
KeyCount=5 ;ShareObj 个数
Key0=2001 ;第一个key的编号
Type0=2 ;HumanSMU类型 1
Key1=3001
Type1=3
Key2=8001
Type2=8
Key3=9001
Type3=9
Key4=5001
Type4=5

LoginInfo.ini


[System]
LoginID=2 ;当前Login服务器端程序的LoginID
DBIP=172.16.1.6
DBPort=3306
DBName=tlbbdb
DBUser=tlbb
DBPassword=t!lbb
ClientVersion=1005
DBConnectCount=10
TurnPlayerCount=100
CryptPwd=0 ;密码是否加?
EnableProxyConnect=0


7. 配置odbc.ini与odbcinst.ini,这里非常重要.请按照参考如下配置

odbc.ini
[tlbbdb]
Driver = /usr/lib/libmyodbc3.so
Description = MyODBC 3.51 Driver DSN
SERVER = 172.16.1.6
PORT = 3306
USER = tlbb
Password = t!lbb
Database = tlbbdb
OPTION = 3
SOCKET =

odbcinst.ini
# Example driver definitinions
#
#

# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1


# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1

保存OK后.设置$LD_LIBRARY_PATH.
export LD_LIBRARY_PATH=/home/tlbb/Server:$LD_LIBRARY_PATH
并编辑/etc/profile 写入以上内容保存.

8. 测试服务启动是否正常,cd /home/tlbb/Server ./shm start 如果出错了服务会自动中止.请查看Log里的日志文件进行调试.
9. shm启动没问题的话就将run.sh和stop.sh 传到root文件夹下.进行启动.启动完成后.ps -ex 看进程是否存在着.如图5

[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image010.gif[/IMG]

为了确定服务启动成功,telnet 172.16.1.5 777 7377 如能连上就表示OK了.这时候应该查看billing服务是否接收到Login服务的响应.到bill服务器./tlbb list

如果没显示出Login服务的IP及World服务的编号说明host.lst配置有问题.请查看log文件夹中gbs-x-x.log进行调试.

10. World服务器配置完成后接下来就是Game服务器的配置.配置基本上跟World的配置差不多.需要更改ServerInfo.ini ShareMemInfo.ini 这两个文件.可直接将World服务器的这两个文件拷贝过来覆盖.然后更改如下几个项

ServerInfo.ini
这个文件不用更改.如果是tlbb-gameserver1就需要更改.
;当前服务器ID，（0，1，3，0根据服务器定）
CurrentServerID=0 ;这里不变.如果是tlbb-gameserver1,就需要设置为1,按ServerID=X 而定.

ShareMemInfo.ini

[ShareMem]
KeyCount=4 ;ShareObj 个数
Key0=1001 ;第一个key的编号
Type0=1 ;HumanSMU类型 1
Key1=4001
Type1=4
Key2=7001
Type2=7
Key3=6001
Type3=6
这里是根据ServerInfo.ini设置的.

odbc.ini和odbcinst.ini 如上面所说的设置,不再赘述.

先启动./shm start 看看是否正常.正常的话就./shm stop 并将run.sh 和stop.sh传到ROOT文件夹运行./run.sh 再ps -ex看下进程情况,如图8

[IMG]file:///C:/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/msohtml1/01/clip_image012.gif[/IMG]

再telnet游戏服务端口.能连上就证明没什么问题了.另外两台服务器设置和这个差不多.唯一区别就是ServerInfo.ini ShareMemInfo.ini文件的设置.上面已经说过设置方法了.不再赘述.
11. 在WINDOWS上把Sohu这个文件夹解压到C盘.还原数据库.改GTOOL下文件夹的那些配置信息.依次启动就可以了

[minhvuong]

Đọc qua cũng có hiểu đôi chút nhưng cái đoạn cài Linux hay dùng Unix thì pó hand rồi,chưa xài HĐH này bao h,toàn dùng của bác Gate

[GamesVN]

cái này là hướng dẫn cài đạt server TLBB off à
nhưng sao hông có link down vậy
co link thì share đi bạn ơi để mình về cài thử ^^!