librelist archives

« back to archive

Fwd: mongrel2 make clean all

Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 12:35
Got
 /root/Mongrel2/mongrel2-1.7.5/src/config/db.c:171: undefined
reference to `sqlite3_prepare_v2'
during "make clean all"
SQLite3, zeromq already installed
Perhaps something else is missing or out-of-place.
Running on Centos5.6
Dick S.
--
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!



-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Ian Barber
Date:
2011-07-07 @ 12:39
On Thu, Jul 7, 2011 at 1:35 PM, Dick Seabrook <dick.seabrook@gmail.com>wrote:

> Got
>  /root/Mongrel2/mongrel2-1.7.5/src/config/db.c:171: undefined
> reference to `sqlite3_prepare_v2'
> during "make clean all"
> SQLite3, zeromq already installed
> Perhaps something else is missing or out-of-place.
> Running on Centos5.6
>

Believe that's the version of SQLite, I think Mongrel2 needs 3.5 and Centos
has 3.3

Ian

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Raj, Sudhaker
Date:
2011-07-07 @ 13:42

I had same issue when I tried to build it on CentOS 5.6

Dirty solution: I copied sqlite3.c & sqlite3.h into mongrel src folder and
took -lsqlite3 out from make file. These files can be found @ 
http://www.sqlite.org/amalgamation.html

Hope that helps.

Cheers,
Sudhaker

-----Original Message-----
From: mongrel2@librelist.com [mailto:mongrel2@librelist.com] On Behalf Of 
Dick Seabrook
Sent: Thursday, July 07, 2011 9:18 AM
To: mongrel2@librelist.com
Subject: Re: [mongrel2] Fwd: mongrel2 make clean all


On Thu, Jul 7, 2011 at 8:39 AM, Ian Barber <ian.barber@gmail.com> wrote:
> On Thu, Jul 7, 2011 at 1:35 PM, Dick Seabrook <dick.seabrook@gmail.com>
> wrote:
>>
>> Got
>>  /root/Mongrel2/mongrel2-1.7.5/src/config/db.c:171: undefined
>> reference to `sqlite3_prepare_v2'
>> during "make clean all"
>> SQLite3, zeromq already installed
>> Perhaps something else is missing or out-of-place.
>> Running on Centos5.6
>
> Believe that's the version of SQLite, I think Mongrel2 needs 3.5 and Centos
> has 3.3
>
> Ian
It didn't come from the CentOS repositories, I installed it.  Version arg shows

 sqlite3 -version
3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f

Any other thoughts?
Dick S.

--
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

----------------------------------------------------------------------
This message w/attachments (message) is intended solely for the use of the
intended recipient(s) and may contain information that is privileged, 
confidential or proprietary. If you are not an intended recipient, please 
notify the sender, and then please delete and destroy all copies and 
attachments, and be advised that any review or dissemination of, or the 
taking of any action in reliance on, the information contained in or 
attached to this message is prohibited. 
Unless specifically indicated, this message is not an offer to sell or a 
solicitation of any investment products or other financial product or 
service, an official confirmation of any transaction, or an official 
statement of Sender. Subject to applicable law, Sender may intercept, 
monitor, review and retain e-communications (EC) traveling through its 
networks/systems and may produce any such EC to regulators, law 
enforcement, in litigation and as required by law. 
The laws of the country of each sender/recipient may impact the handling 
of EC, and EC may be archived, supervised and produced in countries other 
than the country in which you are located. This message cannot be 
guaranteed to be secure or free of errors or viruses. 

References to "Sender" are references to any subsidiary of Bank of America
Corporation. Securities and Insurance Products: * Are Not FDIC Insured * 
Are Not Bank Guaranteed * May Lose Value * Are Not a Bank Deposit * Are 
Not a Condition to Any Banking Service or Activity * Are Not Insured by 
Any Federal Government Agency. Attachments that are part of this EC may 
have additional important disclosures and disclaimers, which you should 
read. This message is subject to terms available at the following link: 
http://www.bankofamerica.com/emaildisclaimer. By messaging with Sender you
consent to the foregoing.

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Zed A. Shaw
Date:
2011-07-07 @ 15:41
On Thu, Jul 07, 2011 at 09:42:26AM -0400, Raj, Sudhaker wrote:
> 
> 
> I had same issue when I tried to build it on CentOS 5.6
> 
> Dirty solution: I copied sqlite3.c & sqlite3.h into mongrel src folder
> and took -lsqlite3 out from make file. These files can be found @
> http://www.sqlite.org/amalgamation.html

Hmmm, I kind of like that. ;-)

-- 
Zed A. Shaw
http://zedshaw.com/

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 14:26
On Thu, Jul 7, 2011 at 9:42 AM, Raj, Sudhaker <sudhaker.raj@baml.com> wrote:
>
>
> I had same issue when I tried to build it on CentOS 5.6
>
> Dirty solution: I copied sqlite3.c & sqlite3.h into mongrel src folder 
and took -lsqlite3 out from make file. These files can be found @ 
http://www.sqlite.org/amalgamation.html
>
> Hope that helps.
>
> Cheers,
> Sudhaker
>
Thanks for the suggestion.  I tried that and now I get:

Running unit tests:
./tests/bstr_tests: error while loading shared libraries: libzmq.so.1:
cannot open shared object file: No such file or directory


Could it be looking for the lib in the wrong place?  I did a 'whereis'
on it and got:

 whereis libzmq.so.1
libzmq.so: /usr/local/lib/libzmq.so.1 /usr/local/lib/libzmq.so

Thanks for any thoughts...
Dick S.

-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Jubaraj Borgohain
Date:
2011-07-07 @ 14:30
Not sure if this will solve the issue but there was a similar issue before.
Check it out here

http://librelist.com/browser//mongrel2/2011/3/22/mongrel2-mongrel2-testing-error-while-compilation/#bd78bfbdb84a07ee2120f2f43134455c

On Thu, Jul 7, 2011 at 9:26 AM, Dick Seabrook <dick.seabrook@gmail.com>wrote:

> On Thu, Jul 7, 2011 at 9:42 AM, Raj, Sudhaker <sudhaker.raj@baml.com>
> wrote:
> >
> >
> > I had same issue when I tried to build it on CentOS 5.6
> >
> > Dirty solution: I copied sqlite3.c & sqlite3.h into mongrel src folder
> and took -lsqlite3 out from make file. These files can be found @
> http://www.sqlite.org/amalgamation.html
> >
> > Hope that helps.
> >
> > Cheers,
> > Sudhaker
> >
> Thanks for the suggestion.  I tried that and now I get:
>
> Running unit tests:
> ./tests/bstr_tests: error while loading shared libraries: libzmq.so.1:
> cannot open shared object file: No such file or directory
>
>
> Could it be looking for the lib in the wrong place?  I did a 'whereis'
> on it and got:
>
>  whereis libzmq.so.1
> libzmq.so: /usr/local/lib/libzmq.so.1 /usr/local/lib/libzmq.so
>
> Thanks for any thoughts...
> Dick S.
>
> --
> Dick Seabrook
> Anne Arundel Community College
> http://vader.aacc.edu/~rhs
> Speed the Net!
>



-- 
Juba
*@jubaborgohain <http://www.twitter.com/jubaborgohain>*

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 14:42
On Thu, Jul 7, 2011 at 10:30 AM, Jubaraj Borgohain
<jubarajborgohain@gmail.com> wrote:
> Not sure if this will solve the issue but there was a similar issue before.
> Check it out here
> 
http://librelist.com/browser//mongrel2/2011/3/22/mongrel2-mongrel2-testing-error-while-compilation/#bd78bfbdb84a07ee2120f2f43134455c
>

Several replies in the thread suggest running ldconfig which I did but
it didn't help.  I still get:

Running unit tests:
./tests/bstr_tests: error while loading shared libraries: libzmq.so.1:
cannot open shared object file: No such file or directory

when I execute 'make clean all' in the mongrel2 directory.
Any other thoughts?
Dick S.

-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Lionel Orry
Date:
2011-07-07 @ 15:05
On Thu, Jul 7, 2011 at 4:42 PM, Dick Seabrook <dick.seabrook@gmail.com> wrote:
> On Thu, Jul 7, 2011 at 10:30 AM, Jubaraj Borgohain
> <jubarajborgohain@gmail.com> wrote:
>> Not sure if this will solve the issue but there was a similar issue before.
>> Check it out here
>> 
http://librelist.com/browser//mongrel2/2011/3/22/mongrel2-mongrel2-testing-error-while-compilation/#bd78bfbdb84a07ee2120f2f43134455c
>>
>
> Several replies in the thread suggest running ldconfig which I did but
> it didn't help.  I still get:
>
> Running unit tests:
> ./tests/bstr_tests: error while loading shared libraries: libzmq.so.1:
> cannot open shared object file: No such file or directory
>
> when I execute 'make clean all' in the mongrel2 directory.
> Any other thoughts?
> Dick S.

add "/usr/local/lib" to /etc/ld.so.conf before executing "sudo ldconfig".

Or you can also do

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

In both ways, the matter is to tell the dynamic linker to find your
shared library where it's installed. For the long term, it's probably
more interesting to add /usr/local/lib in your ld.so.conf (provided
that you trust the libraries installed there of course).

Lionel

>
> --
> Dick Seabrook
> Anne Arundel Community College
> http://vader.aacc.edu/~rhs
> Speed the Net!
>

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 15:21
On Thu, Jul 7, 2011 at 11:05 AM, Lionel Orry <lionel.orry@gmail.com> wrote:

>> Running unit tests:
>> ./tests/bstr_tests: error while loading shared libraries: libzmq.so.1:
>> cannot open shared object file: No such file or directory
>>
>> when I execute 'make clean all' in the mongrel2 directory.
>> Any other thoughts?
>> Dick S.
>
> add "/usr/local/lib" to /etc/ld.so.conf before executing "sudo ldconfig".
>
> Or you can also do
>
> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
>
> In both ways, the matter is to tell the dynamic linker to find your
> shared library where it's installed. For the long term, it's probably
> more interesting to add /usr/local/lib in your ld.so.conf (provided
> that you trust the libraries installed there of course).
>
> Lionel
THANKS!  That seems to have done it.
I added /usr/local/lib to my /etc/ld.so.conf redid ldconfig and got through
the make OK.
Dick S.

-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 13:24
On Thu, Jul 7, 2011 at 8:39 AM, Ian Barber <ian.barber@gmail.com> wrote:
> On Thu, Jul 7, 2011 at 1:35 PM, Dick Seabrook <dick.seabrook@gmail.com>
> wrote:
>>
>> Got
>>  /root/Mongrel2/mongrel2-1.7.5/src/config/db.c:171: undefined
>> reference to `sqlite3_prepare_v2'
>> during "make clean all"
>> SQLite3, zeromq already installed
>> Perhaps something else is missing or out-of-place.
>> Running on Centos5.6
>
> Believe that's the version of SQLite, I think Mongrel2 needs 3.5 and Centos
> has 3.3
>
> Ian

I believe this is the bit of code from src/config/db.c where the error occurs:

    rc = sqlite3_prepare_v2(CONFIG_DB, sql, -1, &stmt, &sql_tail);
    check(rc == SQLITE_OK, "SQL error \"%s\" at: '%s'",
sqlite3_errmsg(CONFIG_DB), sql_tail);

    // we want to return a tns_tag_null if this is a query with no
    // results, which means we have to do a little bit of weird logic
    rc = sqlite3_step(stmt);

    if(rc == SQLITE_DONE) {
        if(sqlite3_column_count(stmt) == 0) {
            // query like UPDATE with no results possible
            res = tns_get_null();
        } else {
            // query that had results possible but had none
            res = tns_new_list();
        }
    } else if(rc == SQLITE_ROW) {
        // query with results, process them
        res = tns_new_list();

        do {
            tns_value_t *row = DB_convert_column(stmt);
            check(row != NULL, "Failed to convert DB column for sql:
'%s'", sql);
            tns_add_to_list(res, row);
        } while((rc = sqlite3_step(stmt)) == SQLITE_ROW);
    }



-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!

Re: [mongrel2] Fwd: mongrel2 make clean all

From:
Dick Seabrook
Date:
2011-07-07 @ 13:17
On Thu, Jul 7, 2011 at 8:39 AM, Ian Barber <ian.barber@gmail.com> wrote:
> On Thu, Jul 7, 2011 at 1:35 PM, Dick Seabrook <dick.seabrook@gmail.com>
> wrote:
>>
>> Got
>>  /root/Mongrel2/mongrel2-1.7.5/src/config/db.c:171: undefined
>> reference to `sqlite3_prepare_v2'
>> during "make clean all"
>> SQLite3, zeromq already installed
>> Perhaps something else is missing or out-of-place.
>> Running on Centos5.6
>
> Believe that's the version of SQLite, I think Mongrel2 needs 3.5 and Centos
> has 3.3
>
> Ian
It didn't come from the CentOS repositories, I installed it.  Version arg shows

 sqlite3 -version
3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f

Any other thoughts?
Dick S.

-- 
Dick Seabrook
Anne Arundel Community College
http://vader.aacc.edu/~rhs
Speed the Net!