Hail,
I use roundcube for a mail server that I use alone, so I chose sqlite as db. The last time I got to make it run, but now this is not true anymore :(
I used the initial sqlite command:
sqlite3 -init SQL/sqlite.initial.sql config/sqlite_db
and then I get write errors for the roundcube install/index.php test:
DSN (write): OK DB Schema: OK DB Write: NOT OK([14] unable to open database file (SQL Query: INSERT INTO "session" ("sess_id", "created", "ip", "vars") VALUES ('6ec44d990f8e706a6a7c1b1e344e6f90', datetime('now'), '127.0.0.1', 'foo'))) DB Time: OK
I tried to fiddle with the sqlite db file, to the point I got the "initialize db" on the install script. I click on it, and I get also an error.
Is sqlite supposed to work ? Am I doing anything wrong ?
I looked for sqlite install instructions, but all I get is http://trac.roundcube.net/browser/github/INSTALL?rev=c4a2264ae7a4f333116a558...
and I do as said there. I installed sqlite2, no good also. I get
DB Schema: NOT OK(Error creating database schema: [26] file is encrypted or is not a database (SQL Query: CREATE TABLE contacts ( contact_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL, changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', email text NOT NULL default '', firstname varchar(128) NOT NULL default '', surname varchar(128) NOT NULL default '', vcard text NOT NULL default '', words text NOT NULL default '' )))
when I use sqlite version 2 to initialize.
I use FreeBSD 10.
Is there a guide for it ?
thanks,
matheus
Hi,
Did I send the message to the wrong list? If so, please let me know :)
Thanks,
Matheus
On July 10, 2015 4:37:21 PM GMT-03:00, Nenhum_de_Nos matheus@arroway.org wrote:
Hail,
I use roundcube for a mail server that I use alone, so I chose sqlite as db. The last time I got to make it run, but now this is not true anymore :(
I used the initial sqlite command:
sqlite3 -init SQL/sqlite.initial.sql config/sqlite_db
and then I get write errors for the roundcube install/index.php test:
DSN (write): OK DB Schema: OK DB Write: NOT OK([14] unable to open database file (SQL Query: INSERT INTO "session" ("sess_id", "created", "ip", "vars") VALUES ('6ec44d990f8e706a6a7c1b1e344e6f90', datetime('now'), '127.0.0.1', 'foo'))) DB Time: OK
I tried to fiddle with the sqlite db file, to the point I got the "initialize db" on the install script. I click on it, and I get also an error.
Is sqlite supposed to work ? Am I doing anything wrong ?
I looked for sqlite install instructions, but all I get is http://trac.roundcube.net/browser/github/INSTALL?rev=c4a2264ae7a4f333116a558...
and I do as said there. I installed sqlite2, no good also. I get
DB Schema: NOT OK(Error creating database schema: [26] file is encrypted or is not a database (SQL Query: CREATE TABLE contacts ( contact_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL, changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', email text NOT NULL default '', firstname varchar(128) NOT NULL default '', surname varchar(128) NOT NULL default '', vcard text NOT NULL default '', words text NOT NULL default '' )))
when I use sqlite version 2 to initialize.
I use FreeBSD 10.
Is there a guide for it ?
thanks,
matheus
-- "We will call you Cygnus, the God of balance you shall be."
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
I dont use sqlite so cant help, but, as to your slight impatience, bare in mind you send this at 5am on a Saturday morning my time, which means late friday night in Europe, and likely close to end of shift of friday for those in the U.S. IOW, its the weekend, so dont expect instant responses, and, since very few of us would be using sqlite, you'll have to learn to be far more patient in waiting than if you used mysql etc which most of us use.
On 12/07/2015 03:35, Nenhum_de_Nos wrote:
Hi,
Did I send the message to the wrong list? If so, please let me know :)
Thanks,
Matheus
On July 10, 2015 4:37:21 PM GMT-03:00, Nenhum_de_Nos matheus@arroway.org wrote:
Hail,
I use roundcube for a mail server that I use alone, so I chose sqlite as db. The last time I got to make it run, but now this is not true anymore :(
I used the initial sqlite command:
sqlite3 -init SQL/sqlite.initial.sql config/sqlite_db
and then I get write errors for the roundcube install/index.php test:
DSN (write): OK DB Schema: OK DB Write: NOT OK([14] unable to open database file (SQL Query: INSERT INTO "session" ("sess_id", "created", "ip", "vars") VALUES ('6ec44d990f8e706a6a7c1b1e344e6f90', datetime('now'), '127.0.0.1 [1]', 'foo'))) DB Time: OK
I tried to fiddle with the sqlite db file, to the point I got the "initialize db" on the install script. I click on it, and I get also an error.
Is sqlite supposed to work ? Am I doing anything wrong ?
I looked for sqlite install instructions, but all I get is http://trac.roundcube.net/browser/github/INSTALL?rev=c4a2264ae7a4f333116a558... [2]
and I do as said there. I installed sqlite2, no good also. I get
DB Schema: NOT OK(Error creating database schema: [26] file is encrypted or is not a database (SQL Query: CREATE TABLE contacts ( contact_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL, changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', email text NOT NULL default '', firstname varchar(128) NOT NULL default '', surname varchar(128) NOT NULL default '', vcard text NOT NULL default '', words text NOT NULL default '' )))
when I use sqlite version 2 to initialize.
I use FreeBSD 10.
Is there a guide for it ?
thanks,
matheus
-- "We will call you Cygnus, the God of balance you shall be."
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users [3]
[1] http://127.0.0.1 [2] http://trac.roundcube.net/browser/github/INSTALL?rev=c4a2264ae7a4f333116a558... [3] http://lists.roundcube.net/mailman/listinfo/users