[SOGo] Mail Ailases and domain part of email

2023-07-09 Thread "Leon L. Robinson" 
I recently updated from SOGO 2 to SOGO 5. In SOGO2 I used LDAP with two
fields for the mail.

MailFieldNames = (
mail,
clearMailAliases
);

mail is a full email e.g. 'f...@example.com' , clearMailAliases is just
an email alias e.g. 'bunbungo'

SOGO 2 appended the domain to the alias on sending but SOGO 5 doesn't
and I get 'Ms Bunbungo@unspecified-domain' in the sent messages folder.
I feel I'm missing an obvious setting in the switch between the two but
I can't figure it out.

Is there away of forcing it by doing something like appending a string
to the ldap  query? e.g.

MailFieldNames = (
mail,
clearMailAliases+'@example.com'
);


Leon

Re: [SOGo] BTS activities for Wednesday, June 14 2023

2023-06-17 Thread "Leon L. Robinson" 

On 15/06/2023 12:51, "Simon Wilson" (si...@simonandkate.net) wrote:
OK, so it looks like it still needs the gnustep exclusion in EPEL repo 
file. Without it, sogo installs but won't run:
/usr/sbin/sogod: error while loading shared libraries: 
libgnustep-base.so.1.24: cannot open shared object


...but I cannot install sogo at all with gnustep excluded from EPEL:

[root@emp96 ~]# dnf install sogo
Updating Subscription Management repositories.
Extra Packages for Enterprise Linux 9 - x86_64                         
      2.5 kB/s | 4.1 kB     00:01

Error:
 Problem: package sogo-5.8.3.20230614-1.el8.x86_64 requires 
gnustep-base >= 1.23, but none of the providers can be installed
  - package gnustep-base-1.24.9-1.el8.x86_64 requires 
libgnustep-base.so.1.24()(64bit), but none of the providers can be 
installed
  - package gnustep-base-1.24.9-1.el8.x86_64 requires 
gnustep-base-libs(x86-64) = 1.24.9-1.el8, but none of the providers 
can be installed

  - conflicting requests
  - nothing provides libffi.so.6()(64bit) needed by 
gnustep-base-libs-1.24.9-1.el8.x86_64
  - nothing provides libicui18n.so.60()(64bit) needed by 
gnustep-base-libs-1.24.9-1.el8.x86_64
  - nothing provides libicuuc.so.60()(64bit) needed by 
gnustep-base-libs-1.24.9-1.el8.x86_64
  - package gnustep-base-1.28.0-3.el9.x86_64 is filtered out by 
exclude filtering
(try to add '--skip-broken' to skip uninstallable packages or 
'--nobest' to use not only best candidate packages)


So no working result on RHEL 9 yet.

Simon


On Thursday, June 15, 2023 20:37 AEST, "Simon Wilson" 
 wrote:
Noting #5697 for packages for CentOS 9 (I can't add a note in the 
ticket).


  * On Redhat 9 does it require codeready-builder repo? Noting that
the correct way to install on RHEL9 is " subscription-manager
repos --enable codeready-builder-for-rhel-9-x86_64-rpms" not the
instruction in the ticket
  * Does it still require the epel exclusion for gnustep and ytnef?

Thanks
Simon



On Thursday, June 15, 2023 14:00 AEST, "SOGo reporter" 
(smizr...@alinto.eu)  wrote:



  BTS Activities

Home page: *https://bugs.sogo.nu*
Project: *SOGo*
For the period covering: *Wednesday, June 14 2023*

id  last update status (resolution) categorysummary
5789  	2023-06-14 16:58:00 
updated (open) 	Apple iPhone OS 	Wrong time Events
5788  	2023-06-14 17:58:17 
assigned (reopened) 	ActiveSync 	Bug in libytnef0 causes ActiveSync 
to fail sync when files in winmail.dat file have long filename
5697  	2023-06-14 11:27:33 
resolved (fixed) 	Packaging (RedHat) 	Build packages for CentOS 
Stream 9, Rocky Linux 9, AlmaLinux 9



--
Simon Wilson
M: 0400 121 116


--
Simon Wilson
M: 0400 121 116 



It looks like you're installing the el8 packages in el9. There is a 
different repo for el9


I didn't need to exclude the gnustep* ytnef* in the epel repo to get it 
to install correctly. Here's my repofile:


[sogo]

name=SOGo Repository
baseurl=https://packages.sogo.nu/nightly/5/rhel/9/x86_64
gpgcheck=1


Leon.

Re: [SOGo] DNF issue on Redhat 8

2023-06-16 Thread "Leon L. Robinson" 

On 15/06/2023 11:06, "Simon Wilson" (si...@simonandkate.net) wrote:
Getting a package error on RHEL8: "package 
sope49-sbjson-2.3.1-20230613_1664.el9.2.1.x86_64 requires 
libgnustep-base.so.1.28()(64bit), but none of the providers can be 
installed"


Server setup is per instructions at 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_software_downloads: 



_/For RHEL/CentOS 8/_

/yum install 
https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm/


/SOGo relies on the GNUstep and ytnef packages provided by Alinto and 
must not use the packages from EPEL. Adjust the repository definition 
to exclude those packages:/


/sed -i '/enabled=1/a \ exclude=gnustep* ytnef*' 
/etc/yum.repos.d/epel.repo/

My epel.repo is excluding EPEL gnustep, and I've done a 'dnf clean all'.

Full output:
[root@emp86 yum.repos.d]# dnf update
Updating Subscription Management repositories.
Last metadata expiration check: 0:00:25 ago on Thu 15 Jun 2023 
19:59:43 AEST.

Error:
 Problem: package sope49-sbjson-2.3.1-20230613_1664.el9.2.1.x86_64 
requires libgnustep-base.so.1.28()(64bit), but none of the providers 
can be installed
  - cannot install the best update candidate for package 
sope49-sbjson-2.3.1-20230530_1664.el8.1.1.x86_64
  - package gnustep-base-libs-1.28.0-3.el8.x86_64 is filtered out by 
exclude filtering
(try to add '--skip-broken' to skip uninstallable packages or 
'--nobest' to use not only best candidate packages)



--
Simon Wilson
M: 0400 121 116 


I can confirm. I'm seeing the same in my centos-stream8 container. I


STEP 8/10: RUN yum -y --refresh install sogo sope49-gdl1-mysql 
sope49-gdl1-postgresql httpd mariadb-connector-c sogo-tool
WARN[0211] Failed to mount subscriptions, skipping entry in 
/usr/share/containers/mounts.conf: getting host subscription data: 
failed to read subscriptions from "/usr/share/rhel/secrets": open 
/usr/share/rhel/secrets/etc-pki-entitlement/6709440158875966238-key.pem: 
permission denied

CentOS Stream 8 - AppStream  11 kB/s | 4.4 kB 00:00
CentOS Stream 8 - BaseOS 32 kB/s | 3.9 kB 00:00
CentOS Stream 8 - Extras 10 kB/s | 2.9 kB 00:00
CentOS Stream 8 - Extras common packages 10 kB/s | 3.0 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64  8.4 MB/s |  16 MB 00:01
SOGo Repository  22 kB/s | 2.9 kB 00:00
Error:
 Problem 1: package sogo-5.8.3.20230615-1.el8.x86_64 requires 
sope49-sbjson, but none of the providers can be installed
  - package sope49-sbjson-2.3.1-20230613_1664.el9.2.1.x86_64 requires 
libgnustep-base.so.1.28()(64bit), but none of the providers can be installed

  - conflicting requests
  - package gnustep-base-libs-1.28.0-3.el8.x86_64 is filtered out by 
exclude filtering
 Problem 2: package sogo-5.8.3.20230615-1.el8.x86_64 requires 
sope49-sbjson, but none of the providers can be installed
  - package sogo-tool-5.8.3.20230615-1.el8.x86_64 requires sogo = 
5.8.3.20230615, but none of the providers can be installed
  - package sope49-sbjson-2.3.1-20230613_1664.el9.2.1.x86_64 requires 
libgnustep-base.so.1.28()(64bit), but none of the providers can be installed

  - conflicting requests
  - package gnustep-base-libs-1.28.0-3.el8.x86_64 is filtered out by 
exclude filtering
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' 
to use not only best candidate packages)
Error: building at STEP "RUN yum -y --refresh install sogo 
sope49-gdl1-mysql sope49-gdl1-postgresql httpd mariadb-connector-c 
sogo-tool": while running runtime: exit status 1


Removing the

/exclude=gnustep* ytnef*'/

in the epel repo let the install continue. However the resulting images 
doesn't run.


e064ff81084f sogod: error while loading shared libraries: 
libgnustep-base.so.1.24: cannot open shared object file: No such file or 
directory


using the suggested --nobest doesn't solve the issue either.

Leon

[SOGo] Deleting odd duplicate calendars, advice needed.

2023-06-13 Thread "Leon L. Robinson" 
Hi, After I accidentally updated my Mariadb to 11 and reverted to 10 I 
have a lot of odd duplicated calendars.


MariaDB [sogo]> SELECT c_foldername,count(*) FROM sogo_folder_info WHERE 
c_path2='baggypants' GROUP BY c_foldername ORDER BY c_foldername;

++--+
| c_foldername   | count(*) |
++--+
| Calendar   |  162 |
| ChristCentral  |    1 |
| Collected Address Book |    1 |
| DEFAULT_TASK_CALENDAR_NAME |   34 |
| Elvanto    |    1 |
| england-and-wales  |    1 |
| Family |    1 |
| Personal Address Book  |    1 |
| Personal Calendar  |    1 |
| Reminders  |  127 |
| Work   |    1 |
++--+
11 rows in set (0.024 sec)

I'm thinking I should be able to just remove these from the 
sogo_folder_info table and then getting sogo-tool cleanup to try and 
clean up the orphaned tables. Or should I really be deleting the tables 
they point in SQL to as well?


There's only one user that has the duplicated calendars.

Leon

Re: [SOGo] Database connection error `got no value for column: attribute=c_path2`

2023-06-13 Thread "Leon L. Robinson" 
On 12 June 2023 23:12:33 BST, "Leon L. Robinson"  wrote:
>
>On Mon, 2023-06-12 at 11:24 +0100, junk wrote:
>> 
>> 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
>> 
>> 
>
>I added the MYSQL4 debug line and got a little more information
>
>5ea3bd8ac7c1 2023-06-12 21:56:23.674 sogod[239:239]
> SQL:
>INSERT INTO sogo_folder_info(c_path, c_path1, c_path2, c_path3,
>c_path4, c_foldername, c_location, c_quick_location,
>c_acl_location, c_folder_type) VALUES
>('/Users/baggypants/Calendar/personal', 'Users', 'baggypants',
>'Calendar', 'personal', 'Personal Calendar',
>'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf',  
>'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf_quic
>k',
>'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf_acl'
>, 'Appointment');
>5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
>   ERROR:
>Duplicate entry '/Users/baggypants/Calendar/personal' for key 'PRIMARY'
>5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
> SQL:
>ROLLBACK;
>5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
>   query
>has no results.
>5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
> SQL:
>SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2
>= 'baggypants' AND c_path3 = 'Calendar' AND c_path4 = 'personal';
>5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239]
>   query
>has results, entering fetch-mode.
>5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239] ERROR(-
>[NSNumber(MySQL4Values) initWithMySQL4Field:value:length:]):
>unsupported MySQL type: 0 (len=35)
>5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239] ERROR(-
>[MySQL4Channel primaryFetchAttributes:withZone:]):
>: got no
>value for column: attribute=c_path
>5ea3bd8ac7c1   valueClass=NSNumber
>5ea3bd8ac7c1   type=DECIMAL
>
>
>I'm not sure why it's trying to add the personal calendar again.
>The sogo version is sogo-5.8.3.20230611-1.el8.x86_64 mariadb is 8
>
>I checked some of the database character settings at they all seem to
>be utf8mb4 
>
>MariaDB [sogo]> SELECT default_character_set_name FROM
>information_schema.SCHEMATA  WHERE schema_name = "sogo";
>++
>| default_character_set_name |
>++
>| utf8mb4|
>++
>1 row in set (0.008 sec)
>
>MariaDB [sogo]> SELECT CCSA.character_set_name FROM
>information_schema.`TABLES` T,   
>information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE
>CCSA.collation_name = T.table_collation   AND T.table_schema = "sogo" 
>AND T.table_name = "sogo_folder_info";
>++
>| character_set_name |
>++
>| utf8mb4|
>++
>1 row in set (0.010 sec)
>
>MariaDB [sogo]> SELECT character_set_name FROM
>information_schema.`COLUMNS`  WHERE table_schema = "sogo"   AND
>table_name = "sogo_folder_info"   AND column_name = "c_path";
>++
>| character_set_name |
>++
>| utf8mb4|
>++
>1 row in set (0.012 sec)
>
>MariaDB [sogo]> SELECT character_set_name FROM
>information_schema.`COLUMNS`  WHERE table_schema = "sogo"   AND
>table_name = "sogo_folder_info"   AND column_name = "c_path2";
>++
>| character_set_name |
>++
>| utf8mb4|
>++
>1 row in set (0.007 sec)
>
>MariaDB [sogo]> SELECT character_set_name FROM
>inform

Re: [SOGo] Database connection error `got no value for column: attribute=c_path2`

2023-06-12 Thread "Leon L. Robinson" 
On Mon, 2023-06-12 at 11:24 +0100, junk wrote:
> 
> 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
> 
> 

I added the MYSQL4 debug line and got a little more information

5ea3bd8ac7c1 2023-06-12 21:56:23.674 sogod[239:239]
 SQL:
INSERT INTO sogo_folder_info(c_path, c_path1, c_path2, c_path3,
c_path4, c_foldername, c_location, c_quick_location,
c_acl_location, c_folder_type) VALUES
('/Users/baggypants/Calendar/personal', 'Users', 'baggypants',
'Calendar', 'personal', 'Personal Calendar',
'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf',  
'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf_quic
k',
'mysql://sogo:password@10.0.0.14:3306/sogo/sogobaggypan0bc18d03bcf_acl'
, 'Appointment');
5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
   ERROR:
Duplicate entry '/Users/baggypants/Calendar/personal' for key 'PRIMARY'
5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
 SQL:
ROLLBACK;
5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
   query
has no results.
5ea3bd8ac7c1 2023-06-12 21:56:23.675 sogod[239:239]
 SQL:
SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2
= 'baggypants' AND c_path3 = 'Calendar' AND c_path4 = 'personal';
5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239]
   query
has results, entering fetch-mode.
5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239] ERROR(-
[NSNumber(MySQL4Values) initWithMySQL4Field:value:length:]):
unsupported MySQL type: 0 (len=35)
5ea3bd8ac7c1 2023-06-12 21:56:23.676 sogod[239:239] ERROR(-
[MySQL4Channel primaryFetchAttributes:withZone:]):
: got no
value for column: attribute=c_path
5ea3bd8ac7c1   valueClass=NSNumber
5ea3bd8ac7c1   type=DECIMAL


I'm not sure why it's trying to add the personal calendar again.
The sogo version is sogo-5.8.3.20230611-1.el8.x86_64 mariadb is 8

I checked some of the database character settings at they all seem to
be utf8mb4 

MariaDB [sogo]> SELECT default_character_set_name FROM
information_schema.SCHEMATA  WHERE schema_name = "sogo";
++
| default_character_set_name |
++
| utf8mb4|
++
1 row in set (0.008 sec)

MariaDB [sogo]> SELECT CCSA.character_set_name FROM
information_schema.`TABLES` T,   
information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE
CCSA.collation_name = T.table_collation   AND T.table_schema = "sogo" 
AND T.table_name = "sogo_folder_info";
++
| character_set_name |
++
| utf8mb4|
++
1 row in set (0.010 sec)

MariaDB [sogo]> SELECT character_set_name FROM
information_schema.`COLUMNS`  WHERE table_schema = "sogo"   AND
table_name = "sogo_folder_info"   AND column_name = "c_path";
++
| character_set_name |
++
| utf8mb4|
++
1 row in set (0.012 sec)

MariaDB [sogo]> SELECT character_set_name FROM
information_schema.`COLUMNS`  WHERE table_schema = "sogo"   AND
table_name = "sogo_folder_info"   AND column_name = "c_path2";
++
| character_set_name |
++
| utf8mb4|
++
1 row in set (0.007 sec)

MariaDB [sogo]> SELECT character_set_name FROM
information_schema.`COLUMNS`  WHERE table_schema = "sogo"   AND
table_name = "sogo_folder_info"   AND column_name = "c_path4";
++
| character_set_name |
++
| utf8mb4|
++
1 row in set (0.010 sec)

Leon

[SOGo] Still can't download attachments on Web Interface

2012-01-25 Thread Leon L. Robinson 
I upgraded to SOGo 1.3.11 a while ago and now I can't download any
attachments.

In the browser I get
==
Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request
GET /SOGo/so/baggypants/Mail/0/folderINBOX/6310/2/Christ Central
Blogging.docx.

Reason: Error reading from remote server

In Sogo log I Get
==

Jan 25 14:41:04 sogod [921]: [ERROR]
0x0x9b33ebc[UIxMailRenderingContext] found no viewer for MIME type:
application/vnd.openxmlformats-officedocument.wordprocessingml.document
localhost.localdomain - - [25/Jan/2012:14:41:04 GMT]
POST /SOGo/so/baggypants/Mail//0/folderINBOX/6310/view?noframe=1
HTTP/1.1 200 1561/0 0.366 4504 65% 0
EXCEPTION: NSException: 0x9bdf85c NAME:NSInvalidArgumentException
REASON:NGImap4Connection(instance) does not recognize
fetchContentOfBodyPart:atURL:withPeek: INFO:(null)
Jan 25 14:41:06 sogod [27135]: 0x0x98407c4[WOWatchDogChild] child 921
exited
Jan 25 14:41:06 sogod [27135]: 0x0x98407c4[WOWatchDogChild]
(terminated due to signal 6)

I don't think this is a bug as I've installed a clean version of SOGo on
a virtual machine of similar configuration and it works fine.

I've reset the SOGo.conf so I don't think it is an error with that.

Leon

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