cppcms-users

[Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Aris S. <ari...@gm...>]

After I have successfully build cppcms 0.0.x and cms blog source, then
I ran cppblog_setup and run_lighttpd command, but an error related to
"failed backend access" raised.

Here are outputs from my terminal:

[root@masihmurah cms]# ./cppblog_setup
Select Backend
1 - MySQL
2 - PostrgreSQL
3 - Sqlite3
3
DATABASE
sqloe
Enter Blog username and password
arissety balbalanA1
[root@masihmurah cms]# ./run_lighttpd
Press any key to exit
Failed to access DBFailed to load backend
2011-01-07 05:43:56: (log.c.166) server started

was I wrong entering blog username and password?
where is the location of my sqlite database file?

Re: [Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Artyom <art...@ya...>]

You need to create the database first and run the
sqlite configuration script, i.e.:

sqlite3 my.db <data-sqlite3.sql 

Something like that and then configure it
in the configuration file.

Same for any other database you may want to use.

Keep in mind the blog is not officially released
and still has some "raw" parts in it.

Artyom



----- Original Message ----
> From: Aris Setyawan <ari...@gm...>
> To: cpp...@li...
> Sent: Fri, January 7, 2011 5:58:31 PM
> Subject: [Cppcms-users] cppcms blog, failed to access sqlite3 backend
> 
> After I have successfully build cppcms 0.0.x and cms blog source, then
> I ran  cppblog_setup and run_lighttpd command, but an error related to
> "failed  backend access" raised.
> 
> Here are outputs from my  terminal:
> 
> [root@masihmurah cms]# ./cppblog_setup
> Select Backend
> 1 -  MySQL
> 2 - PostrgreSQL
> 3 - Sqlite3
> 3
> DATABASE
> sqloe
> Enter Blog  username and password
> arissety balbalanA1
> [root@masihmurah cms]#  ./run_lighttpd
> Press any key to exit
> Failed to access DBFailed to load  backend
> 2011-01-07 05:43:56: (log.c.166) server started
> 
> was I wrong  entering blog username and password?
> where is the location of my sqlite  database  file?
> 
> ------------------------------------------------------------------------------
> Gaining  the trust of online customers is vital for the success of any company
> that  requires sensitive data to be transmitted over the Web.   Learn how to 
> best implement a security strategy that keeps consumers' information secure 
> and instills the confidence they need to proceed with  transactions.
> http://p.sf.net/sfu/oracle-sfdevnl 
> _______________________________________________
> Cppcms-users mailing  list
> Cpp...@li...
> https://lists.sourceforge.net/lists/listinfo/cppcms-users
> 


      

Re: [Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Aris S. <ari...@gm...>]

> Keep in mind the blog is not officially released
> and still has some "raw" parts in it.
I knew it.
I plan to add an FTS search box in this blog.

I have create sqlite3 database in "db" directory, then I configure
config.txt manually. But it still raised the same error.
What kind of error "*Failed to access DBFailed to load backend*" is? how I
can find more detailed error message?

here are my config.txt configuration:

*##############
# SQL Engine #
##############

# dbi.debug=1
# dbi.engine="mysql"
dbi.engine="sqlite3"
# dbi.engine="pgsql"

# mysql.db="cppcms"
# mysql.user="root"
# mysql.pass="root"

sqlite3.db="sqloe.db"
sqlite3.dir="./db/"


# pgsql.db="cppcms"
# pgsql.user="artik"
*
Here are errors from my terminal:

*[root@masihmurah cms]# ./run_lighttpd
Failed to access DBFailed to load backend
2011-01-07 13:56:59: (log.c.166) server started
Press any key to exit
2011-01-07 13:57:08: (mod_fastcgi.c.1734) connect failed: Connection refused
on unix:/tmp/cppblog.socket
2011-01-07 13:57:08: (mod_fastcgi.c.3037) backend died; we'll disable it for
1 seconds and send the request to another backend instead: reconnects: 0
load: 1
2011-01-07 13:57:08: (mod_fastcgi.c.3608) all handlers for /blog? on /blog
are down.
2011-01-07 13:57:10: (mod_fastcgi.c.2864) fcgi-server re-enabled:
unix:/tmp/cppblog.socket *

Re: [Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Artyom <art...@ya...>]

>I knew it. 
>I plan to add an FTS search box in this blog.

One small point:

I'm going to convert (but most likely rewrite) the blog
to CppCMS 1.x.x at some point.

The blog's code is very bad and very old - it does not
even use session and forms support of CppCMS, it
also has some other **very** serious issues that I'm not going to
discuss on this list (if you want e-mail me privately)

So it should be almost rewritten and I probably going to do it
in a month or two - not decided when, as it is quite a lot of
work to do.

Regards,
  Artyom


      

Re: [Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Aris S. <ari...@gm...>]

I have found that I forget to install libdbi driver for sqlite3. After
install it, the following error occur:

[root@masihmurah cms]# ./run_lighttpd
/usr/local/lib/dbd/libdbdsqlite3.so: undefined symbol:
_dbi_internal_error_handler
libdbi: Failed to load driver: /usr/local/lib/dbd/libdbdsqlite3.so
2011-01-07 20:06:53: (log.c.166) server started
Press any key to exit
Failed to access DBFailed to load backend

please help..

Re: [Cppcms-users] cppcms blog, failed to access sqlite3 backend

[Aris S. <ari...@gm...>]

I already fix it :). My blog is running.
these problem were about:

   1. I must comment out openjaded related command from line 579 until 590.
   These lines are about creating sqlite3 documentation and I can skip these.
   2. Related to error *"/usr/local/lib/dbd/libdbdsqlite3.so: undefined
   symbol: _dbi_internal_error_handler"*, this is a bug from 0.8.3 version
   libdbi-driver. I upgraded it to 0.8.3-1. I found it here:
   http://www.mail-archive.com/lib...@li.../msg00135.html


On Sat, Jan 8, 2011 at 1:16 PM, Aris Setyawan <ari...@gm...> wrote:

> I have found that I forget to install libdbi driver for sqlite3. After
> install it, the following error occur:
>
>
> [root@masihmurah cms]# ./run_lighttpd
> /usr/local/lib/dbd/libdbdsqlite3.so: undefined symbol:
> _dbi_internal_error_handler
> libdbi: Failed to load driver: /usr/local/lib/dbd/libdbdsqlite3.so
> 2011-01-07 20:06:53: (log.c.166) server started
>
> Press any key to exit
> Failed to access DBFailed to load backend
>
> please help..
>