Vault or sqlite

Senne · Post by **Senne** » Mon Mar 05, 2007 1:42 pm

Hi installed the new version 3.0 RC 5
and since i had alot of troubled when i used an mysql database(sort of lagg) i decided to keep it on the server.

Which on is the best to save xp to ? vault or sqlite?
Where can i locate one of those 2 files to take a backup.
(and yes i did forum search, and i also read the sqlite documentation, but it looks like that one is for an older war3ft version).

Thx

--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Mon Mar 05, 2007 1:50 pm

Well, SQLite will be your only choice if you can't get a MySQL database when RC6 is released.

I think it is stored in your base mod folder, not sure though

Senne · Post by **Senne** » Mon Mar 05, 2007 2:16 pm

well mysql database made it lagg..
i think the gameserver and mysql where to far based from each other..
Sometimes ppl were able to choose there changerace menu at the 3th round..
and sometimes it gave them 0 xp bec the mysql database got overloaded?

euhm i enable sqlite now.
i found a folder at /addons/amxmodx/data/sqlite3
it was created after enabling it, but when in game it didnt load. Server log message was an eror that it couldnt be found.

Anything special i need to do?
except enabling it in modules.ini

Code: Select all

// Saving Options

wc3_save_xp		1		// Enables saving of experience (uses a vault, default is 0)
wc3_save_xp_db		2		// How should we save XP? (0 = NVault, 1 = MySQL, 2 = SQLite)

wc3_save_by		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (SQL ONLY, default is 0)
wc3_save_pruning	0		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	200		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost		"localhost"	// Host Name
wc3_sql_dbuser		"root"		// User Name
wc3_sql_dbpass		""		// Password
wc3_sql_dbname		""		// Database Name
wc3_sql_tbname		"war3users"	// Table Name

bec the help file here at the forum of sqite is out dated i think , and i didnt really understand it.

Senne · Post by **Senne** » Mon Mar 05, 2007 2:30 pm

logfile :

Code: Select all

L 03/05/2007 - 14:34:13: [war3ft.amxx] Error: unable to open database file
L 03/05/2007 - 14:34:14: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI 
handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'
L 03/05/2007 - 14:34:14: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'
L 03/05/2007 - 14:34:14: [admin.amxx] Login: "Senne<39><STEAM_0:0:3637317><>" became an admin (account "STEAM_0:0:3637317") (access "abcdefghijklmnopqrstu") (address "81.164.42.109")
L 03/05/2007 - 14:34:14: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'

error log :

Code: Select all

L 03/05/2007 - 14:35:52: [SQLITE] Invalid DBI handle 0
L 03/05/2007 - 14:35:52: [AMXX] Displaying debug trace (plugin "war3ft.amxx")
L 03/05/2007 - 14:35:52: [AMXX] Run time error 10: native error (native "log_amx")
L 03/05/2007 - 14:35:52: [AMXX]    [0] db_sqlite.inl::SQLITE_UpdateTimestamp (line 362)
L 03/05/2007 - 14:35:52: [AMXX]    [1] db_common.inl::DB_UpdateTimestamp (line 282)
L 03/05/2007 - 14:35:52: [AMXX]    [2] war3ft.sma::client_connect (line 349)

ow and this is my amx_modules :

Code: Select all

MySQL                   1.76b    AMX Mod X Dev Team  
Fun                     1.76     AMX Mod X Dev Team  
CStrike                 1.76     AMX Mod X Dev Team  
CSX                     1.76c    AMX Mod X Dev Team  
Engine                  1.76     AMX Mod X Dev Team  
FakeMeta                1.76b    AMX Mod X Dev Team  
nVault                  1.76c    AMX Mod X Dev Team  
SQLite                  1.76b    AMX Mod X D

i need mysql for banlist

my modules.ini :

Code: Select all

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use      ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;mysql
sqlite

and i do have my sql.cfg set to a mysql server where the amxbans is listed , does this create the problem?

Post by **YamiKaitou** » Mon Mar 05, 2007 4:40 pm

You need to fill in the database name field. Just use any name and it should work

Senne · Post by **Senne** » Mon Mar 05, 2007 4:42 pm

so no /addons/amxmodx thingy bec i tried that and it didnt , i can just do 'amxxxp' ?
and i dont need to do anything in the sql.cfg right? (bec in the old manual itt said something about that, or a topic i read by searching)

Post by **YamiKaitou** » Mon Mar 05, 2007 4:44 pm

the sql.cfg file is tied to AmxX. All database settings for wc3ft is done in the war3ft.cfg file. Yes, you should be fine setting it to amxxxp or something.

Senne · Post by **Senne** » Mon Mar 05, 2007 4:52 pm

thx ( i just got confused with reading other topics i guess

)
keep up the great work
i'm glad there are ppl making updates for war3ft and other mods for the old 1.6.

i just setted it to :

Code: Select all

// SQL Database Information

wc3_sql_dbhost		"localhost"	// Host Name
wc3_sql_dbuser		"root"		// User Name
wc3_sql_dbpass		""		// Password
wc3_sql_dbname		"xpserver"		// Database Name
wc3_sql_tbname		"war3users"	// Table Name

changed map and i still cant pull up changerace to get xp started

Senne · Post by **Senne** » Mon Mar 05, 2007 4:58 pm

same error in log file

Code: Select all

L 03/05/2007 - 16:59:34: [war3ft.amxx] Error: unable to open database file
L 03/05/2007 - 16:59:34: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'
L 03/05/2007 - 16:59:34: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'
L 03/05/2007 - 16:59:34: [war3ft.amxx] [ERROR] '[SQLITE] Invalid DBI handle 0' '10' '1' 'Run time error 10: native error (native "dbi_query")'

extra question : can i run mysql and sqlite at the same time, now only sqlite is running in the sql.cfg, but i need mysql for amxbans...

Post by **YamiKaitou** » Mon Mar 05, 2007 5:13 pm

I don't know much about SQLite as I use MySQL (server in San Jose, Cali and SQL in Austria -.- ).

Maybe it requires a password? Try 127.0.0.1 instead of localhost

Senne · Post by **Senne** » Mon Mar 05, 2007 5:26 pm

yea i tried 127.0.0.1 too after reading it causes troubles for linux servers.

Who knows alot or made this thing?

btw your mysql and gameserver are far from each other and they work good? damn.. mine made ppl freak out.

Post by **YamiKaitou** » Mon Mar 05, 2007 5:31 pm

Actually, it does timeout for about 5 secs on mapchange. Of course, the server just went up Sunday, so it hasn't had time to populate yet.

Geesu is the creater of this mod

Senne · Post by **Senne** » Tue Mar 06, 2007 5:13 am

well i had the same delya like you, but you ll get shit whrn 8 players or more are connected.

Is Geesu still around? does he check forums?(often or weekly

) edit ; just checked and it looks like he reads it daily.

(just read the topic where you hard discourage using Nvault.ini, but this would be my last step

if i would not get the sqlite up,where can i see thre Nvault.ini , bec i already located vault.ini but it doesnt seem like it saves the xp there.. (when i use Nvault.ini option in war3ft.cfg , my xp does save but i want to make edits and backup the file).
It just that i'm afraid to lose alot of gamers if i have to wait a week or longer

.

Post by **YamiKaitou** » Tue Mar 06, 2007 7:19 am

The nVault saves to addons/amxmodx/data/nvault

It saves each file in .vault format which is a binary type. You can not read it just by opening the file

Senne · Post by **Senne** » Tue Mar 06, 2007 7:43 am

yea i see , its at /cstrike/addons/amxmodx/data/vault all in .vault format. Its odd bec when i used the older mod it saved in a vault.ini , and i could acces the xp and steamid's.

Well i'll just wait some days on Geesu then i guess, or should i contact him in some way?

(thx btw)

ow : euhm those it cause any problem having mysql on at the same time with sqlite? i tried disable it too tho and it doesnt change my sqlite problem. But when i have to put it of i have of course no amxbans..

Code: Select all

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time.  Use      ;;
;;  amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;mysql
sqlite

to
mysql
sqlite
cause a problem?

Senne · Post by **Senne** » Tue Mar 06, 2007 2:01 pm

ok i did a clean install , and tried a free database out (mysql)
It does work now.
it appears changing it to sqlite , makes the rest fuck up?
bec when i did go back to mysql , it had still the same problem.

Are you guys sure it does never use sql.cfg ?? bec its is fucking strange, before i had amxbans running fine. And now amxbans does not run together with war3ft Mysql. When i put the amxbans.amxx off war3ft mysql works fine again....
while only thing amxbans does is acces the sql.cfg for the mysql database records...

I just tested it again, i added amxbans , blump no more xp no more changerace.
I do it away ups there is the xp..
while i did not had this issue before...

Post by **YamiKaitou** » Tue Mar 06, 2007 2:22 pm

Nope, it uses the war3ft.cfg for the sql configs.

Can't you just use the same database for wc3ft and amxxbans?

Senne · Post by **Senne** » Tue Mar 06, 2007 4:40 pm

ill try, im currently using a free mysqlhost . since SQLITE wont work.
I started witha clean version tho. retried it all , but gave the same error.

Magnuz · Post by **Magnuz** » Tue Apr 10, 2007 3:01 pm

I use War3ft version 3.0 rc5 right now and I am wondering something about the MySQL and Nvault.

1. Can I host an MySQL on the same computer as the client I am playing on? (I saw that I needed to pay for a host.)

2. If the Nvault won't work anymore after 3.0 rc6, do I have to restart the XP savings?

3. Is it hard to maintain and control a MySQL? (how?)

Post by **YamiKaitou** » Tue Apr 10, 2007 3:12 pm

Magnuz wrote:1. Can I host an MySQL on the same computer as the client I am playing on? (I saw that I needed to pay for a host.)

If you are running the server on a personal computer, yes you can.

2. If the Nvault won't work anymore after 3.0 rc6, do I have to restart the XP savings?

Yes, you will be forced to restart the xp. If your nVault is large, send me a copy so I can try and create something that could transfer the xp, but I need a copy of a nVault so I can test it.

3. Is it hard to maintain and control a MySQL? (how?)

Not sure, I have never ran one myself

Magnuz · Post by **Magnuz** » Tue Apr 10, 2007 3:21 pm

send me a copy so I can try and create something that could transfer the xp

Sorry... It was more of a public interest matter. The XP was "blah" anyway because I was playing versus bots and the XP got pretty screwed since the vault saved everyones XP on a specific way so everyone had exactly the same amount of XP as anyone had...

(have posted this problem in this topic... sorry for the spread.

)
viewtopic.php?t=2704