On Jun 23, 2008, at 10:53 PM, German Escallon wrote:
> Hello all,
>
>
>
> I am having issues when opening the sqlite db. Here's a snippet of
> my code..
Unix permissions on the database file? Is the cgi script running
as a different user than the one that successfully opened the database
using the shell tool?
Dan.
>
>
>
>
> #include "sqlite3.h"
>
> Int main(){
>
> sqlite3 *db;
>
>
>
> if (sqlite3_open("/full/path/to/mysqlite.db", &db) != SQLITE_OK)
>
> {
>
> fprintf(stderr, "MyError found: %s\n", sqlite3_errmsg(db));
>
> sqlite3_close(db);
>
> exit(1);
>
> }
>
>
>
> ..
>
> ..
>
> //rest of my code..
>
> ..
>
> ..
>
>
>
> }
>
>
>
>
>
>
>
> The code above produces an error and displays the following message
> in my
> system log.
>
>
>
> Jun 23 11:32:16 signEdje-F013B1C httpd[9062]: [error] [client
> ip.address.00.000] MyError found: unable to open database file,
> referer:
> http://host.ip.address/mypage.html
>
>
>
>
>
>
>
> I have checked that my path is correct by using the command line which
> properly opens the db file.
>
>
>
> $>sqlite3 /full/path/to/mysqlite.db
>
>
>
>
>
> I restarted my system a couple of days ago, and that may have
> triggered this
> error, because it was working properly before that. Any ideas?
>
>
>
> Thank you in advance for any help you can provide. Let me know if
> more info
> is needed.
>
>
>
>
>
>
>
> German Escallon
>
>
>
>
>
>
>
>
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
