[HellsCook]

Also, I was thinking it would be nice to be able to make pumpkins solid instead of walk through objects.

Nevermind, I realized that you can only walk through them when first placed.

[TFC]

My databases.cfg can u take a look into this please


"c863142_autopumpkins"
{
"driver" "mysql"
"host" "66.55.132.33"
"database" "c863142_autopumpkins"
"user" "c863142_autopum"
"pass" "********"
//"timeout" "0"
"port" "3306"
}

i got error

L 01/16/2011 - 18:16:42: [AutoPumpkins.smx] Can't select database
L 01/16/2011 - 18:16:42: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 01/16/2011 - 18:16:42: [SM] Displaying call stack trace for plugin "AutoPumpkins.smx":
L 01/16/2011 - 18:16:42: [SM] [0] Line 127, /home/groups/alliedmodders/forums/files/4/9/8/6/5/76027.attach::createdbtables()
L 01/16/2011 - 18:16:42: [SM] [1] Line 27, /home/groups/alliedmodders/forums/files/4/9/8/6/5/76027.attach::OnPluginStart()

[DarthNinja]

The plugin can't connect to your database ether because you put in incorrect settings, or because the game server's IP isnt allowed access to that database.

[TFC]

Originally Posted by DarthNinja because the game server's IP isnt allowed access to that database.

you can say how to allow?

[DarthNinja]

Originally Posted by TFC you can say how to allow?

No, ask your host.

On my web server I have a control panel, if you have one, look for something like mysql -> databases -> manage users.

-Edit: Example

[TFC]

hmm,,, i tried my best... i can not install.

ty for help. nice plugin

[DarthNinja]

Originally Posted by TFC hmm,,, i tried my best... i can not install. ty for help. nice plugin

Did you figure out how to allow access to the database from a specific IP?

[TFC]

yes, i created a new database , user and added user to database

database: c863142_autopumpkins
user: c863142_autopump

my database.cfg

"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"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"
}
"autopumpkins"
{
"driver" "mysql"
"host" "66.55.132.33"
"database" "c863142_autopumpkins"
"user" "c863142_autopump"
"pass" "******"
//"timeout" "0"
"port" "3306"
}
}

[DarthNinja]

Did you allow that MySQL user to access the database when connecting from your game server's IP?

Most SQL setups will only allow users to connect from localhost by default, so if you want your game server to connect to your webserver you have to 'whitelist' your game server's ip address.

This is something you have to do on your web server, probably in your server control panel. If you can't find out how, your host can tell you.

BTW: when you post a config or other long file, it's nice if you wrap it in [code][/code] tags so it retains its formatting and doesn't spew down the page

[natex2012]

hi. do you need a website for this too work?.