I have strange results with sqlite-2.8.15. For some unclear for me reason I can not write to database via the dbish or DBI (DBD::SQLite2). I guess I'm doing something wrong, but I have no idea what exactly...
In database directory I have: [EMAIL PROTECTED]:~$ ls -l /db/ total 964 drwxr-xr-x 3 root root 4096 2004-10-07 17:09 bld drwxrwxr-x 8 500 500 4096 2004-05-17 12:47 sqlite -rw------- 1 slava slava 963232 2004-10-07 16:56 sqlite-2.8.15.tar.gz -rwxrwxrwx 1 root root 6144 2004-10-11 16:42 test.db I can access, read and write /db/test.db using command line /db/bld/sqlite /db/test.db It makes me thinking that binary is fine, however, I doubt that sqlite was not moved to /usr/bin/ somewhere... Anyway, I can live with this since I need to access the database from my perl scripts mainly. I can access /db/test.db from dbish and is able to read, but can not write: [EMAIL PROTECTED]:~$ dbish dbi:SQLite2:/db/test.db DBI::Shell 11.93 using DBI 1.45 WARNING: The DBI::Shell interface and functionality are ======= very likely to change in subsequent versions! Connecting to 'dbi:SQLite2:/db/test.db' as ''... @dbi:SQLite2:/db/test.db> /table_info TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS,sqlite_sql undef,undef,'sqlite_master','SYSTEM TABLE',undef,undef undef,undef,'sqlite_temp_master','SYSTEM TABLE',undef,undef undef,undef,'Ident','TABLE',undef,'CREATE TABLE Ident (ID int unsigned auto_increment primary key, Ident text not null,LastUpdate timestamp )' undef,undef,'server_tbl','TABLE',undef,'create table server_tbl (id integer primary key, ip varchar(32), name varchar(255))' [4 rows of 6 fields returned] @dbi:SQLite2:/db/test.db> DROP TABLE server_tbl; DBD::SQLite2::st execute failed: unable to open database file(1) at dbdimp.c line 419. @dbi:SQLite2:/db/test.db> CREATE TABLE User (ID int unsigned auto_increment primary key, @dbi:SQLite2:/db/test.db> User text not null, @dbi:SQLite2:/db/test.db> LastUpdate timestamp @dbi:SQLite2:/db/test.db> ); DBD::SQLite2::st execute failed: unable to open database file(1) at dbdimp.c line 419. @dbi:SQLite2:/db/test.db> A similar thing happens when I try to use /db/test.db from my perl script: I can read, but I can not write... What is wrong? Can somebody suggest me what to look at (or where to read about the similar solution)? Thanks, Slava
