Scheduler/PHP startup error - php-5.0.4/fc4
  • I finally got livesupport 1.0.1 to build and install on an up-to-date fc4 system, after digging up what rpms were missing, but now I have an error showing up when I start the scheduler.
    running './bin/scheduler.sh start', I get the following:

    $ ./bin/scheduler.sh start
    Starting the LiveSupport scheduler...
    using config file '/home/dead/livesupport/etc/scheduler.xml'
    error executing command start
    authentication problem: Login method returned fault response:
    [faultCode:805,faultString:ERROR:xrLocStor: 2048 Non-static method PEAR::setErrorHandling() should not be called statically (/home/dead/livesupport/var/LiveSupport/storageServer/var/xmlrpc/xrLocStor.php:72)]

    The scheduler doesn't start, obviously, and the web UI only reports "DB Error: connect failed".
    I'm also getting the following error in apache's error_log:
    [client 10.10.10.102] PHP Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /home/dead/livesupport/var/LiveSupport/htmlUI/var/ui_browser_init.php on line 49

    not sure if that has any bearing on the scheduler start issue...

    background:
    I am using the pgsql database for fc4 on another local server (also fully up-to-date with latest fc4 updates), 10.10.10.50, and can connect with php both using the pear/DB.php library and standard pg_pconnect(), with psql and isql via ODBC.
    Observe:
    $ isql livesupport livesupport livesupport
    +---------------------------------------+
    | Connected! |
    | |
    | sql-statement |
    | help [tablename] |
    | quit |
    | |
    +---------------------------------------+
    SQL> quit
    $ psql LiveSupport -h 10.10.10.50 -U livesupport
    Password:
    Welcome to psql 8.0.4, the PostgreSQL interactive terminal.

    Type: \copyright for distribution terms
    \h for help with SQL commands
    \? for help with psql commands
    \g or terminate with semicolon to execute query
    \q to quit

    LiveSupport=> \q
    $ cat ./test.php

    require_once 'lib/pear/DB.php';

    $dsn = array(
    'phptype' => 'pgsql',
    'username' => 'livesupport',
    'password' => 'livesupport',
    'hostspec' => '10.10.10.50',
    'database' => 'LiveSupport',
    );

    $options = array(
    'debug' => 2,
    'portability' => DB_PORTABILITY_ALL,
    );

    $db =& DB::connect($dsn, $options);
    if (PEAR::isError($db)) {
    die($db->getMessage());
    } else {
    print("Connected! woot!\n");
    }

    ?>
    $ php ./test.php
    Connected! woot!
    $
    I did have to manually create the db and db user, but I did it using the sql commands that the 'make install' output displayed when it failed to do it automatically, and as you can see the db and dbuser work fine from the livesupport box. also, I had to employ the "class ErrorHandler;" fix from another php5 thread here in this forum to get libodbc++ to build (http://code.campware.org/phorum/read.php?20,2395,2409#msg-2409).


    Where do I go from here? is it a compatibility issue with php5 or pgsql-8.0.4? or...?

    Did I leave any steps or information out?

    Thanks for reading =)
  • 1 Comment sorted by
  • also, I verified that the scheduler.xml config file is using the proper dns, user, pass for the ODBC connection I created called 'livesupport':

    snipped from ./etc/scheduler.xml:

    userName = "livesupport"
    password = "livesupport"
    />


    and:

    $ cat /etc/odbc.ini
    [livesupport]
    Description = PostgreSQL
    Driver = PostgreSQL
    Trace = No
    TraceFile =
    Database = LiveSupport
    Servername = 10.10.10.50
    Username = livesupport
    Password = livesupport
    Port = 5432
    Protocol = 6.4
    ReadOnly = No
    RowVersioning = No
    ShowSystemTables = No
    ShowOidColumn = No
    FakeOidIndex = No
    ConnSettings =