On Thu, 24 Apr 2008, pete wrote:
Some progs pulled the distro-version of sqlite and of its dev packages, and
i think upon build this is picked up instead of a local copy of a fresher
sqlite which is only built but not installed to prevent problems with the
distro-packages which needs sqlite.
I'm not sure my hack in makefile's cflags (i added '-I../sqlite-3.5.6' to
make it find the newer lib) are enough for a successful build, but i can't
risk wrecking a live mail server by installing an updated version of sqlite
:( I'll research what pkg depends on the distro-devel files....
I understand that
seems close....
without the mod, the last errors after make clean && make
/usr/local/src/clapf-nightly_2008_04_23/bayes.c:605: undefined reference to
`sqlite3_prepare_v2'
/usr/local/src/clapf-nightly_2008_04_23/bayes.c:647: undefined reference to
`sqlite3_prepare_v2'
sqlite3.o: In function `sqlite3_qry':
/usr/local/src/clapf-nightly_2008_04_23/sqlite3.c:43: undefined reference
to `sqlite3_prepare_v2'
sqlite3.o: In function `do_sqlite3_qry':
/usr/local/src/clapf-nightly_2008_04_23/sqlite3.c:147: undefined reference
to `sqlite3_prepare_v2'
sql.o: In function `update_training_metadata':
/usr/local/src/clapf-nightly_2008_04_23/sql.c:276: undefined reference to
`sqlite3_prepare_v2'
sql.o:/usr/local/src/clapf-nightly_2008_04_23/sql.c:208: more undefined
references to `sqlite3_prepare_v2' follow
collect2: ld returned 1 exit status
make: *** [clapf] Error 1
after the mod
clapf_admin.o: In function `next_uid':
/usr/local/src/clapf-nightly_2008_04_23/clapf_admin.c:59: undefined
reference to `sqlite3_prepare_v2'
clapf_admin.o: In function `main':
/usr/local/src/clapf-nightly_2008_04_23/clapf_admin.c:146: undefined
reference to `sqlite3_prepare_v2'
/usr/local/src/clapf-nightly_2008_04_23/clapf_admin.c:163: undefined
reference to `sqlite3_prepare_v2'
collect2: ld returned 1 exit status
make: *** [clapf_admin] Error 1
hope this helps.
certainly, we are almost there. Then you should add the given "hack fix"
to clapf_admin.c, and it should compile cleanly. But I think, you may
be fine without it.
Its main purpose is to add an entry for the given user to the "main"
database, which is fine for mysql, because it uses a single database,
but this is not the case with sqlite3, because I changed the concept,
so every user has his own database. Anyway I would be happy if everyting
compiles with sqlite3, but again, you may comment out the clapf_admin
entry in the Makefile.
Digitally yours,
SJ.
--
