[SOGo] Database connection error `got no value for column: attribute=c_path2`
With the dropping of SOGo1 I recently moved to SOGo 5. I created a container image using Centos Stream 8 and got it all working about three weeks ago using LDAP for auth and mariadb for the database. I used sogo-tool to export the data from the old db into a fresh one. However 4 days ago I suddenly lost the ability to connect to the DAV data for all users, and in the logs I'm getting 2023-06-12 10:16:34.573 sogo-tool[345:345] ERROR(-[NSNumber(MySQL4Values) initWithMySQL4Field:value:length:]): unsupported MySQL type: 0 (len=4) 2023-06-12 10:16:34.573 sogo-tool[345:345] ERROR(-[MySQL4Channel primaryFetchAttributes:withZone:]): connection=0x0x274e6b0>: got no value for column: attribute=c_path2 valueClass=NSNumber type=DECIMAL Sometimes the attribute is c_path, c_path2 or c_path4 Any attempt to use sogo-tool checkup or backup also just shows this message. Can someone help me work out how to fix it? Leon
Re: [SOGo] LDAP email alias mangle
Thanks for the reply Simon A quick rundown of the topology. I have a machine called gateway set up with SOGo on it using postfix as the MDA / MTA. Mutt is on the same machine mainly for testing so I can be sure they are both using the localhost service. Evolution is also set up to use the gateway as the smtp server. I feel reasonably confident that it's not an issue with the smtp server, but rather the interaction between SOGo and the LDAP server. I had it configured in a similar way with SOGo 1.3 and ClearOS 5.2, although the clearMailAliases didn't exist then, I had to make do with putting them in the street field which worked ok. You don't mention it in your reply so forgive me for asking. Are your email aliases stored in an LDAP server too? and which version of SOGo are you running? I've checked the LDAP server using jxplorer and the aliases are being stored fine. After a little more testing, the mangled from addresses seem to be being generated from the CNFieldName field, so where I have cn=Name Surname I get FROM: Name@fqdn, Surname@fqdn where I have cn=Name M. Surname I end up with FROM: Name@fqdn, M.Surname@fqdn I hope this clarifies the issue somewhat. Leon L. Robinson On 11/05/2012 08:58 AM, Junk wrote: Hi. I've set up SOGo 2.0.1 on ClearOS 6.3 (based on RHEL6.3) using the instructions found here http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,40/func,view/id,45488/#45488 Those instructions say nothing about how you've setup your mail server(s). It all works fine apart from when I try to send mail using aliases with periods (full stops) in like this e.g. one.two@fqdn or a.b.cee@fqdn I end up with two addresses in the FROM field like one@fqdn, o.two@fqdn The aliases are provided from LDAP as per the link. (see the line MailFieldNames=(clearMailAliases,mail) ) I can send mail from other clients (mutt evolution) without the mangling happening so I'm pretty sure it's the webmail part of SOGo that isn't happy. Can you help? Almost all of my email users and some aliases have a dot in their address: firstname.surn...@example.net How are mutt and Evolution configured to send mail? Perhaps ClearOS is configured to use clearMailAliases in the LDAP server for email aliases. However, that does change the way SOGo sends email: it looks like you've configured SOGo to send via SMTP on the localhost. That maybe where your problem is. HTH, Simon -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot download attchments from Web interface
here is an extract from /var/log/httpd/ssl_error_log as well
I guess if I dont have a reply by the 23rd Ill open it as a bug.
[Mon Dec 19 14:31:00 2011] [error] [client server_external_IP] (20014)Internal error: proxy: error reading status line from remote server 127.0.0.1, referer: https://server/SOGo/so/user/Mail/view
[Mon Dec 19 14:31:00 2011] [error] [client server_external_IP] proxy: Error reading from remote server returned by /SOGo/so/username/Mail/0/folderINBOX/6234/2/Leon_L__Robinson_RHCSA.pdf, referer: https://server/SOGo/so/user/Mail/view
On Saturday, December 17, 2011 09:39 PM GMT, Junk j...@therobinsonfamily.net wrote:
I can no longer download attachments from SOGos web interface either in
version 1.3.10 or 1.3.11. I have been trying to get CardDav for iOS
working but as Apache will not restart due to the perennial already
used by another worker issue (which people in this list seem to have
resolved but I cant find a concrete answer for, thats not the issue)
So in trying this I may have damaged the SOGo.conf file. I dont think I
have however as Im quite careful about making backups.
The web error and log file are pasted below
Web Browser Error:
Proxy Error
The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request
GET /SOGo/so//Mail/0/folderINBOX/6229/2/Leon.181211.LDS.pdf.
Reason: Error reading from remote server
Apache/2.2.3 (ClearOS) Server at Port 443
/var/log/sogo.log:
localhost.localdomain - - [17/Dec/2011:21:23:08 GMT]
PROPFIND /SOGo/dav//Contacts/personal/ HTTP/1.1 207 26759/95
0.136 - - 412K
localhost.localdomain - - [17/Dec/2011:21:23:11 GMT]
PROPFIND /SOGo/dav//Contacts/personal/ HTTP/1.1 207 26759/95
0.041 - - 8K
localhost.localdomain - - [17/Dec/2011:21:23:11 GMT]
GET /SOGo/dav//Contacts/personal/139 HTTP/1.1 200 163/0
0.007 - - 28K
localhost.localdomain - - [17/Dec/2011:21:23:30 GMT]
PROPFIND /SOGo/dav//Contacts/personal/ HTTP/1.1 207 26759/95
0.042 - - 8K
localhost.localdomain - - [17/Dec/2011:21:23:30 GMT]
PROPFIND /SOGo/dav//Contacts/personal/ HTTP/1.1 207 26759/95
0.039 - - 0
Dec 17 21:23:30 sogod [28829]:
0x0931A83C[SOGoContactGCSEntry]:54C44355-30BE09A4-52F3747F.vcf TODO:
implement if-none-match for etag: *
localhost.localdomain - - [17/Dec/2011:21:23:30 GMT]
PUT /SOGo/dav//Contacts/personal/54C44355-30BE09A4-52F3747F.vcf HTTP/1.1 201 0/138 0.097 - - 144K
localhost.localdomain - - [17/Dec/2011:21:23:31 GMT]
PROPFIND /SOGo/dav//Calendar/personal/ HTTP/1.1 207 317/113
0.012 - - 0
localhost.localdomain - - [17/Dec/2011:21:23:31 GMT]
PROPFIND /SOGo/dav//Calendar/personal/ HTTP/1.1 207 317/113
0.016 - - 0
localhost.localdomain - - [17/Dec/2011:21:23:37 GMT]
PROPFIND /SOGo/dav//Contacts/personal/ HTTP/1.1 207 26994/95
0.045 - - 120K
2011-12-17 21:24:26.768 sogod[28829] Note: Using UTF-8 as URL encoding
in NGExtensions.
2011-12-17 21:24:26.773 sogod[28829] WARNING: IMAP4 connection pooling
is disabled!
2011-12-17 21:24:26.976 sogod[28829] Note(NGImap4Connection): using /
as the IMAP4 folder separator.
EXCEPTION: NAME:NSInvalidArgumentException
REASON:NGImap4Connection(instance) does not recognize
fetchContentOfBodyPart:atURL:withPeek: INFO:(null)
Dec 17 21:24:27 sogod [32064]: 0x0x90b37c4[WOWatchDogChild] child
28829 exited
Dec 17 21:24:27 sogod [32064]: 0x0x90b37c4[WOWatchDogChild]
(terminated due to signal 6)
Dec 17 21:24:27 sogod [32064]: 0x0x916a344[WOWatchDog] child spawned
with pid 29007
Dec 17 21:24:31 sogod [29007]: 0x0x915e17c[SOGoCache] Cache cleanup
interval set every 300.00 seconds
Dec 17 21:24:31 sogod [29007]: 0x0x915e17c[SOGoCache] Using host(s)
localhost as server(s)
Dec 17 21:24:31 sogod [29007]: [WARN]
0x0x92cc35c[SOGoWebDAVAclManager] entry {DAV:}write already exists
in DAV permissions table
Dec 17 21:24:31 sogod [29007]: [WARN]
0x0x92cc35c[SOGoWebDAVAclManager] entry {DAV:}write-properties
already exists in DAV permissions table
Dec 17 21:24:31 sogod [29007]: [WARN]
0x0x92cc35c[SOGoWebDAVAclManager] entry {DAV:}write-content already
exists in DAV permissions table
2011-12-17 21:24:31.707 sogod[29007] Note(SoObject): SoDebugKeyLookup is
enabled!
2011-12-17 21:24:31.708 sogod[29007] Note(SoObject): SoDebugBaseURL is
enabled!
2011-12-17 21:24:31.708 sogod[29007] Note(SoObject): relative base URLs
are enabled.
2011-12-17 21:24:31.710 sogod[29007] File NSKeyValueCoding.m: 913. In
-[NSObject(KeyValueCoding) valuesForKeys:] This method is deprecated,
use -dictionaryWithValuesForKeys:
localhost.localdomain - - [17/Dec/2011:21:24:31 GMT]
PROPFIND /SOGo/dav//Calendar/personal/ HTTP/1.1 207 317/113
0.031 - - 1M
localhost.localdomain - - [17/Dec/2011:21:24:31 GMT]
PROPFIND /SOGo/dav//Calendar/personal/ HTTP/1.1 207 317/113
0.011 - - 0
Leon
--
users@sogo.nu
https://inverse.ca/sogo/lists
