Email tickets

[scott]

I'm trying to setup cowtacular and I'm having a problem with the
backgroupprocess.php script. When run from the console I get the
following error

sfarrell@fog:/var/www/cowtacular/scripts$ php -f backgroundprocess.php
Starting background process...
db_query error! <br/>
Query: DELETE FROM AUTHCODES WHERE DATECREATED < 1259081427<br/>
PDO Error Code: HY000<br/>
Message: SQLSTATE[HY000]: General error: 8 attempt to write a readonly
database<br/>

I can create tickets from the web interface but I would really like to
use email. Here is the permissions on my database folder

sfarrell@fog:/var/www/cowtacular/scripts$ ls -lh /var/local/
cowtacular/
total 612K
-rwxrwxr-x 1 www-data www-data 211K 2009-11-24 10:33 archived.db
-rwxrwxr-x 1 www-data www-data 373K 2009-11-24 11:46 cowtacular.db
-rwxrwxr-x 1 www-data www-data 10K 2009-11-24 11:46 eventlog.db
-rwxrwxr-x 1 www-data www-data 2.0K 2009-11-24 10:33 filestore.db

Any help would be greatly appreciated.

[Chris VanHorn]

Hi Scott,

You can try a few things here.

The database files from your post indicate that only the www-data user
has read-write access. If you are running the backgroundprocess.php
file as a user other than www-data, that could be the source of this
problem. Also, sqlite needs the ability to create temporary files
within the database folder. So the folder itself must have read-write
access as well.

I would try

chmod -R 777 /var/local/cowtacular

That will set the cowtacular folder and it's contents read/writable by
everyone. If that solves your problem and you want to secure it a bit
better. You should add the users who would be accessing that data to
the www-data group (for example) and then chmod -R 770 /var/local/
cowtacular

Hope that helps.

- Chris