mysql/sqlite help!

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

Moderator: Forum Moderator

Post Reply
disnfectant
Peon
Posts: 4
Joined: Sun Jun 24, 2007 11:56 pm

mysql/sqlite help!

Post by disnfectant » Mon Jun 25, 2007 5:34 pm

Ok... so I understand a little about the mysql stuff and everything I tried installing following viewtopic.php?t=31 that installation procedures. When I get to about step III #2 I can't do that "create tables" stuff because it gives me errors... if there is another way to set it all up please let me know!

my cfgs are:


;;;
; 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
sqlite_amxx.dll
sqlite_amxx_amd64.so
sqlite_amxx_i386.so
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; 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


; AMX Mod X plugins

; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
cheat.amxx
admin_ammo.amxx
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
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
mapchooser.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
war3ft.amxx debug

// 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 "addons/amxmodx/data/amxx.db"
amx_sql_table ""
amx_sql_type "mysql"

<?
/*************************************************
* This is the configuration file, please
* enter the mysql information below
*
* Details at http://war3ft.com
*
* Credits: Design set up by b4p
*************************************************/

$host = "127.0.0.1";
$username = "amxx";
$pass = "pooder90";
$dbname = "mysql";
$tbname = "war3users";

// Set this to true to show the user's steam ID
$show_steam_id = false;

// The amount to display per page
$limit = 100;

/*** DO NOT EDIT BELOW THIS LINE ***/
require("functions.inc.php");

// Open the mysql connection
$mysql = mysql_connect($host, $username, $pass) or die("Could not connect : " . mysql_error());

// Select the database
mysql_select_db($dbname) or die("Could not select " . $dbname . " database");
?>

L 06/21/2007 - 11:15:21: Log file started (file "czero\addons\amxmodx\configs\war3ft\wc3_error.log") (game "czero") (amx "1.76d")
L 06/21/2007 - 11:15:21: ** Map 'de_dust_cz' started
L 06/21/2007 - 11:15:21: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 11:17:13: ** Map 'de_dust_cz' started
L 06/21/2007 - 11:17:13: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 11:33:59: ** Map 'de_dust_cz' ended
L 06/21/2007 - 16:45:43: ** Map 'de_dust_cz' started
L 06/21/2007 - 16:45:43: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 17:16:01: ** Map 'de_dust_cz' ended
L 06/21/2007 - 17:16:04: ** Map 'cs_747' started
L 06/21/2007 - 17:16:04: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 17:22:10: ** Map 'cs_747' ended
L 06/21/2007 - 17:22:11: ** Map 'de_dust2' started
L 06/21/2007 - 17:22:11: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 17:23:23: ** Map 'de_dust2' ended
L 06/21/2007 - 17:37:05: ** Map 'de_dust_cz' started
L 06/21/2007 - 17:37:05: ** Plugin version: '3.0 RC7'
L 06/21/2007 - 17:37:08: [MYSQLX] Database Connection Failed: [2003] Can't connect to MySQL server on 'localhost' (10061)
L 06/21/2007 - 17:37:11: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 06/21/2007 - 17:37:12: [ERROR] Unable to retreive user's (2) Unique ID, trying again...
L 06/21/2007 - 17:37:12: [ERROR] Unable to retreive user's (3) Unique ID, trying again...
L 06/21/2007 - 17:37:12: [ERROR] Unable to retreive user's (4) Unique ID, trying again...
L 06/21/2007 - 17:37:12: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (5) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (2) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (6) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (3) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (7) Unique ID, trying again...
L 06/21/2007 - 17:37:13: [ERROR] Unable to retreive user's (4) Unique ID, trying again...

I used a different cfg format for the war3ft.cfg and I set the savexp to 1 and it doesn't save or anything. When I use default format and set savexp to 1 I can't choose a race or anything. PLEASE HELP SOMEHOW if anything else is required, will gladly post

btw... this is all lan stuff that I'm attempting



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

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

Post by Geesu » Mon Jun 25, 2007 6:35 pm

Your mysql connection information is wrong...
No Support via PM

disnfectant
Peon
Posts: 4
Joined: Sun Jun 24, 2007 11:56 pm

Post by disnfectant » Mon Jun 25, 2007 7:50 pm

i've changed it a couple times but i still have no effect with the server and mysql. when I type amx_sqladmins is says it can't connect to "127.0.0.1" and some other stuff

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

Post by YamiKaitou » Mon Jun 25, 2007 8:47 pm

Please provide the info requested in this topic. viewtopic.php?t=2868


I have a feeling you have stuff running that you shouldn't. For example, trying to use a MySQL connection using the SQLite module
Image

No support via PM or Email

disnfectant
Peon
Posts: 4
Joined: Sun Jun 24, 2007 11:56 pm

Post by disnfectant » Tue Jun 26, 2007 5:39 pm

Currently loaded plugins:
name version author file status
Admin Base 1.76d AMXX Dev Team admin.amxx running
amx_cheat 1.0 watch cheat.amxx running
Admin Ammo 1.0 AssKicR admin_ammo.amxx running
Admin Base (SQL) 1.76d AMXX Dev Team admin_sql.amxx running
Admin Commands 1.76d AMXX Dev Team admincmd.amxx running
Admin Help 1.76d AMXX Dev Team adminhelp.amxx running
Slots Reservation 1.76d AMXX Dev Team adminslots.amxx running
Multi-Lingual Sys 1.76d AMXX Dev Team multilingual.am running
Menus Front-End 1.76d AMXX Dev Team menufront.amxx running
Commands Menu 1.76d AMXX Dev Team cmdmenu.amxx running
Players Menu 1.76d AMXX Dev Team plmenu.amxx running
Maps Menu 1.76d AMXX Dev Team mapsmenu.amxx running
Admin Chat 1.76d AMXX Dev Team adminchat.amxx running
Anti Flood 1.76d AMXX Dev Team antiflood.amxx running
Scrolling Message 1.76d AMXX Dev Team scrollmsg.amxx running
Info. Messages 1.76d AMXX Dev Team imessage.amxx running
Admin Votes 1.76d AMXX Dev Team adminvote.amxx running
NextMap 1.76d AMXX Dev Team nextmap.amxx running
Nextmap Chooser 1.76d AMXX Dev Team mapchooser.amxx running
TimeLeft 1.76d AMXX Dev Team timeleft.amxx running
Pause Plugins 1.76d AMXX Dev Team pausecfg.amxx running
Stats Configurati 1.76d AMXX Dev Team statscfg.amxx running
Restrict Weapons 1.76d AMXX Dev Team restmenu.amxx running
StatsX 1.76d AMXX Dev Team statsx.amxx running
CS Stats Logging 1.76d AMXX Dev Team stats_logging.a running
Warcraft 3 Frozen 3.0 RC7 Geesu & Avanderi war3ft.amxx debug
\par
\par
name version author
Sqlite 1.70 AMX Mod X Dev Team
Fun 1.76 AMX Mod X Dev Team
Engine 1.76 AMX Mod X Dev Team
FakeMeta 1.76d AMX Mod X Dev Team
nVault 1.76c AMX Mod X Dev Team
CStrike 1.76 AMX Mod X Dev Team
CSX 1.76c AMX Mod X Dev Team
MySQL 1.76b AMX Mod X Dev Team
\par
\par
Currently loaded plugins:\par
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.76d ini ANY ANY
[ 2] Fun RUN - fun_amxx.dll v1.76 pl1 ANY ANY
[ 3] Engine RUN - engine_amxx.dll v1.76 pl1 ANY ANY
[ 4] FakeMeta RUN - fakemeta_amxx.dl v1.76d pl1 ANY ANY
[ 5] CStrike RUN - cstrike_amxx.dll v1.76 pl1 ANY ANY
[ 6] CSX RUN - csx_amxx.dll v1.76c pl1 ANY ANY
[ 7] MySQL RUN - mysql_amxx.dll v1.76b pl1 ANY ANY
7 plugins, 7 running

ok well when I downloaded mysql, I tried configuring it by using that installation topic I found on here but I only get to a certain point and I can't complete the configuration. I messed with it a little bit and still couldn't get it to work. I know that the order effects some things but please provide any help. Thank you

disnfectant
Peon
Posts: 4
Joined: Sun Jun 24, 2007 11:56 pm

Post by disnfectant » Tue Jun 26, 2007 9:04 pm

I also installed it on regular counter-strike and everything works out fine. Actually when I turn on some plugins that are required it makes it not work. I left mysql module off and it works on there.

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

Post by Geesu » Wed Jun 27, 2007 10:25 am

That's b/c the plugins you're turning on are using the old DBI module, and not the new way of doing databaes shit - so it's f'in everything up... Tell the plugin developers to update their code
No Support via PM

Post Reply