[campcaster-dev] Current SVN code can't open ODBC driver
  • Vote Up0Vote Down importimport
    Posts: 0Member
    using config file '/home/studio/src/campcaster/src/products/scheduler/etc/scheduler.xml'
    [GstreamerPlayer] [virtual void LiveSupport::PlaylistExecutor::GstreamerPlayer::configure(const xmlpp::Element&)]
    error executing command start
    database installation problem: Failed to connect to datasource: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

    Distro is Debian testing (etch)

    I have the odbc-postgresql and unixodbc-dev packages installed. The only thing I can find in the XML config file that relates to a database is:


    userName = "test"
    password = "test"
    />


    but no reference to ODBC

    I don't know where else to go from here.

    -lee
  • 3 Comments sorted by
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Hi Lee,

    Did you set up Campcaster according to the DevelopmentEnvironment wiki?
    http://code.campware.org/projects/campcaster/wiki/DevelopmentEnvironment

    If so, your database and ODBC data source should have been set up by the
    bin/user_setup_db.sh script. Re-running it might give you useful error
    messages.

    Check your ODBC settings in /etc/odbc.ini and especially
    /etc/odbcinst.ini, which should look like this:
    [PostgreSQL]
    Description = PostgreSQL driver
    Driver = /usr/lib/odbc/psqlodbcw.so
    Setup = /usr/lib/odbc/libodbcpsqlS.so
    UsageCount = 1

    You can test your ODBC driver installation by typing
    isql Campcaster- test test
    it should say "Connected!" if it is set up correctly.

    Ferenc
  • Vote Up0Vote Down importimport
    Posts: 0Member
    ----- Ferenc Gerlits wrote:
    > Hi Lee,
    >
    > Did you set up Campcaster according to the DevelopmentEnvironment
    > wiki?
    > http://code.campware.org/projects/campcaster/wiki/DevelopmentEnvironment

    I did but it looks like the installation script named setupDevelopmentEnvironment.sh didn't edit the line


    userName = "test"
    password = "test"
    />


    for my username. When I changed it manually the error went away but now this one appears:

    Error in XmlRpcClient::parseResponse: Invalid response - no methodResponse. Response:


    404 Not Found

    Not Found


    The requested URL /campcasterStorageServer/xmlrpc/xrLocStor.php was not found on this server.



    Apache/2.2.3 (Debian) PHP/5.1.6-5 Server at localhost Port 80



    error executing command start
    authentication problem: Login failed.
    sleep 2
    make[1]: Leaving directory `/home/studio/src/campcaster/src/products/scheduler'

    I'm begining to think the installation script didn't update scheduler.xml with valid data.

    -lee
  • Vote Up0Vote Down importimport
    Posts: 0Member
    After last night I decided to wipe the code I was was trying to compile and do a fresh checkout from SVN. This magically fixed all the problems I was having. Everything works as expected.

    -lee

    ----- Ferenc Gerlits wrote:
    > Hi Lee,
    >
    > Did you set up Campcaster according to the DevelopmentEnvironment
    > wiki?
    > http://code.campware.org/projects/campcaster/wiki/DevelopmentEnvironment
    >
    > If so, your database and ODBC data source should have been set up by
    > the
    > bin/user_setup_db.sh script. Re-running it might give you useful
    > error
    > messages.
    >
    > Check your ODBC settings in /etc/odbc.ini and especially
    > /etc/odbcinst.ini, which should look like this:
    > [PostgreSQL]
    > Description = PostgreSQL driver
    > Driver = /usr/lib/odbc/psqlodbcw.so
    > Setup = /usr/lib/odbc/libodbcpsqlS.so
    > UsageCount = 1
    >
    > You can test your ODBC driver installation by typing
    > isql Campcaster- test test
    > it should say "Connected!" if it is set up correctly.
    >
    > Ferenc
Add a Comment