[SOGo] using sogo-tool to insert AuxiliaryMailAccounts
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
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
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
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
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