[SOGo] using sogo-tool to insert AuxiliaryMailAccounts

2019-01-08 Thread "Daniel Carlos Silva"
 Hello,
I´m having some difficulty to use sogo-tool to set AuxiliaryMailAccounts. I 
always got a json parser error. Even using the json that sogo-tool outputed. Im 
likely familiar to sogo-tool, I use with success to set mail signature and 
sieve rules.
Ex.
sogo-tool user-preferences get defaults fulano-p .pwsieve AuxiliaryMailAccounts
output:
<0x0x15f21a0[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x15f21a0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
AuxiliaryMailAccounts: [{"receipts": {"receiptNonRecipientAction": "ignore", 
"receiptAction": "ignore", "receiptAnyAction": "ignore", 
"receiptOutsideDomainAction": "ignore"}, "encryption": "tls", "isNew": 1, 
"port": 993, "name": "ful...@myserver.com", "password": "X", 
"serverName": "imap.myserver.com", "userName": "fulano", "identities": 
[{"email": "ful...@myserver.com", "fullName": "ful...@myserver.com", 
"signature": "Atenciosamente, Fulano<\/\/strong \/>"}]}]
When I try to insert same json i get this error
sogo-tool user-preferences set defaults 01208801643 -p .pwsieve 
AuxiliaryMailAccounts [{"receipts": {"receiptNonRecipientAction": "ignore", 
"receiptAction": "ignore", "receiptAnyAction": "ignore", 
"receiptOutsideDomainAction": "ignore"}, "encryption": "tls", "isNew": 1, 
"port": 993, "name": "ful...@myserver.com", "password": "X", 
"serverName": "imap.myserver.com", "userName": "fulano", "identities": 
[{"email": "ful...@myserver.com", "fullName": "ful...@myserver.com", 
"signature": "Atenciosamente, Fulano<\/\/strong \/>"}]}]
<0x0x1ec2140[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x1ec2140[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
<0x0x1cf52e0[GSCBufferString]> json parser: Expected value while parsing array, 
attempting once more after unescaping...
<0x0x1cf52e0[GSCBufferString]> total failure. Original string is: [{receipts:
2019-01-08 20:55:16.175 sogo-tool[12828:12828] Invalid JSON input - no changes 
performed in the database. The supplied value was: [{receipts:Can someone help 
me? Is there any trick?
--
​Daniel Carlos Silva
 


Analista
GSR – Gerência de Serviços de Rede
Tel.: (31) 3339-1287
Companhia de Tecnologia da Informação do Estado de Minas Gerais – PRODEMGE
 
Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é 
dirigida, podendo conter informação sigilosa e legalmente protegida. O uso 
impróprio será tratado conforme as normas da empresa e a legislação em vigor. 
Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a 
utilização, divulgação, cópia e distribuição 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Configuring Preferences/Administering SOGo

2019-01-08 Thread Odhiambo Washington
On Tue, 8 Jan 2019 at 16:14, Christian Mack  wrote:

> Am 04.01.19 um 12:10 schrieb Odhiambo Washington (odhia...@gmail.com):
> > On Thu, 3 Jan 2019 at 23:28, Christian Mack  wrote:
> < ... >
> >>
> >>> I am also trying to understand how to correctly use the
> SOGOLoginDomains
> >>> parameter within domains config block. I have 4 domains, so I wonder
> how
> >> to
> >>> use this to give me a dropdown of the domains.
> >>>
> >>
> >> I don't use that, but according to the "SOGo - Installation and
> >> Configuration Guide" you have to set SOGoLoginDomains to an array of
> >> keys from your domains configuration.
> >> With "keys" they really mean the name of domains given (e.g. acme.com
> >> from "acme.com = {")
> >>
> >> For the example configuration that would be:
> >> SOGoLoginDomains = ("acme.com", "coyote.com");
> >>
> >>
> >>
> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_multi_domains_configuration
> >
> >
> > I have done exactly that. However, the moment I enable the
> > SOGoLoginDomains, I cannot login as authentication fails:
> >
> > Jan 04 05:05:36 sogod [81552]: SOGoRootPage Login from '41.215.134.216'
> for
> > user 'ictsupport' might not have worked - password policy: 65535  grace:
> > -1  expire: -1  bound: 0
> >
> > Without it, I am able to login with username@domain successfully.
> > My domain names are quite long for typing, hence my need to select from a
> > dropdown list.
> >
>
> You said you use a mysql database as SOGoUserSources.
>

Yes.


> I assume your c_uid field contains the complete email address.
>

Correct.


> SOGo does query for a username without "@domain" part.
>

Noted. That is why it's failing then...


> Do you have an username field used in LoginFieldNames without @domain part?
>

No.
I created a VIEW of the users table for SOGo to use. Now, unless there is a
way to create the VIEW in a way that creates that field:
I created the VIEW as follows:

CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid,
username AS c_name, crypt AS c_password, realname AS c_cn, username AS
mail, realname AS displayName FROM users WHERE enabled='1';

I suppose there is a way? (I am a noob with SQL).
My authentication system query expects a complete email address as username
though.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Print mail with more than 1 page with firefox

2019-01-08 Thread cedric.archamb...@solidairesfinancespubliques.org

Hi there,

We've got a problem we can't reproduce Sogo demo, whereas we're on 4.0.4 
: We can't print mail with more than 1 page, the second one is blank.


It's the same (old and solved) problem than exposed here : 
https://sogo.nu/bugs/view.php?id=3731


Does anyone have any idea?

Thanks

--
Cedric
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Configuring Preferences/Administering SOGo

2019-01-08 Thread Christian Mack
Am 04.01.19 um 12:10 schrieb Odhiambo Washington (odhia...@gmail.com):
> On Thu, 3 Jan 2019 at 23:28, Christian Mack  wrote:
< ... >
>>
>>> I am also trying to understand how to correctly use the SOGOLoginDomains
>>> parameter within domains config block. I have 4 domains, so I wonder how
>> to
>>> use this to give me a dropdown of the domains.
>>>
>>
>> I don't use that, but according to the "SOGo - Installation and
>> Configuration Guide" you have to set SOGoLoginDomains to an array of
>> keys from your domains configuration.
>> With "keys" they really mean the name of domains given (e.g. acme.com
>> from "acme.com = {")
>>
>> For the example configuration that would be:
>> SOGoLoginDomains = ("acme.com", "coyote.com");
>>
>>
>> https://sogo.nu/files/docs/SOGoInstallationGuide.html#_multi_domains_configuration
> 
> 
> I have done exactly that. However, the moment I enable the
> SOGoLoginDomains, I cannot login as authentication fails:
> 
> Jan 04 05:05:36 sogod [81552]: SOGoRootPage Login from '41.215.134.216' for
> user 'ictsupport' might not have worked - password policy: 65535  grace:
> -1  expire: -1  bound: 0
> 
> Without it, I am able to login with username@domain successfully.
> My domain names are quite long for typing, hence my need to select from a
> dropdown list.
> 

You said you use a mysql database as SOGoUserSources.
I assume your c_uid field contains the complete email address.
SOGo does query for a username without "@domain" part.
Do you have an username field used in LoginFieldNames without @domain part?


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] Missing Administration button

2019-01-08 Thread Christian Mack
Am 04.01.19 um 12:29 schrieb Odhiambo Washington (odhia...@gmail.com):
> Running two identical instances of SOGo, one on Ubuntu 18.04 and the other
> on FreeBSD 11.2.
> The configuration files are exactly the same.
> On the Ubuntu instance, when I login with an admin account, the
> "Administration" is missing!
> Anyone knows what is the cause?
> 
> 

Did you restart sogo and memcached on Ubuntu after setting SOGoSuperUser?
A reload of sogo is not sufficient!


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature