date:20240201

[SOGo] BTS activities for Thursday, February 01 2024

2024-02-01 Thread SOGo reporter

Title: BTS activities for Thursday, February 01 2024





  
BTS Activities

  Home page: https://bugs.sogo.nu
  Project: SOGo
  For the period covering: Thursday, February 01 2024

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5916
	2024-02-01 09:21:00
	closed (fixed)
	Web Administration
	Automatic response with date and time does not work anymore since version 5.9.1

Re: [SOGo] SOGo 5.9.0 could not load product

2024-02-01 Thread "burkha...@konsultaner.de"

To answer you other questions:

cat /usr/local/include/ytnef.h | grep TNEFParseMemory
int TNEFParseMemory(BYTE *memory, long size, TNEFStruct *TNEF);

gcc -lytnef
/usr/bin/ld: /usr/lib/gcc/x86_64-redhat-linux/11/../../../../lib64/crt1.o: in 
function `_start':
(.text+0x1b): undefined reference to `main'
collect2: error: ld returned 1 exit status

I finally got ld to find the libytnef.so and libytnef.a

ldconfig -p | grep libyt
libytnef.so.0 (libc6,x86-64) => /usr/local/lib/libytnef.so.0
libytnef.so (libc6,x86-64) => /usr/local/lib/libytnef.so

I needed to add /usr/local/lib to the ld path. Seems like Alma puts everything 
into /usr/local/lib64

I could compile the test.c without a problem. I also added the BUNDLE_LIBS += 
-lytnef but still

Nothing works. The linker can see ytnef and sogo should find it too, because it 
is available in /usr/local/lib64 via a symlink.

Is there any other possible condition why the mail component doesn't find my 
libytnef.so?

The version of ytnef also contains the symbol:

nm -D /usr/local/lib/libytnef.so | grep TNEFParseMemory 54e0 T 
TNEFParseMemory

Am Mittwoch, dem 31.01.2024 um 18:25 + schrieb burkha...@konsultaner.de:
Sorry, this is the output of the daemon. So when running it not building. 
Compiling works well.

Am 31.01.2024 17:29 schrieb qhivert :
It’s not clear to me if you get the errors when building or after when running 
sogo ?

From: users-requ...@sogo.nu On Behalf Of 
"burkha...@konsultaner.de"
Sent: mercredi 31 janvier 2024 16:14
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

Thank you, compiling the test.c worked. my I added the ytnef.h to ld but still 
the same error. If it helps here is my part of the ansible script that compiles 
sogo on alma 9.3 minimal


- name: set data path
  set_fact:
sogo_gnustep_path: "/usr/local/lib64/GNUstep/SOGo"

- name: Enable additional repo
  dnf:
name:
  - epel-release
  - almalinux-release-devel

- name: Enable CRB repository
  command: dnf config-manager --set-enabled crb

- name: Enable devel repository
  command: dnf config-manager --set-enabled devel

- name: Install required packages
  dnf:
enablerepo: epel
name:
  - gnustep-base
  - gnustep-make
  - gnustep-base-devel
  - gcc-objc
  - libsodium
  - libsodium-devel
  - libmemcached-awesome
  - libmemcached-awesome-devel
  - libzip
  - libzip-devel

- name: Install required packages
  dnf:
name:
  - redhat-rpm-config
  - libxml2-devel
  - libxml2
  - openssl-devel
  - openssl
  - openldap-devel
  - openldap
  - postgresql-devel
  - postgresql
  - libcurl-devel
  - libcurl
  - python3-psycopg2
  - autoconf
  - automake
  - libtool
  - git
state: present

- name: Clone ytnef from GitHub
  git:
repo: 'https://github.com/Yeraze/ytnef.git'
dest: '/tmp/ytnef'
version: "{{ ytnef_git_tag }}"
clone: yes
update: yes

- name: Compile and Install SOPE
  shell: |
cd /tmp/ytnef
autoreconf -i
./configure
make
make install
echo "/usr/local/include" | sudo tee -a /etc/ld.so.confD
ldconfig
  args:
executable: /bin/bash

- name: Clone SOPE from GitHub
  git:
repo: 'https://github.com/Alinto/sope.git'
dest: '/tmp/SOPE'
version: "{{ sope_git_tag }}"
clone: yes
update: yes

- name: Clone SOGo from GitHub
  git:
repo: 'https://github.com/Alinto/sogo.git'
dest: '/tmp/SOGo'
version: "{{ sogo_git_tag }}"
clone: yes
update: yes

- name: Compile and Install SOPE
  shell: |
cd /tmp/SOPE
./configure --with-gnustep --enable-debug --disable-strip
make
make install
  args:
executable: /bin/bash

- name: Compile and Install SOGo
  shell: |
cd /tmp/SOGo
./configure --enable-debug --disable-strip
make
make install
  args:
executable: /bin/bash

you just need to set the vars in you playbook, this is only my sogo role.

Am Mittwoch, dem 31.01.2024 um 15:16 +0100 schrieb qhivert:
Ok,
It seems related to https://bugs.sogo.nu/view.php?id=5907
but it it’s not the same symbol. Could you try the steps of my first comment 
there (qhivert)?

From: users-requ...@sogo.nu 
mailto:users-requ...@sogo.nu>>On Behalf Of 
"burkha...@konsultaner.de"
Sent: mercredi 31 janvier 2024 15:06
To: users@sogo.nu
Subject: Re: [SOGo] SOGo 5.9.0 could not load product

Hey Queintin,

no I tried installing from yum, from the nightly repo and finally tried to 
install by compiling from source. Nothing worked. I always get the same error. 
Even going down on a 5.8 didn't work.

Richard

Am Mittwoch, dem 31.01.2024 um 14:32 +0100 schrieb qhivert:
Hello,

Are you saying that when installing ytnef via yum it don’t work but when you’re 
building ytnef yourself it works fine?

Queintin




From: users-requ...@sogo.nu

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

2024-02-01 Thread Bits 'n Tricks


Hi Markus,

thanks, will try this.
I actually just copied the sogo.conf file from another working server,

---
Met Vriendelijke Groet,
Kind Regards,
Salutations,


Bart Coninckx
Bits 'n Tricks



On 01/02/2024 21:00, Markus Winkler wrote:

Hi Bart,

On 31.01.24 18:07, Bits 'n Tricks (i...@bitsandtricks.com) wrote:


it came from /var/log/sogo/sogo.log:

ERROR: Table 'sogo.sogo_users' doesn't exist


[...]
Anyway, I have only one occurrence in the sogo.conf file and it is 
this:

viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";


IMHO the main question is: according to which documentation did you 
create/edit your sogo.conf?


Please have a look at:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL

At the end of this section you'll find an example of a 
'SOGoUserSources' config and there (among others) the 'viewURL' 
parameter. Couldn't you try to use this example from the official 
documentation?


On a former system I used:

  SOGoUserSources =
(
  {
type = sql;
id = users;
viewURL = "mysql://sogo:xxx@127.0.0.1:3306/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = SHA512-CRYPT;
prependPasswordScheme = YES;
displayName = "SOGo Benutzer";
  }
);

and it worked without any problem.

Maybe it's worth a try.

HTH and regards,
Markus

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

2024-02-01 Thread Markus Winkler


Hi Bart,

On 31.01.24 18:07, Bits 'n Tricks (i...@bitsandtricks.com) wrote:


it came from /var/log/sogo/sogo.log:

ERROR: Table 'sogo.sogo_users' doesn't exist


[...]

Anyway, I have only one occurrence in the sogo.conf file and it is this:
viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";


IMHO the main question is: according to which documentation did you 
create/edit your sogo.conf?


Please have a look at:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL

At the end of this section you'll find an example of a 'SOGoUserSources' 
config and there (among others) the 'viewURL' parameter. Couldn't you try 
to use this example from the official documentation?


On a former system I used:

  SOGoUserSources =
(
  {
type = sql;
id = users;
viewURL = "mysql://sogo:xxx@127.0.0.1:3306/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = SHA512-CRYPT;
prependPasswordScheme = YES;
displayName = "SOGo Benutzer";
  }
);

and it worked without any problem.

Maybe it's worth a try.

HTH and regards,
Markus

Re: [SOGo] ActiveSync Error

2024-02-01 Thread "Robert Himics"

Follow-up question.Is there a working apache SOGo.conf file that I can compare to to make sure everything is set right.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 4:54 PM, "\\Robert Himics\\"  wrote:Yes. I tried Multiple time And I agree that it is strange.I used activeSync from a different mail Env (not SOGo based) with an Apache reverse proxy infront. So not sure the issue.Robert Himicsr...@himicsfamily.comOn Jan 31, 2024 8:45 AM, "\\Raoul Schroeder\\"  wrote:Hi Robert, The wstunnel is not needed, that is for a websocket proxy only. Are you sure you gave the ActiveSync Test the proper username and password? The 401 error is strange. BR, Raoul Von: users-requ...@sogo.nu  Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 13:47An: users@sogo.nuBetreff: RE: [SOGo] ActiveSync Error Yes using apache and yes have the below line.Will check on the modules.  Wstunnel is the ony one not sure.ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600 I have the followings in the environment.  Apache svr on internet that has Reverse proxy to internal Apache svr where SOGo is running. Robert Himicsr...@himicsfamily.com On Jan 31, 2024 4:34 AM, "\\Raoul Schroeder\\"  wrote:Are you using apache? Do you have proxy enabled on your apache config?If you enter: sudo apachectl -MYou should find the following in the list:proxy_module (shared)proxy_http_module (shared)proxy_wstunnel_module (shared) Do you have the following line in your config?ProxyPass /Microsoft-Server-ActiveSync \http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync \retry=60 connectiontimeout=5 timeout=3600  Von: users-requ...@sogo.nu  Im Auftrag von "Robert Himics"Gesendet: Mittwoch, 31. Januar 2024 08:02An: users@sogo.nuCc: 'Rob Himics' Betreff: RE: [SOGo] ActiveSync Error I’m Trying to Get ActiveSync to Work Getting this in sogo logsJan 31 01:49:27 sogod [5769]: |SOGo| starting method 'OPTIONS' on uri '/SOGo/Microsoft-Server-ActiveSync/'Jan 31 01:49:27 sogod [5769]: |SOGo| request took 0.000950 seconds to executeJan 31 01:49:27 sogod [5769]: 52.109.8.10, 101.11.11.179 "OPTIONS /SOGo/Microsoft-Server-ActiveSync/ HTTP/1.0" 401 0/0 0.003 - - 0 - 12 Also From The Microsoft ActiveSync testing ToolWhat have I Missed – Other that ActiveSync Everything Looks like it’s Works Rob Himicsr...@himicsfamily.com

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

2024-02-01 Thread Odhiambo Washington

If your two systems are supposed to be identical, then just dump the other
database schema and import it into the new server.



On Thu, Feb 1, 2024 at 11:17 AM Bits 'n Tricks  wrote:

>
>
> On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks  wrote:
>
> Hi,
>
> it came from /var/log/sogo/sogo.log:
>
>
> ERROR: Table 'sogo.sogo_users' doesn't exist
>
>
>
> PS: I hate to-posting!
>
> In one of my setups, I have these definitions in sogo.conf:
>
>  /* Database Configuration */
> SOGoProfileURL = "mysql://sogou:/* Database Configuration */
> SOGoProfileURL = "mysql://
> sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile";
> OCSFolderInfoURL = "mysql://
> sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info";
> OCSSessionsFolderURL = "mysql://
> sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder";
> OCSEMailAlarmsFolderURL="mysql://
> sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder";
>
> OCSStoreURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_store
> ";
> OCSAclURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl";
> OCSCacheFolderURL="mysql://
> sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder";
>
> Looking at the exim4u DB:
>
> ```
> root@localhost [exim4u]> show tables;
> ++
> | Tables_in_exim4u   |
> ++
> | blocklists |
> | domainalias|
> | domains|
> | group_contents |
> | ml |
> | mygroups   |
> | sogo_acl   |
> | sogo_alarms_folder |
> | sogo_auth_view |
> | sogo_cache_folder  |
> | sogo_folder_info   |
> | sogo_quick_appointment |
> | sogo_quick_contact |
> | sogo_sessions_folder   |
> | sogo_store |
> | sogo_user_profile  |
> | users  |
> ++
> ```
>
> As you can see, there's nothing like sogo_users table in the DB!
>
> If you need more help, I will do that, but only IF you do not top-post!
>
>
> --
> Best regards,
> Odhiambo WASHINGTON,
> Nairobi,KE
> +254 7 3200 0004/+254 7 2274 3223
>  In an Internet failure case, the #1 suspect is a constant: DNS.
> "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
> [How to ask smart questions:
> http://www.catb.org/~esr/faqs/smart-questions.html]
>
> Bottom postingi in HTML mails is not ideal, that's why I don't do it
> usually.
> Anyway, I have only one occurrence in the sogo.conf file and it is this:
>
> viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";
>
>
> But it is also in my other serverwhich does work with that config and it
> also has the sogo_users table ...
>
> BC
>
>
>

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
 In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]

Re: [SOGo] Sync outlook calendar to SOGO error

2024-02-01 Thread Kenren Taisho

Hi Christian,

Thank you!
 I will try to use the SOGoDisableOrganizerEventCheck option to prevent the
error from showing to end users.


Kind regards





,


On Thu, Feb 1, 2024 at 3:50 PM Christian Mack  wrote:

> Hello
>
> Am 01.02.24 um 02:56 schrieb Kenren Taisho (toushin.tai...@gmail.com):
> > Hi Christian,
> >
> > Thank you for the reply and explanation of the problem.
> > Do you have recommendations on how to get around these errors?
> >  From the user's point of view, CaldavSyncronizer is now throwing errors
> > which do not happen before.
> > Are there any CaldavSyncronizer settings to get around it?
> >
>
> No, there is nothing CalDAV Synchronizer can do.
> It is an error message generated by SOGo.
> But you can use OptionSOGoDisableOrganizerEventCheck = YES;
> in sogo.conf.
> It will prevent this test, and therefore prevent that '412'
> ('Precondition Failed') error.
>
>
> Kind regards,
> Christian Mack
>
> > On Wed, Jan 31, 2024 at 11:42 PM Christian Mack  wrote:
> >
> >> Hello
> >>
> >> Am 31.01.24 um 10:20 schrieb Kenren Taisho (toushin.tai...@gmail.com):
> >>> Hello.
> >>> I am having issues migrating users to our SOGO server specifically
> >> because
> >>> of Outlook Calender issues. When using CaldavSyncronizer to sync the
> >>> Outlook Calendar entries to SOGO, we are experiencing the following
> error
> >>> from CaldavSyncronizer:
> >>>
> >>>
> >>
> CalDavSynchronizer.DataAccess.WebDavClientException:
>  Response status code does not indicate success: '412' ('Precondition
>  Failed'). Message:
>  ?xml version="1.0" encoding="utf-8"?
> >>>
> >>>
> >>> Does anyone know what is the meaning of this error and how to solve it?
> >>>
> >>
> >> Usually you will get this error, if you try to import an event to which
> >> you were invited, while the original event of the owner/inviting person
> >> is not already there.
> >>
> >> You only can import the owner prior to the attedees, or repeat the
> >> import after the owner was imported.
> >>
> >>
> >> Kind regards,
> >> Christian Mack
> >>
>
> --
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung IT-Dienste Forschung, Lehre, Infrastruktur
> 78457 Konstanz
> +49 7531 88-4416
>
>

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

2024-02-01 Thread Bits 'n Tricks


On Tue, Jan 30, 2024 at 9:19 PM Bits 'n Tricks  wrote:


Hi,

it came from /var/log/sogo/sogo.log:

ERROR: Table 'sogo.sogo_users' doesn't exist


PS: I hate to-posting!

In one of my setups, I have these definitions in sogo.conf:

/* Database Configuration */
SOGoProfileURL = "mysql://sogou:/* Database Configuration */ 
SOGoProfileURL = 
"mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile [1]";
OCSFolderInfoURL = 
"mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info [2]";
OCSSessionsFolderURL = 
"mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder 
[3]";
OCSEMailAlarmsFolderURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder 
[4]";


OCSStoreURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_store 
[5]";
OCSAclURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl 
[6]";
OCSCacheFolderURL="mysql://sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder 
[7]";


Looking at the exim4u DB:

```
root@localhost [exim4u]> show tables;
++
| Tables_in_exim4u   |
++
| blocklists |
| domainalias|
| domains|
| group_contents |
| ml |
| mygroups   |
| sogo_acl   |
| sogo_alarms_folder |
| sogo_auth_view |
| sogo_cache_folder  |
| sogo_folder_info   |
| sogo_quick_appointment |
| sogo_quick_contact |
| sogo_sessions_folder   |
| sogo_store |
| sogo_user_profile  |
| users  |
++
```

As you can see, there's nothing like sogo_users table in the DB!

If you need more help, I will do that, but only IF you do not top-post!

--

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions: 
http://www.catb.org/~esr/faqs/smart-questions.html]


Bottom postingi in HTML mails is not ideal, that's why I don't do it 
usually.
Anyway, I have only one occurrence in the sogo.conf file and it is 
this:


viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";

But it is also in my other serverwhich does work with that config and 
it also has the sogo_users table ...


BC



Links:
--
[1] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_user_profile
[2] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_folder_info
[3] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_sessions_folder
[4] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_alarms_folder
[5] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_store
[6] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_acl
[7] http://sogou:XX@127.0.0.1:3306/exim4u/sogo_cache_folder

[SOGo] BTS activities for Thursday, February 01 2024

Re: [SOGo] SOGo 5.9.0 could not load product

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

Re: [SOGo] ActiveSync Error

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

Re: [SOGo] Sync outlook calendar to SOGO error

Re: [SOGo] Table 'sogo.sogo_users' doesn't exist

8 matches

Site Navigation

Mail list logo

Footer information