[ShadoX]

Hey sn4k3

I'm having problems again, it seems the plugin can't load the freelib part of this plugin. I run the following in console and get the following

meta refresh Unable to find an interface, ignoring SU: Auto-Loading Source Utils Events To EventScripts! SU: Source Utils Security Loaded Sucessfull! ***************************************** Source Utils Load Successfull!! Game: Day of Defeat: Source Using 'ServerGameDLL006' Version: 1.5 MMS Written By: Sn4k3 Contact: [email protected] ***************************************** L 06/18/2007 - 20:05:07: [META] Loaded 1 plugins from file. Failed to load plugin addons/sourceutils/bin/sourceutils_freelib_mm (libstdc++.so.6: cannot open shared object file: No such file or directory).

It doesn't seem to be able to see the freelib_mm file
I can confirm that that particular file is there, under the exactly path that it looks for it above

Any ideas? This is on Linux, i'm about to try it on my Windows test server (but even if it works there i'll still need a working linux version since all our production/public servers are linux)

Cheers

[edit] Nevermind, i saw on the SourcePlugins forum that the "libstdc++" binary needs to be version 6, i of course had version 5.
An update fixed it
Perhaps add a note on the front page about this requirement?

[sn4k3]

a guy have already solved that problem

deac_neo :

I have the Problem...
it was a problem with the libstdc++.so.6 file from the debian system. i had installed the older version 5. so the freelib doesn´t run...

now all is running. thx for all
---

you should have libstdc++.so.5, you must update for libstdc++.so.6

[devicenull]

I'm not sure if you are aware of this.. but the GeoIP stuff included in the main plugin is under the LGPL, which based on how you used it, requires the code to be open :/

[sn4k3]

Originally Posted by devicenull I'm not sure if you are aware of this.. but the GeoIP stuff included in the main plugin is under the LGPL, which based on how you used it, requires the code to be open :/

i not have repared in this i think LGPL allow you use for free usage and can be in closed source

[sn4k3]

Originally Posted by devicenull I'm not sure if you are aware of this.. but the GeoIP stuff included in the main plugin is under the LGPL, which based on how you used it, requires the code to be open :/

i send a mail for MaxMind asking about LGPL

and the guy say i can use C API under closed source

http://sn4k3.apresent.aloj.net/img/LGPL.JPG

[sn4k3]

new version !!

v1.6 [26/7/07]

- added SourceUtils FreeLib can run without SourceUtils bin files (only mysql functions)
- added 'su_thread' event for threaded functions like geoip http
- added 'su_file' event for debug/print a file
- added file open/endwrite/list/remove/event commands
- added su_echo command
- added su_getexists mapent (allow know if exists an entity in map eg. buy_zone)
- added su_for command
- added su_FileCreate command (allow you create your own files!)
- added su_dumpclassprops command
- added su_dumpmapentitys command
- added su_dumpsclean command
- added a new folder 'addons/sourceutils/dumps' for dumps

- added 'su_nextmap' cvar to know nextmap
- added 'su_backmap' cvar to know backmap

- updated GeoIp.dat
- updated sourceutils_security.cfg with Files Options

- Improved su_compile command!
- Improved su_cvarforceset command!

- fixed all userid problems (crashs, not found userid)
- fixed "su_getnetinfo timeout" no setvalue to 0
- fixed all "su_getexists" no setvalue to 0

[PsYcH]

Hello people,

At first i searched the whole forum for help (not only this forum ;);))
Some days ago i started my own CSS server. For now i use an dedicated server (located home) and these are the specs.
Amd 2400+/Asrock mobo/1gb ram/ati9600 Its not a great server but its just for testing.

Its running fine without the WCS3mod and i played with friends on it. It also works with the WCS3Mod without a database (or stored in a .txt). Ports and all that other stuff is forwared on the right way and is also working.

But......


The software:
Windows xp SP1
Kaspersky (up to date)
hldsupdatetool
srcds counterstrike dedicated server (up to date)
Wamp 1.7.2 (apache & MySQL)

Counterstrike plugins/addons
Source_Utils_v1.6_mms (metamod version)
sourcemm-1.4.2 (metamod itself)
Mattie eventscript
Eventscript_ver 1.3.0.006
Est_eversion 0.418
WCS3 version 0.75

The problem:
Because i just started with all this stuff, i have no idea how it actually works.
So here are my main questions:
1. Does Source_Utils have anything to do with MySQL (the MySQL from www.mysql.com)?
2. If no, where does this Source Utils stores its data? (databases)
3. If yes, how to set up a decent connection for the WCS3 mod because it just wont connect to the MySQL server.
4. What is the default root password for Source Utils? And how or where do i change it?
5. Could somebody give me a link with a tutorial or something about this all ?

I think it could be something with the code of the WCS3mod:

block load
{
  // DB settings
  es_xsetinfo wcs_sql_user "this is the place where i put my MySQL username"
  es_xsetinfo wcs_sql_password "************"
  es_xsetinfo wcs_sql_host "192.168.1.206"
  es_xsetinfo wcs_sql_port "3306" // 3306 is default
  es_xsetinfo wcs_sql_dbname "wcs_users" // can be modified !
  es_xsetinfo wcs_sql_tablename "player_levels" // can be modified !

  es es_xexists wcs_exists command wcs_sql_setplayer
  es es_xif (server_var(wcs_exists) = "0") then es_xregcmd wcs_sql_setplayer wcs/WCSsql/wcs_sql_setplayer "saves a player"
  es es_xexists wcs_exists command wcs_sql_getplayer
  es es_xif (server_var(wcs_exists) = "0") then es_xregcmd wcs_sql_getplayer wcs/WCSsql/wcs_sql_getplayer "get a player"
  es_xsetinfo wcs_sql_query 0
  es_xsetinfo wcs_sql_query2 0
  es_xsetinfo wcs_sql_query_result 0
  es_xsetinfo wcs_sql_tmp1 0
  es_xsetinfo wcs_sql_tmp2 0
  alias wcs_runquery "es_xsetinfo wcs_sql_query_result 0; es su_mysql server_var(wcs_sql_host) server_var(wcs_sql_port) server_var(wcs_sql_user) server_var(wcs_sql_password) server_var(wcs_sql_dbname) server_var(wcs_sql_query) wcs_sql_query_result;"
  alias wcs_runquery "es est_strlen wcs_strlen server_var(wcs_sql_query);es es_xif (server_var(wcs_debug) = 1) then echo qry: server_var(wcs_sql_query) len: server_var(wcs_strlen) result: ' server_var(wcs_sql_query_result) '"
  // init the DB, table 1
  es es_xformat wcs_sql_query "CREATE TABLE %1 (steamid VARCHAR(30) NOT NULL, lastplayed INT DEFAULT 0, race TINYINT DEFAULT 0, PRIMARY KEY (steamid))" server_var(wcs_sql_tablename)
  wcs_runquery
  es_xsetinfo wcs_counter 1
    while "server_var(wcs_counter) <= server_var(wcs_numberofraces)" "es_xdoblock wcs/WCSsql/wcs_sql_createloop;es_xmath wcs_counter + 1"
    // get the name as last column
    es es_xformat wcs_sql_query "ALTER TABLE %1 ADD name_1 VARCHAR(50) DEFAULT 0" server_var(wcs_sql_tablename)
  wcs_runquery
  es es_xformat wcs_sql_query "UPDATE %1 set name_1 = name" server_var(wcs_sql_tablename)
  wcs_runquery
  es es_xformat wcs_sql_query "ALTER TABLE %1 DROP COLUMN name" server_var(wcs_sql_tablename)
  wcs_runquery
  es es_xformat wcs_sql_query "ALTER TABLE %1 CHANGE name_1 name VARCHAR(50) DEFAULT 0" server_var(wcs_sql_tablename)
  wcs_runquery
}

This is just a piece of the code .

These are my questions so far (yeah im a big noob(^^)).

Any help would be greatfull.

Thanks,

PsYcH

[sn4k3]

WCS is using SourceUtils v1.0 or v1.1 so the SourceUtils mysql change a little

request to WCS scripters for update with new SourceUtils Mysql System
OR

use old versions

[PsYcH]

What is the default password of sourceUtils?
Where to change that password?

The error i get:

 SU: MySql erro: Host 'server' is not allowed to connect to this MySql server

And does SourceUtils have anything to do with MySql (from www.mysql.com)?

Thanks

[sn4k3]

Originally Posted by PsYcH What is the default password of sourceUtils? Where to change that password? The error i get: SU: MySql erro: Host 'server' is not allowed to connect to this MySql server And does SourceUtils have anything to do with MySql (from www.mysql.com)? Thanks

???

yes www.mysql.com can give you some info about mysql like docs, syntax

sourceutils not have default pw

mysql is a database system
password and user is choosed by you

for you have a mysql database you need rent one
In Some Host Plans you can see MySQL Checked that means host include MYSQL

 SU: MySql erro: Host 'server' is not allowed to connect to this MySql server

this mean 'server' not exists

this is the same thing you write 'server' in your webbrowser and preset Go or Navigate