Raised This Month: $ Target: $400
 0% 

Sourcemod Webadmin (Updated 12/05/2012)


Post New Thread Reply   
 
Thread Tools Display Modes
chora
SourceMod Donor
Join Date: Dec 2010
Location: Brazil
Old 10-16-2012 , 09:28   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #601

Maybe something is missing on server's side. According to MySql documentation, you'll need an user account to connect with it (it's an advanced configuration).

Check with your hosting service if they can help you.

Are you hosting your webpages on the same server of your gameserver?
__________________

chora is offline
paterinvictus
Senior Member
Join Date: Aug 2012
Old 10-16-2012 , 09:32   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #602

Quote:
Originally Posted by chora View Post
Maybe something is missing on server's side. According to MySql documentation, you'll need an user account to connect with it (it's an advanced configuration).

Check with your hosting service if they can help you.

Are you hosting your webpages on the same server of your gameserver?
Where is this Advanced Configuration of which you speak?

And no, Our webpage has a seperate IP from our Gameserver.

We are running 3 other Databases at the moment. 1 For our Joomla Template. 1 for Sourcebans. 1 for our Forum. This is the first time I've come across this error.
paterinvictus is offline
chora
SourceMod Donor
Join Date: Dec 2010
Location: Brazil
Old 10-16-2012 , 10:20   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #603

paterinvictus,

Try to change your webadmin database's server and use $servername = "localhost" on your config files.

Quote:
Where is this Advanced Configuration of which you speak?
When you use a servername other than localhost, you'll need to create a specific user on this mysql one. If user 'c995495_ABMadmin'@'xxxxx.gameservers.com' doesn't exist, you'll get a similar mysql error.
__________________

chora is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 10-16-2012 , 10:22   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #604

Quote:
Originally Posted by chora View Post
Try to change your webadmin database's server and use $servername = "localhost" on your config files.
I'm gonna guess that you didn't bother reading the previous posts.
__________________
asherkin is offline
chora
SourceMod Donor
Join Date: Dec 2010
Location: Brazil
Old 10-16-2012 , 10:30   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #605

Quote:
Originally Posted by asherkin View Post
I'm gonna guess that you didn't bother reading the previous posts.
Yes I started to read it on post #591
__________________

chora is offline
paterinvictus
Senior Member
Join Date: Aug 2012
Old 10-16-2012 , 11:13   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #606

I have tried using "localhost" as the servername. I get the same error.

Might just have to scrap this all together. Becoming a hassle. :/

Last edited by paterinvictus; 10-16-2012 at 11:15.
paterinvictus is offline
Jumpman
Senior Member
Join Date: Mar 2010
Location: Denmark
Old 10-16-2012 , 11:33   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #607

Hmm my work's fine

database.cfg
Code:
"Databases"
{
 "driver_default"   "mysql"
 
 "default"
 {
  "driver"   "default"
  "host"    "myhost.dk"
  "database"   "mydatabase"
  "user"    "myusername"
  "pass"    "mypassword"
  //"timeout"   "0"
  //"port"   "3306"
 }
 "storage-local"
 {
  "driver"   "sqlite"
  "database"   "sourcemod-local"
 }
 "clientprefs"
 {
  "driver"   "sqlite"
  "host"    "localhost"
  "database"   "clientprefs-sqlite"
  "user"    "root"
  "pass"    ""
  //"timeout"   "0"
  //"port"   "3306"
 }
}
webadmin/inc/config.php
Code:
// Webadmin MySQL Settings:
$servername = "myhost.dk"; // DB hostname
$dbport     = "3306";    // DB port (Default: 3306)
$dbusername = "myusername";   // DB username
$dbpassword = "mypassword";  // DB password
$dbname     = "mydatabase";   // DB name
$table      = "smwa";    // Tableprefix interface tables.
$smtable    = "sm";     // Tableprefix sourcemod "SQL Admin" tables.
__________________
[+35]Jumpman
Jumpman is offline
codydbgt
Member
Join Date: Apr 2009
Old 10-21-2012 , 23:02   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #608

so we ever going to fix this ?????

Quote:
Query:
UPDATE
smwa_users
SET
UserName = 'admin',
UserMail='[email protected]',
UserEditUsers='1',UserSQLAdmins='1',UserServe rsettings='1',UserEditPluginsettings='1',User EditInterfacesettings='1',UserEditMods='1',Us erEditPermissions='1',UserPlugincontrol='1',
UserLanguage='default'
WHERE
UserID = 1
Antwort: Unknown column 'UserPlugincontrol' in 'field list'
EDIT:Not shure if this helps or makes it worse but i just added the table with phpmyadmin and that fixed my issue
__________________

Last edited by codydbgt; 10-21-2012 at 23:13.
codydbgt is offline
DontWannaName
Veteran Member
Join Date: Jun 2007
Location: VALVe Land, WA
Old 10-26-2012 , 03:51   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #609

Are you adding support for https://forums.alliedmods.net/showthread.php?p=1718454 ?
__________________

DontWannaName is offline
StrikerMan780
AlliedModders Donor
Join Date: Jul 2009
Location: Canada
Old 10-26-2012 , 11:06   Re: Sourcemod Webadmin (Updated 12/05/2012)
Reply With Quote #610

The AdSQL Section is inserting backslashes, and &quot when I'm using apostrophes or quotation marks, when it should not. I'm using Firefox as my browser.

eg:
{orange}Tip: {white}If you cry {red}\'\'Don\'t Kill Me!!\'\' {white}chances are, you\'ll be shot at even more.

Last edited by StrikerMan780; 10-26-2012 at 11:06.
StrikerMan780 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 21:36.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode