Page 1 of 1
Vault or sqlite
Posted: Mon Mar 05, 2007 1:42 pm
by Senne
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:
Posted: Mon Mar 05, 2007 1:50 pm
by YamiKaitou
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
Posted: Mon Mar 05, 2007 2:16 pm
by Senne
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.
Posted: Mon Mar 05, 2007 2:30 pm
by Senne
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?
Posted: Mon Mar 05, 2007 4:40 pm
by YamiKaitou
You need to fill in the database name field. Just use any name and it should work
Posted: Mon Mar 05, 2007 4:42 pm
by Senne
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)
Posted: Mon Mar 05, 2007 4:44 pm
by YamiKaitou
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.
Posted: Mon Mar 05, 2007 4:52 pm
by Senne
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
Posted: Mon Mar 05, 2007 4:58 pm
by Senne
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...
Posted: Mon Mar 05, 2007 5:13 pm
by YamiKaitou
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
Posted: Mon Mar 05, 2007 5:26 pm
by Senne
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.
Posted: Mon Mar 05, 2007 5:31 pm
by YamiKaitou
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
Posted: Tue Mar 06, 2007 5:13 am
by Senne
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
.
Posted: Tue Mar 06, 2007 7:19 am
by YamiKaitou
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
Posted: Tue Mar 06, 2007 7:43 am
by Senne
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?
Posted: Tue Mar 06, 2007 2:01 pm
by Senne
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...
Posted: Tue Mar 06, 2007 2:22 pm
by YamiKaitou
Nope, it uses the war3ft.cfg for the sql configs.
Can't you just use the same database for wc3ft and amxxbans?
Posted: Tue Mar 06, 2007 4:40 pm
by Senne
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.
Posted: Tue Apr 10, 2007 3:01 pm
by Magnuz
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?)
Posted: Tue Apr 10, 2007 3:12 pm
by YamiKaitou
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
Posted: Tue Apr 10, 2007 3:21 pm
by Magnuz
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