Can't get sqlite to work...

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
Chaotic
Peon
Posts: 7
Joined: Mon Oct 31, 2005 6:48 pm

Can't get sqlite to work...

Post by Chaotic » Mon Oct 23, 2006 12:27 am

I have done everything in there viewtopic.php?t=357#2226_a2d1d1

and in there
viewtopic.php?t=358

and everytime I try to run my server I get this

L 10/23/2006 - 02:32:17: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 10/23/2006 - 02:32:17: [warcraft3FT.amxx] Error: unable to open database file
Stats disabled: Player Name
Total 1
L 10/23/2006 - 02:32:22: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 10/23/2006 - 02:32:22: [warcraft3FT.amxx] Error: unable to open database file
L 10/23/2006 - 02:32:27: [warcraft3FT.amxx] Unable to connect to the SQLite database after 3 attempts, switching to short-term mode
L 10/23/2006 - 02:32:27: [warcraft3FT.amxx] Error: unable to open database file
Now here are my files
;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; 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

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Put third party modules below here. ;;
;; You can just list their names, without the _amxx ;;
;; or file extension. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; These modules will be auto-detected and loaded ;;
;; as needed. You do not need to enable them here ;;
;; unless you have problems. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

fun
engine
fakemeta
;geoip
;sockets
;regex
;nvault
cstrike
csx
// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db ""
amx_sql_table "admins"
Do I even need that, aint it for admins only?
// Warcraft 3 Frozen Throne Configuration File

mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_sql 1 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag "g" // Admin flag required to give/take XP (default is m)

// SQL configuration
FT_sql_host "127.0.0.1" // Host Name
FT_sql_user "root" // User Name
FT_sql_pass "" // Password
FT_sql_db "addons/amxmodx/data/amxx.db" // Database Name
FT_auto_pruning 0 // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete 31 // However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename "war3users" // Table Name, no need to change (default is war3users)
sv_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)

// Experience options
mp_xpmultiplier 1.0 // set the level required to gain a level as a multiple (default 1.0)
mp_weaponxpmodifier 1 // gives additional XP for using certain weaker weapons (default is 1)
FT_min_b4_XP 1 // Minimum amount of players needed b4 awarding XP (default is 2)
FT_objectives 1 // If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
FT_kill_objectives 0 // Shows how much XP you gain for killing someone (each kill, default is 0)
FT_bombplanterxp 20 // XP given for planting the bomb (default is 15)
FT_defusexp 20 // XP given for defusing the bomb (default is 30)
FT_hostagexp 20 // XP given for helping to rescue the hostages (default is 25)
FT_killrescuemanxp 20 // XP given for killing the person rescuing the hostages (default is 25)
FT_xpbonus 20 // XP given for purchasing tome of experience (default is 50)
FT_kill_bomb_carrier_bonus 20 // XP given for killing the bomb carrier (default is 25)
FT_defuser_kill_bonus 20 // XP given for killing the defuser (default is 25)
FT_VIP_kill_bonus 20 // XP given for killing the VIP (default is 25)
FT_VIP_escape_bonus 20 // XP given when the VIP escapes (default is 30)
FT_headshot_bonus 9 // XP given for getting a headshot (default is 9)
FT_xp_radius 1000 // Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)
FT_round_win_XP 20 // Experience given to the winning team (default is 35)
FT_autoxp 0 // With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)

// Game Play Enhancements
sv_warcraft3 1 // Set this to 0 to disable warcraft (default is 1)
mp_grenadeprotection 0 // Only 1 HE grenade will be allowed for purchase per round (default is 0)
FT_position 0 // 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
FT_centerhud 1 // Automatically makes the hud be centered (message that shows xp/race/level, default is 1)
FT_items_in_hud 0 // Display items w/a HUD message (this will take up 1 of the 4 channels, default is 0)
FT_spec_info 1 // Show Spectating information for dead players (default is 1)
FT_show_icons 1 // Shows icons on your screen when your ultimate is ready (default is 1)
FT_race_icons 1 // Allow users to type /icons to show player icons above the player (default is 1)
FT_level_icons 1 // Allow users to type /icons to see player levels above the player (default is 1)
FT_CD 0 // If set to 1, it will not allow players without Cheating Death to play this mod (default is 0)
FT_buyzone 0 // Restrict purchasing shopmenu items to within the buyzone? (default is 0)
FT_buytime 0 // Restrict purchasing shopmenu items to within the buytime? (default is 0)
FT_buydead 1 // Allow users to purchase items when dead? (default is 1)
FT_show_player 1 // Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
FT_query_client 1 // Check user's cl_minmodel cvar every second (default is 1)

// TYPE OF WARCRAFT (If race 4 or 5 is selected, messsages will say WAR3 instead
// of saying WAR3FT, also shopmenu2 will be disabled, as well as saying rings and ability)
FT_races 9 // Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)

// ****************************************************************************************************
// ABILITY ENHANCEMENTS
// ****************************************************************************************************

// Chameleon Race Configuration Options (Race 9)
// This race allows you to either assign skills that will be permanent, or random skills will be chosen each round
FT_Race9_Random 1 // Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
FT_Race9_Skill1 1 // What race should the first skill be taken from? (default is 1)
FT_Race9_Skill2 1 // What race should the second skill be taken from? (default is 1)
FT_Race9_Skill3 1 // What race should the third skill be taken from? (default is 1)
FT_Race9_Ultimate 1 // What race should the ultimate be taken from? (default is 1)


// Skill and Ultimate configurations
FT_ultimatedelay 15.0 // Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
FT_healing_range 750 // Range for Healing Wave to jump from player to player and heal (default is 750)
FT_ultimate_cooldown 35.0 // Cooldown of all ultimates (default is 35.0)
FT_warn_suicide 1 // Tells Undead Scourges their bomb is armed when they hit ultimate key, a second key press then detonates it (default is 1)
FT_blinkenabled 1 // Use blink instead of team teleport (default is 1)
FT_blink_protection 1 // slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
FT_blink_radius 500 // Enemies who have immunity w/in this radius will cause blink to fail (default is 500)
FT_blink_dizziness 1 // What type of diziness? (1 or 0 is flashbang effect, 2 is fading blue screen, default is 1)
FT_entangle_drop 0 // Should the player's primary weapon be dropped when they are entangled? (default is 0)
FT_impale_intensity 10 // Setting this to a lower non-negative number will lower the intensity of impale (default is 10)

// Item configurations
FT_glove_timer 10 // Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
FT_no_gloves_on_ka 1 // Prevents Flaming gloves of warmth on ka maps and scoutzknivez (default is 1)
FT_glove_orc_damage 0 // When using gloves, should orcs be given the critical dmg? (Default is 0)
FT_no_orcnades 0 // Prevent orc nades on ka_ maps, fy_ maps and jail_riot (default is 0)
FT_claw 6 // Damage done by Claws of Attack (default is 6)
FT_bootspeed 275.0 // Speed given for purchasing boots of speed (different for dod, see dod section, default is 275)
FT_health_bonus 15 // Health bonus given for periapt of health (default is 15)
FT_frost_speed 125.0 // Speed of victim when attacked with Orb of Frost (default is 125.0)
FT_mask_of_death 0.2 // Percentage of like gained back by mask of death (default is 0.3)
FT_cloak 150 // Invisibility given with cloak, lower is more invisible (default is 150)
FT_sock 0.5 // Gravity level for Sock of the Feather

// Bot Configuration Options
FT_bot_buy_item 0.33 // Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)

// DOD Options
DOD_startmoney 800 // Starting "fake" money for dod
DOD_bootspeed 45.0 // Stamina given for boots of speed in Day of Defeat (default is 45.0)
amxx list
Currently loaded plugins:
name version author file status

[ 1] Admin Base 1.76 AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.76 AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.76 AMXX Dev Team adminhelp.amxx running
[ 4] Slots Reservation 1.76 AMXX Dev Team adminslots.amxx running
[ 5] Menus Front-End 1.76 AMXX Dev Team menufront.amxx running
[ 6] Commands Menu 1.76 AMXX Dev Team cmdmenu.amxx running
[ 7] Players Menu 1.76 AMXX Dev Team plmenu.amxx running
[ 8] Maps Menu 1.76a AMXX Dev Team mapsmenu.amxx running
[ 9] Std Admin Color Chat 1.1.1 Van der Cal std_admin_color running
[ 10] Admin Chat 1.76 AMXX Dev Team adminchat.amxx running
[ 11] Anti Flood 1.76 AMXX Dev Team antiflood.amxx running
[ 12] Scrolling Message 1.76 AMXX Dev Team scrollmsg.amxx running
[ 13] Info. Messages 1.76 AMXX Dev Team imessage.amxx running
[ 14] Admin Votes 1.76 AMXX Dev Team adminvote.amxx running
[ 15] NextMap 1.76 AMXX Dev Team nextmap.amxx running
[ 16] Nextmap Chooser+ 0.5 SuicideDog mapchooserII.am running
[ 17] TimeLeft 1.76 AMXX Dev Team timeleft.amxx running
[ 18] Pause Plugins 1.76 AMXX Dev Team pausecfg.amxx running
[ 19] Stats Configuration 1.76 AMXX Dev Team statscfg.amxx running
[ 20] Restrict Weapons 1.76 AMXX Dev Team restmenu.amxx running
[ 21] StatsX 1.76 AMXX Dev Team statsx.amxx running
[ 22] CS Misc. Stats 1.76a AMXX Dev Team miscstats.amxx running
[ 23] Admin Say Cmd 2.0 Bishop saycmd.amxx running
[ 24] Admin Slash 1.1 mike_cao admin_slash.amx running
[ 25] AdminModX 0.9h AMXX DoD Communi adminmodx.amxx running
[ 26] Jedi Force Grab 1.1 SpaceDude jedi_force_grab running
[ 27] Admin NoBuy 1.0 AssKicR/Scarzzur admin_nobuy.amx running
[ 28] Admin Poison 1.1 AssKicR admin_poison.am running
[ 29] AdminListen 2.3x /dev/ urandom adminlisten.amx running
[ 30] AINO Commands 2.0 AMX(x) Community admin_allinone. running
[ 31] fullupdate Blocker 1.1 JTP10181 fullupdate_bloc running
[ 32] High-Ping-Kicker 1.4 Sp4rt4n pingkicker.amxx running
[ 33] amx_team 1.2 XunTric amx_team.amxx running
[ 34] Server Rules 1.1 FullThrottle server_rules.am running
[ 35] OOB Zone Builder 1.02 xeroblood oob_builder.amx running
[ 36] OOB Zone Protector 1.02 xeroblood oob_protector.a running
[ 37] Warcraft 3 Frozen Thro 2.3.2 Geesu==(Pimp Dad warcraft3FT.amx running
37 plugins, 37 running
; AMX Mod X plugins

; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
adminslots.amxx ; slot reservation
;multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
;telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)

; Chat / Messages
std_admin_color_chat.amxx ; Green admin chat, psay and other
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
mapchooserII.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Counter-Strike
restmenu.amxx ; restrict weapons menu
statsx.amxx ; stats on death or round end (CSX Module required!)
miscstats.amxx ; bunch of events announcement for Counter-Strike
;stats_logging.amxx ; weapons stats logging (CSX Module required!)

; Enable to use AMX Mod plugins
;amxmod_compat.amxx ; AMX Mod backwards compatibility layer

; Custom - Add 3rd party plugins here

saycmd.amxx ; Allow the use of say : !kick instand of console admin_kick
admin_slash.amxx ; Allow the use of say : /kick instand of console admin_kick
adminmodx.amxx ; Add a bunch of cool stuff, most are config to owners only
jedi_force_grab.amxx ; Add grab to all, roop and hook to owners (don't use them thought)
admin_nobuy.amxx ; Stop a player to buy a specifc gun (Owners only)
admin_poison.amxx ; Poison players
adminlisten.amxx ; Read all text
admin_allinone.amxx ; Add more stuff
fullupdate_blocker.amxx ; block the fullupdate command
pingkicker.amxx ; ping kicker, set to 200
amx_team.amxx ; Allow admins to be able to send a player to the other team
server_rules.amxx ; Show the servers rules
oob_builder.amxx ; oob plugins are out of bound protections
oob_protector.amxx ; oob plugins are out of bound protections
warcraft3FT.amxx ; fT plugin
Currently loaded modules:
name version author status
[ 1] SQLite 1.76 AMX Mod X Dev Team running
[ 2] Fun 1.76 AMX Mod X Dev Team running
[ 3] Engine 1.76 AMX Mod X Dev Team running
[ 4] FakeMeta 1.76 AMX Mod X Dev Team running
[ 5] CStrike 1.76 AMX Mod X Dev Team running
[ 6] CSX 1.76a AMX Mod X Dev Team running
6 modules, 6 correct
Last edited by Chaotic on Tue Oct 24, 2006 12:17 am, edited 1 time in total.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Mon Oct 23, 2006 8:15 am

In modules.ini

Change

sqlite_amxx.dll
sqlite_amxx_i386.so
sqlite_amxx_amd64.so

to

sqlite
No Support via PM

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Mon Oct 23, 2006 9:48 am

or, just remove those and enable sqlite as it is in there already
Image

No support via PM or Email

Chaotic
Peon
Posts: 7
Joined: Mon Oct 31, 2005 6:48 pm

Post by Chaotic » Mon Oct 23, 2006 3:29 pm

does not do anything at all

Chaotic
Peon
Posts: 7
Joined: Mon Oct 31, 2005 6:48 pm

Post by Chaotic » Mon Oct 23, 2006 8:01 pm

I'd like to add that currently, this is a dedicated server on my own computer, getting the exp to save while using sqlite is the last thing I need to do to upload this on my server. I have been dealing with this mod for years, I just currently updated amxx, metamod and want to get rid of vault.

Since this is on my computer, I tryed to add the complete path in the FT_sql_db and it still didn't do anything at all.

This is gonna sound retarted since I have read the stickys and the how tos, but I really need help. Can anyone contact me throught aim (I am not expecting geesu at all) at Achnod6 and try ot help me out?

Thx

erik2k3
Militia
Posts: 73
Joined: Wed Aug 03, 2005 6:34 am
Location: Germany / UK
Contact:

Post by erik2k3 » Mon Oct 23, 2006 10:59 pm

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; 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
maybe removing the " ; " in front of sqlite module ?
amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "addons/amxmodx/data/amxx.db"
amx_sql_table "admins"
amx_sql_type "sqlite"
didn`know that a database is a path ??? simply enter the NAME of the databese you want2 use, therefore go to phpmyadmin on your server and create a new databse, or select an already existing one.
Image

Chaotic
Peon
Posts: 7
Joined: Mon Oct 31, 2005 6:48 pm

Post by Chaotic » Tue Oct 24, 2006 12:10 am

erik2k3 wrote:
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; 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
maybe removing the " ; " in front of sqlite module ?
amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "addons/amxmodx/data/amxx.db"
amx_sql_table "admins"
amx_sql_type "sqlite"
didn`know that a database is a path ??? simply enter the NAME of the databese you want2 use, therefore go to phpmyadmin on your server and create a new databse, or select an already existing one.
Have you read my other posts? I did what geesu told me, heck I should have posted my module.ini file that way, adding those 3 lines were my last desperate attemp.

Like I said, did everything in the HOW-tos, downloaded, installed sqlite and all...

Previously, geesu said
If you don't have access to a MySQL server, use SQLite, otherwise use MySQL
viewtopic.php?t=2015

Now, let's take a look at lazarus topic

viewtopic.php?t=358
Change the variable FT_mysql_db (yes FT_mysql_db is correct, all SQL related variables in Warcarft 3 FT reflect their inheritance of former MySQL only support) to point to where you want the database file to live (don't worry if it doesn't exist yet it will be created automatically). It is highly recommended to keep it in the "addons\amxmodx\data" directory, so edit the file to read as the following snippet of a changed war3FT.cfg (you can leave FT_mysql_host, FT_mysql_user and FT_mysql_pass with their default values since they are ignored by the SQLite module but you should set both mp_savexp and sv_mysql, you might also want to have a look at sv_mysql_save_end_round and/or at sv_mysql_auto_pruning and sv_daysbeforedelete)

Code: Select all

// Warcraft 3 Frozen Throne Configuration File
// Note: NO MATTER WHAT, you must have a database module running
// even if you're not using it

mp_savexp      1      // Enables saving of experience (uses a vault, default is 0)
sv_mysql      1      // this will save w/MySQL (note: to use this mp_savexp must also be 1, default is 0)
FT_saveby      0      // What should I save this as?  steam id = 0, IP = 1, name = 2 (works for vault and mysql, default is 0)

// MySQL configuration
FT_mysql_host      "127.0.0.1"   // Host Name
FT_mysql_user      "root"      // User Name
FT_mysql_pass      ""      // Password
FT_mysql_db      "addons/amxmodx/data/amxx.db"      // Database Name
sv_mysql_auto_pruning   0      // Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete   31      // However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename   "war3users"   // Table Name, no need to change (default is war3users)
sv_mysql_save_end_round 0      // Save Users at the end of each round (causes slight lag, default is 0)
FT_disable_savexp   0      // Set this to 1 to disable users typing /savexp (default is 0)

So yeah, I think I need a path and not a table...

I just tryed to use the conversion trick, an db file just appeared in the data folder..it was not there before, but I still cannot connect to it.

Like I said, the server and everything else is hosted on my own pc, not on a website, so phpmyadmin....don't think I can use that.

Sqlite is not supposed to require any already existng database from what I understand, or I understood wrong and that's why I am asking for help over aim.

Btw, I just updated my files

Post Reply