Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

SqlException

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


natarajsn at gmail

Jul 29, 2013, 8:38 AM

Post #1 of 4 (67 views)
Permalink
SqlException

Hi

On dbmail 3.1.1-1.

dburi = sqlite:///home/nataraj/dbmail.db

Jul 29 20:23:01 localhost dbmail-pop3d[381]: [0x15daa30]
Critical:[libzdb] TabortHandler(+43): SQLException: cannot rollback -
no transaction is active
raised in Connection_rollback at src/db/Connection.c:279

Loosing time on this.

Am I missing something?

regards

Nataraj
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


paul at nfg

Jul 29, 2013, 9:26 AM

Post #2 of 4 (65 views)
Permalink
Re: SqlException [In reply to]

On 07/29/2013 05:38 PM, Nataraj S Narayan wrote:
> Hi
>
> On dbmail 3.1.1-1.
>
> dburi = sqlite:///home/nataraj/dbmail.db
>
> Jul 29 20:23:01 localhost dbmail-pop3d[381]: [0x15daa30]
> Critical:[libzdb] TabortHandler(+43): SQLException: cannot rollback -
> no transaction is active
> raised in Connection_rollback at src/db/Connection.c:279


Can you please provide more log lines? No way to tell from this when and
where it happens.

> Loosing time on this.

That sounds rather impatient.


--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin

* Premium Hosting Services and Web Application Consultancy *

www.nfg.nl/info [at] nfg/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail


natarajsn at gmail

Aug 2, 2013, 2:49 AM

Post #3 of 4 (40 views)
Permalink
Re: SqlException [In reply to]

Hi Paul

Please give me the owners and permissions of these needed by dbmail:-

'/var/tmp/dbmail.db'
'/var/run/dbmail-lmtpd.pid'

I use postfix MTA.

My dbmail.conf:-

[DBMAIL]
dburi = sqlite:///var/tmp/dbmail.db
authdriver = sql
table_prefix = dbmail_
encoding = utf8
default_msg_encoding = utf8
sendmail = /usr/sbin/sendmail
file_logging_levels = 7
syslog_logging_levels = 31
query_time_info = 10
query_time_notice = 20
query_time_warning = 30
query_timeout = 300
effective_user = nobody
effective_group = nogroup
bindip = 0.0.0.0 # IPv4 only - all IP's
timeout = 300
login_timeout = 60
resolve_ip = no
authlog = no
logfile = /var/log/dbmail.log
errorlog = /var/log/dbmail.err
pid_directory = /var/run
tls_cafile =
tls_cert =
tls_key =
tls_ciphers =
[LMTP]
port = 24
[POP]
port = 110
pop_before_smtp = no
[HTTP]
port = 41380
bindip = 127.0.0.1
admin = admin:secret
[IMAP]
port = 143
timeout = 4000
imap_before_smtp = no
[SIEVE]
port = 2000
tls_port =
[LDAP]
port = 389
version = 3
hostname = ldap
base_dn = ou=People,dc=mydomain,dc=com
bind_dn =
bind_pw =
scope = SubTree
referrals = yes
user_objectclass = top,account,dbmailUser
forw_objectclass = top,account,dbmailForwardingAddress
cn_string = uid
field_passwd = userPassword
field_uid = uid
field_nid = uidNumber
min_nid = 10000
max_nid = 15000
field_cid = gidNumber
min_cid = 10000
max_cid = 15000
field_mail = mail
field_quota = mailQuota
field_fwdtarget = mailForwardingAddress
[DELIVERY]
SIEVE = yes
SUBADDRESS = yes
SIEVE_VACATION = yes
SIEVE_NOTIFY = yes
SIEVE_DEBUG = no
AUTO_NOTIFY = no
AUTO_REPLY = no
suppress_duplicates = no
quota_failure = hard


regards

Nataraj

On Mon, Jul 29, 2013 at 9:56 PM, Paul J Stevens <paul [at] nfg> wrote:

> On 07/29/2013 05:38 PM, Nataraj S Narayan wrote:
> > Hi
> >
> > On dbmail 3.1.1-1.
> >
> > dburi = sqlite:///home/nataraj/dbmail.db
> >
> > Jul 29 20:23:01 localhost dbmail-pop3d[381]: [0x15daa30]
> > Critical:[libzdb] TabortHandler(+43): SQLException: cannot rollback -
> > no transaction is active
> > raised in Connection_rollback at src/db/Connection.c:279
>
>
> Can you please provide more log lines? No way to tell from this when and
> where it happens.
>
> > Loosing time on this.
>
> That sounds rather impatient.
>
>
> --
> ________________________________________________________________
> Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
>
> * Premium Hosting Services and Web Application Consultancy *
>
> www.nfg.nl/info [at] nfg/+31.85.877.99.97
> ________________________________________________________________
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>


h.reindl at thelounge

Aug 2, 2013, 2:59 AM

Post #4 of 4 (40 views)
Permalink
Re: SqlException [In reply to]

Am 02.08.2013 11:49, schrieb Nataraj S Narayan:
> Please give me the owners and permissions of these needed by dbmail:-
> '/var/tmp/dbmail.db'

i would never place a database in /var/tmp because it is *no* temporary
data and tmpwatch or whatever cleanup could become your enemy from one
day to another

> '/var/run/dbmail-lmtpd.pid'

the ones you configured as "effective_user" and "effective_group"
they are created at start and deleted at stop from the daemons
so you can not set the permissions of the file itself

most likely the problem is "/var/run/dbmail-lmtpd.pid" instead
of "/var/run/dbmail/dbmail-lmtpd.pid" and so the owner of the folder
would be the user dbmail is running with

and no, the parent /var/run should not be writeable for everybody
dbmail.conf: "pid_directory = /var/run/dbmail"

[root [at] srv-rhsof:~]$ stat /var/run/dbmail/
File: '/var/run/dbmail/'
Size: 100 Blocks: 0 IO Block: 4096 directory
Device: 10h/16d Inode: 15469 Links: 2
Access: (0755/drwxr-xr-x) Uid: ( 496/ dbmail) Gid: ( 494/ dbmail)
Access: 2013-08-02 09:11:20.249940617 +0200
Modify: 2013-08-02 09:11:30.300814964 +0200
Change: 2013-08-02 09:11:30.300814964 +0200
Birth: -

[root [at] srv-rhsof:~]$ ls /var/run/dbmail/
total 12K
-rw-r--r-- 1 dbmail dbmail 5 2013-08-02 09:11 dbmail-imapd.pid
-rw-r--r-- 1 dbmail dbmail 5 2013-08-02 09:11 dbmail-lmtpd.pid
-rw-r--r-- 1 dbmail dbmail 5 2013-08-02 09:11 dbmail-timsieved.pid

> My dbmail.conf:-
>
> [DBMAIL]
> dburi = sqlite:///var/tmp/dbmail.db
> authdriver = sql
> table_prefix = dbmail_
> encoding = utf8
> default_msg_encoding = utf8
> sendmail = /usr/sbin/sendmail
> file_logging_levels = 7
> syslog_logging_levels = 31
> query_time_info = 10
> query_time_notice = 20
> query_time_warning = 30
> query_timeout = 300
> effective_user = nobody
> effective_group = nogroup
> pid_directory = /var/run
Attachments: signature.asc (0.26 KB)

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.