[Bacula-users] Bacula problem with Sqlite
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
Thanks
--
Giancarlo Rubio
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is bacula-director
configured to run with regard to user group? I'll bet it is not the same as
the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26 /var/db/bacula/bacula.db
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is bacula-director
configured to run with regard to user group? I'll bet it is not the same as
the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Giancarlo Rubio
(041) 9192-5042
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep
bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26 /var/db/bacula/bacula.db
What are the permissions ownership of the directories along the path to
bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an
error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is bacula-director
configured to run with regard to user group? I'll bet it is not the
same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep
bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26 /var/db/bacula/bacula.db
What are the permissions ownership of the directories along the path to
bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get an
error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal error:
sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is bacula-director
configured to run with regard to user group? I'll bet it is not the
same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Giancarlo Rubio
(041) 9192-5042
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to run as
root:root. If it works then you know it's a permissions/ownerwhip problem
somewhere. If not, then we're on the wrong track and need to take a closer
look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep
bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the path to
bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get
an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user group? I'll
bet it is not the same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula problem with Sqlite
Running as root bacula works good.
It's a bug on bacula??
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to run as
root:root. If it works then you know it's a permissions/ownerwhip problem
somewhere. If not, then we're on the wrong track and need to take a closer
look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep
bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the path to
bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get
an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user group? I'll
bet it is not the same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Giancarlo Rubio
(041) 9192-5042
Re: [Bacula-users] Bacula problem with Sqlite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Giancarlo Rubio wrote:
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to run as
root:root. If it works then you know it's a permissions/ownerwhip problem
somewhere. If not, then we're on the wrong track and need to take a closer
look at bacula.db.
Running as root bacula works good.
It's a bug on bacula??
Things working as root and not working as other users can almost never
be bugs in Bacula. It's probably best not to suggest that it's a bug at
the drop of a hat, as it tends to piss off developers and others from
whom you might want help. :)
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01 grep
bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the path to
bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i get
an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write a
readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but no
solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user group? I'll
bet it is not the same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
- --
_ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III
|$| |__| | | |__/ | \| _| |[EMAIL
Re: [Bacula-users] Bacula problem with Sqlite
On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
Running as root bacula works good.
It's a bug on bacula??
No, it means that user/group bacula:bacula can not
access /var/db/bacula/bacula.db but user/group root:root can. So, as I said
earlier, you have a permissions problem somewhere along the path.
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to run
as root:root. If it works then you know it's a permissions/ownerwhip
problem somewhere. If not, then we're on the wrong track and need to take
a closer look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01
grep bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the
path to bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i
get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write
a readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but
no solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user group?
I'll bet it is not the same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
Re: [Bacula-users] Bacula problem with Sqlite
It's not permission problem for the user bacula see
# su - bacula
$ echo teste /var/db/bacula/bacula.test (user have write
permission on this folder)
$ sqlite3 /var/db/bacula/bacula.db
SQLite version 3.3.15
Enter .help for instructions
sqlite INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
09:11:42',1176898302);
sqlite select * from Job;
1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
sqlite .quit
User have write permission on bacula.db
Giancarlo Rubio
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
Running as root bacula works good.
It's a bug on bacula??
No, it means that user/group bacula:bacula can not
access /var/db/bacula/bacula.db but user/group root:root can. So, as I said
earlier, you have a permissions problem somewhere along the path.
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to run
as root:root. If it works then you know it's a permissions/ownerwhip
problem somewhere. If not, then we're on the wrong track and need to take
a closer look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-dir -u bacula -g bacula -v -c /usr/
root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM 0:00.03
/usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/loca
bacula49009 0.0 0.9 4248 2048 ?? Ss 11:26AM 0:00.04
/usr/local/sbin/bacula-sd -u bacula -g bacula -v -c /usr/l
root 49024 0.0 0.4 1592 900 p1 S+ 11:27AM 0:00.01
grep bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the
path to bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run job i
get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Fatal
error: sql_create.c:520 sql_create.c:520 insert INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14 Error:
sql_create.c:522 Create DB Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed. ERR=attempt to write
a readonly database
The owner of bacula.db is bacula user, and have write and read
permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) , but
no solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula on
FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to run with regard to user group?
I'll bet it is not the same as the owner/group of bacula.db.
Cheers!
cmr
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Debian 'Etch' - Registered Linux User #241964
More laws, less justice. -- Marcus Tullius Ciceroca, 42 BC
Re: [Bacula-users] Bacula problem with Sqlite
On Wednesday 18 April 2007 11:34, Giancarlo Rubio wrote:
It's not permission problem for the user bacula see
# su - bacula
$ echo teste /var/db/bacula/bacula.test (user have write
permission on this folder)
$ sqlite3 /var/db/bacula/bacula.db
SQLite version 3.3.15
Enter .help for instructions
sqlite INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
09:11:42',1176898302);
sqlite select * from Job;
1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
sqlite .quit
User have write permission on bacula.db
Giancarlo Rubio
This makes a very good argument that it is _not_ a permission problem, but on
the other hand, it is very unlikely to be a bug in bacula. (Since I am not
running FreeBSD anything I say at this point is a guess.) This certainly
looks similar to the problem report that you indicated at the beginning of
this thread and could be some kind of weird problem owing to a combination of
FreeBSD, Sqlite3 Bacula.
To the best of my knowledge there is no built-in database security in Sqlite.
If you have write permission on the file you have write permission on the
database.
Let's make one more test before we shout bug. Please set the permissions on
bacula.db to 666 (read/write for all) and see what happens.
And, while we're at it. What version of Bacula and FreeBSD are you using? Is
Bacula from a package or did you roll your own?
Cheers!
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
Running as root bacula works good.
It's a bug on bacula??
No, it means that user/group bacula:bacula can not
access /var/db/bacula/bacula.db but user/group root:root can. So, as I
said earlier, you have a permissions problem somewhere along the path.
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to
run as root:root. If it works then you know it's a
permissions/ownerwhip problem somewhere. If not, then we're on the
wrong track and need to take a closer look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM
0:00.03 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c
/usr/ root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM
0:00.03 /usr/local/sbin/bacula-fd -u root -g wheel -v -c
/usr/loca bacula49009 0.0 0.9 4248 2048 ?? Ss
11:26AM 0:00.04 /usr/local/sbin/bacula-sd -u bacula -g bacula
-v -c /usr/l root 49024 0.0 0.4 1592 900 p1 S+
11:27AM 0:00.01 grep bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the
path to bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run
job i get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
Fatal error: sql_create.c:520 sql_create.c:520 insert
INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
VALUES ('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
Error: sql_create.c:522 Create DB Client record INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
VALUES ('gian-fd','',1,2592000,15552000) failed.
ERR=attempt to write a readonly database
The owner of bacula.db is bacula user, and have write and
read permission.
I found a similar user report about this problem
(http://permalink.gmane.org/gmane.comp.bacula.user/15367) ,
but no solution at this moment.
Is a FreeBSD problem on sqlite?? Have anyone running bacula
on FreeBSD?
Thanks
Almost certainly a user or permissions problem. How is
bacula-director configured to
Re: [Bacula-users] Bacula problem with Sqlite
its' a problem when creating tables
/usr/local/share/bacula/make_sqlite3_tables
When create table the permission are set to user root and group bacula
ls -ll
-rw-r- 1 rootbacula 49152 Apr 18 15:20 bacula.db
I have changed tto user bacula and group bacula and restarted bacula director.
I prepare to submit a bug report to this port to freebsd
Thank's all for atention
Giancarlo Rubio
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 11:34, Giancarlo Rubio wrote:
It's not permission problem for the user bacula see
# su - bacula
$ echo teste /var/db/bacula/bacula.test (user have write
permission on this folder)
$ sqlite3 /var/db/bacula/bacula.db
SQLite version 3.3.15
Enter .help for instructions
sqlite INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('gian.2007-04-18_09.11.45','gian','B','I','C','2007-04-18
09:11:42',1176898302);
sqlite select * from Job;
1|gian.2007-04-18_09.11.45|gian|B|I|0|C|2007-04-18
09:11:42|0|0|0|1176898302|0|0|0|0|0|0|0|0|0|0|0
sqlite .quit
User have write permission on bacula.db
Giancarlo Rubio
This makes a very good argument that it is _not_ a permission problem, but on
the other hand, it is very unlikely to be a bug in bacula. (Since I am not
running FreeBSD anything I say at this point is a guess.) This certainly
looks similar to the problem report that you indicated at the beginning of
this thread and could be some kind of weird problem owing to a combination of
FreeBSD, Sqlite3 Bacula.
To the best of my knowledge there is no built-in database security in Sqlite.
If you have write permission on the file you have write permission on the
database.
Let's make one more test before we shout bug. Please set the permissions on
bacula.db to 666 (read/write for all) and see what happens.
And, while we're at it. What version of Bacula and FreeBSD are you using? Is
Bacula from a package or did you roll your own?
Cheers!
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 11:02, Giancarlo Rubio wrote:
Running as root bacula works good.
It's a bug on bacula??
No, it means that user/group bacula:bacula can not
access /var/db/bacula/bacula.db but user/group root:root can. So, as I
said earlier, you have a permissions problem somewhere along the path.
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:57, Giancarlo Rubio wrote:
# ls -ll /var/db/|grep bacula
drwxr-xr-x2 baculabacula512 Apr 18 11:26 bacula
What are the permissions of /var/db and /var?
Also, just as an experiment, you might reconfigure bacula-director to
run as root:root. If it works then you know it's a
permissions/ownerwhip problem somewhere. If not, then we're on the
wrong track and need to take a closer look at bacula.db.
HTH
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 09:27, Giancarlo Rubio wrote:
See
# ps axu|grep bacula
bacula48990 0.0 1.2 4732 2600 ?? Ss 11:26AM
0:00.03 /usr/local/sbin/bacula-dir -u bacula -g bacula -v -c
/usr/ root 48998 0.0 0.9 3952 1952 ?? Ss 11:26AM
0:00.03 /usr/local/sbin/bacula-fd -u root -g wheel -v -c
/usr/loca bacula49009 0.0 0.9 4248 2048 ?? Ss
11:26AM 0:00.04 /usr/local/sbin/bacula-sd -u bacula -g bacula
-v -c /usr/l root 49024 0.0 0.4 1592 900 p1 S+
11:27AM 0:00.01 grep bacula
# ls -l /var/db/bacula/bacula.db
-rw-r--r-- 1 bacula bacula 49152 Apr 18 11:26
/var/db/bacula/bacula.db
What are the permissions ownership of the directories along the
path to bacula.db (var, db, bacula)?
cmr
2007/4/18, C M Reinehr [EMAIL PROTECTED]:
On Wednesday 18 April 2007 06:49, Giancarlo Rubio wrote:
Hi all,
I have instaled Bacula on Freebsd 6.2. When i try to run
job i get an error
Job failed.
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
Fatal error: sql_create.c:520 sql_create.c:520 insert
INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('gian-fd','',1,2592000,15552000) failed:
attempt to write a readonly database
18-Apr 08:42 aerofirewall-dir: sql_create.c:520 INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
VALUES ('gian-fd','',1,2592000,15552000)
18-Apr 08:42 aerofirewall-dir: gian.2007-04-18_08.42.14
Error: sql_create.c:522 Create DB Client record INSERT INTO
Client (Name,Uname,AutoPrune,FileRetention,JobRetention)
VALUES ('gian-fd','',1,2592000,15552000) failed.
ERR=attempt to write
