CoD4 - MySQL problem

[BlancO]

I've got a problem with MySQL. I don't know what's wrong. After this MySQL is still the same. There's no players table.

.gsc script

		    mysql = std\mysql::mysql_real_connect(std\mysql::mysql_init(), level.mysqlAdress, level.mysqlUser, level.mysqlPass, level.mysqlDb, level.mysqlPort)

    std\mysql::mysql_query(mysql, "CREATE TABLE players (id int NOT NULL AUTO_INCREMENT, name varchar(30), score varchar(12), kills varchar(9), PRIMARY KEY(id))");
    std\mysql::mysql_close(mysql); 
	

.sh script

cd /home/cod4/zombie
LD_LIBRARY_PATH="/home/libcod/mysql" LD_PRELOAD="/home/libcod/libcod4_1_7.so" ./cod4x17a_lnxded +set dedicated "2" +set net_port "28961" +set fs_basepath "/home/cod4/zombie/" +set fs_game "mods/nlMod" +exec nlMod.cfg +map_rotate

Contents of /home/libcod:

root@blanco:/home/libcod# ls
libastar.so     libcod2_1_2.so  libcod2.so      mysql
libcod1_1_5.so  libcod2_1_3.so  libcod4_1_7.so

Contents of /home/libcod/mysql:

root@blanco:/home/libcod/mysql# ls
libmysqlclient.a     libmysqlclient.so  libmysql.so.16
libmysqlclient_r.so  libmysql.so        libmysql.so.16.0.0

[kung foo man]

It might be everything, best is to check always for errors and printing them:

		#include std\mysql;

mysql_test()
{
    host = getcvar("mysql_host");
    user = getcvar("mysql_user");
    pass = getcvar("mysql_pass");
    db = getcvar("mysql_db");
    port = getcvarint("mysql_port");
    
    
    mysql = mysql_init();
    
    if ( ! isDefined(mysql))
    {
        std\io::println("mysql not defined!");
        return;    
    }

    std\io::print("mysql=" + ("2"+2) + "\n");
    
    ret = mysql_real_connect(mysql, host, user, pass, db, port);
    if (!ret)
    {
        std\io::print("errno="+mysql_errno(mysql) + " error=''"+mysql_error(mysql) + "''\n");
        mysql_close(mysql);
        return 0;
    }
    
    std\io::print("affected_rows="+mysql_affected_rows(mysql)+"\n");
    
    
    
    name = "fo\"0'z0`r"; // all user-input is evil!
    name = mysql_real_escape_string(mysql, name); // so escape it :)
    
    theQuery = "SELECT * FROM players";
    theQuery = "SELECT \""+name+"\" as first,2 as second,3 as third UNION SELECT 11,22,33";
    
    std\io::print(theQuery);
    
    ret = mysql_query(mysql, theQuery);
    if (ret != 0)
    {
        std\io::print("errno="+mysql_errno(mysql) + " error=''"+mysql_error(mysql) + "''\n");
        mysql_close(mysql);
        return 0;
    }
    
    result = mysql_store_result(mysql);
    
    std\io::print("num_rows="+mysql_num_rows(result) + " num_fields="+mysql_num_fields(result)+"\n");
    
    mysql_field_seek(result, 0);
    while (1)
    {
        result_name = mysql_fetch_field(result);
        if (!isString(result_name))
            break;
        std\io::print("field-name=" + result_name+"\n");
    }
    
    while (1)
    {
        row = mysql_fetch_row(result);
        if (!isDefined(row))
        {
            //std\io::print("row == undefined\n");
            break;
        }
        output = "";
        for (i=0; i<row.size; i++)
            output += row[i] + " ";
        std\io::print(output+"\n");
    }
    
    mysql_free_result(result);
    
    mysql_close(mysql);
            
} 
	

Example from: http://killtube.org/downloads/cod2/e..._debugging.gsc

[Sense]

Do you have a mysql database? if not then here we go.

Before installing Mysql, make sure your repositories are up to date:

apt-get update

Now you need Apache:

apt-get install apache2

To install Mysql, enter terminal or screen and type in these commands:

apt-get install mysql-server

Follow the instructions.
If you miss the chance to set the password then you can always do it within the mysql shell.

Run the mysql setup script:

mysql_secure_installation

The prompt will ask you for your current root password. Type it in.

Once again follow the instructions and remember pressing N is for No and Y for yes.

INSTALLING PHP? not sure if it's necessary but here we go:

apt-get install php5 php-pear php5-suhosin php5-mysql

Answer YES twice and it will install itself.

Finish up by restarting apache:

service apache2 restart

[YuriJurek]

Well all of that is already installed no worry about such a basic stuff

[Sense]

Well all of that is already installed no worry about such a basic stuff

Just tried to help, show a little gratitude instead..

[BlancO]

I think it's something wrong with libcod. I even don't receive any of these "std\io::print". I have mysql-server, apache2, php5 installed.

[kung foo man]

When you start the server, you should see something like this:

> [WARNING] Compiled for: 210
Compiled: Sep 17 2013 23:08:19
> [INFO] value of closer=08111d32
> [PLUGIN LOADED]
CoD2 MP 1.0 build linux-i386 Oct 24 2005
----- FS_Startup -----
Current search path:
/home/k_deathrun/zombots
/home/k_deathrun/main/iw_14.iwd (4038 files)
/home/k_deathrun/main/iw_13.iwd (22624 files)
/home/k_deathrun/main/iw_12.iwd (1016 files)
/home/k_deathrun/main/iw_11.iwd (1462 files)
/home/k_deathrun/main/iw_10.iwd (1936 files)
/home/k_deathrun/main/iw_09.iwd (2142 files)
/home/k_deathrun/main/iw_08.iwd (2723 files)
/home/k_deathrun/main/iw_07.iwd (3384 files)
/home/k_deathrun/main/iw_06.iwd (990 files)
/home/k_deathrun/main/iw_05.iwd (928 files)
/home/k_deathrun/main/iw_04.iwd (698 files)
/home/k_deathrun/main/iw_03.iwd (26 files)
/home/k_deathrun/main/iw_02.iwd (40 files)
/home/k_deathrun/main/iw_01.iwd (16 files)
/home/k_deathrun/main/iw_00.iwd (102 files)
/home/k_deathrun/main
/home/k_deathrun/raw
/home/k_deathrun/raw_shared
/home/k_deathrun/devraw
/home/k_deathrun/devraw_shared

Do you see the [PLUGIN LOADED]? It might can't find the mysql-dependency

[YuriJurek]

Just tried to help, show a little gratitude instead..

I mean no disrespect maybe it just sounds so a little bit.

[BlancO]

I can't see "[PLUGIN LOADED]"...

.sh file

export LD_LIBRARY_PATH="/home/cod4/server/libs:/home/cod4/server/libs/mysql"
export LD_PRELOAD="/home/cod4/server/libs/libcod4_1_7.so"

cd /home/cod4/server
./cod4_lnxded +set dedicated "2" +set net_port "28961" +set fs_basepath "/home/cod4/server" +set fs_homepath "/home/cod4/server" +set fs_game "mods/nl_zom" +exec zom.cfg +map_rotate

[kung foo man]

cod4_lnxded is a start-script, call cod4_lnxded_bin directly