Need some help/tips

[naruto820]

Hi Im veryy new to world of cabal servers but anyways im interested in making a server, took it as a challenge.

Anyways i have a dedi sitting and It has CentOS installed and in this forum Ive found some tutorials but none shows how to install on CentOS. Most of them have repacks taht includes a virtualization for CentOS but u need windows first. But is there any tutorial to make server without windows and without having to do it with VMware. Any tutorial that will show how to install on CentOS directly?

Please dont flame me, any help is appreciated.

Thanks.

 

[Yamachi]

Get Chumpy's 2.5 repack. It's in the stickies in the Release section. Also, you will either need virtualbox/vmware running MSSQL on CentOS, or a seperate Windows machine running MSSQL.

 

[naruto820]

yea i can do that as my dedicated is running CentOS as its main OS and i have another dedi where i have windows i can host the mssql db's from there but and host cabal from the Cent.

oh and 1 more question in the other pc where ill host the dbs i have another game running there which also uses a db called account, so can i rename cabal "account" db to something else?

 

[Yamachi]

yea i can do that as my dedicated is running CentOS as its main OS and i have another dedi where i have windows i can host the mssql db's from there but and host cabal from the Cent.

oh and 1 more question in the other pc where ill host the dbs i have another game running there which also uses a db called account, so can i rename cabal "account" db to something else?

Yes, but you'll need to change all references to the ACCOUNT database in the server files and DB

 

[chumpywumpy]

Yes, but you'll need to change all references to the ACCOUNT database in the server files and DB

Specifically /etc/odbc.ini on the centos machine and in the stored procedures in the DB (all of them that reference account.dbo.blah).

 

[naruto820]

ok changed the odbc.ini and i named the account db to account2 and in odc.ini renamed to that.

But not sure what to do with stored procedures.

 

[cypher]

the something must have gone wrong at the setup. run cabal_install.sh

 

[naruto820]

hmm found odbc.ini and changed it but where to cchange in stored procedures?

 

[chumpywumpy]

Look in the stored procedures folder of each db. Edit each of them and anywhere in the queries you see "account." replace with "account2.".

 

[naruto820]

ok my servers up, checked using status checker but now gotta get the account reg to work.
Hey chumpy i used ur reg page and got an error

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'Password', table 'account2.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails. (severity 16) in

Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'UserNum', table 'account2.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails. (severity 16) in

Warning: mssql_query() [function.mssql-query]: Query failed in
Something went wrong.


Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in

any idea what i did wrong ? Also which table is used for manually creating accounts? wanna test if i can login server.

Btw Im using Xampps.

so is this because my account database is named differently?

 

[chumpywumpy]

Please use the Edit button rather than double posting. I don't like giving infractions for it (i'm supposed to) but i will if you do it after being warned. Just a heads up.

The NULL errors abotu passwords are down to your xp_md5 support not working on the server and it can't encrypt your passwords. Open the extended procedures folder in your "master" database and check the path to the dll is correct on xp_md5's properties.

You can test MD5 is working with the command below. Getting a "NULL" back is bad, letters and numbers is good.

select account.dbo.fn_md5('test')