[dead] My guides + databases + server files repack -V2!

Death__ · 09-26-2008, 10:56 AM

Chumpy im using no-ip system to connect to cabal server but the problem is my other pc in my lan network cant connect it just keep on loading at the login screen, while my frend outside my place can do connect but only up to the channel selection part they cant make it inside they say it just keep on loading... What could I be missing here? I think I did my portforwarding right on my speedstream 4200? Any advice pls?

**chumpywumpy** · 09-26-2008, 12:20 PM

It will be an IP configuration problem if neither external or lan players can get in.

In the server ini files (except odbc.ini) all ip addresses should be 127.0.0.1 and in WorldSvr_24_01.ini the IPAddress= and AddrForClient should both be your WAN IP address (whatismyip.com). When testing with a no-ip it would not work if i used the no-ip in the server configs i had to use an actual IP, though since then i foud a network problem which could have caused that so using the no-ip may or may not work.

B-Kill-K · 05:24 PM

I can`t make an account..."duplicate row":((

Code:

SQL error 80040E21
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
DB address: 127.0.0.1 (1433, false)
DB user: sa

cacalost · 09-26-2008, 06:14 PM

Thank U :)

pffboy · 09-26-2008, 06:23 PM

..when i try to install centos i have this error "No Drivers Found" any idea cause i select a driver`?!

**chumpywumpy** · 09-26-2008, 06:49 PM

@B-Kill-K - That is an error from my gm tools, not my server repack. It is an error i am trying to figure out though so post the db server os and whether you are running the tools from the db server or not on the gm tools topic (in my sig) as it will help me out a lot. It definitely isn't a permissions problem here as i thought it might be in some cases.

@pffboy - VMWare can do that if you choose the wrong Virtual Machine type when creating the VM. It must be a Linux VM with the latest "Red Hat" version.

pffboy · 09-26-2008, 07:08 PM

thx a lot chumy now its work:P

B-Kill-K · 09-26-2008, 08:25 PM

Well i got your server files..i just want to know how i can create an account:P

**chumpywumpy** · 09-26-2008, 08:39 PM

If the tools aren't working you will have to do it manually. Go into your account database and look for cabal_tool_registerAccount in the stored procedures folder, right-click it and Open and you can use this panel.

B-Kill-K · 09-26-2008, 09:37 PM

what should i chose from this list..couz i get a error when im trying to make an account
[Only Registered and Activated Users Can See Links. Click Here To Register...][Only Registered and Activated Users Can See Links. Click Here To Register...]

**chumpywumpy** · 09-26-2008, 10:26 PM

Choose "Execute stored procedure" and it should ask you for the user and pass. If it errors then post them ;)

BloodDrink3r · 09-27-2008, 07:27 AM

Need help!!
Error when i restore your database files!!

[Only Registered and Activated Users Can See Links. Click Here To Register...]

B-Kill-K · 09-27-2008, 07:49 AM

Code:

Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

This is strange,coz i put my id and password and when im trying to connect i wait 1 minute and then "conect failed try later" :(

pffboy · 09-27-2008, 08:33 AM

mm ..when i intstall the centos i have [Only Registered and Activated Users Can See Links. Click Here To Register...] and i have enough space in local driver,any idea?!Thx

**chumpywumpy** · 06:33 PM

@BloodDrink3r - You have some form of "devide authentication" error so i would check the permissions on the data folder it says as it might not have permission to create the database files. Make sure you are logging into SQL using your "sa" logon as ell to make sure you aren't getting premissions problems in SQL.

@B-Kill-K - You get that using the stored procedure?? It looks similar to the error you get when xp_md5 isn't working, but it isn't a password it is complaining about. Are you using a 64-bit computer for the database?

@pffboy - The virtual hard disk you created for your centos machine isn't big enough, it is 196Mb too small. You need around 3Gb for centos4 so delete your virtual hdd in vmware and make a bigger new one.

pffboy · 09-27-2008, 05:16 PM

chumpy for database work i need a 64-bit computer?cause my computer is not 64 bit.And when i finish the cemtos instalation it say "some other host uses the adress 89.146.36.1"
[Only Registered and Activated Users Can See Links. Click Here To Register...]

**chumpywumpy** · 09-27-2008, 06:35 PM

No, 32 bit is fine. That error means you are probably manually entering the ip in your network config which you cannot do as your windows computer (or anotther one) is using the IP. Leave your network settings on auto (DHCP) and it will pick up the settings it needs.

ivan junior · 09-27-2008, 11:56 PM

Login fix ?

Tierra Gloriosa fix ?

DC, NPC fix?

Thanks a lot's ;)

**cypher** · 09-28-2008, 08:40 AM

you should search not place other people to search for you!

**chumpywumpy** · 09-28-2008, 11:06 PM

It's still the 28th here in the UK and as promised v2 has just been added to the first post along with a new guide for it :rule:

Enjoy!

Quote: Originally Posted by V2 Changes

* Lots of comments added to various files at different points
* Modified the install process for less manual copying
* Added WAN IP detection to cabal_config.sh, hopefully solving some problems :/
* Added alternate method to cabal_install.sh for Centos 5 thanks to grasshoper
* You now get a choice about cron process restart support
* Server files now use SAUR0N's client synch data
* Added TG lobby wait and duration to cabal_config.sh
* Added warmap d/c thanks to fabby
* Added patched GlobalMgrSvr (+keyfiles) thanks to youyou
* Added LogLvl and Max Users to cabal_config.sh
* Made TG work using cabal_config.sh to switch configs
* Added multiconfig switch idea using gen_config2.sh

Note: If you don't use SAUR0N's client synch patch then keep your original const.scp and product.scp.

novacorp · 09-29-2008, 12:51 AM

At the end ... T_T thanks man uses what you spend you're a genius will be the first to acknowledge thanks ...

dedeku · 09-29-2008, 01:50 AM

finally, thanks chumpy

[Only Registered and Activated Users Can See Links. Click Here To Register...][Only Registered and Activated Users Can See Links. Click Here To Register...]

is that normal?

btw, im using Win Vista ultimate 64-bit for the database

novacorp · 09-29-2008, 02:37 AM

@ echo -ne "\nAre you installing on Centos 4? [Y] : ========> N ( Centos 5.2 ) ??
the question is whether I'm using 4.5 cents or 5.2 truth my serious response (N)

gpadmin · 09-29-2008, 06:51 AM

Thank you Chumpy for update! :)

Some special info for ppl who run atm your server v1 ? i mean how we can save update server?

Chump, you find workeble cash shop???

Thank you

Xcell · 09-29-2008, 08:18 AM

Quote: Originally Posted by gpadmin

Thank you Chumpy for update! :)

Some special info for ppl who run atm your server v1 ? i mean how we can save update server?

Chump, you find workeble cash shop???

Thank you

To update the server from V1, you need to backup your old \etc\cabal files, then put in the new ones, overwriting the old ones, then you need to just copy the /home/cabal files and overwrite them, but do not put in the ImageAuth file, as it is not needed and it is a big file.