3 messages in com.mysql.lists.perlRead only error| From | Sent On | Attachments |
|---|---|---|
| Giff Hammar | 28 Feb 2005 07:19 | |
| Peter Pentchev | 28 Feb 2005 07:30 | |
| Giff Hammar | 28 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
Giff Hammar gham...@certifiedparts.com IT Director Certified Parts Warehouse V: 603.772.8870 F: 603.778.6931 http://www.certifiedparts.com




