date:20240123

Re: [SOGo] SOGo Documentation for the version that uses nginx

2024-01-23 Thread Odhiambo Washington

😂 Karibu sana ndugu.
I'm very glad to hear that I helped.

On Tue, Jan 23, 2024, 21:00 "Michael Callum Mayaka"  wrote:

> Thank you, it seems that's the way I'd installed it - you've solved my
> issue, and glad do see a fellow Kenyan (though I'm based in London).
> Asante sana, mukubwa
>
> On Tuesday, January 23, 2024 15:48 GMT, "Odhiambo Washington" (
> odhia...@gmail.com)  wrote:
>
>
>
>
> On Tue, Jan 23, 2024 at 6:35 PM "Michael"  wrote:
>
>> Hello,
>>
>> I am running SOGo on a Debian 11 server, and when I installed it I used a
>> package I can't seem to find now which required a separate server and
>> installed SOGo and all the associated packages with nginx as the web
>> server,
>> rather than Apache2.  I am trying to find documentation as I need to
>> reconfigure my SSL certificates after changing domain names, and need
>> Exchange
>> ActiveSync to work (I need users to be able to connect and sync on their
>> devices and desktop apps with no SSL/certificate errors.
>>
>> I would be most grateful if anyone could point me in the right direction
>> or
>> give me advice how to do this.
>>
>> Kind regards,
>>
>> Michael
>
>
> Borrow from iRedmail -
> https://forum.iredmail.org/topic19176-iredmail-nginx-proxy-problem-with-sogo-log-in.html
>
>
> --
> 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] SOGo Documentation for the version that uses nginx

2024-01-23 Thread "Michael Callum Mayaka"


Thank you, it seems that's the way I'd installed it - you've solved my issue, 
and glad do see a fellow Kenyan (though I'm based in London).  Asante sana, 
mukubwa

On Tuesday, January 23, 2024 15:48 GMT, "Odhiambo Washington" 
(odhia...@gmail.com)  wrote:
   On Tue, Jan 23, 2024 at 6:35 PM "Michael"  wrote:Hello,

I am running SOGo on a Debian 11 server, and when I installed it I used a
package I can't seem to find now which required a separate server and
installed SOGo and all the associated packages with nginx as the web server,
rather than Apache2.  I am trying to find documentation as I need to
reconfigure my SSL certificates after changing domain names, and need Exchange
ActiveSync to work (I need users to be able to connect and sync on their
devices and desktop apps with no SSL/certificate errors.

I would be most grateful if anyone could point me in the right direction or
give me advice how to do this.

Kind regards,

Michael Borrow from iRedmail - 
https://forum.iredmail.org/topic19176-iredmail-nginx-proxy-problem-with-sogo-log-in.html
  -- 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] SOGo Documentation for the version that uses nginx

2024-01-23 Thread Odhiambo Washington

On Tue, Jan 23, 2024 at 6:35 PM "Michael"  wrote:

> Hello,
>
> I am running SOGo on a Debian 11 server, and when I installed it I used a
> package I can't seem to find now which required a separate server and
> installed SOGo and all the associated packages with nginx as the web
> server,
> rather than Apache2.  I am trying to find documentation as I need to
> reconfigure my SSL certificates after changing domain names, and need
> Exchange
> ActiveSync to work (I need users to be able to connect and sync on their
> devices and desktop apps with no SSL/certificate errors.
>
> I would be most grateful if anyone could point me in the right direction or
> give me advice how to do this.
>
> Kind regards,
>
> Michael
>

Borrow from iRedmail -
https://forum.iredmail.org/topic19176-iredmail-nginx-proxy-problem-with-sogo-log-in.html


-- 
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]

[SOGo] SOGo Documentation for the version that uses nginx

2024-01-23 Thread "Michael"

Hello,

I am running SOGo on a Debian 11 server, and when I installed it I used a
package I can't seem to find now which required a separate server and
installed SOGo and all the associated packages with nginx as the web server,
rather than Apache2.  I am trying to find documentation as I need to
reconfigure my SSL certificates after changing domain names, and need Exchange
ActiveSync to work (I need users to be able to connect and sync on their
devices and desktop apps with no SSL/certificate errors.

I would be most grateful if anyone could point me in the right direction or
give me advice how to do this.

Kind regards,

Michael

[SOGo] import additional .ttf for custom fonts

2024-01-23 Thread International Security Providers

hey there

is it somehwo possible to inlcude custom .ttf files to add additional fonts?

I am looking to integrate google hind, so maybe there' salso a way to integrate 
it by referencing their public source:

@import 
url('https://fonts.googleapis.com/css2?family=Hind:wght@300&display=swap');
BR

RE: [SOGo] ActiveSync Question Update

2024-01-23 Thread "Robert Himics"

And Here is another Block with errors

2024-01-22 23:06:25.279 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d';

2024-01-22 23:06:25.280 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.281 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HAJkaXNwbGF5TmFtZQAGSU5CT1gAAA==');

2024-01-22 23:06:25.281 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value

Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af8ed9b0[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder8
79a9b26eb22ac65c60ea739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d'
in sogo_cache_folder:  NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value

2024-01-22 23:06:25.283 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d';

2024-01-22 23:06:25.283 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.284 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HQJkaXNwbGF5TmFtZQAHRHJhZnRzAAA=');

2024-01-22 23:06:25.285 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value

Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af748410[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder7
65ed91e067dac65b416a739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d'
in sogo_cache_folder:  NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value

2024-01-22 23:06:25.286 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d';

2024-01-22 23:06:25.287 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.287 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'GwJkaXNwbGF5TmFtZQAFU2VudAAA');


Is Something missing in the Database Cofiguration

or Due to the First Error c_uid is Not being Retrieved right 


My sogo User table is a View Based on the Dovecot users table

++--+--+-+-+---+

| Field  | Type | Null | Key | Default | Extra |

++--+--+-+-+---+

| c_uid  | varchar(100) | NO   | | NULL|   |

| c_name | varchar(100) | NO   | | NULL|   |

| c_cn   | varchar(120) | NO   | | NULL|   |

| c_password | varchar(64)  | NO   | | NULL|   |

| mail   | varchar(100) | NO   | | NULL|   |

++--+--+-+-+---+

 

 

Robert Himics 
  r...@himicsfamily.com

 

From: "Robert Himics"
 
Sent: Monday, January 22, 2024 11:26 PM
To: users@sogo.nu
Subject: RE: ActiveSync Question ** Update **

 

After turning on active Sync Logging I see an Error that Repeats

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established
0x0x5609af69d250

2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel
openChannel]: 
opens channel count[0]

2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600
opened (connection=0x0x5609af69d250,grpware)

2024-01-22 23:06:23.009 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
o

RE: [SOGo] ActiveSync Question Update

2024-01-23 Thread "Robert Himics"

After turning on active Sync Logging I see an Error that Repeats

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established
0x0x5609af69d250

2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel
openChannel]: 
opens channel count[0]

2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600
opened (connection=0x0x5609af69d250,grpware)

2024-01-22 23:06:23.009 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.009757 seconds to
execute

Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.013 - - 256K - 11

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.122 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_familyhome WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.123 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:23.123 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_dmfamilyhome
WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.124 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.004947 seconds to
execute

Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.007 - - 0 - 11

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'POST' on uri
'/SOGo/Microsoft-Server-ActiveSync?Cmd=FolderSync&User=em...@domain.net&Devi
ceId=641E1A9E3AD644BC89A235F3906A60F5&DeviceType=WindowsOutlook15'

2024-01-22 23:06:23.141 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domaine WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.143 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

2024-01-22 23:06:23.145 sogod[16188:16188]  SQL: SELECT count(*) FROM
sogo_cache_folder_email_A_domain_D_net;

2024-01-22 23:06:23.146 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609aef83ac0[SOGoActiveSyncDispatcher]>
EAS - request for device 641E1A9E3AD644BC89A235F3906A60F5: 

http://www.microsoft.com/>



0



 

 

I have scrubbed any IP Addresses / Email Addresses from Log Extract

 

Robert Himics 
  r...@himicsfamily.com

 

From: "Robert Himics"
 
Sent: Monday, January 22, 2024 10:39 PM
To: users@sogo.nu
Subject: RE: ActiveSync Question

 

Question:

 

Trying to Configure ActiveSync to connect Through Microsoft Office 365.

 

I don't see any outright Errors in the Log



I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed
from the inbox.

I know there are Email Present can Log into the web UI to see emails.

 

I have tried on Multiple PCs Running Microsoft Office 365.

 

Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm

 

Robert Himics 
  r...@himicsfamily.com

RE: [SOGo] ActiveSync Question

2024-01-23 Thread "Robert Himics"

Question:

 

Trying to Configure ActiveSync to connect Through Microsoft Office 365.

 

I don't see any outright Errors in the Log



I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed
from the inbox.

I know there are Email Present can Log into the web UI to see emails.

 

I have tried on Multiple PCs Running Microsoft Office 365.

 

Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm

 

Robert Himics 
  r...@himicsfamily.com

Re: [SOGo] SOGo Documentation for the version that uses nginx

Re: [SOGo] SOGo Documentation for the version that uses nginx

Re: [SOGo] SOGo Documentation for the version that uses nginx

[SOGo] SOGo Documentation for the version that uses nginx

[SOGo] import additional .ttf for custom fonts

RE: [SOGo] ActiveSync Question Update

RE: [SOGo] ActiveSync Question Update

RE: [SOGo] ActiveSync Question

8 matches

Site Navigation

Mail list logo

Footer information