Displaying 5 results from an estimated 5 matches for "email_users".
Did you mean:
mail_users
2023 Feb 19
2
Redundant Database, Pgsql ?
...rrent have this in the dovecot-pgsql.conf
______________________________________________________________________
driver = pgsql
connect = host=localhost port=5433 dbname=scom_billing user=pgsql
password=xxxxxxxxx
default_pass_scheme = PLAIN
password_query = SELECT username as user, password FROM email_users
WHERE username = '%u' and password <> 'alias' and status = True and
destination = '%u'
user_query = SELECT home, uid, gid FROM email_users WHERE username =
'%u' and password <> 'alias' and status = True and destination = '%u'
#iterate...
2023 Jan 06
1
replicator: Panic: data stack: Out of memory when allocating 268435496 bytes
...nts.ca
> }
>
> pg sql support supporting replication
>
> # cat dovecot-pgsql.conf
> driver = pgsql
> connect = host=localhost port=5433 dbname=scom_billing user=pgsql password=
> default_pass_scheme = PLAIN
>
> password_query = SELECT username as user, password FROM email_users WHERE username = '%u' and password <> 'alias' and status = True and destination = '%u'
>
> user_query = SELECT home, uid, gid FROM email_users WHERE username = '%u' and password <> 'alias' and status = True and destination = '%u'
&g...
2023 Jan 07
1
replicator: Panic: data stack: Out of memory when allocating 268435496 bytes
...ort supporting replication
>>
>> # cat dovecot-pgsql.conf
>> driver = pgsql
>> connect = host=localhost port=5433 dbname=scom_billing user=pgsql
>> password=
>> default_pass_scheme = PLAIN
>>
>> password_query = SELECT username as user, password FROM email_users
>> WHERE username = '%u' and password <> 'alias' and status = True and
>> destination = '%u'
>>
>> user_query = SELECT home, uid, gid FROM email_users WHERE username =
>> '%u' and password <> 'alias' and status = T...
2023 Jan 06
2
replicator: Panic: data stack: Out of memory when allocating 268435496 bytes
One step further in my quest to create a replacement mail server.
I now have my old mail server (2.3.19.1, macOS + MacPorts) and my new (2.3.20, Alpine Linux, Docker, apk package). When I turn on replication it works, but, after a while I see:
Jan 06 00:50:31 replicator: Panic: data stack: Out of memory when allocating 268435496 bytes
Jan 06 00:50:32 replicator: Fatal: master:
2004 Dec 29
0
dovecot_auth / pam_mysql login errors
...29 12:22:10 websrv dovecot-auth: db_connect called.
Dec 29 12:22:10 websrv dovecot-auth: returning 0 .
Dec 29 12:22:10 websrv dovecot-auth: db_checkpasswd called.
Dec 29 12:22:10 websrv dovecot-auth: pam_mysql: where clause =
Dec 29 12:22:10 websrv dovecot-auth: SELECT password FROM email_users
WHERE log in='myname'
Dec 29 12:22:10 websrv dovecot-auth: sqlLog called.
Dec 29 12:22:10 websrv dovecot-auth: returning 0 .
Dec 29 12:22:10 websrv dovecot-auth: returning 0.
## And then:
Dec 29 12:22:10 websrv dovecot-auth: pam_mysql: setcred called but not implemen...