Raised This Month: $51 Target: $400
 12% 

[ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)


Post New Thread Reply   
 
Thread Tools Display Modes
BReeZ
AlliedModders Donor
Join Date: Feb 2013
Location: Denmark
Old 10-24-2016 , 04:26   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #431

Hello, i could use some help.

When creating the table, how do i know the names of the columns, and how many i need?
A bit unsure on setting up the table^
BReeZ is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 10-24-2016 , 06:56   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #432

The table is setup automaticaly by the plugin, just create the database and configure databases.cfg
h3bus is offline
BReeZ
AlliedModders Donor
Join Date: Feb 2013
Location: Denmark
Old 12-09-2016 , 05:33   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #433

[redirect.smx] A2S Socket error on server 151.80.47.9:27017 |Type 6, errno 111
[redirect.smx] A2S error 'SocketError' while refreshing 151.80.47.9:27017 infos
BReeZ is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 12-10-2016 , 09:52   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #434

Errno 111 is "Connection refused"
h3bus is offline
Czar_
Senior Member
Join Date: Nov 2016
Location: Moms Basement
Old 12-11-2016 , 13:33   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #435

Just installed this on both of my Csgo retake servers. I have followed all the install instructions and the plugin is running. When i do sm_servers, sm_hop nothing shows up. Is there something i am missing when installing?
__________________
Czar_ is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 12-13-2016 , 14:37   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #436

You should check error logs.
I suspect an error with the database but I could be wrong.
h3bus is offline
Czar_
Senior Member
Join Date: Nov 2016
Location: Moms Basement
Old 12-13-2016 , 17:21   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #437

Quote:
Originally Posted by h3bus View Post
You should check error logs.
I suspect an error with the database but I could be wrong.
L 12/11/2016 - 13:21:19: [redirect.smx] Database table creation failure: near "KEY": syntax error
L 12/11/2016 - 13:22:18: Error log file session closed.

Database config:
"redirect"
{
"driver" "sqlite"
"host" "localhost"
"database" "redirect"
"user" "root"
"pass" ""
}

Should I be using Mysql instead of Sqlite?
__________________
Czar_ is offline
sneaK
SourceMod Moderator
Join Date: Feb 2015
Location: USA
Old 12-13-2016 , 18:06   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #438

Quote:
Originally Posted by Czar_ View Post
Should I be using Mysql instead of Sqlite?
Yes.

Quote:
Originally Posted by h3bus View Post
Requirements
  • A mySQL server


How to install?
  1. Setup a mySQL table, and grant a user all privilege on it
__________________
sneaK is offline
Czar_
Senior Member
Join Date: Nov 2016
Location: Moms Basement
Old 12-13-2016 , 19:15   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #439

Quote:
Originally Posted by blackhawk74 View Post
Yes.
Setup the mysql table. Same problem. Plugins load but commands do nothing.
Checked error logs. No errors.

EDIT: The plugin is loaded "Server Redirect: Ask connect with connect box" (0.2.5) by H3bus
Config
"redirect"
{
"driver" "mysql"
"host" "localhost"
"database" "redirect"
"user" "root"
"pass" "<password>"
}

L 12/13/2016 - 23:53:18: [SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory
L 12/13/2016 - 23:53:18: [redirect.smx] Database connection failure: Could not find driver "mysql"
Fixed these errors. !servers sm_servers !hop sm_hop still dont do anything
Next error: L 12/14/2016 - 00:106: [redirect.smx] Database connection failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
No longer getting that error or any other error. still cant get commands to work. About to just give up on this plugin....
__________________

Last edited by Czar_; 12-14-2016 at 00:25. Reason: adding errors
Czar_ is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 12-14-2016 , 01:55   Re: [ANY] Server Redirect - A full featured server listing/hoper (v0.2.6, 24/01/2016)
Reply With Quote #440

One server having access to the mySQL database is à thing. You Can check in the database if the tables are actually created and if a line coresponding to that server is present.
However, !hop command won't show anything until another server running the plugin has registered into the SAME database.
h3bus 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 05:16.


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