3 messages in com.mysql.lists.perlRead only error
FromSent OnAttachments
Giff Hammar28 Feb 2005 07:19 
Peter Pentchev28 Feb 2005 07:30 
Giff Hammar28 Feb 2005 09:03 
Subject:Read only error
From:Giff Hammar (gham@certifiedparts.com)
Date:02/28/2005 07:19:51 AM
List:com.mysql.lists.perl

I know this should be easy, but I'm stumped.

I inherited a system that uses perl and mysql to read in a set of e-mails and process them. The system is running on Debian and was copied from a different Debian system. When I try to run the perl script to import an e-mail, I get

DBD::mysql::db do failed: Table 'table_name' is read only at ./parts.pl line 435. DBD::mysql::db do failed: Table 'table_name' is read only at /home/inv/sparts.pm line 140. Can't lock tables: Table 'table_name' is read only

I get the same error when I run the script as root or the user 'inv'. So far, I have:

1. Changed ownership of all of the database files to inv 2. Opened the database file permissions to 777 3. Changed the user table in mysql to allow inv full access to all privs 4. Changed the host table in mysql to allow the local host full access to the database

What did I miss?

Giff