sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] sqlr-start; sqlr-listener problems

[Luis M. C. C. <lmc...@ho...>]

Hi!!
I’m having problems with the slr-start comand. Because the sqlr-listener command doesn’t create the “sqlr-listener-example” file needed by the sqlr-scaler command.
 
[root@localhost bin]# ./sqlr-start -debug -id example -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var
 
Starting listener:
  sqlr-listener -id example -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.718
 
Starting 3 connections to db1 :
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.720
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.722
  sqlr-connection-mysql -id example -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.724
 
Starting scaler:
  sqlr-scaler -id example -debug  -config /usr/local/firstworks/etc/sqlrelay.conf -localstatedir /usr/local/firstworks/var
 
sqlr-scaler error: 
        The file /usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-example was not found.
        This usually means that the sqlr-listener is not running.
        The sqlr-listener must be running for the sqlr-scaler to start.
 
 
sqlr-scaler failed to start.
 
 
Thanks to MP3.com for sponsoring: 
        Clustered/Replicated database support.
        Perl API.
Thanks to FeedLounge for sponsoring: 
        Query routing and filtering.
 
 
However, if I execute the command by itself, the “sqlr-listener-example” is created successfully.
 
But when trying to access the database with the command, the response is a failure.
[root@localhost bin]# sqlrsh 192.168.1.123 9000 "" user1 password1
SQLRShell - Version 0.22
        Connected to: 192.168.1.123:9000 as user1
 
        type help; for a help.
 
0> ping;
        The database is down.
 
Also, in the sqlrelay.conf file I got this configuration.
<instance id="example" port="9000" socket="/tmp/examplesocket" dbase="mysql"
 
Does this means that a file called “/tmp/examplesocket” has to be created? Because I don’t see it anywhere.
 
Thanks.
 
Atte
Luis Mauricio Calderon Castro.
_________________________________________________________________
Windows Live Hotmail now works up to 70% faster.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008

Re: [Sqlrelay-discussion] Listener crash on Linux64

[Adrian-Cristian G. <adr...@gm...>]

I use strace and ltrace, maybe you can we this:
It crash in function detach():

In /sqlrelay-0.40/src/listener/sqlrlistener.C
bool sqlrlistener::initListener(int argc, const char **argv) {

        init=true;

        cmdl=new cmdline(argc,argv);

        tempdir         tmpdir(cmdl);

        if (!cfgfl.parse(cmdl->getConfig(),cmdl->getId())) {
                return false;
        }

        setUserAndGroup();

        if (!verifyAccessToConfigFile(cmdl->getConfig())) {
                return false;
        }

        dbgfile.init("listener",cmdl->getLocalStateDir());
        if (cmdl->found("-debug")) {
                dbgfile.enable();
        }

        if (!handlePidFile(&tmpdir,cmdl->getId())) {
                return false;
        }

        handleDynamicScaling();

        setHandoffMethod();

        if (cfgfl.getAuthOnListener()) {
                authc=new authenticator(&cfgfl);
        }

        setIpPermissions();

        if (!createSharedMemoryAndSemaphores(&tmpdir,cmdl->getId())) {
                return false;
        }

        if ((passdescriptor=cfgfl.getPassDescriptor())) {
                if (!listenOnHandoffSocket(&tmpdir,cmdl->getId())) {
                        return false;
                }
                if (!listenOnDeregistrationSocket(&tmpdir,cmdl->getId())) {
                        return false;
                }
                if (!listenOnFixupSocket(&tmpdir,cmdl->getId())) {
                        return false;
                }
        }

        idleclienttimeout=cfgfl.getIdleClientTimeout();
        maxquerysize=cfgfl.getMaxQuerySize();
        maxlisteners=cfgfl.getMaxListeners();
        listenertimeout=cfgfl.getListenerTimeout();

        detach();

        createPidFile(pidfile,permissions::ownerReadWrite());

        return true;
}

The function detach() is defined here:
/rudiments-0.32/src/daemonprocess.C:

bool daemonprocess::detach() const {

        // fork off a child process
        int     result;
        do {
                result=fork();
        } while (result==-1 && error::getErrorNumber()==EINTR);

        if (result==-1) {
                return false;
        }

        // let the parent process exit
        if (result) {
                // cygwin needs a sleep or both processes will exit
                #ifdef __CYGWIN__
                snooze::macrosnooze(1);
                #endif
                _exit(0);
        }

        // become process group and session group leader
        // with no controlling terminal
        setsid();

        // change directory to root to avoid keeping any directories in use
        do {} while (chdir("/")==-1 && error::getErrorNumber()==EINTR);

        // Set umask such that files are created 666 and directories 777.
        // This way we can change them to whatever we like using chmod().
        // We want to avoid inheriting a umask which wouldn't give us write
        // permissions to files we create.
        umask(0);

        return true;
}

which is implemented with fork()

Fron listener.str(strace):
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD,
child_tidptr=0x2adc653e82e0) = 9760
exit_group(0)

Thank you in advance!

On Mon, Mar 2, 2009 at 5:31 PM, Adrian-Cristian Grigoras <
adr...@gm...> wrote:

> Hi,
> I need to run sqlrelay on a RHEL 5 on 64 bits. I use sqlrelay 0.4. It
> starts the listener, but the listener crashes when I execute :
> /usr/local/firstworks/bin/sqlrsh -id oratest
>
> I receive thie error: Authentification failed.
>
> I set up the authentier to: listener, connection and database, but with no
> luck.
>
> How to resolve this? Does version 0.39.4 work on Linux64 or has the same
> problems? I saw that the problem with listener in happening in version 0.40.
>
> Thank you in advance!
>

[Sqlrelay-discussion] Listener crash on Linux64

[Adrian-Cristian G. <adr...@gm...>]

Hi,
I need to run sqlrelay on a RHEL 5 on 64 bits. I use sqlrelay 0.4. It starts
the listener, but the listener crashes when I execute :
/usr/local/firstworks/bin/sqlrsh -id oratest

I receive thie error: Authentification failed.

I set up the authentier to: listener, connection and database, but with no
luck.

How to resolve this? Does version 0.39.4 work on Linux64 or has the same
problems? I saw that the problem with listener in happening in version 0.40.

Thank you in advance!

Re: [Sqlrelay-discussion] oddity with cursors in sqlrelay-0.39

[Guillaume G. <sql...@bl...>]

David Muse a écrit :
> Hi Guillaume,
> 
> Sorry for taking so long to respond.  Hopefully you figured out the
> problem already :)

Sure :)

> 
> I'm not sure what's going on.  When I run that C++ program it works fine
> for me with 0.40.  It could be that there was a bug in 0.39.  You might
> try a more recent release.  Also, what database are you using?

I use postgresql (8.2.7-2+b1 from debian) with sqlrelay-postgresql 
(1:0.39.4-7 also from debian).

If it's ok for you with this connector, I'll go for 0.40.

Thanks a lot !

Best regards - Guillaume Gimenez

Re: [Sqlrelay-discussion] oddity with cursors in sqlrelay-0.39

[David M. <dav...@fi...>]

Hi Guillaume,

Sorry for taking so long to respond.  Hopefully you figured out the
problem already :)

I'm not sure what's going on.  When I run that C++ program it works fine
for me with 0.40.  It could be that there was a bug in 0.39.  You might
try a more recent release.  Also, what database are you using?

David Muse
dav...@fi...

On Tue, 2009-02-03 at 18:42 +0100, Guillaume Gimenez wrote:
> Hi folks,
> 
> I'm working on a project that puts an abstraction layer around sqlrelay. 
> And I found something like an inconsistency in the manner the cursors 
> are constructed and destructed. All cursors are consumed with the error 
> message
> "No server-side cursors were available to process the query."
> 
> 
> I'm using sqlrelay-0.39 provided by debian
> 
> the interesting part of /etc/sqlrelay/sqlrelay.conf
>      <instance id="cpta" port="9000" socket="/tmp/.sqlrelay.cpta" 
> dbase="postgresql" connections="5" maxconnections="5" maxqueuelength="0" 
> growby="1" ttl="60" endofsession="rollback" sessiontimeout="600" 
> runasuser="sqlrelay" runasgroup="sqlrelay" cursors="40" 
> authtier="listener" handoff="pass">
> 
> the snippet of code that exhausts cursors
> ----------8<--------------------8<--------------------8<----------
> #include <iostream>
> #include <sqlrelay/sqlrclient.h>
> 
> using namespace std;
> 
> int main(int argc, char **argv) {
> 
>          sqlrconnection      *con=new 
> sqlrconnection("localhost",9000,"/tmp/.sqlrelay.cpta","zorro","11digitsprimenumber",1,1);
> 
> 
>      for ( int i=0 ; i<100 ; ++i ) {
>              sqlrcursor          *cursor1=new sqlrcursor(con);
>              sqlrcursor          *cursor2=new sqlrcursor(con);
>          if ( cursor1->sendQuery("SELECT 1 AS r1") == 0 ) {
>              cout << cursor1->errorMessage() << endl;
>              return 1;
>          }
>          if ( cursor2->sendQuery("SELECT 2 AS r2") == 0 ) {
>              cout << cursor2->errorMessage() << endl;
>              return 1;
>          }
>          delete cursor2;
>          delete cursor1;
>      }
> 
> return 0;
> }
> ----------8<--------------------8<--------------------8<----------
> 
> I know that in this example sqlrcursor's pointers should be declared and 
> initialized outer the for loop. but it is approximatively what the 
> abstraction layer does with the following code  :
> 
> Connection 
> conn("sqlrelay://zoro:11digitsprimenumber@localhost:9000/tmp/.sqlrelay.cpta");
> for (...) {
>      Begin transaction(conn);
>      conn.query(...);
> }
> 
> Could you tell me if I'm wrong ?
> And if I'm wrong, why this strange issue occurs ?
> 
> Thanks in advance
> 
> 
> Best regards - Guillaume Gimenez
> 
> 
> PS: For information this pseudo code
> class Begin {
>      Connection& conn;
>      public:
>      Begin(Connection& conn) {
>          conn.setAutoCommitOff();
>      }
>      ~Begin() {
>          conn.rollback();
>          conn.setAutoCommitOn();
>      }
>      commit();
>      rollback();
>      ...
> };
> class Connection {
>      sqlrconnection *sqlrconn;
>      public:
>      ...
>      ResultSet query(const std::string& str);
>      ...
> }
> class ResultSet {
>      sqlrcursor *sqlrcur;
>      public:
>      ...
>      next();
>      std::string operator[](const std::string& str);
>      ...
> }
> 
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] sqlrcur_inputBind not updating ODBC Param Number

[David M. <dav...@fi...>]

When processing a bind variable, SQL Relay eventually calls the ODBC
function SQLBindParameter().  SQLBindParamter() only allows you to
specify which parameter to bind to by number, not by name.  So when
using ODBC, SQL Relay requires that you specify parameters by number,
not by name.

Other DB's have their own odd bind-variable naming restrictions too.
I'll check the docs and make sure that the ODBC docs say that you have
to use numbers.

I'm actually surprised that the query worked, ODBC normally requires
queries to have a ? for the parameter rather than colon-delimited.  It
could be that the TimesTen driver handles the colon-delimited format
though.

SQL Relay could potentially allow named parameters in the future.  I
could make it dig through the query, looking for colon-delimited
parameters and map them to numbers.  I'll put it on the TODO list.

Dave
dav...@fi...

On Thu, 2009-02-26 at 14:34 +0000, jim watts wrote:
> Hi
> 
> 
> We are using sqlrelay 39.4 on RHEL5.2 x86_64 Linux to connect to
> TimesTen 7.0.5 via unixODBC(2.2.11) on same system.
> 
> 
> The language we are using is PHP.
> 
> When sqlrcur_inputBind is called:
> 
> 
>        sqlrcur_prepareQuery($cur,"select rs_id, rs_group from
> qlog.resources where rs_id = :resourceid");
>        sqlrcur_inputBind($cur,"resourceid",'99903');
> 
> 
> The odbc trace file shows:
> 
> 
> [ODBC][21083][SQLBindParameter.c][193]
>                Entry:
>                        Statement = 0x1d031740
>                        Param Number = 0
>                        Param Type = 1
>                        C Type = -8 SQL_C_WCHAR
>                        SQL Type = 1 SQL_CHAR
>                        Col Def = 0
>                        Scale = 0
>                        Rgb Value = 0x1d19f360
>                        Value Max = 10
>                        StrLen Or Ind = (nil)
> [ODBC][21083][SQLBindParameter.c][204]Error: 07009
> 
> 
> Since the Param Number = 0, and invalid parameter index is thrown.
> 
> 
> 
> 
> 
> 
> 
> 
> When we change the php to call:
> 
> 
>        sqlrcur_prepareQuery($cur,"select rs_id, rs_group from
> qlog.resources where rs_id = :resourceid");
>        sqlrcur_inputBind($cur,"1",'99903');
> 
> 
> 
> 
> Where the sqlrcur_inputBind parameter is now the integer 1, the ODBC
> trace shows Para Number = 1 and the query is processed by TimesTen.
> 
> 
> 
> 
> Is this an error or bug that you may be aware of ? We have changed the
> php calls but would like some clarification.
> 
> 
> SQLRelay is used in other parts of the organisation and has proven to
> be a reliable and excellent tool (so thanks for that).
> 
> 
> Jim 
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion __________________________________________________ D O T E A S Y - "Join the web hosting revolution!" http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] sqlrcur_inputBind not updating ODBC Param Number

[jim w. <jim...@gm...>]

Hi
We are using sqlrelay 39.4 on RHEL5.2 x86_64 Linux to connect to TimesTen
7.0.5 via unixODBC(2.2.11) on same system.

The language we are using is PHP.

When sqlrcur_inputBind is called:

       sqlrcur_prepareQuery($cur,"select rs_id, rs_group from
qlog.resources where rs_id = :resourceid");
       sqlrcur_inputBind($cur,"resourceid",'99903');

The odbc trace file shows:

[ODBC][21083][SQLBindParameter.c][193]
               Entry:
                       Statement = 0x1d031740
                       Param Number = 0
                       Param Type = 1
                       C Type = -8 SQL_C_WCHAR
                       SQL Type = 1 SQL_CHAR
                       Col Def = 0
                       Scale = 0
                       Rgb Value = 0x1d19f360
                       Value Max = 10
                       StrLen Or Ind = (nil)
[ODBC][21083][SQLBindParameter.c][204]Error: 07009

Since the Param Number = 0, and invalid parameter index is thrown.




When we change the php to call:

       sqlrcur_prepareQuery($cur,"select rs_id, rs_group from
qlog.resources where rs_id = :resourceid");
       sqlrcur_inputBind($cur,"1",'99903');


Where the sqlrcur_inputBind parameter is now the integer 1, the ODBC trace
shows Para Number = 1 and the query is processed by TimesTen.


Is this an error or bug that you may be aware of ? We have changed the php
calls but would like some clarification.

SQLRelay is used in other parts of the organisation and has proven to be a
reliable and excellent tool (so thanks for that).

Jim

[Sqlrelay-discussion] Possible bug with sqlrelay-0.40 with oracle output bind cursors

[<ben...@fr...>]

Hi all,

I've just installed SQL Relay 0.40/Oracle on a Debian machine and found
a possible bug.
It is not reproducible with SQL Relay 0.39.4. (i use sqlrelay 0.39.4 /
rudiment 0.31 and oracle 9i in production without problem)

It concerns output bind cursors : it seems to be not freed correctly.

My tests :
I spawn 5 sqlr-connection.
I execute (php code) several times the same oracle package (with output
cursor). At the 6th execution, there is no data return until I reload
sqlrelay connexions. SELECT operations and Functions still working in this
state.
It seems that the output cursor is not freed correctly. (with 10
connections, the 11st request failed).


Based on the following discussion :
http://sourceforge.net/mailarchive/message.php?msg_id=47AC89D1.6030107%40portavita.nl
I commented out the 1658th ligne of oracle8connection.C. (with the
ligne, sqlr-connexions crashed (segfault maybe), when it's commented
out, they don't segfault anymore, but don't work better.)




Here some php and SQL to reproduce the bug :

create or replace PACKAGE               testrelay_proc AS
  TYPE ref_cursor IS REF CURSOR;
  PROCEDURE testrelay (
         PI$SITE_ID IN NUMBER
       , C_CURSOR       OUT ref_cursor
       , PI$ERROR       OUT integer);

  PROCEDURE testrelay2 (
         PI$SITE_ID IN NUMBER
       , PI$ERROR       OUT integer);
END testrelay_proc;

create or replace PACKAGE BODY               testrelay_proc AS
  PROCEDURE testrelay(
         PI$SITE_ID IN NUMBER
       , C_CURSOR       OUT ref_cursor
       , PI$ERROR       OUT integer) AS
  BEGIN
  PI$ERROR := -20999;
  OPEN C_CURSOR FOR
    SELECT NAME FROM xxxxxxxxx WHERE ID=PI$SITE_ID;
    PI$ERROR := 0;
    EXCEPTION
      WHEN OTHERS THEN
          IF C_CURSOR%ISOPEN THEN
              CLOSE C_CURSOR;
          END IF;
          PI$ERROR := sqlcode;
  END testrelay;

  PROCEDURE testrelay2 (
         PI$SITE_ID IN NUMBER
       , PI$ERROR       OUT integer) AS
  BEGIN
  PI$ERROR := -20999;
    PI$ERROR := 2;
  END testrelay2;
END testrelay_proc;



create or replace FUNCTION testrelay4 (
  PI$SITE_ID IN NUMBER
  ) RETURN number  as

  LN$NAME number;
  BEGIN
  SELECT 155 into LN$NAME FROM xxxxxxxxx ID=PI$SITE_ID AND rownum < 2;
  return LN$NAME;
end testrelay4;


<?php
    $con=sqlrcon_alloc("IP_sqlrelay",PORT,"","USER","PASS",1,3);
    $cur=sqlrcur_alloc($con);

    echo "testrelay1 <br>";
    $query1 = 'select system.testrelay4(10) from dual';
    sqlrcur_sendQuery($cur, $query1);

    echo sqlrcur_getField($cur,0,0); // returns 1 row 1 col.
    //Always return 155 (work fine in every case evry time)

    echo "<br>testrelay2 <br>";
    $query3 = 'BEGIN system.testrelay_proc.testrelay2(:SITE_ID,
:ERROR_BIND);END;';
    sqlrcur_prepareQuery($cur,$query3);
    sqlrcur_inputBind($cur,'SITE_ID', 10);
    sqlrcur_defineOutputBindInteger($cur,'ERROR_BIND');
    $resultquery = sqlrcur_executeQuery($cur);
    $bindcurError = sqlrcur_getOutputBindInteger($cur,'ERROR_BIND');
    var_dump($bindcurError);
    // Always return int 2 (work fine in every case)

    echo "testrelay3 - The Real Problem";
    $query = 'BEGIN system.testrelay_proc.testrelay(:SITE_ID,
:CURSOR_BIND, :ERROR_BIND);END;';
    sqlrcur_prepareQuery($cur,$query);
    sqlrcur_inputBind($cur,'SITE_ID', 10);

sqlrcur_defineOutputBindCursor($cur,'CURSOR_BIND');

sqlrcur_defineOutputBindInteger($cur,'ERROR_BIND');
    $resultquery = sqlrcur_executeQuery($cur);
    $bindcur =
sqlrcur_getOutputBindCursor($cur,'CURSOR_BIND');
    $bindcurError =
sqlrcur_getOutputBindInteger($cur,'ERROR_BIND');

    //Fetching from output cursor
    sqlrcur_fetchFromBindCursor($bindcur);
    $iNbFirstResult = sqlrcur_rowCount($bindcur);
    $return['NbResult'] =
$iNbFirstResult;


    for ($i=0; $i<sqlrcur_rowCount($bindcur); $i++) {
       for ($j=0; $j<sqlrcur_colCount($bindcur); $j++)
{
           $return[$i][sqlrcur_getColumnName($bindcur,$j)] =
sqlrcur_getField($bindcur,$i,$j);

       }

}

    var_dump($return);
    // work after sqlrelay restart for number of available connections -
but failed after : return array  'NbResult' => int 0

    // Clean cursors, connexions ...
    sqlrcon_endSession($con);
    sqlrcur_free($bindcur);
    sqlrcur_free($cur);
    sqlrcon_free($con);
?>


When changing connexion pointing to a sqlrelay 0.39.4, it's always working.

Someone else got the same bug ?
I didnt find any solutions.

Best regards.
Benoit Cattié

Re: [Sqlrelay-discussion] help running

[Felipe C. - P. <fel...@gm...>]

Hi Alberto!

That was great!

Thank you,

Felipe


Alberto Cabello wrote:
> 2009/2/10 Felipe Ceglia - PY1NB <fel...@gm...>:
>> Hello,
>>
>> I upgraded from 39 to 40, when I try to start it, it says listener is
>> not ok.
>>
> 
> I think this is the same issue reported and "solved" (rather worked
> around) by Manuel Studer:
> 
> http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion
> 
> Hope that helps.
> 
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

-- 
Felipe Ceglia - PY1NB
PR1T team member - Rio DX Group
http://www.dxwatch.com
http://skimmer.dxwatch.com
http://riodxgroup.dxwatch.com

Re: [Sqlrelay-discussion] help running

[Alberto C. <aca...@pu...>]

2009/2/10 Felipe Ceglia - PY1NB <fel...@gm...>:
> Hello,
>
> I upgraded from 39 to 40, when I try to start it, it says listener is
> not ok.
>

I think this is the same issue reported and "solved" (rather worked
around) by Manuel Studer:

http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion

Hope that helps.

[Sqlrelay-discussion] help running

[Felipe C. - P. <fel...@gm...>]

Hello,

I upgraded from 39 to 40, when I try to start it, it says listener is 
not ok.

If I run listener by hand, it starts ok.

any help is appreciated.

Thanks

-----------------------------------------------------------------------------------------------------------------------------------

sqlr-start -id clx_db -config /etc/sqlrelay.conf

Starting listener:
  sqlr-listener -id clx_db -config /etc/sqlrelay.conf

Starting 15 connections to clx_db :
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf
  sqlr-connection-postgresql -id clx_db -connectionid clx_db -config 
/etc/sqlrelay.conf

Starting scaler:
  sqlr-scaler -id clx_db -config /etc/sqlrelay.conf

sqlr-scaler error:
        The file 
/usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-clx_db was not 
found.
        This usually means that the sqlr-listener is not running.
        The sqlr-listener must be running for the sqlr-scaler to start.


sqlr-scaler failed to start.



----------------------------------------------------------------------

My config file:

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>

        <instance id="clx_db" port="9000" socket="/tmp/clx_db.socket" 
dbase="postgresql" connections="15" maxconnections="50" 
maxqueuelength="0" growby="1" ttl="60" endofsession="commit" 
sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" 
authtier="listener" handoff="pass">
                <users>
                        <user user="postgres" password="password"/>
                        <user user="postgres" password="passwd"/>
                        <user user="postgres" password="pass"/>
                        <user user="postgres" password=""/>
                </users>
                <connections>
                        <!connection connectionid="clx_db" 
string="host=localhost;db=clx_db;user=postgres;password=password" 
metric="1"/>
                        <connection connectionid="clx_db" 
string="host=/tmp;port=5432;db=clx_db;user=postgres;password=password" 
metric="1"/>
                </connections>
        </instance>

</instances>

-- 
Felipe Ceglia - PY1NB
PR1T team member - Rio DX Group
http://www.dxwatch.com
http://skimmer.dxwatch.com
http://riodxgroup.dxwatch.com

[Sqlrelay-discussion] oddity with cursors in sqlrelay-0.39

[Guillaume G. <sql...@bl...>]

Hi folks,

I'm working on a project that puts an abstraction layer around sqlrelay. 
And I found something like an inconsistency in the manner the cursors 
are constructed and destructed. All cursors are consumed with the error 
message
"No server-side cursors were available to process the query."


I'm using sqlrelay-0.39 provided by debian

the interesting part of /etc/sqlrelay/sqlrelay.conf
     <instance id="cpta" port="9000" socket="/tmp/.sqlrelay.cpta" 
dbase="postgresql" connections="5" maxconnections="5" maxqueuelength="0" 
growby="1" ttl="60" endofsession="rollback" sessiontimeout="600" 
runasuser="sqlrelay" runasgroup="sqlrelay" cursors="40" 
authtier="listener" handoff="pass">

the snippet of code that exhausts cursors
----------8<--------------------8<--------------------8<----------
#include <iostream>
#include <sqlrelay/sqlrclient.h>

using namespace std;

int main(int argc, char **argv) {

         sqlrconnection      *con=new 
sqlrconnection("localhost",9000,"/tmp/.sqlrelay.cpta","zorro","11digitsprimenumber",1,1);


     for ( int i=0 ; i<100 ; ++i ) {
             sqlrcursor          *cursor1=new sqlrcursor(con);
             sqlrcursor          *cursor2=new sqlrcursor(con);
         if ( cursor1->sendQuery("SELECT 1 AS r1") == 0 ) {
             cout << cursor1->errorMessage() << endl;
             return 1;
         }
         if ( cursor2->sendQuery("SELECT 2 AS r2") == 0 ) {
             cout << cursor2->errorMessage() << endl;
             return 1;
         }
         delete cursor2;
         delete cursor1;
     }

return 0;
}
----------8<--------------------8<--------------------8<----------

I know that in this example sqlrcursor's pointers should be declared and 
initialized outer the for loop. but it is approximatively what the 
abstraction layer does with the following code  :

Connection 
conn("sqlrelay://zoro:11digitsprimenumber@localhost:9000/tmp/.sqlrelay.cpta");
for (...) {
     Begin transaction(conn);
     conn.query(...);
}

Could you tell me if I'm wrong ?
And if I'm wrong, why this strange issue occurs ?

Thanks in advance


Best regards - Guillaume Gimenez


PS: For information this pseudo code
class Begin {
     Connection& conn;
     public:
     Begin(Connection& conn) {
         conn.setAutoCommitOff();
     }
     ~Begin() {
         conn.rollback();
         conn.setAutoCommitOn();
     }
     commit();
     rollback();
     ...
};
class Connection {
     sqlrconnection *sqlrconn;
     public:
     ...
     ResultSet query(const std::string& str);
     ...
}
class ResultSet {
     sqlrcursor *sqlrcur;
     public:
     ...
     next();
     std::string operator[](const std::string& str);
     ...
}

Re: [Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable

[Manuel S. <man...@sy...>]

Well, I could trace the problem with rdebug (ruby debug) for one case.

It seems that the SQLR Cursor is not working properly.
The cursor has 82 columns but by accessing a value >=15 with for example Cursor.getField(0,15) or getRow(0) it always crashes. 
Interestingly enough: it does not crash for the other hundred cases where the script does exactly the same thing.

There is an error log in this post. There are no errors displayed by using sqlr-status.

Any suggestions how to solve this problem?

Thanks in advance!

Regards,
Manuel



-----Ursprüngliche Nachricht-----
Von: Manuel Studer [mailto:man...@sy...] 
Gesendet: Montag, 26. Januar 2009 17:50
An: sql...@li...
Betreff: [Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable

Hi folks,

I'm using Fedora Core 10 as a database connection client and I want to
copy tables from a Sybase ASE 12.5 (freetds connection) database to a
PostgreSQL 8.3 db. For this, I programmed a pure Ruby script. The script
is working fine for several hundred rows, but then quits returning
different errors like segmentation faults, invalid pointers, corrupted
double-linked list (see errors_compilation.txt) etc. When starting the
script a second time, it just crashes at another point.

I tried different environments such as:
CentOS 5.2 and latest FreeTDS connection library
Fedora 9/10 with SQL Relay 0.39.4, SQL Relay 0.40, with Sybase Open
Client Library or with FreeTDS connection
I tried as well different Ruby Versions such as Ruby "Enterprise" and
older versions too.

However, the system crashes "randomly" at different points. The
computer's memory is 100% ok (memtest). 

I started to use gdb and other tools, but no luck so far. Does anyone
have some tips or suggestions to pinpoint the problem?

Regards,
Manuel

[Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable

[Manuel S. <man...@sy...>]

Hi folks,

I'm using Fedora Core 10 as a database connection client and I want to
copy tables from a Sybase ASE 12.5 (freetds connection) database to a
PostgreSQL 8.3 db. For this, I programmed a pure Ruby script. The script
is working fine for several hundred rows, but then quits returning
different errors like segmentation faults, invalid pointers, corrupted
double-linked list (see errors_compilation.txt) etc. When starting the
script a second time, it just crashes at another point.

I tried different environments such as:
CentOS 5.2 and latest FreeTDS connection library
Fedora 9/10 with SQL Relay 0.39.4, SQL Relay 0.40, with Sybase Open
Client Library or with FreeTDS connection
I tried as well different Ruby Versions such as Ruby "Enterprise" and
older versions too.

However, the system crashes "randomly" at different points. The
computer's memory is 100% ok (memtest). 

I started to use gdb and other tools, but no luck so far. Does anyone
have some tips or suggestions to pinpoint the problem?

Regards,
Manuel

Re: [Sqlrelay-discussion] rudiments will not build

[Pepe Le M. <gu...@ov...>]

I spent quite a bit of time tracking this down.  Oracle requires some
RPMs to install that basically bork up a build environment.  You need
to remove  these RPMs: 



compat-gcc-32-c++-3.2.3 

compat-libstdc++-33-3.2.3 

compat-libstdc++-296-2.96

compat-oracle-rhel4-1.0-5



do your build and then put them back.  This doesn't seem to disturb
oracle, but I would not count on everything being OK if you do this on
a live server.



These are install instructions for oracle :

http://www.puschitz.com/InstallingOracle9i.shtml

You can see that if you follow instructions you will always get
a oracle machine that SQLrelay will not install on.  Every time.  I
hesitate to call this a bug, because  virtually ever C or C++ program
will not compile, but given that your typical oracle DBA/admin is,
shall we say, somewhat... artless, it might be wise to put together an
RPM that they can slap on a new box.



Just a thought.



Regards,

-Dave





David Muse wrote:

  I've seen this before, but I don't remember exactly what causes it.
Some program is missing from the server.  Maybe it's the program called
"file".

Try searching the discussion group archives.  I'll see if I can find it
in my notes.

David Muse
dav...@fi...

On Wed, 2009-01-21 at 20:25 -0500, Pepe Le Moko wrote:
  
  
    -- 


-- 

Re: [Sqlrelay-discussion] rudiments will not build

[David M. <dav...@fi...>]

I've seen this before, but I don't remember exactly what causes it.
Some program is missing from the server.  Maybe it's the program called
"file".

Try searching the discussion group archives.  I'll see if I can find it
in my notes.

David Muse
dav...@fi...

On Wed, 2009-01-21 at 20:25 -0500, Pepe Le Moko wrote:
> -- 
> 
> 
> 
> 
> I have a new redhat Enterprise linux 4 update 4 oracle server.  It was
> built 4 days ago.  This is what i get when i try to install rudiments 0.32
> on the machine:
> 
> [root@dba4 rudiments-0.32]# make
> cd src; make all
> make[1]: Entering directory `/root/rudiments-0.32/src'
> /bin/sh ../libtool --mode=compile g++ -pipe  -Wall -D_REENTRANT
> -D_THREAD_SAFE -D__EXTENSIONS__  -pthread  -I/usr/kerberos/include   
> -I../ -I../include -c namevaluepairs.C -o namevaluepairs.lo
> libtool: compile: unable to infer tagged configuration
> libtool: compile: specify a tag with `--tag'
> make[1]: *** [namevaluepairs.lo] Error 1
> make[1]: Leaving directory `/root/rudiments-0.32/src'
> make: *** [all] Error 2
> 
> 
> i have played with the tag flag like so:
> 
> export CXX="--tag=CXX g++"
> 
> which produces this:
> 
> [root@dba4 rudiments-0.32]# make
> cd src; make all
> make[1]: Entering directory `/root/rudiments-0.32/src'
> /bin/sh ../libtool --mode=compile --tag=CXX g++  -D_REENTRANT
> -D_THREAD_SAFE -D__EXTENSIONS__    -I/usr/kerberos/include    -I../
> -I../include -c namevaluepairs.C -o namevaluepairs.lo
> mkdir .libs
>  g++ -D_REENTRANT -D_THREAD_SAFE -D__EXTENSIONS__ -I/usr/kerberos/include
> -I../ -I../include -c namevaluepairs.C  -DPIC
> In file included from ../include/rudiments/private/charstringincludes.h:7,
>                  from ../include/rudiments/charstring.h:7,
>                  from ../include/rudiments/private/linkedlistutilinlines.h:6,
>                  from ../include/rudiments/private/linkedlistutil.h:24,
>                  from ../include/rudiments/private/linkedlistincludes.h:6,
>                  from ../include/rudiments/linkedlist.h:7,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> /usr/include/sys/types.h:95: conflicting types for `typedef __off64_t off_t'
> /usr/include/sys/types.h:88: previous declaration as `typedef __off_t off_t'
> In file included from ../include/rudiments/private/linkedlistutilinlines.h:6,
>                  from ../include/rudiments/private/linkedlistutil.h:24,
>                  from ../include/rudiments/private/linkedlistincludes.h:6,
>                  from ../include/rudiments/linkedlist.h:7,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/charstring.h:46: type specifier omitted for parameter `
>    uint32_t'
> ../include/rudiments/charstring.h:46: syntax error before `)' token
> ../include/rudiments/charstring.h:143: `static char*
>    charstring::findFirst(char*, char*)' and `static char*
>    charstring::findFirst(char*, char*)' cannot be overloaded
> ../include/rudiments/charstring.h:146: `static char*
>    charstring::findFirst(char*, char)' and `static char*
>    charstring::findFirst(char*, char)' cannot be overloaded
> ../include/rudiments/charstring.h:149: `static char*
>    charstring::findLast(char*, char*)' and `static char*
>    charstring::findLast(char*, char*)' cannot be overloaded
> ../include/rudiments/charstring.h:152: `static char*
>    charstring::findLast(char*, char)' and `static char*
>    charstring::findLast(char*, char)' cannot be overloaded
> ../include/rudiments/charstring.h:161: `static char*
>    charstring::findFirstOfSet(char*, char*)' and `static char*
>    charstring::findFirstOfSet(char*, char*)' cannot be overloaded
> ../include/rudiments/charstring.h:222: `uint16_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:222: syntax error before `)' token
> ../include/rudiments/charstring.h:223: `uint32_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:223: syntax error before `)' token
> ../include/rudiments/charstring.h:223: `static int
>    charstring::integerLength(...)' and `static int
>    charstring::integerLength(...)' cannot be overloaded
> ../include/rudiments/charstring.h:224: `uint64_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:224: syntax error before `)' token
> ../include/rudiments/charstring.h:224: `static int
>    charstring::integerLength(...)' and `static int
>    charstring::integerLength(...)' cannot be overloaded
> ../include/rudiments/charstring.h:238: `uint16_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:238: syntax error before `)' token
> ../include/rudiments/charstring.h:241: `uint16_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:241: syntax error before `,' token
> ../include/rudiments/charstring.h:242: `static char*
>    charstring::parseNumber(...)' and `static char*
> charstring::parseNumber(...)
>    ' cannot be overloaded
> ../include/rudiments/charstring.h:244: `uint32_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:244: syntax error before `)' token
> ../include/rudiments/charstring.h:244: `static char*
>    charstring::parseNumber(...)' and `static char*
> charstring::parseNumber(...)
>    ' cannot be overloaded
> ../include/rudiments/charstring.h:247: `uint32_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:247: syntax error before `,' token
> ../include/rudiments/charstring.h:248: `static char*
>    charstring::parseNumber(...)' and `static char*
> charstring::parseNumber(...)
>    ' cannot be overloaded
> ../include/rudiments/charstring.h:250: `uint64_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:250: syntax error before `)' token
> ../include/rudiments/charstring.h:250: `static char*
>    charstring::parseNumber(...)' and `static char*
> charstring::parseNumber(...)
>    ' cannot be overloaded
> ../include/rudiments/charstring.h:253: `uint64_t' was not declared in this
>    scope
> ../include/rudiments/charstring.h:253: syntax error before `,' token
> ../include/rudiments/charstring.h:254: `static char*
>    charstring::parseNumber(...)' and `static char*
> charstring::parseNumber(...)
>    ' cannot be overloaded
> ../include/rudiments/charstring.h:290: ISO C++ forbids declaration of
> `uint64_t
>    ' with no type
> ../include/rudiments/charstring.h:290: syntax error before `(' token
> ../include/rudiments/charstring.h:292: ISO C++ forbids declaration of
> `uint64_t
>    ' with no type
> ../include/rudiments/charstring.h:292: syntax error before `(' token
> ../include/rudiments/charstring.h:297: ISO C++ forbids declaration of
> `uint64_t
>    ' with no type
> ../include/rudiments/charstring.h:297: syntax error before `(' token
> ../include/rudiments/charstring.h:301: ISO C++ forbids declaration of
> `uint64_t
>    ' with no type
> ../include/rudiments/charstring.h:301: syntax error before `(' token
> ../include/rudiments/charstring.h:340: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:340: syntax error before `,' token
> ../include/rudiments/charstring.h:346: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:346: syntax error before `,' token
> ../include/rudiments/charstring.h:357: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:357: syntax error before `)' token
> ../include/rudiments/charstring.h:361: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:361: syntax error before `,' token
> ../include/rudiments/charstring.h:363: `static void
>    charstring::base64Encode(...)' and `static char*
>    charstring::base64Encode(...)' cannot be overloaded
> ../include/rudiments/charstring.h:373: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:373: syntax error before `)' token
> ../include/rudiments/charstring.h:377: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:377: syntax error before `,' token
> ../include/rudiments/charstring.h:379: `static void
>    charstring::base64Decode(...)' and `static unsigned char*
>    charstring::base64Decode(...)' cannot be overloaded
> ../include/rudiments/charstring.h:439: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:439: syntax error before `*' token
> ../include/rudiments/charstring.h:445: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:445: syntax error before `*' token
> ../include/rudiments/charstring.h:445: `static void
> charstring::split(...)' and
>    `static void charstring::split(...)' cannot be overloaded
> ../include/rudiments/charstring.h:451: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:451: syntax error before `*' token
> ../include/rudiments/charstring.h:451: `static void
> charstring::split(...)' and
>    `static void charstring::split(...)' cannot be overloaded
> ../include/rudiments/charstring.h:456: type specifier omitted for parameter `
>    uint64_t'
> ../include/rudiments/charstring.h:456: syntax error before `*' token
> ../include/rudiments/charstring.h:456: `static void
> charstring::split(...)' and
>    `static void charstring::split(...)' cannot be overloaded
> In file included from ../include/rudiments/private/linkedlistutilinlines.h:6,
>                  from ../include/rudiments/private/linkedlistutil.h:24,
>                  from ../include/rudiments/private/linkedlistincludes.h:6,
>                  from ../include/rudiments/linkedlist.h:7,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/charstring.h:292: duplicate member
> `charstring::uint64_t'
> ../include/rudiments/charstring.h:297: duplicate member
> `charstring::uint64_t'
> ../include/rudiments/charstring.h:301: duplicate member
> `charstring::uint64_t'
> In file included from ../include/rudiments/private/linkedlistutil.h:24,
>                  from ../include/rudiments/private/linkedlistincludes.h:6,
>                  from ../include/rudiments/linkedlist.h:7,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/private/linkedlistutilinlines.h:36: redefinition of
> `void
>    linkedlistutil<datatype>::print(datatype) [with datatype = char*]'
> ../include/rudiments/private/linkedlistutilinlines.h:30: `void
>    linkedlistutil<datatype>::print(datatype) [with datatype = char*]'
>    previously declared here
> ../include/rudiments/private/linkedlistutilinlines.h:49: redefinition of `int
>    linkedlistutil<datatype>::compare(datatype, datatype) [with datatype =
>    char*]'
> ../include/rudiments/private/linkedlistutilinlines.h:42: `int
>    linkedlistutil<datatype>::compare(datatype, datatype) [with datatype =
>    char*]' previously declared here
> In file included from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/linkedlist.h:74: syntax error before `,' token
> ../include/rudiments/linkedlist.h:79: syntax error before `,' token
> ../include/rudiments/linkedlist.h:85: syntax error before `)' token
> ../include/rudiments/linkedlist.h:102: syntax error before `,' token
> ../include/rudiments/linkedlist.h:108: syntax error before `,' token
> ../include/rudiments/linkedlist.h:115: syntax error before `)' token
> ../include/rudiments/linkedlist.h:118: syntax error before `)' token
> In file included from ../include/rudiments/linkedlist.h:138,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/private/linkedlist.h:5: 'uint64_t' is used as a type,
> but
>    is not defined as a type.
> In file included from ../include/rudiments/linkedlist.h:151,
>                  from ../include/rudiments/private/dictionaryincludes.h:4,
>                  from ../include/rudiments/dictionary.h:7,
>                  from namevaluepairs.C:5:
> ../include/rudiments/private/linkedlistinlines.h:57: syntax error before `,'
>    token
> ../include/rudiments/private/linkedlistinlines.h:65: syntax error before `,'
>    token
> ../include/rudiments/private/linkedlistinlines.h:65: redefinition of `bool
>    linkedlist<datatype, linkedlistnodetype>::insert(...)'
> ../include/rudiments/private/linkedlistinlines.h:57: `bool
> linkedlist<datatype,
>    linkedlistnodetype>::insert(...)' previously declared here
> ../include/rudiments/private/linkedlistinlines.h:65: no `bool
>    linkedlist<datatype, linkedlistnodetype>::insert(...)' member function
>    declared in class `linkedlist<datatype, linkedlistnodetype>'
> ../include/rudiments/private/linkedlistinlines.h:102: syntax error before `,'
>    token
> ../include/rudiments/private/linkedlistinlines.h:113: syntax error before `)'
>    token
> ../include/rudiments/private/linkedlistinlines.h: In member function `bool
>    linkedlist<datatype, linkedlistnodetype>::removeByData(datatype)':
> ../include/rudiments/private/linkedlistinlines.h:121: syntax error before `='
>    token
> ../include/rudiments/private/linkedlistinlines.h: In member function `bool
>    linkedlist<datatype, linkedlistnodetype>::removeAllByData(datatype)':
> ../include/rudiments/private/linkedlistinlines.h:136: syntax error before `='
>    token
> ../include/rudiments/private/linkedlistinlines.h: At global scope:
> ../include/rudiments/private/linkedlistinlines.h:175: syntax error before `,'
>    token
> ../include/rudiments/private/linkedlistinlines.h:186: syntax error before `<'
>    token
> ../include/rudiments/private/linkedlistinlines.h:186: `datatype' was not
>    declared in this scope
> ../include/rudiments/private/linkedlistinlines.h:186: `linkedlistnodetype'
> was
>    not declared in this scope
> ../include/rudiments/private/linkedlistinlines.h:186: template argument 1 is
>    invalid
> ../include/rudiments/private/linkedlistinlines.h:186: template argument 2 is
>    invalid
> ../include/rudiments/private/linkedlistinlines.h:186: ISO C++ forbids
>    declaration of `getLength' with no type
> ../include/rudiments/private/linkedlistinlines.h: In function `int
>    getLength()':
> ../include/rudiments/private/linkedlistinlines.h:187: `length' undeclared
>    (first use this function)
> ../include/rudiments/private/linkedlistinlines.h:187: (Each undeclared
>    identifier is reported only once for each function it appears in.)
> ../include/rudiments/private/linkedlistinlines.h: At global scope:
> ../include/rudiments/private/linkedlistinlines.h:192: syntax error before `)'
>    token
> ../include/rudiments/private/linkedlistinlines.h: In member function
>    `linkedlistnodetype* linkedlist<datatype,
>    linkedlistnodetype>::getNodeByIndex(...)':
> ../include/rudiments/private/linkedlistinlines.h:197: syntax error before `='
>    token
> ../include/rudiments/private/linkedlistinlines.h: In member function `void
>    linkedlist<datatype, linkedlistnodetype>::clear()':
> ../include/rudiments/private/linkedlistinlines.h:229: syntax error before `='
>    token
> ../include/rudiments/private/linkedlistinlines.h: In member function `void
>    linkedlist<datatype, linkedlistnodetype>::print()':
> ../include/rudiments/private/linkedlistinlines.h:243: syntax error before `='
>    token
> ../include/rudiments/private/linkedlistinlines.h: At global scope:
> ../include/rudiments/linkedlist.h: In instantiation of
> `linkedlist<dictionarynode<char*, char*>*, dictionarylistnode<char*,
> char*> >':
> namevaluepairs.C:14:   instantiated from `dictionarylist<char*, char*>'
> namevaluepairs.C:14:   instantiated from `stringdictionarylist<char*>'
> namevaluepairs.C:14:   instantiated from here
> ../include/rudiments/private/linkedlistinlines.h:57: `bool
> linkedlist<datatype,
>    linkedlistnodetype>::insert(...) [with datatype = dictionarynode<char*,
>    char*>*, linkedlistnodetype = dictionarylistnode<char*, char*>]' and `bool
>    linkedlist<datatype, linkedlistnodetype>::insert(...) [with datatype =
>    dictionarynode<char*, char*>*, linkedlistnodetype =
>    dictionarylistnode<char*, char*>]' cannot be overloaded
> namevaluepairs.C:34: duplicate explicit instantiation of `class
>    dictionarynode<char*, char*>'
> namevaluepairs.C:35: duplicate explicit instantiation of `class
>    dictionarylistnode<char*, char*>'
> namevaluepairs.C:36: duplicate explicit instantiation of `class
>    dictionarylist<char*, char*>'
> namevaluepairs.C:42: duplicate explicit instantiation of `class
>    linkedlistnode<dictionarynode<char*, char*>*>'
> namevaluepairs.C:44: duplicate explicit instantiation of `class
>    linkedlist<dictionarynode<char*, char*>*, dictionarylistnode<char*,
> char*> >
>    '
> ../include/rudiments/private/linkedlistinlines.h: In member function `bool
>    linkedlist<datatype, linkedlistnodetype>::insert(...) [with datatype =
>    dictionarynode<char*, char*>*, linkedlistnodetype =
>    dictionarylistnode<char*, char*>]':
> namevaluepairs.C:27:   instantiated from here
> ../include/rudiments/private/linkedlistinlines.h:68: `index' undeclared
> (first
>    use this function)
> ../include/rudiments/private/linkedlistinlines.h:74: `node' undeclared (first
>    use this function)
> ../include/rudiments/private/linkedlistinlines.h: In member function `bool
>    linkedlist<datatype, linkedlistnodetype>::removeByData(datatype) [with
>    datatype = dictionarynode<char*, char*>*, linkedlistnodetype =
>    dictionarylistnode<char*, char*>]':
> namevaluepairs.C:27:   instantiated from here
> ../include/rudiments/private/linkedlistinlines.h:121: `i' undeclared
> (first use
>    this function)
> ../include/rudiments/private/linkedlistinlines.h: In member function `bool
>    linkedlist<datatype, linkedlistnodetype>::setDataByIndex(...) [with
> datatype
>    = dictionarynode<char*, char*>*, linkedlistnodetype =
>    dictionarylistnode<char*, char*>]':
> namevaluepairs.C:27:   instantiated from here
> ../include/rudiments/private/linkedlistinlines.h:105: `data' undeclared
> (first
>    use this function)
> make[1]: *** [namevaluepairs.lo] Error 1
> make[1]: Leaving directory `/root/rudiments-0.32/src'
> make: *** [all] Error 2
> 
> has anyone else seen this?  How can I fix this problem?
> 
> 
> Thanks
> -Dave
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] rudiments will not build

[Pepe Le M. <gu...@ov...>]

-- 




I have a new redhat Enterprise linux 4 update 4 oracle server.  It was
built 4 days ago.  This is what i get when i try to install rudiments 0.32
on the machine:

[root@dba4 rudiments-0.32]# make
cd src; make all
make[1]: Entering directory `/root/rudiments-0.32/src'
/bin/sh ../libtool --mode=compile g++ -pipe  -Wall -D_REENTRANT
-D_THREAD_SAFE -D__EXTENSIONS__  -pthread  -I/usr/kerberos/include   
-I../ -I../include -c namevaluepairs.C -o namevaluepairs.lo
libtool: compile: unable to infer tagged configuration
libtool: compile: specify a tag with `--tag'
make[1]: *** [namevaluepairs.lo] Error 1
make[1]: Leaving directory `/root/rudiments-0.32/src'
make: *** [all] Error 2


i have played with the tag flag like so:

export CXX="--tag=CXX g++"

which produces this:

[root@dba4 rudiments-0.32]# make
cd src; make all
make[1]: Entering directory `/root/rudiments-0.32/src'
/bin/sh ../libtool --mode=compile --tag=CXX g++  -D_REENTRANT
-D_THREAD_SAFE -D__EXTENSIONS__    -I/usr/kerberos/include    -I../
-I../include -c namevaluepairs.C -o namevaluepairs.lo
mkdir .libs
 g++ -D_REENTRANT -D_THREAD_SAFE -D__EXTENSIONS__ -I/usr/kerberos/include
-I../ -I../include -c namevaluepairs.C  -DPIC
In file included from ../include/rudiments/private/charstringincludes.h:7,
                 from ../include/rudiments/charstring.h:7,
                 from ../include/rudiments/private/linkedlistutilinlines.h:6,
                 from ../include/rudiments/private/linkedlistutil.h:24,
                 from ../include/rudiments/private/linkedlistincludes.h:6,
                 from ../include/rudiments/linkedlist.h:7,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
/usr/include/sys/types.h:95: conflicting types for `typedef __off64_t off_t'
/usr/include/sys/types.h:88: previous declaration as `typedef __off_t off_t'
In file included from ../include/rudiments/private/linkedlistutilinlines.h:6,
                 from ../include/rudiments/private/linkedlistutil.h:24,
                 from ../include/rudiments/private/linkedlistincludes.h:6,
                 from ../include/rudiments/linkedlist.h:7,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/charstring.h:46: type specifier omitted for parameter `
   uint32_t'
../include/rudiments/charstring.h:46: syntax error before `)' token
../include/rudiments/charstring.h:143: `static char*
   charstring::findFirst(char*, char*)' and `static char*
   charstring::findFirst(char*, char*)' cannot be overloaded
../include/rudiments/charstring.h:146: `static char*
   charstring::findFirst(char*, char)' and `static char*
   charstring::findFirst(char*, char)' cannot be overloaded
../include/rudiments/charstring.h:149: `static char*
   charstring::findLast(char*, char*)' and `static char*
   charstring::findLast(char*, char*)' cannot be overloaded
../include/rudiments/charstring.h:152: `static char*
   charstring::findLast(char*, char)' and `static char*
   charstring::findLast(char*, char)' cannot be overloaded
../include/rudiments/charstring.h:161: `static char*
   charstring::findFirstOfSet(char*, char*)' and `static char*
   charstring::findFirstOfSet(char*, char*)' cannot be overloaded
../include/rudiments/charstring.h:222: `uint16_t' was not declared in this
   scope
../include/rudiments/charstring.h:222: syntax error before `)' token
../include/rudiments/charstring.h:223: `uint32_t' was not declared in this
   scope
../include/rudiments/charstring.h:223: syntax error before `)' token
../include/rudiments/charstring.h:223: `static int
   charstring::integerLength(...)' and `static int
   charstring::integerLength(...)' cannot be overloaded
../include/rudiments/charstring.h:224: `uint64_t' was not declared in this
   scope
../include/rudiments/charstring.h:224: syntax error before `)' token
../include/rudiments/charstring.h:224: `static int
   charstring::integerLength(...)' and `static int
   charstring::integerLength(...)' cannot be overloaded
../include/rudiments/charstring.h:238: `uint16_t' was not declared in this
   scope
../include/rudiments/charstring.h:238: syntax error before `)' token
../include/rudiments/charstring.h:241: `uint16_t' was not declared in this
   scope
../include/rudiments/charstring.h:241: syntax error before `,' token
../include/rudiments/charstring.h:242: `static char*
   charstring::parseNumber(...)' and `static char*
charstring::parseNumber(...)
   ' cannot be overloaded
../include/rudiments/charstring.h:244: `uint32_t' was not declared in this
   scope
../include/rudiments/charstring.h:244: syntax error before `)' token
../include/rudiments/charstring.h:244: `static char*
   charstring::parseNumber(...)' and `static char*
charstring::parseNumber(...)
   ' cannot be overloaded
../include/rudiments/charstring.h:247: `uint32_t' was not declared in this
   scope
../include/rudiments/charstring.h:247: syntax error before `,' token
../include/rudiments/charstring.h:248: `static char*
   charstring::parseNumber(...)' and `static char*
charstring::parseNumber(...)
   ' cannot be overloaded
../include/rudiments/charstring.h:250: `uint64_t' was not declared in this
   scope
../include/rudiments/charstring.h:250: syntax error before `)' token
../include/rudiments/charstring.h:250: `static char*
   charstring::parseNumber(...)' and `static char*
charstring::parseNumber(...)
   ' cannot be overloaded
../include/rudiments/charstring.h:253: `uint64_t' was not declared in this
   scope
../include/rudiments/charstring.h:253: syntax error before `,' token
../include/rudiments/charstring.h:254: `static char*
   charstring::parseNumber(...)' and `static char*
charstring::parseNumber(...)
   ' cannot be overloaded
../include/rudiments/charstring.h:290: ISO C++ forbids declaration of
`uint64_t
   ' with no type
../include/rudiments/charstring.h:290: syntax error before `(' token
../include/rudiments/charstring.h:292: ISO C++ forbids declaration of
`uint64_t
   ' with no type
../include/rudiments/charstring.h:292: syntax error before `(' token
../include/rudiments/charstring.h:297: ISO C++ forbids declaration of
`uint64_t
   ' with no type
../include/rudiments/charstring.h:297: syntax error before `(' token
../include/rudiments/charstring.h:301: ISO C++ forbids declaration of
`uint64_t
   ' with no type
../include/rudiments/charstring.h:301: syntax error before `(' token
../include/rudiments/charstring.h:340: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:340: syntax error before `,' token
../include/rudiments/charstring.h:346: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:346: syntax error before `,' token
../include/rudiments/charstring.h:357: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:357: syntax error before `)' token
../include/rudiments/charstring.h:361: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:361: syntax error before `,' token
../include/rudiments/charstring.h:363: `static void
   charstring::base64Encode(...)' and `static char*
   charstring::base64Encode(...)' cannot be overloaded
../include/rudiments/charstring.h:373: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:373: syntax error before `)' token
../include/rudiments/charstring.h:377: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:377: syntax error before `,' token
../include/rudiments/charstring.h:379: `static void
   charstring::base64Decode(...)' and `static unsigned char*
   charstring::base64Decode(...)' cannot be overloaded
../include/rudiments/charstring.h:439: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:439: syntax error before `*' token
../include/rudiments/charstring.h:445: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:445: syntax error before `*' token
../include/rudiments/charstring.h:445: `static void
charstring::split(...)' and
   `static void charstring::split(...)' cannot be overloaded
../include/rudiments/charstring.h:451: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:451: syntax error before `*' token
../include/rudiments/charstring.h:451: `static void
charstring::split(...)' and
   `static void charstring::split(...)' cannot be overloaded
../include/rudiments/charstring.h:456: type specifier omitted for parameter `
   uint64_t'
../include/rudiments/charstring.h:456: syntax error before `*' token
../include/rudiments/charstring.h:456: `static void
charstring::split(...)' and
   `static void charstring::split(...)' cannot be overloaded
In file included from ../include/rudiments/private/linkedlistutilinlines.h:6,
                 from ../include/rudiments/private/linkedlistutil.h:24,
                 from ../include/rudiments/private/linkedlistincludes.h:6,
                 from ../include/rudiments/linkedlist.h:7,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/charstring.h:292: duplicate member
`charstring::uint64_t'
../include/rudiments/charstring.h:297: duplicate member
`charstring::uint64_t'
../include/rudiments/charstring.h:301: duplicate member
`charstring::uint64_t'
In file included from ../include/rudiments/private/linkedlistutil.h:24,
                 from ../include/rudiments/private/linkedlistincludes.h:6,
                 from ../include/rudiments/linkedlist.h:7,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/private/linkedlistutilinlines.h:36: redefinition of
`void
   linkedlistutil<datatype>::print(datatype) [with datatype = char*]'
../include/rudiments/private/linkedlistutilinlines.h:30: `void
   linkedlistutil<datatype>::print(datatype) [with datatype = char*]'
   previously declared here
../include/rudiments/private/linkedlistutilinlines.h:49: redefinition of `int
   linkedlistutil<datatype>::compare(datatype, datatype) [with datatype =
   char*]'
../include/rudiments/private/linkedlistutilinlines.h:42: `int
   linkedlistutil<datatype>::compare(datatype, datatype) [with datatype =
   char*]' previously declared here
In file included from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/linkedlist.h:74: syntax error before `,' token
../include/rudiments/linkedlist.h:79: syntax error before `,' token
../include/rudiments/linkedlist.h:85: syntax error before `)' token
../include/rudiments/linkedlist.h:102: syntax error before `,' token
../include/rudiments/linkedlist.h:108: syntax error before `,' token
../include/rudiments/linkedlist.h:115: syntax error before `)' token
../include/rudiments/linkedlist.h:118: syntax error before `)' token
In file included from ../include/rudiments/linkedlist.h:138,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/private/linkedlist.h:5: 'uint64_t' is used as a type,
but
   is not defined as a type.
In file included from ../include/rudiments/linkedlist.h:151,
                 from ../include/rudiments/private/dictionaryincludes.h:4,
                 from ../include/rudiments/dictionary.h:7,
                 from namevaluepairs.C:5:
../include/rudiments/private/linkedlistinlines.h:57: syntax error before `,'
   token
../include/rudiments/private/linkedlistinlines.h:65: syntax error before `,'
   token
../include/rudiments/private/linkedlistinlines.h:65: redefinition of `bool
   linkedlist<datatype, linkedlistnodetype>::insert(...)'
../include/rudiments/private/linkedlistinlines.h:57: `bool
linkedlist<datatype,
   linkedlistnodetype>::insert(...)' previously declared here
../include/rudiments/private/linkedlistinlines.h:65: no `bool
   linkedlist<datatype, linkedlistnodetype>::insert(...)' member function
   declared in class `linkedlist<datatype, linkedlistnodetype>'
../include/rudiments/private/linkedlistinlines.h:102: syntax error before `,'
   token
../include/rudiments/private/linkedlistinlines.h:113: syntax error before `)'
   token
../include/rudiments/private/linkedlistinlines.h: In member function `bool
   linkedlist<datatype, linkedlistnodetype>::removeByData(datatype)':
../include/rudiments/private/linkedlistinlines.h:121: syntax error before `='
   token
../include/rudiments/private/linkedlistinlines.h: In member function `bool
   linkedlist<datatype, linkedlistnodetype>::removeAllByData(datatype)':
../include/rudiments/private/linkedlistinlines.h:136: syntax error before `='
   token
../include/rudiments/private/linkedlistinlines.h: At global scope:
../include/rudiments/private/linkedlistinlines.h:175: syntax error before `,'
   token
../include/rudiments/private/linkedlistinlines.h:186: syntax error before `<'
   token
../include/rudiments/private/linkedlistinlines.h:186: `datatype' was not
   declared in this scope
../include/rudiments/private/linkedlistinlines.h:186: `linkedlistnodetype'
was
   not declared in this scope
../include/rudiments/private/linkedlistinlines.h:186: template argument 1 is
   invalid
../include/rudiments/private/linkedlistinlines.h:186: template argument 2 is
   invalid
../include/rudiments/private/linkedlistinlines.h:186: ISO C++ forbids
   declaration of `getLength' with no type
../include/rudiments/private/linkedlistinlines.h: In function `int
   getLength()':
../include/rudiments/private/linkedlistinlines.h:187: `length' undeclared
   (first use this function)
../include/rudiments/private/linkedlistinlines.h:187: (Each undeclared
   identifier is reported only once for each function it appears in.)
../include/rudiments/private/linkedlistinlines.h: At global scope:
../include/rudiments/private/linkedlistinlines.h:192: syntax error before `)'
   token
../include/rudiments/private/linkedlistinlines.h: In member function
   `linkedlistnodetype* linkedlist<datatype,
   linkedlistnodetype>::getNodeByIndex(...)':
../include/rudiments/private/linkedlistinlines.h:197: syntax error before `='
   token
../include/rudiments/private/linkedlistinlines.h: In member function `void
   linkedlist<datatype, linkedlistnodetype>::clear()':
../include/rudiments/private/linkedlistinlines.h:229: syntax error before `='
   token
../include/rudiments/private/linkedlistinlines.h: In member function `void
   linkedlist<datatype, linkedlistnodetype>::print()':
../include/rudiments/private/linkedlistinlines.h:243: syntax error before `='
   token
../include/rudiments/private/linkedlistinlines.h: At global scope:
../include/rudiments/linkedlist.h: In instantiation of
`linkedlist<dictionarynode<char*, char*>*, dictionarylistnode<char*,
char*> >':
namevaluepairs.C:14:   instantiated from `dictionarylist<char*, char*>'
namevaluepairs.C:14:   instantiated from `stringdictionarylist<char*>'
namevaluepairs.C:14:   instantiated from here
../include/rudiments/private/linkedlistinlines.h:57: `bool
linkedlist<datatype,
   linkedlistnodetype>::insert(...) [with datatype = dictionarynode<char*,
   char*>*, linkedlistnodetype = dictionarylistnode<char*, char*>]' and `bool
   linkedlist<datatype, linkedlistnodetype>::insert(...) [with datatype =
   dictionarynode<char*, char*>*, linkedlistnodetype =
   dictionarylistnode<char*, char*>]' cannot be overloaded
namevaluepairs.C:34: duplicate explicit instantiation of `class
   dictionarynode<char*, char*>'
namevaluepairs.C:35: duplicate explicit instantiation of `class
   dictionarylistnode<char*, char*>'
namevaluepairs.C:36: duplicate explicit instantiation of `class
   dictionarylist<char*, char*>'
namevaluepairs.C:42: duplicate explicit instantiation of `class
   linkedlistnode<dictionarynode<char*, char*>*>'
namevaluepairs.C:44: duplicate explicit instantiation of `class
   linkedlist<dictionarynode<char*, char*>*, dictionarylistnode<char*,
char*> >
   '
../include/rudiments/private/linkedlistinlines.h: In member function `bool
   linkedlist<datatype, linkedlistnodetype>::insert(...) [with datatype =
   dictionarynode<char*, char*>*, linkedlistnodetype =
   dictionarylistnode<char*, char*>]':
namevaluepairs.C:27:   instantiated from here
../include/rudiments/private/linkedlistinlines.h:68: `index' undeclared
(first
   use this function)
../include/rudiments/private/linkedlistinlines.h:74: `node' undeclared (first
   use this function)
../include/rudiments/private/linkedlistinlines.h: In member function `bool
   linkedlist<datatype, linkedlistnodetype>::removeByData(datatype) [with
   datatype = dictionarynode<char*, char*>*, linkedlistnodetype =
   dictionarylistnode<char*, char*>]':
namevaluepairs.C:27:   instantiated from here
../include/rudiments/private/linkedlistinlines.h:121: `i' undeclared
(first use
   this function)
../include/rudiments/private/linkedlistinlines.h: In member function `bool
   linkedlist<datatype, linkedlistnodetype>::setDataByIndex(...) [with
datatype
   = dictionarynode<char*, char*>*, linkedlistnodetype =
   dictionarylistnode<char*, char*>]':
namevaluepairs.C:27:   instantiated from here
../include/rudiments/private/linkedlistinlines.h:105: `data' undeclared
(first
   use this function)
make[1]: *** [namevaluepairs.lo] Error 1
make[1]: Leaving directory `/root/rudiments-0.32/src'
make: *** [all] Error 2

has anyone else seen this?  How can I fix this problem?


Thanks
-Dave

[Sqlrelay-discussion] Possible Bug in SQL Relay 0.40

[Manuel S. <man...@sy...>]

Hi all,

I've just installed SQL Relay 0.40 on my Fedora Core 9 Machine and found
a possible bug. It is not reproducible with SQL Relay 0.39.4!

The conf file is attached below.
I'm connecting to a Sybase Server by using freeTDS and to another
postgreSQL db.

When I start all connections with:

#!/bin/bash
sqlr-stop
sqlr-start -id sybase-ba1 -config sqlr-config/sqlrelay.conf
sqlr-start -id sybase-ba2 -config sqlr-config/sqlrelay.conf
sqlr-start -id postgres -config sqlr-config/sqlrelay.conf
sqlr-start -id sybase-nodb -config sqlr-config/sqlrelay.conf

The first mentioned sqlr-start above ALWAYS fails in the sense:

--------------------------------
Starting listener:
  sqlr-listener -id sybase-ba1 -config sqlr-config/sqlrelay.conf

Starting 5 connections to sybase-ba1 :
  sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1
-config sqlr-config/sqlrelay.conf
  sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1
-config sqlr-config/sqlrelay.conf
  sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1
-config sqlr-config/sqlrelay.conf
  sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1
-config sqlr-config/sqlrelay.conf
  sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1
-config sqlr-config/sqlrelay.conf

Starting scaler:
  sqlr-scaler -id sybase-ba1 -config sqlr-config/sqlrelay.conf

sqlr-scaler error: 
	The file
/usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-sybase-ba1 was
not found.
	This usually means that the sqlr-listener is not running.
	The sqlr-listener must be running for the sqlr-scaler to start.


sqlr-scaler failed to start.

-------------------------------------

Ok, there is no pid file for that first listener. The solution to this
problem is to add in the conf XML at first a dummy entry such as:
<instance id="dummy" port="12009" socket="/tmp/sybase-dummy.socket"
dbase="freetds" connections="5" maxconnections="20" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="studma" runasgroup="users" cursors="10" authtier="listener"
handoff="pass" deniedips="" allowedips="" debug="none"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
listenertimeout="0" reloginatstart="false">
		<users>
			<user user="user" password="pw"/>
		</users>
		<connections>
			<connection connectionid="sybase-ba1"
string="user=sa;password=;server=SYBTEST;db=ba31;charset=iso_1;"
 metric="1" behindloadbalancer="no"/>
		</connections>
	</instance>


And then all works! I suppose there is a problem with XML Parsing.


Cheers,
Manuel 

Re: [Sqlrelay-discussion] Problems with Oracle output string binds

[Renat S. <sr...@st...>]

Renat Sabitov пишет:
> 1) When you prepare cursor, bind output variable and then execute it in
> a loop, size of bind variable changes from one iteration to another - it
> becomes the size of return value from previous iteration. For example,
> if result in first iteration was 'abc', then size of output bind in next
> iteration will be 3, no matter what value you put in
> sqlrcur_defineOutputBindString.

I've just written an issue for this problem, and attach the patch there.

https://sourceforge.net/tracker/index.php?func=detail&aid=2513213&group_id=10238&atid=360238

-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...

Re: [Sqlrelay-discussion] SQL Relay 0.40 is out

[David M. <dav...@fi...>]

Unfortunately, that wasn't patched in this release.  It's high on the
list, but didn't make it into this one.

Dave
dav...@fi...

On Thu, 2009-01-08 at 21:19 -0600, Chad Johnson wrote:
> Any chance that this bug :
> 
> http://sourceforge.net/tracker/index.php?func=detail&aid=1906458&group_id=10238&atid=360238
> 
> Was patched as well?
> 
> -Chad Johnson
> 
> On Thu, Jan 8, 2009 at 7:37 PM, David Muse <dav...@fi...> wrote:
> > Hello all,
> >
> > It's been a while, but SQL Relay 0.40 is finally out.
> >
> > This release includes lots of bug fixes, most for obscure bugs.  I also
> > integrated a few patches.  New features in this release include an
> > erlang API and ODBC driver.  The ODBC driver is very incomplete, but is
> > usable.
> >
> > Here's the full Changelog:
> >
> > * fixed readline detection in configure script
> > * fixed an uninitialized variable in sqlr-import
> > * changed clientSession() to call endSessionCommand()
> >        instead of endSession() so endSessionInternal() would be called
> >        every time
> > * fixed debug option in sqlr-import and sqlr-export
> > * fixed postgresql typemangling=no option
> > * set dbversion to unknown if sp_version wasn't found in freetds/sybase
> > * output bind variables' null indicator is reset now
> > * updated postgresql typemangling
> > * included Jesse Wagner's oracle 11g acsite patch
> > * added +1 to inbindvars[i].valuesize for CLOB's to make sure the NULL
> >        terminator is included
> > * postgresql connection uses PQparameterStatus if PQserverVersion
> >        doesn't exist and runs "select version()" if PQparameterStatus
> >        doesn't exist; to get the db version
> > * added mysql-5.1 drop-in replacement lib
> > * fixed a bug that caused result set data not to be cleaned up before
> >        a cursor is reused as a bind cursor
> > * changed string bind length to uint32_t from uint16_t
> > * added clearBinds() call after executeQuery() in perl dbi driver
> > * began work on an ODBC driver
> > * added serverVersion and clientVersion methods
> > * incorporated Alfred Fazio's python api patches
> > * fixed a bug where cursors might not get aborted when a client
> >        disconnects
> > * made shared memory segment group-readable
> > * applied Renaud Amar's HAVE_MYSQL_OPT_RECONNECT patch
> > * added ODBC driver to spec file
> > * added DESTDIR= to .pc files
> > * made freetds use single-quote for escape character, other db's use
> >        backslash
> > * made sqlr-export/import use &##; for non-printable characters,
> >        &, < and >
> > * fixed scaler; supports -localstatedir option properly now
> > * fixed many it's -> its typos in the documentation
> > * changed debug so that only one binary is built and it's selected at
> >        runtime
> > * integrated erlang api
> > * added -localstatedir to sqlr-stop
> > * fixed mysql (with statement api) relogin problems
> > * removed non-functional config app
> > * added Oracle 11g on fc9 document
> > * added ASE 15.0.2 installation doc
> > * made it possible to only bind to port, not socket
> > * added test for tdsver.h
> >
> >
> > I have received a few patches that haven't been integrated yet and a few
> > bug reports that haven't been resolved yet.  In the interest of getting
> > this release out, I had to cut some things out, but they will be taken
> > care of as soon as possible.
> >
> > Rudiments 0.32 is also out with some bug fixes and is recommended, but
> > should not be required to build SQL Relay 0.40.
> >
> > Give it a try, report any bugs or issues you find.
> >
> > Take care,
> >
> > David Muse
> > dav...@fi...
> >
> >
> > __________________________________________________
> > D O T E A S Y - "Join the web hosting revolution!"
> >             http://www.doteasy.com
> >
> > ------------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It is the best place to buy or sell services for
> > just about anything Open Source.
> > http://p.sf.net/sfu/Xq1LFB
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
> 
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] Compilation bug

[David M. <dav...@fi...>]

Arrg.  That looks like maybe ruby runtime is installed, but the ruby
development stuff isn't.  I'll update the configure script to detect
both rather than just looking for ruby itself.

Dave
dav...@fi...

On Fri, 2009-01-09 at 11:47 +0000, Peter Clapham wrote:
> Hello David,
> 
> Many thanks for the release of 0.4.
> 
> On compiling on a Debian Etch system I hit on the the following:
> 
> ./configure -prefix=/usr/local --with-mysql-prefix=/usr/local/mysql-5.1
> --with-rudiments-prefix=/usr/local
> 
> caused errors in the attached file
> 
> 
> adding --disable-ruby = success.
> 
> Pete
> 
> 
> 
> -- 
>  The Wellcome Trust Sanger Institute is operated by Genome Research 
>  Limited, a charity registered in England with number 1021457 and a 
>  company registered in England with number 2742969, whose registered 
>  office is 215 Euston Road, London, NW1 2BE. 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com
> plain text document attachment (error.log)
> ssgtest1a:/usr/local/src/sqlrelay-0.40# make make -C src all make[1]: Entering directory `/usr/local/src/sqlrelay-0.40/src' make -C util all make[2]: Entering directory `/usr/local/src/sqlrelay-0.40/src/util' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/util' make -C listener all make[2]: Entering directory `/usr/local/src/sqlrelay-0.40/src/listener' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/listener' make -C api all make[2]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api' make -C c++ all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/c++' make -C src all make[4]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/c++/src' make[4]: Nothing to be done for `all'. make[4]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/c++/src' make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/c++' make -C c all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/c' make -C src all make[4]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/c/src' make[4]: Nothing to be done for `all'. make[4]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/c/src' make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/c' make -C postgresql all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/postgresql' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/postgresql' make -C mysql all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/mysql' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/mysql' make -C perl/Connection -f Makefile all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/perl/Connection' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/perl/Connection' make -C perl/Cursor -f Makefile all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/perl/Cursor' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/perl/Cursor' make -C perl/DBD -f Makefile all make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/perl/DBD' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/perl/DBD' make -C ruby all getcflags.rb:1:in `require': no such file to load -- mkmf (LoadError) from getcflags.rb:1 make[3]: *** No targets. Stop. getcflags.rb:1:in `require': no such file to load -- mkmf (LoadError) from getcflags.rb:1 make[3]: *** No targets. Stop. make[3]: Entering directory `/usr/local/src/sqlrelay-0.40/src/api/ruby' cp rubyincludes1.h rubyincludes.h; \ /bin/sh ../../../libtool --mode=compile g++ -Wall -pipe -DHAVE_CONFIG -pthread -I./ -I../../../src/api/c++/include -I/usr/local/include -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors1; \ if ( test ! -r sqlrelay.lo ); then \ cp rubyincludes2.h rubyincludes.h; \ /bin/sh ../../../libtool --mode=compile g++ -Wall -pipe -DHAVE_CONFIG -pthread -I./ -I../../../src/api/c++/include -I/usr/local/include -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors2; \ if ( test ! -r sqlrelay.lo ); then \ if ( test -s errors1 ); then \ echo "first try errors : "; cat errors1; echo; \ fi; \ if ( test -s errors2 ); then \ echo "second try errors : "; cat errors2; echo; \ fi; \ exit 1; \ else \ cat errors2; \ fi; \ else \ cat errors1; \ fi; \ rm -f errors1 errors2 rubyincludes.h mkdir .libs g++ -Wall -pipe -DHAVE_CONFIG -pthread -I./ -I../../../src/api/c++/include -I/usr/local/include -pthread -c sqlrelay.C -fPIC -DPIC -o .libs/sqlrelay.o g++ -Wall -pipe -DHAVE_CONFIG -pthread -I./ -I../../../src/api/c++/include -I/usr/local/include -pthread -c sqlrelay.C -fPIC -DPIC -o .libs/sqlrelay.o first try errors : sqlrelay.C:4:18: error: ruby.h: No such file or directory sqlrelay.C:16: error: 'VALUE' does not name a type sqlrelay.C:36: error: 'VALUE' does not name a type sqlrelay.C:43: error: 'VALUE' does not name a type sqlrelay.C:49: error: 'VALUE' does not name a type sqlrelay.C:55: error: 'VALUE' does not name a type sqlrelay.C:66: error: 'VALUE' does not name a type sqlrelay.C:73: error: 'VALUE' does not name a type sqlrelay.C:79: error: 'VALUE' does not name a type sqlrelay.C:90: error: 'VALUE' does not name a type sqlrelay.C:101: error: 'VALUE' does not name a type sqlrelay.C:112: error: 'VALUE' does not name a type sqlrelay.C:123: error: 'VALUE' does not name a type sqlrelay.C:134: error: 'VALUE' does not name a type sqlrelay.C:140: error: 'VALUE' does not name a type sqlrelay.C:146: error: 'VALUE' does not name a type sqlrelay.C:152: error: 'VALUE' does not name a type sqlrelay.C:158: error: 'VALUE' does not name a type sqlrelay.C:165: error: 'VALUE' does not name a type sqlrelay.C:172: error: 'VALUE' does not name a type sqlrelay.C:180: error: 'VALUE' does not name a type sqlrelay.C: In function 'void Init_SQLRConnection()': sqlrelay.C:183: error: 'csqlrconnection' was not declared in this scope sqlrelay.C:183: error: 'rb_cObject' was not declared in this scope sqlrelay.C:183: error: 'rb_define_class' was not declared in this scope sqlrelay.C:185: error: expected primary-expression before ')' token sqlrelay.C:185: error: 'VALUE' was not declared in this scope sqlrelay.C:185: error: 'rb_define_singleton_method' was not declared in this scope sqlrelay.C:187: error: expected primary-expression before ')' token sqlrelay.C:187: error: 'rb_define_method' was not declared in this scope sqlrelay.C:189: error: expected primary-expression before ')' token sqlrelay.C:191: error: expected primary-expression before ')' token sqlrelay.C:193: error: expected primary-expression before ')' token sqlrelay.C:195: error: expected primary-expression before ')' token sqlrelay.C:197: error: expected primary-expression before ')' token sqlrelay.C:199: error: expected primary-expression before ')' token sqlrelay.C:201: error: expected primary-expression before ')' token sqlrelay.C:203: error: expected primary-expression before ')' token sqlrelay.C:205: error: expected primary-expression before ')' token sqlrelay.C:207: error: expected primary-expression before ')' token sqlrelay.C:209: error: expected primary-expression before ')' token sqlrelay.C:211: error: expected primary-expression before ')' token sqlrelay.C:213: error: expected primary-expression before ')' token sqlrelay.C:215: error: expected primary-expression before ')' token sqlrelay.C:217: error: expected primary-expression before ')' token sqlrelay.C:219: error: expected primary-expression before ')' token sqlrelay.C:221: error: expected primary-expression before ')' token sqlrelay.C: At global scope: sqlrelay.C:227: error: 'VALUE' does not name a type sqlrelay.C:233: error: 'VALUE' does not name a type sqlrelay.C:241: error: 'VALUE' does not name a type sqlrelay.C:248: error: 'VALUE' does not name a type sqlrelay.C:254: error: 'VALUE' does not name a type sqlrelay.C:261: error: 'VALUE' does not name a type sqlrelay.C:268: error: 'VALUE' does not name a type sqlrelay.C:275: error: 'VALUE' does not name a type sqlrelay.C:282: error: 'VALUE' does not name a type sqlrelay.C:289: error: 'VALUE' does not name a type sqlrelay.C:296: error: 'VALUE' does not name a type sqlrelay.C:303: error: 'VALUE' does not name a type sqlrelay.C:314: error: 'VALUE' does not name a type sqlrelay.C:321: error: 'VALUE' does not name a type sqlrelay.C:327: error: 'VALUE' does not name a type sqlrelay.C:334: error: 'VALUE' does not name a type sqlrelay.C:341: error: 'VALUE' does not name a type sqlrelay.C:348: error: 'VALUE' does not name a type sqlrelay.C:356: error: 'VALUE' does not name a type sqlrelay.C:363: error: 'VALUE' does not name a type sqlrelay.C:370: error: 'VALUE' does not name a type sqlrelay.C:376: error: 'VALUE' does not name a type sqlrelay.C:404: error: 'VALUE' does not name a type sqlrelay.C:432: error: 'VALUE' does not name a type sqlrelay.C:448: error: 'VALUE' does not name a type sqlrelay.C:464: error: 'VALUE' does not name a type sqlrelay.C:472: error: 'VALUE' does not name a type sqlrelay.C:479: error: 'VALUE' does not name a type sqlrelay.C:486: error: 'VALUE' does not name a type sqlrelay.C:493: error: 'VALUE' does not name a type sqlrelay.C:500: error: 'VALUE' does not name a type sqlrelay.C:507: error: 'VALUE' does not name a type sqlrelay.C:558: error: 'VALUE' does not name a type sqlrelay.C:606: error: 'VALUE' does not name a type sqlrelay.C:613: error: 'VALUE' does not name a type sqlrelay.C:619: error: 'VALUE' does not name a type sqlrelay.C:625: error: 'VALUE' does not name a type sqlrelay.C:631: error: 'VALUE' does not name a type sqlrelay.C:644: error: 'VALUE' does not name a type sqlrelay.C:657: error: 'VALUE' does not name a type sqlrelay.C:670: error: 'VALUE' does not name a type sqlrelay.C:678: error: 'VALUE' does not name a type sqlrelay.C:686: error: 'VALUE' does not name a type sqlrelay.C:692: error: 'VALUE' does not name a type sqlrelay.C:702: error: 'VALUE' does not name a type sqlrelay.C:708: error: 'VALUE' does not name a type sqlrelay.C:714: error: 'VALUE' does not name a type sqlrelay.C:720: error: 'VALUE' does not name a type sqlrelay.C:726: error: 'VALUE' does not name a type sqlrelay.C:732: error: 'VALUE' does not name a type sqlrelay.C:738: error: 'VALUE' does not name a type sqlrelay.C:744: error: 'VALUE' does not name a type sqlrelay.C:755: error: 'VALUE' does not name a type sqlrelay.C:762: error: 'VALUE' does not name a type sqlrelay.C:769: error: 'VALUE' does not name a type sqlrelay.C:788: error: 'VALUE' does not name a type sqlrelay.C:800: error: 'VALUE' does not name a type sqlrelay.C:812: error: 'VALUE' does not name a type sqlrelay.C:824: error: 'VALUE' does not name a type sqlrelay.C:841: error: 'VALUE' does not name a type sqlrelay.C:861: error: 'VALUE' does not name a type sqlrelay.C:875: error: 'VALUE' does not name a type sqlrelay.C:888: error: 'VALUE' does not name a type sqlrelay.C:906: error: 'VALUE' does not name a type sqlrelay.C:917: error: 'VALUE' does not name a type sqlrelay.C:933: error: 'VALUE' does not name a type sqlrelay.C:943: error: 'VALUE' does not name a type sqlrelay.C:953: error: 'VALUE' does not name a type sqlrelay.C:963: error: 'VALUE' does not name a type sqlrelay.C:973: error: 'VALUE' does not name a type sqlrelay.C:983: error: 'VALUE' does not name a type sqlrelay.C:993: error: 'VALUE' does not name a type sqlrelay.C:1003: error: 'VALUE' does not name a type sqlrelay.C:1013: error: 'VALUE' does not name a type sqlrelay.C:1023: error: 'VALUE' does not name a type sqlrelay.C:1033: error: 'VALUE' does not name a type sqlrelay.C:1045: error: 'VALUE' does not name a type sqlrelay.C:1055: error: 'VALUE' does not name a type sqlrelay.C:1061: error: 'VALUE' does not name a type sqlrelay.C:1068: error: 'VALUE' does not name a type sqlrelay.C:1074: error: 'VALUE' does not name a type sqlrelay.C: In function 'void Init_SQLRCursor()': sqlrelay.C:1083: error: 'csqlrcursor' was not declared in this scope sqlrelay.C:1083: error: 'rb_cObject' was not declared in this scope sqlrelay.C:1083: error: 'rb_define_class' was not declared in this scope sqlrelay.C:1085: error: expected primary-expression before ')' token sqlrelay.C:1085: error: 'VALUE' was not declared in this scope sqlrelay.C:1085: error: 'rb_define_singleton_method' was not declared in this scope sqlrelay.C:1087: error: expected primary-expression before ')' token sqlrelay.C:1087: error: 'rb_define_method' was not declared in this scope sqlrelay.C:1089: error: expected primary-expression before ')' token sqlrelay.C:1091: error: expected primary-expression before ')' token sqlrelay.C:1093: error: expected primary-expression before ')' token sqlrelay.C:1095: error: expected primary-expression before ')' token sqlrelay.C:1097: error: expected primary-expression before ')' token sqlrelay.C:1099: error: expected primary-expression before ')' token sqlrelay.C:1101: error: expected primary-expression before ')' token sqlrelay.C:1103: error: expected primary-expression before ')' token sqlrelay.C:1105: error: expected primary-expression before ')' token sqlrelay.C:1107: error: expected primary-expression before ')' token sqlrelay.C:1109: error: expected primary-expression before ')' token sqlrelay.C:1111: error: expected primary-expression before ')' token sqlrelay.C:1113: error: expected primary-expression before ')' token sqlrelay.C:1115: error: expected primary-expression before ')' token sqlrelay.C:1117: error: expected primary-expression before ')' token sqlrelay.C:1119: error: expected primary-expression before ')' token sqlrelay.C:1121: error: expected primary-expression before ')' token sqlrelay.C:1123: error: expected primary-expression before ')' token sqlrelay.C:1125: error: expected primary-expression before ')' token sqlrelay.C:1127: error: expected primary-expression before ')' token sqlrelay.C:1129: error: expected primary-expression before ')' token sqlrelay.C:1131: error: expected primary-expression before ')' token sqlrelay.C:1133: error: expected primary-expression before ')' token sqlrelay.C:1135: error: expected primary-expression before ')' token sqlrelay.C:1137: error: expected primary-expression before ')' token sqlrelay.C:1139: error: expected primary-expression before ')' token sqlrelay.C:1141: error: expected primary-expression before ')' token sqlrelay.C:1143: error: expected primary-expression before ')' token sqlrelay.C:1145: error: expected primary-expression before ')' token sqlrelay.C:1147: error: expected primary-expression before ')' token sqlrelay.C:1149: error: expected primary-expression before ')' token sqlrelay.C:1151: error: expected primary-expression before ')' token sqlrelay.C:1153: error: expected primary-expression before ')' token sqlrelay.C:1155: error: expected primary-expression before ')' token sqlrelay.C:1157: error: expected primary-expression before ')' token sqlrelay.C:1159: error: expected primary-expression before ')' token sqlrelay.C:1161: error: expected primary-expression before ')' token sqlrelay.C:1163: error: expected primary-expression before ')' token sqlrelay.C:1165: error: expected primary-expression before ')' token sqlrelay.C:1167: error: expected primary-expression before ')' token sqlrelay.C:1169: error: expected primary-expression before ')' token sqlrelay.C:1171: error: expected primary-expression before ')' token sqlrelay.C:1173: error: expected primary-expression before ')' token sqlrelay.C:1175: error: expected primary-expression before ')' token sqlrelay.C:1177: error: expected primary-expression before ')' token sqlrelay.C:1179: error: expected primary-expression before ')' token sqlrelay.C:1181: error: expected primary-expression before ')' token sqlrelay.C:1183: error: expected primary-expression before ')' token sqlrelay.C:1185: error: expected primary-expression before ')' token sqlrelay.C:1187: error: expected primary-expression before ')' token sqlrelay.C:1189: error: expected primary-expression before ')' token sqlrelay.C:1191: error: expected primary-expression before ')' token sqlrelay.C:1193: error: expected primary-expression before ')' token sqlrelay.C:1195: error: expected primary-expression before ')' token sqlrelay.C:1197: error: expected primary-expression before ')' token sqlrelay.C:1199: error: expected primary-expression before ')' token sqlrelay.C:1201: error: expected primary-expression before ')' token sqlrelay.C:1203: error: expected primary-expression before ')' token sqlrelay.C:1205: error: expected primary-expression before ')' token sqlrelay.C:1207: error: expected primary-expression before ')' token sqlrelay.C:1209: error: expected primary-expression before ')' token sqlrelay.C:1211: error: expected primary-expression before ')' token sqlrelay.C:1213: error: expected primary-expression before ')' token sqlrelay.C:1215: error: expected primary-expression before ')' token sqlrelay.C:1217: error: expected primary-expression before ')' token sqlrelay.C:1219: error: expected primary-expression before ')' token sqlrelay.C:1221: error: expected primary-expression before ')' token sqlrelay.C:1223: error: expected primary-expression before ')' token sqlrelay.C:1225: error: expected primary-expression before ')' token sqlrelay.C:1227: error: expected primary-expression before ')' token sqlrelay.C:1229: error: expected primary-expression before ')' token sqlrelay.C:1231: error: expected primary-expression before ')' token sqlrelay.C:1233: error: expected primary-expression before ')' token sqlrelay.C:1235: error: expected primary-expression before ')' token sqlrelay.C:1237: error: expected primary-expression before ')' token sqlrelay.C:1239: error: expected primary-expression before ')' token sqlrelay.C:1241: error: expected primary-expression before ')' token sqlrelay.C:1243: error: expected primary-expression before ')' token sqlrelay.C: At global scope: sqlrelay.C:12: warning: 'void sqlrcon_free(void*)' defined but not used sqlrelay.C:229: warning: 'void sqlrcur_free(void*)' defined but not used second try errors : sqlrelay.C:4:18: error: ruby.h: No such file or directory sqlrelay.C:16: error: 'VALUE' does not name a type sqlrelay.C:36: error: 'VALUE' does not name a type sqlrelay.C:43: error: 'VALUE' does not name a type sqlrelay.C:49: error: 'VALUE' does not name a type sqlrelay.C:55: error: 'VALUE' does not name a type sqlrelay.C:66: error: 'VALUE' does not name a type sqlrelay.C:73: error: 'VALUE' does not name a type sqlrelay.C:79: error: 'VALUE' does not name a type sqlrelay.C:90: error: 'VALUE' does not name a type sqlrelay.C:101: error: 'VALUE' does not name a type sqlrelay.C:112: error: 'VALUE' does not name a type sqlrelay.C:123: error: 'VALUE' does not name a type sqlrelay.C:134: error: 'VALUE' does not name a type sqlrelay.C:140: error: 'VALUE' does not name a type sqlrelay.C:146: error: 'VALUE' does not name a type sqlrelay.C:152: error: 'VALUE' does not name a type sqlrelay.C:158: error: 'VALUE' does not name a type sqlrelay.C:165: error: 'VALUE' does not name a type sqlrelay.C:172: error: 'VALUE' does not name a type sqlrelay.C:180: error: 'VALUE' does not name a type sqlrelay.C: In function 'void Init_SQLRConnection()': sqlrelay.C:183: error: 'csqlrconnection' was not declared in this scope sqlrelay.C:183: error: 'rb_cObject' was not declared in this scope sqlrelay.C:183: error: 'rb_define_class' was not declared in this scope sqlrelay.C:185: error: expected primary-expression before ')' token sqlrelay.C:185: error: 'VALUE' was not declared in this scope sqlrelay.C:185: error: expected primary-expression before '...' token sqlrelay.C:185: error: 'rb_define_singleton_method' was not declared in this scope sqlrelay.C:187: error: expected primary-expression before ')' token sqlrelay.C:187: error: expected primary-expression before '...' token sqlrelay.C:187: error: 'rb_define_method' was not declared in this scope sqlrelay.C:189: error: expected primary-expression before ')' token sqlrelay.C:189: error: expected primary-expression before '...' token sqlrelay.C:191: error: expected primary-expression before ')' token sqlrelay.C:191: error: expected primary-expression before '...' token sqlrelay.C:193: error: expected primary-expression before ')' token sqlrelay.C:193: error: expected primary-expression before '...' token sqlrelay.C:195: error: expected primary-expression before ')' token sqlrelay.C:195: error: expected primary-expression before '...' token sqlrelay.C:197: error: expected primary-expression before ')' token sqlrelay.C:197: error: expected primary-expression before '...' token sqlrelay.C:199: error: expected primary-expression before ')' token sqlrelay.C:199: error: expected primary-expression before '...' token sqlrelay.C:201: error: expected primary-expression before ')' token sqlrelay.C:201: error: expected primary-expression before '...' token sqlrelay.C:203: error: expected primary-expression before ')' token sqlrelay.C:203: error: expected primary-expression before '...' token sqlrelay.C:205: error: expected primary-expression before ')' token sqlrelay.C:205: error: expected primary-expression before '...' token sqlrelay.C:207: error: expected primary-expression before ')' token sqlrelay.C:207: error: expected primary-expression before '...' token sqlrelay.C:209: error: expected primary-expression before ')' token sqlrelay.C:209: error: expected primary-expression before '...' token sqlrelay.C:211: error: expected primary-expression before ')' token sqlrelay.C:211: error: expected primary-expression before '...' token sqlrelay.C:213: error: expected primary-expression before ')' token sqlrelay.C:213: error: expected primary-expression before '...' token sqlrelay.C:215: error: expected primary-expression before ')' token sqlrelay.C:215: error: expected primary-expression before '...' token sqlrelay.C:217: error: expected primary-expression before ')' token sqlrelay.C:217: error: expected primary-expression before '...' token sqlrelay.C:219: error: expected primary-expression before ')' token sqlrelay.C:219: error: expected primary-expression before '...' token sqlrelay.C:221: error: expected primary-expression before ')' token sqlrelay.C:221: error: expected primary-expression before '...' token sqlrelay.C: At global scope: sqlrelay.C:227: error: 'VALUE' does not name a type sqlrelay.C:233: error: 'VALUE' does not name a type sqlrelay.C:241: error: 'VALUE' does not name a type sqlrelay.C:248: error: 'VALUE' does not name a type sqlrelay.C:254: error: 'VALUE' does not name a type sqlrelay.C:261: error: 'VALUE' does not name a type sqlrelay.C:268: error: 'VALUE' does not name a type sqlrelay.C:275: error: 'VALUE' does not name a type sqlrelay.C:282: error: 'VALUE' does not name a type sqlrelay.C:289: error: 'VALUE' does not name a type sqlrelay.C:296: error: 'VALUE' does not name a type sqlrelay.C:303: error: 'VALUE' does not name a type sqlrelay.C:314: error: 'VALUE' does not name a type sqlrelay.C:321: error: 'VALUE' does not name a type sqlrelay.C:327: error: 'VALUE' does not name a type sqlrelay.C:334: error: 'VALUE' does not name a type sqlrelay.C:341: error: 'VALUE' does not name a type sqlrelay.C:348: error: 'VALUE' does not name a type sqlrelay.C:356: error: 'VALUE' does not name a type sqlrelay.C:363: error: 'VALUE' does not name a type sqlrelay.C:370: error: 'VALUE' does not name a type sqlrelay.C:376: error: 'VALUE' does not name a type sqlrelay.C:404: error: 'VALUE' does not name a type sqlrelay.C:432: error: 'VALUE' does not name a type sqlrelay.C:448: error: 'VALUE' does not name a type sqlrelay.C:464: error: 'VALUE' does not name a type sqlrelay.C:472: error: 'VALUE' does not name a type sqlrelay.C:479: error: 'VALUE' does not name a type sqlrelay.C:486: error: 'VALUE' does not name a type sqlrelay.C:493: error: 'VALUE' does not name a type sqlrelay.C:500: error: 'VALUE' does not name a type sqlrelay.C:507: error: 'VALUE' does not name a type sqlrelay.C:558: error: 'VALUE' does not name a type sqlrelay.C:606: error: 'VALUE' does not name a type sqlrelay.C:613: error: 'VALUE' does not name a type sqlrelay.C:619: error: 'VALUE' does not name a type sqlrelay.C:625: error: 'VALUE' does not name a type sqlrelay.C:631: error: 'VALUE' does not name a type sqlrelay.C:644: error: 'VALUE' does not name a type sqlrelay.C:657: error: 'VALUE' does not name a type sqlrelay.C:670: error: 'VALUE' does not name a type sqlrelay.C:678: error: 'VALUE' does not name a type sqlrelay.C:686: error: 'VALUE' does not name a type sqlrelay.C:692: error: 'VALUE' does not name a type sqlrelay.C:702: error: 'VALUE' does not name a type sqlrelay.C:708: error: 'VALUE' does not name a type sqlrelay.C:714: error: 'VALUE' does not name a type sqlrelay.C:720: error: 'VALUE' does not name a type sqlrelay.C:726: error: 'VALUE' does not name a type sqlrelay.C:732: error: 'VALUE' does not name a type sqlrelay.C:738: error: 'VALUE' does not name a type sqlrelay.C:744: error: 'VALUE' does not name a type sqlrelay.C:755: error: 'VALUE' does not name a type sqlrelay.C:762: error: 'VALUE' does not name a type sqlrelay.C:769: error: 'VALUE' does not name a type sqlrelay.C:788: error: 'VALUE' does not name a type sqlrelay.C:800: error: 'VALUE' does not name a type sqlrelay.C:812: error: 'VALUE' does not name a type sqlrelay.C:824: error: 'VALUE' does not name a type sqlrelay.C:841: error: 'VALUE' does not name a type sqlrelay.C:861: error: 'VALUE' does not name a type sqlrelay.C:875: error: 'VALUE' does not name a type sqlrelay.C:888: error: 'VALUE' does not name a type sqlrelay.C:906: error: 'VALUE' does not name a type sqlrelay.C:917: error: 'VALUE' does not name a type sqlrelay.C:933: error: 'VALUE' does not name a type sqlrelay.C:943: error: 'VALUE' does not name a type sqlrelay.C:953: error: 'VALUE' does not name a type sqlrelay.C:963: error: 'VALUE' does not name a type sqlrelay.C:973: error: 'VALUE' does not name a type sqlrelay.C:983: error: 'VALUE' does not name a type sqlrelay.C:993: error: 'VALUE' does not name a type sqlrelay.C:1003: error: 'VALUE' does not name a type sqlrelay.C:1013: error: 'VALUE' does not name a type sqlrelay.C:1023: error: 'VALUE' does not name a type sqlrelay.C:1033: error: 'VALUE' does not name a type sqlrelay.C:1045: error: 'VALUE' does not name a type sqlrelay.C:1055: error: 'VALUE' does not name a type sqlrelay.C:1061: error: 'VALUE' does not name a type sqlrelay.C:1068: error: 'VALUE' does not name a type sqlrelay.C:1074: error: 'VALUE' does not name a type sqlrelay.C: In function 'void Init_SQLRCursor()': sqlrelay.C:1083: error: 'csqlrcursor' was not declared in this scope sqlrelay.C:1083: error: 'rb_cObject' was not declared in this scope sqlrelay.C:1083: error: 'rb_define_class' was not declared in this scope sqlrelay.C:1085: error: expected primary-expression before ')' token sqlrelay.C:1085: error: 'VALUE' was not declared in this scope sqlrelay.C:1085: error: expected primary-expression before '...' token sqlrelay.C:1085: error: 'rb_define_singleton_method' was not declared in this scope sqlrelay.C:1087: error: expected primary-expression before ')' token sqlrelay.C:1087: error: expected primary-expression before '...' token sqlrelay.C:1087: error: 'rb_define_method' was not declared in this scope sqlrelay.C:1089: error: expected primary-expression before ')' token sqlrelay.C:1089: error: expected primary-expression before '...' token sqlrelay.C:1091: error: expected primary-expression before ')' token sqlrelay.C:1091: error: expected primary-expression before '...' token sqlrelay.C:1093: error: expected primary-expression before ')' token sqlrelay.C:1093: error: expected primary-expression before '...' token sqlrelay.C:1095: error: expected primary-expression before ')' token sqlrelay.C:1095: error: expected primary-expression before '...' token sqlrelay.C:1097: error: expected primary-expression before ')' token sqlrelay.C:1097: error: expected primary-expression before '...' token sqlrelay.C:1099: error: expected primary-expression before ')' token sqlrelay.C:1099: error: expected primary-expression before '...' token sqlrelay.C:1101: error: expected primary-expression before ')' token sqlrelay.C:1101: error: expected primary-expression before '...' token sqlrelay.C:1103: error: expected primary-expression before ')' token sqlrelay.C:1103: error: expected primary-expression before '...' token sqlrelay.C:1105: error: expected primary-expression before ')' token sqlrelay.C:1105: error: expected primary-expression before '...' token sqlrelay.C:1107: error: expected primary-expression before ')' token sqlrelay.C:1107: error: expected primary-expression before '...' token sqlrelay.C:1109: error: expected primary-expression before ')' token sqlrelay.C:1109: error: expected primary-expression before '...' token sqlrelay.C:1111: error: expected primary-expression before ')' token sqlrelay.C:1111: error: expected primary-expression before '...' token sqlrelay.C:1113: error: expected primary-expression before ')' token sqlrelay.C:1113: error: expected primary-expression before '...' token sqlrelay.C:1115: error: expected primary-expression before ')' token sqlrelay.C:1115: error: expected primary-expression before '...' token sqlrelay.C:1117: error: expected primary-expression before ')' token sqlrelay.C:1117: error: expected primary-expression before '...' token sqlrelay.C:1119: error: expected primary-expression before ')' token sqlrelay.C:1119: error: expected primary-expression before '...' token sqlrelay.C:1121: error: expected primary-expression before ')' token sqlrelay.C:1121: error: expected primary-expression before '...' token sqlrelay.C:1123: error: expected primary-expression before ')' token sqlrelay.C:1123: error: expected primary-expression before '...' token sqlrelay.C:1125: error: expected primary-expression before ')' token sqlrelay.C:1125: error: expected primary-expression before '...' token sqlrelay.C:1127: error: expected primary-expression before ')' token sqlrelay.C:1127: error: expected primary-expression before '...' token sqlrelay.C:1129: error: expected primary-expression before ')' token sqlrelay.C:1129: error: expected primary-expression before '...' token sqlrelay.C:1131: error: expected primary-expression before ')' token sqlrelay.C:1131: error: expected primary-expression before '...' token sqlrelay.C:1133: error: expected primary-expression before ')' token sqlrelay.C:1133: error: expected primary-expression before '...' token sqlrelay.C:1135: error: expected primary-expression before ')' token sqlrelay.C:1135: error: expected primary-expression before '...' token sqlrelay.C:1137: error: expected primary-expression before ')' token sqlrelay.C:1137: error: expected primary-expression before '...' token sqlrelay.C:1139: error: expected primary-expression before ')' token sqlrelay.C:1139: error: expected primary-expression before '...' token sqlrelay.C:1141: error: expected primary-expression before ')' token sqlrelay.C:1141: error: expected primary-expression before '...' token sqlrelay.C:1143: error: expected primary-expression before ')' token sqlrelay.C:1143: error: expected primary-expression before '...' token sqlrelay.C:1145: error: expected primary-expression before ')' token sqlrelay.C:1145: error: expected primary-expression before '...' token sqlrelay.C:1147: error: expected primary-expression before ')' token sqlrelay.C:1147: error: expected primary-expression before '...' token sqlrelay.C:1149: error: expected primary-expression before ')' token sqlrelay.C:1149: error: expected primary-expression before '...' token sqlrelay.C:1151: error: expected primary-expression before ')' token sqlrelay.C:1151: error: expected primary-expression before '...' token sqlrelay.C:1153: error: expected primary-expression before ')' token sqlrelay.C:1153: error: expected primary-expression before '...' token sqlrelay.C:1155: error: expected primary-expression before ')' token sqlrelay.C:1155: error: expected primary-expression before '...' token sqlrelay.C:1157: error: expected primary-expression before ')' token sqlrelay.C:1157: error: expected primary-expression before '...' token sqlrelay.C:1159: error: expected primary-expression before ')' token sqlrelay.C:1159: error: expected primary-expression before '...' token sqlrelay.C:1161: error: expected primary-expression before ')' token sqlrelay.C:1161: error: expected primary-expression before '...' token sqlrelay.C:1163: error: expected primary-expression before ')' token sqlrelay.C:1163: error: expected primary-expression before '...' token sqlrelay.C:1165: error: expected primary-expression before ')' token sqlrelay.C:1165: error: expected primary-expression before '...' token sqlrelay.C:1167: error: expected primary-expression before ')' token sqlrelay.C:1167: error: expected primary-expression before '...' token sqlrelay.C:1169: error: expected primary-expression before ')' token sqlrelay.C:1169: error: expected primary-expression before '...' token sqlrelay.C:1171: error: expected primary-expression before ')' token sqlrelay.C:1171: error: expected primary-expression before '...' token sqlrelay.C:1173: error: expected primary-expression before ')' token sqlrelay.C:1173: error: expected primary-expression before '...' token sqlrelay.C:1175: error: expected primary-expression before ')' token sqlrelay.C:1175: error: expected primary-expression before '...' token sqlrelay.C:1177: error: expected primary-expression before ')' token sqlrelay.C:1177: error: expected primary-expression before '...' token sqlrelay.C:1179: error: expected primary-expression before ')' token sqlrelay.C:1179: error: expected primary-expression before '...' token sqlrelay.C:1181: error: expected primary-expression before ')' token sqlrelay.C:1181: error: expected primary-expression before '...' token sqlrelay.C:1183: error: expected primary-expression before ')' token sqlrelay.C:1183: error: expected primary-expression before '...' token sqlrelay.C:1185: error: expected primary-expression before ')' token sqlrelay.C:1185: error: expected primary-expression before '...' token sqlrelay.C:1187: error: expected primary-expression before ')' token sqlrelay.C:1187: error: expected primary-expression before '...' token sqlrelay.C:1189: error: expected primary-expression before ')' token sqlrelay.C:1189: error: expected primary-expression before '...' token sqlrelay.C:1191: error: expected primary-expression before ')' token sqlrelay.C:1191: error: expected primary-expression before '...' token sqlrelay.C:1193: error: expected primary-expression before ')' token sqlrelay.C:1193: error: expected primary-expression before '...' token sqlrelay.C:1195: error: expected primary-expression before ')' token sqlrelay.C:1195: error: expected primary-expression before '...' token sqlrelay.C:1197: error: expected primary-expression before ')' token sqlrelay.C:1197: error: expected primary-expression before '...' token sqlrelay.C:1199: error: expected primary-expression before ')' token sqlrelay.C:1199: error: expected primary-expression before '...' token sqlrelay.C:1201: error: expected primary-expression before ')' token sqlrelay.C:1201: error: expected primary-expression before '...' token sqlrelay.C:1203: error: expected primary-expression before ')' token sqlrelay.C:1203: error: expected primary-expression before '...' token sqlrelay.C:1205: error: expected primary-expression before ')' token sqlrelay.C:1205: error: expected primary-expression before '...' token sqlrelay.C:1207: error: expected primary-expression before ')' token sqlrelay.C:1207: error: expected primary-expression before '...' token sqlrelay.C:1209: error: expected primary-expression before ')' token sqlrelay.C:1209: error: expected primary-expression before '...' token sqlrelay.C:1211: error: expected primary-expression before ')' token sqlrelay.C:1211: error: expected primary-expression before '...' token sqlrelay.C:1213: error: expected primary-expression before ')' token sqlrelay.C:1213: error: expected primary-expression before '...' token sqlrelay.C:1215: error: expected primary-expression before ')' token sqlrelay.C:1215: error: expected primary-expression before '...' token sqlrelay.C:1217: error: expected primary-expression before ')' token sqlrelay.C:1217: error: expected primary-expression before '...' token sqlrelay.C:1219: error: expected primary-expression before ')' token sqlrelay.C:1219: error: expected primary-expression before '...' token sqlrelay.C:1221: error: expected primary-expression before ')' token sqlrelay.C:1221: error: expected primary-expression before '...' token sqlrelay.C:1223: error: expected primary-expression before ')' token sqlrelay.C:1223: error: expected primary-expression before '...' token sqlrelay.C:1225: error: expected primary-expression before ')' token sqlrelay.C:1225: error: expected primary-expression before '...' token sqlrelay.C:1227: error: expected primary-expression before ')' token sqlrelay.C:1227: error: expected primary-expression before '...' token sqlrelay.C:1229: error: expected primary-expression before ')' token sqlrelay.C:1229: error: expected primary-expression before '...' token sqlrelay.C:1231: error: expected primary-expression before ')' token sqlrelay.C:1231: error: expected primary-expression before '...' token sqlrelay.C:1233: error: expected primary-expression before ')' token sqlrelay.C:1233: error: expected primary-expression before '...' token sqlrelay.C:1235: error: expected primary-expression before ')' token sqlrelay.C:1235: error: expected primary-expression before '...' token sqlrelay.C:1237: error: expected primary-expression before ')' token sqlrelay.C:1237: error: expected primary-expression before '...' token sqlrelay.C:1239: error: expected primary-expression before ')' token sqlrelay.C:1239: error: expected primary-expression before '...' token sqlrelay.C:1241: error: expected primary-expression before ')' token sqlrelay.C:1241: error: expected primary-expression before '...' token sqlrelay.C:1243: error: expected primary-expression before ')' token sqlrelay.C:1243: error: expected primary-expression before '...' token sqlrelay.C: At global scope: sqlrelay.C:12: warning: 'void sqlrcon_free(void*)' defined but not used sqlrelay.C:229: warning: 'void sqlrcur_free(void*)' defined but not used make[3]: *** [sqlrelay.lo] Error 1 make[3]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api/ruby' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/local/src/sqlrelay-0.40/src/api' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/local/src/sqlrelay-0.40/src' make: *** [all] Error 2
> ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB __________________________________________________ D O T E A S Y - "Join the web hosting revolution!" http://www.doteasy.com
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] Compilation bug

[Peter C. <pc...@sa...>]

Hello David,

Many thanks for the release of 0.4.

On compiling on a Debian Etch system I hit on the the following:

./configure -prefix=/usr/local --with-mysql-prefix=/usr/local/mysql-5.1
--with-rudiments-prefix=/usr/local

caused errors in the attached file


adding --disable-ruby = success.

Pete



-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE. 

Re: [Sqlrelay-discussion] SQL Relay 0.40 is out

[Chad J. <cha...@gm...>]

Any chance that this bug :

http://sourceforge.net/tracker/index.php?func=detail&aid=1906458&group_id=10238&atid=360238

Was patched as well?

-Chad Johnson

On Thu, Jan 8, 2009 at 7:37 PM, David Muse <dav...@fi...> wrote:
> Hello all,
>
> It's been a while, but SQL Relay 0.40 is finally out.
>
> This release includes lots of bug fixes, most for obscure bugs.  I also
> integrated a few patches.  New features in this release include an
> erlang API and ODBC driver.  The ODBC driver is very incomplete, but is
> usable.
>
> Here's the full Changelog:
>
> * fixed readline detection in configure script
> * fixed an uninitialized variable in sqlr-import
> * changed clientSession() to call endSessionCommand()
>        instead of endSession() so endSessionInternal() would be called
>        every time
> * fixed debug option in sqlr-import and sqlr-export
> * fixed postgresql typemangling=no option
> * set dbversion to unknown if sp_version wasn't found in freetds/sybase
> * output bind variables' null indicator is reset now
> * updated postgresql typemangling
> * included Jesse Wagner's oracle 11g acsite patch
> * added +1 to inbindvars[i].valuesize for CLOB's to make sure the NULL
>        terminator is included
> * postgresql connection uses PQparameterStatus if PQserverVersion
>        doesn't exist and runs "select version()" if PQparameterStatus
>        doesn't exist; to get the db version
> * added mysql-5.1 drop-in replacement lib
> * fixed a bug that caused result set data not to be cleaned up before
>        a cursor is reused as a bind cursor
> * changed string bind length to uint32_t from uint16_t
> * added clearBinds() call after executeQuery() in perl dbi driver
> * began work on an ODBC driver
> * added serverVersion and clientVersion methods
> * incorporated Alfred Fazio's python api patches
> * fixed a bug where cursors might not get aborted when a client
>        disconnects
> * made shared memory segment group-readable
> * applied Renaud Amar's HAVE_MYSQL_OPT_RECONNECT patch
> * added ODBC driver to spec file
> * added DESTDIR= to .pc files
> * made freetds use single-quote for escape character, other db's use
>        backslash
> * made sqlr-export/import use &##; for non-printable characters,
>        &, < and >
> * fixed scaler; supports -localstatedir option properly now
> * fixed many it's -> its typos in the documentation
> * changed debug so that only one binary is built and it's selected at
>        runtime
> * integrated erlang api
> * added -localstatedir to sqlr-stop
> * fixed mysql (with statement api) relogin problems
> * removed non-functional config app
> * added Oracle 11g on fc9 document
> * added ASE 15.0.2 installation doc
> * made it possible to only bind to port, not socket
> * added test for tdsver.h
>
>
> I have received a few patches that haven't been integrated yet and a few
> bug reports that haven't been resolved yet.  In the interest of getting
> this release out, I had to cut some things out, but they will be taken
> care of as soon as possible.
>
> Rudiments 0.32 is also out with some bug fixes and is recommended, but
> should not be required to build SQL Relay 0.40.
>
> Give it a try, report any bugs or issues you find.
>
> Take care,
>
> David Muse
> dav...@fi...
>
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>             http://www.doteasy.com
>
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] SQL Relay 0.40 is out

[David M. <dav...@fi...>]

Hello all,

It's been a while, but SQL Relay 0.40 is finally out.

This release includes lots of bug fixes, most for obscure bugs.  I also
integrated a few patches.  New features in this release include an
erlang API and ODBC driver.  The ODBC driver is very incomplete, but is
usable.

Here's the full Changelog:

* fixed readline detection in configure script
* fixed an uninitialized variable in sqlr-import
* changed clientSession() to call endSessionCommand()
	instead of endSession() so endSessionInternal() would be called
	every time
* fixed debug option in sqlr-import and sqlr-export
* fixed postgresql typemangling=no option
* set dbversion to unknown if sp_version wasn't found in freetds/sybase
* output bind variables' null indicator is reset now
* updated postgresql typemangling
* included Jesse Wagner's oracle 11g acsite patch
* added +1 to inbindvars[i].valuesize for CLOB's to make sure the NULL
	terminator is included
* postgresql connection uses PQparameterStatus if PQserverVersion 
	doesn't exist and runs "select version()" if PQparameterStatus
	doesn't exist; to get the db version
* added mysql-5.1 drop-in replacement lib
* fixed a bug that caused result set data not to be cleaned up before
	a cursor is reused as a bind cursor
* changed string bind length to uint32_t from uint16_t
* added clearBinds() call after executeQuery() in perl dbi driver
* began work on an ODBC driver
* added serverVersion and clientVersion methods
* incorporated Alfred Fazio's python api patches
* fixed a bug where cursors might not get aborted when a client
	disconnects
* made shared memory segment group-readable
* applied Renaud Amar's HAVE_MYSQL_OPT_RECONNECT patch
* added ODBC driver to spec file
* added DESTDIR= to .pc files
* made freetds use single-quote for escape character, other db's use
	backslash
* made sqlr-export/import use &##; for non-printable characters,
	&, < and >
* fixed scaler; supports -localstatedir option properly now
* fixed many it's -> its typos in the documentation
* changed debug so that only one binary is built and it's selected at
	runtime
* integrated erlang api
* added -localstatedir to sqlr-stop
* fixed mysql (with statement api) relogin problems
* removed non-functional config app
* added Oracle 11g on fc9 document
* added ASE 15.0.2 installation doc
* made it possible to only bind to port, not socket
* added test for tdsver.h


I have received a few patches that haven't been integrated yet and a few
bug reports that haven't been resolved yet.  In the interest of getting
this release out, I had to cut some things out, but they will be taken
care of as soon as possible.

Rudiments 0.32 is also out with some bug fixes and is recommended, but
should not be required to build SQL Relay 0.40.

Give it a try, report any bugs or issues you find.

Take care,

David Muse
dav...@fi...


__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] php + sqlrelay

[D. V. <as...@gm...>]

Hi,

As time I've stopped wasting time on $subject, php4 was using it's own
client library to mysql - making it impossible to use mysql drop-in
for lazy php developers.

Have anyone archieved any advantages on it?

daniel

-- 
Dániel Vásárhelyi

"He who asks a question is a fool for five minutes; he who does not
ask a question remains a fool forever"
Chinese proverb