[ Release ] Server Files Fixed!

07/12/2012 16:40 axelcro#61
Short tutorial forMSSQL 2008:

Download: [Only registered and activated users can see links. Click Here To Register...]

When install select SQL Authentication mode and set password.

When installation finished open Server Managment Studio, login with your password, create a database called "boi". Right click on database and select Restore database. > Restore db from file > point the .bak file which is in the server files/ mssql folder. After u've restored rename the database to "PassportBoi".
07/12/2012 17:36 yueyue4567#62
Can provide supporting clients to download address thank you very much!~!!!
07/12/2012 17:52 axelcro#63
Quote:
Originally Posted by yueyue4567 View Post
Can provide supporting clients to download address thank you very much!~!!!
Quote:
[Only registered and activated users can see links. Click Here To Register...]
OR
Quote:
[Only registered and activated users can see links. Click Here To Register...]
07/12/2012 22:50 ZorroXXX#64
How do i make new account?
07/12/2012 23:38 joseus34#65
/etc Edit : table.xml add your microsoft db and config
07/13/2012 00:01 ZorroXXX#66
WHen i am running ./dbserver i get this
Quote:
run dir:../bin
07/13/2012 00:36 bluedev#67
How do I point my client to the test server?
How do I create an account to login?

I'm running the windows version.

Thanks
07/13/2012 00:53 LordMadara#68
btw: on which system is easier to set up. Linux or Windows ?
07/13/2012 01:09 ZorroXXX#69
You need to run on both.
07/13/2012 01:23 bloodyshade#70
I guess plenty of you guys still don't get it, it's not a windows and a linux version which you can simply choose from and run the server from that.
You gotta run both to have it actually working, each of those have different sub-servers that work together.

@ZorroXXX:
That is fine, it's just pointing out in which directory the script is running from.

@bluedev:
To point the client to the server just edit BOI Folder/Bin/ServerList.ini with something like:
Code:
node server normal WhateverNameYouWant 127.0.0.1 30002  1
No idea how to create the account correctly yet, you create it on PassportBOI..account, but I still couldn't get the password to work.

Btw, for those who don't frequent rz:

Quote:
Originally Posted by BloodyShade
Btw, I changed the scripts around a bit to make them actually accurate:

start.sh:
Code:
#!/bin/bash
cd /home/BOI/DBServer/bin
./dbserver&
sleep 2
cd /home/BOI/CardServer/bin
./cardsvrd&
sleep 2
cd /home/BOI/NameServer/bin
./namesvrd&
sleep 2
cd /home/BOI/gacd
./gacd io.conf&
sleep 2
cd /home/BOI/LogServer/bin
./logsrv&
sleep 2
cd /home/BOI/authd/build
./authd&
stop.sh:
Code:
#!/bin/bash
pkill -9 dbserver
pkill -9 cardsvrd
pkill -9 namesvrd
pkill -9 gacd
pkill -9 logsrv
pkill -9 java
Also remember to change /home/BOI/authd/build/authd:
Otherwise it will keep looping forever, and since it seems the java app doesn't close on failure (it will fail when relaunching because the port will already be in use from the first start), it will start eating memory until it makes the server unusable and will probably cause it to reboot due to a lack of memory (and eventually swap).
Code:
#!/bin/sh

java -cp ../lib/jio.jar:../lib/cache.jar:../lib/wanmeiaudb.jar:../lib/log4j-1.2.9.jar:../lib/jconn3.jar:../msSQLjdbc/lib/msbase.jar:../msSQLjdbc/lib/mssqlserver.jar:../msSQLjdbc/lib/msutil.jar:. authd /etc/table.xml &> authd.out
Hope that helps a bit, just need to figure out now how to insert the password correctly on PassportBOI..account :(
07/13/2012 01:46 LordMadara#71
~Linux part
You must logged as a /root user (super user)
copy the linux file into root folder
Run Terminal (Applications /System Tools/ Terminal)
tar -zxvf boi-linux.tar.gz
tar xvfz boi-linux.tar.gz
Click on Install.sh - Click Run
Now downloading 700mb :*(
Will keep posting with progress
----------------------------------------------------------------------------------------
Create Databases


ERROR 1007 (HY000) at line 1: Can't create database 'shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'empty_shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguiex'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'forbid'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguicard'; database exists

??? Need help with that one what i did wrong ?
07/13/2012 02:03 bloodyshade#72
Quote:
Originally Posted by LordMadara View Post
~Linux part
You must logged as a /root user (super user)
copy the linux file into root folder
Run Terminal (Applications /System Tools/ Terminal)
tar -zxvf boi-linux.tar.gz
tar xvfz boi-linux.tar.gz
Click on Install.sh - Click Run
Now downloading 700mb :*(
Will keep posting with progress
----------------------------------------------------------------------------------------
Create Databases


ERROR 1007 (HY000) at line 1: Can't create database 'shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'empty_shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguiex'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'forbid'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguicard'; database exists

??? Need help with that one what i did wrong ?
From the looks of it, you already ran the install_db.sh file, so it should be fine.
07/13/2012 02:21 LordMadara#73
How to config ip's in Linux (for Linux) and in Windows (For Windows)
[DBINFO]

DBUSER = root

DBNAME = shenguicard

DBPASSWD = game

DBSOCKFILE = /tmp/mysql.sock



[CARDSVRD]

SERVERID = 1

SERVICEIP = LINUX

SERVICEPORT =10080

CHECKINTERVAL = 6000

PRINTSTATINTERVAL = 300

ISAUTO = 1

ISENCRYPT = 0



[MANAGERSVRD]

MANAGERSVRDNUM = 1

[MANAGERSVRD.1]

SERVERID = 1

SERVICEIP = WINDOWS
07/13/2012 02:33 axelcro#74
In terminal: "yum install compat-libstdc++-33"


Ohh and u will get an error "Create-Database.sh No such file or directory".

How to fix that:

Get the old server files package.
Copy "createtab" folder from "old CardServer" folder to your NEW CardServer folder on linux.
Copy "db" folder from "old DBServer" folder to your NEW DBServer folder on linux.

Then:

Run a command in terminal: yum install dos2unix

cd /home/BOI/CardServer/createtab/

dos2unix createcardtable-beta1.sh
dos2unix create-database.sh

cd /home/BOI/DBServer/db/
dos2unix type all file names here in here in order etc: dos2unix create-database.sh (Yes i know there are many files:D Have fun)

Quote:
Originally Posted by LordMadara View Post
~Linux part
You must logged as a /root user (super user)
copy the linux file into root folder
Run Terminal (Applications /System Tools/ Terminal)
tar -zxvf boi-linux.tar.gz
tar xvfz boi-linux.tar.gz
Click on Install.sh - Click Run
Now downloading 700mb :*(
Will keep posting with progress
----------------------------------------------------------------------------------------
Create Databases


ERROR 1007 (HY000) at line 1: Can't create database 'shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'empty_shengui'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguiex'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'forbid'; database exists
ERROR 1007 (HY000) at line 1: Can't create database 'shenguicard'; database exists

??? Need help with that one what i did wrong ?
U followed wrong order. First u have to install "install.sh" then "install_db.sh"
07/13/2012 03:11 LordMadara#75
Quote:
Originally Posted by axelcro View Post
In terminal: "yum install compat-libstdc++-33"


Ohh and u will get an error "Create-Database.sh No such file or directory".

How to fix that:

Get the old server files package.
Copy "createtab" folder from "old CardServer" folder to your NEW CardServer folder on linux.
Copy "db" folder from "old DBServer" folder to your NEW DBServer folder on linux.

Then:

Run a command in terminal: yum install dos2unix

cd /home/BOI/CardServer/createtab/

dos2unix createcardtable-beta1.sh
dos2unix create-database.sh

cd /home/BOI/DBServer/db/
dos2unix type all file names here in here in order etc: dos2unix create-database.sh (Yes i know there are many files:D Have fun)



U followed wrong order. First u have to install "install.sh" then "install_db.sh"
is there way to fix it ?