Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2013-01-25 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog
Chat

War3:Source
January 24, 2013, 11:15:38 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?
Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version= 		 
   Home   Help Search Login Register  
War3:Source > General Discussion > War3: Source - Support > Databases, yes I've read the wiki, yes I used google, yes I'm bad :P
Pages: [1]
« previous next »
  Print  
Author Topic: Databases, yes I've read the wiki, yes I used google, yes I'm bad :P  (Read 213 times)
Madlollipop
Newbie
*
Posts: 6


View Profile Email
« on: November 01, 2012, 12:43:43 PM »
Hello, so I've tried for about 9 ish hours to fix this, without success... I know you hate (Or dislike atleast) people who won't read the wiki, well I have done that but still I can't figure out what is wrong.
Please do not just tell me to read it again, I'm no programmer/Hacker or cracker so "logic" within these subjects helps... Sorry, but yeah...
The plugin itself works fine and here is my other things.

Here is the sourcemod error log
Quote
10/30/12 11:42:39 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 11:42:39 ERRMSG:([2003]: Can't connect to MySQL server on 'localhost' (10061))
10/30/12 11:42:46 NO GENREIC SKILL FOUND
10/30/12 11:58:56 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 11:58:56 ERRMSG:([2003]: Can't connect to MySQL server on 'localhost' (10061))
10/30/12 11:59:57 NO GENREIC SKILL FOUND
10/30/12 12:04:25 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 12:04:25 ERRMSG:([2003]: Can't connect to MySQL server on 'localhost' (10061))
10/30/12 12:04:31 NO GENREIC SKILL FOUND
10/30/12 12:45:32 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 12:45:32 ERRMSG:([2003]: Can't connect to MySQL server on 'localhost' (10061))
10/30/12 12:45:39 NO GENREIC SKILL FOUND
10/30/12 12:52:31 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 12:52:31 ERRMSG:([2003]: Can't connect to MySQL server on 'localhost' (10061))
10/30/12 12:52:37 NO GENREIC SKILL FOUND
10/30/12 19:08:27 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 19:08:27 ERRMSG:(Configuration "default" not found)
10/30/12 19:08:35 NO GENREIC SKILL FOUND
10/30/12 19:23:15 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/30/12 19:23:15 ERRMSG:(Configuration "default" not found)
10/30/12 19:24:12 NO GENREIC SKILL FOUND
10/31/12 17:28:07 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 17:28:07 ERRMSG:(Configuration "default" not found)
10/31/12 17:29:18 NO GENREIC SKILL FOUND
10/31/12 17:43:54 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 17:43:54 ERRMSG:(Configuration "default" not found)
10/31/12 17:45:01 NO GENREIC SKILL FOUND
10/31/12 17:50:48 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 17:50:48 ERRMSG:(Configuration "default" not found)
10/31/12 17:50:54 NO GENREIC SKILL FOUND
10/31/12 18:46:18 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 18:46:18 ERRMSG:(Configuration "default" not found)
10/31/12 18:46:24 NO GENREIC SKILL FOUND
10/31/12 18:50:15 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 18:50:15 ERRMSG:(Configuration "default" not found)
10/31/12 18:50:21 NO GENREIC SKILL FOUND
10/31/12 18:51:33 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 18:51:33 ERRMSG:(Configuration "default" not found)
10/31/12 18:51:39 NO GENREIC SKILL FOUND
10/31/12 18:52:12 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 18:52:12 ERRMSG:(Configuration "default" not found)
10/31/12 18:52:17 NO GENREIC SKILL FOUND
10/31/12 18:58:08 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 18:58:08 ERRMSG:(Configuration "default" not found)
10/31/12 18:58:14 NO GENREIC SKILL FOUND
10/31/12 19:14:02 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 19:14:02 ERRMSG:(Configuration "default" not found)
10/31/12 19:14:07 NO GENREIC SKILL FOUND
10/31/12 19:19:02 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 19:19:02 ERRMSG:(Configuration "default" not found)
10/31/12 19:19:07 NO GENREIC SKILL FOUND
10/31/12 19:19:59 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
10/31/12 19:19:59 ERRMSG:(Configuration "default" not found)
10/31/12 19:20:05 NO GENREIC SKILL FOUND
11/01/12 01:12:57 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
11/01/12 01:12:57 ERRMSG:(Configuration "default" not found)
11/01/12 01:13:37 NO GENREIC SKILL FOUND
11/01/12 05:29:44 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
11/01/12 05:29:44 ERRMSG:(Configuration "default" not found)
11/01/12 05:30:33 NO GENREIC SKILL FOUND
11/01/12 05:48:20 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
11/01/12 05:48:20 ERRMSG:(Configuration "default" not found)
11/01/12 05:48:25 NO GENREIC SKILL FOUND
11/01/12 05:53:18 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
11/01/12 05:53:18 ERRMSG:(Configuration "default" not found)
11/01/12 05:53:24 NO GENREIC SKILL FOUND
11/01/12 06:02:16 [War3Source] ERROR: hDB invalid handle, Check SourceMod database config, could not connect.
11/01/12 06:02:16 ERRMSG:(Configuration "default" not found)
11/01/12 06:02:28 NO GENREIC SKILL FOUND
I don't know where to find the war3source error log
And I'll post screenshots since I do not know how to copy from the "cmd" ish console... Can't select the text.
http://i.imgur.com/VAk6C.jpg
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2169



View Profile WWW
« Reply #1 on: November 01, 2012, 04:03:50 PM »
did you delete "default" from database.cfg Huh?
Logged
DarkEnergy
Madlollipop
Newbie
*
Posts: 6


View Profile Email
« Reply #2 on: November 01, 2012, 05:16:59 PM »
This is my database.cfg file

Actually it is called databases.cfg
C:\srcds\orangebox\tf\configs
"Databases"
{
    "driver_default"        "mysql"
   
    "default"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
   
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

C:\srcds\orangebox\tf\addons\sourcemod\configs
"default"     
{
  "driver" "sqlite" //<--
  "host" "localhost" //<-- can leave alone
  "database" "sourcemod" //<-- change if you want, this is the name of the database
  "user" "username" //<-- leave alone sqlite doesnt have authentication
  "pass" "password" //<-- leave alone sqlite doesnt have authentication
//"timeout" "0" //<--leave alone
//"port" "0" //<--leave alone
}

War3source looks like this
C:\srcds\orangebox\tf\addons\sourcemod\configs

"War3SourceSettings"
{
   "database"   "default"
   "levels"
   {
      "long_term"
      {
         "required_xp"   "0   100 200 350 500 750 1000 1500 2000 3000 4500 6000 8000 10000 12500 15000 20000"
         "kill_xp"   "25   25  25  25 25   25  25    25   25   25  25   25   25   25   25   25    25"
      }
      "short_term"
      {
         "required_xp"   "0 100 200 400 800 1600 3200 6400 9000 9200 9400 9600 9700 9800 9800 9800 10000"
         "kill_xp"   "40 80 120 160 200 240 280 300 300 300 300 300 300 300 300 300 300"
      }
   }
}
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2169



View Profile WWW
« Reply #3 on: November 01, 2012, 09:23:55 PM »
databases.cfg does not belong in C:\srcds\orangebox\tf\configs

the one in C:\srcds\orangebox\tf\addons\sourcemod\configs is not properly formatted, copy the other one back, it should be:

"Databases"
{
    "driver_default"        "mysql"
  
    "default"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
  
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}
Logged
DarkEnergy
-El Diablo
Sr. Member
****
Posts: 252


View Profile
« Reply #4 on: November 01, 2012, 09:29:26 PM »

if your going to use sqlite, then you need to change
"driver_default"        "mysql"
to
"driver_default"        "sqlite"
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2169



View Profile WWW
« Reply #5 on: November 01, 2012, 09:30:40 PM »
actually, thats not required, driver_default is effective when   "driver" is   "default" under the sub entry. "sqlite" overrides default
Logged
DarkEnergy
Madlollipop
Newbie
*
Posts: 6


View Profile Email
« Reply #6 on: November 02, 2012, 07:29:40 AM »
Ownz these things should be written on the wiki as it would help alot of us I think, I do not blame you but most who post here already read the wiki and sometimes it is written for expetienced people where you guys assume we know more than we do.
The path and the "full" database thing could be useful for noobs like me! We all appriciate your work and time here, but to avoid all questions about things such as databases over and over again you could try to update the database wiki a bit with too much info rather than too little or just expanding it from time to time when you get a new question.
When you just redirect us to the wiki, you did not now but I've seen you do it, I've got the feeling that more than me had a problem understanding it. Please do not think I'm complaining, rather giving a suggestion.
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!