Re: [SOGo] SOGo starting, but with a ton of errors

[Odhiambo Washington]

On Mon, 18 Feb 2019 at 22:01, Ludovic Marcotte  wrote:

> On 2019-02-18 2:11 a.m., Odhiambo Washington (odhia...@gmail.com) wrote:
>
> > 2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION:  > 0x80ba0f558> NAME:NSInvalidArgumentException
> > REASON:[NSString+stringWithString:]: NULL string INFO:(null)
> Upgrade SOPE packages using the nightly builds.
>

Since this is FreeBSD ports being used that is impossible - if I need a
clean system.
Both sope and sogo are currently on version 4.0.4 in both FreeBSD ports as
well as the packages.

I just need to figure out what I broke the last time I upgraded all ports.

As Gordon Messmer points out, I think there is something that messed up the
libraries.
This system was working well - even better than one I have running on
Ubuntu.


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Odhiambo Washington]

On Mon, 18 Feb 2019 at 22:24, Gordon Messmer  wrote:

> On 2/17/19 11:11 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:
> > Feb 18 10:05:00 sogod [33719]: 41.215.134.216 "POST
> > /SOGo/so/ictsupp...@mydomain.name/Mail/unseenCount
> >  HTTP/1.1" 200 21/31
> > 0.763 - - -
> > 2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION:  > 0x80ba0f558> NAME:NSInvalidArgumentException
> > REASON:[NSString+stringWithString:]: NULL string INFO:(null)
>
>
> I saw a similar error last year when an error in my build process caused
> SOGo to update, while SOPE did not.  I'd venture to guess that either
> you have multiple versions of some library installed and the linker is
> locating the wrong one, or you've updated your application but not your
> supporting libraries.
>

That is highly likely the reason.


>
> It might be easier to troubleshoot if you started with a clean system
> and installed from scratch there.
>

I might, but not now. Luckily, I have an alternative webmail suite if any
user wanted it,
but again, no one on this system uses webmail, so I am safe as I try to
figure this out.


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Gordon Messmer]

On 2/17/19 11:11 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:
Feb 18 10:05:00 sogod [33719]: 41.215.134.216 "POST 
/SOGo/so/ictsupp...@mydomain.name/Mail/unseenCount 
 HTTP/1.1" 200 21/31 
0.763 - - -
2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION: 0x80ba0f558> NAME:NSInvalidArgumentException 
REASON:[NSString+stringWithString:]: NULL string INFO:(null)



I saw a similar error last year when an error in my build process caused 
SOGo to update, while SOPE did not.  I'd venture to guess that either 
you have multiple versions of some library installed and the linker is 
locating the wrong one, or you've updated your application but not your 
supporting libraries.


It might be easier to troubleshoot if you started with a clean system 
and installed from scratch there.


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Ludovic Marcotte]

On 2019-02-18 2:11 a.m., Odhiambo Washington (odhia...@gmail.com) wrote:

2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION: 0x80ba0f558> NAME:NSInvalidArgumentException 
REASON:[NSString+stringWithString:]: NULL string INFO:(null)

Upgrade SOPE packages using the nightly builds.

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  https://inverse.ca
Inverse inc. :: Leaders behind SOGo (https://sogo.nu), PacketFence 
(https://packetfence.org) and Fingerbank (https://fingerbank.org)

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

Re: [SOGo] SOGo starting, but with a ton of errors

[Odhiambo Washington]

On Sun, 17 Feb 2019 at 15:09, Gordon Messmer  wrote:

> On 2/11/19 11:37 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:
> > That is where I am at the moment. Webmail does NOT load the e-mails
> > and I am not sure I can tell what is causing it.
>
>
> If you watch the log ("tail -f /var/log/sogo/sogo.log" here) as you
> select the item in the mailbox, what do you see?  I see something like:
>
> Feb 16 19:09:51 sogod [6088]: 10.1.10.163 "GET
> /SOGo/so/gordon/Mail/0/folderINBOX/314323/view HTTP/1.1" 200 739/0 0.931
> - - 12K
>
> The server should log any errors to that file.
>
>

Here is what I see:
Feb 18 10:04:06 sogod [33719]: <0x0x80fc39228[WOHttpAdaptor]> notified the
watchdog that we are ready
Feb 18 10:04:45 sogod [33719]: <0x0x80e6dce68[SOGoCache]> Cache cleanup
interval set every 360.00 seconds
Feb 18 10:04:45 sogod [33719]: <0x0x80e6dce68[SOGoCache]> Using host(s)
'127.0.0.1' as server(s)
Feb 18 10:04:46 sogod [33719]: 41.215.134.216 "GET /SOGo HTTP/1.1" 302 0/0
0.226 - - -
Feb 18 10:04:46 sogod [33719]: 41.215.134.216 "GET /SOGo/ HTTP/1.1" 200
6709/0 0.017 22296 69% -
Feb 18 10:04:55 sogod [33719]: SOGoRootPage successful login from
'41.215.134.216' for user 'ictsupp...@mydomain.name' - expire = -1  grace =
-1
Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]>
entry '{DAV:}write' already exists in DAV permissions table
Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]>
entry '{DAV:}write-properties' already exists in DAV permissions table
Feb 18 10:04:55 sogod [33719]: [WARN] <0x0x80bae45a8[SOGoWebDAVAclManager]>
entry '{DAV:}write-content' already exists in DAV permissions table
Feb 18 10:04:55 sogod [33719]: 41.215.134.216 "POST /SOGo/connect HTTP/1.1"
200 60/83 0.084 - - -
Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/
ictsupp...@mydomain.name HTTP/1.1" 302 0/0 0.004 - - -
Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/
ictsupp...@mydomain.name/view HTTP/1.1" 302 0/0 0.007 - - -
Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/so/
ictsupp...@mydomain.name/Mail HTTP/1.1" 302 0/0 0.004 - - -
Feb 18 10:04:56 sogod [33719]: 41.215.134.216 "GET /SOGo/so/
ictsupp...@mydomain.name/Mail/view HTTP/1.1" 200 18389/0 0.147 78650 76% -
Feb 18 10:04:57 sogod [33719]: 41.215.134.216 "GET /SOGo/so/
ictsupp...@mydomain.name/Calendar/alarmslist?browserTime=1550473570
HTTP/1.1" 200 63/0 0.007 - - -
Feb 18 10:04:57 sogod [33719]: 41.215.134.216 "GET /SOGo/so/
ictsupp...@mydomain.name/Mail/0/view HTTP/1.1" 200 836/0 0.762 - - -
Feb 18 10:04:59 sogod [33719]: 41.215.134.216 "POST /SOGo/so/
ictsupp...@mydomain.name/Mail/0/folderINBOX/view HTTP/1.1" 200 6161/48
1.229 - - -
Feb 18 10:05:00 sogod [33719]: 41.215.134.216 "POST /SOGo/so/
ictsupp...@mydomain.name/Mail/unseenCount HTTP/1.1" 200 21/31 0.763 - - -
2019-02-18 10:05:03.908 sogod[33719:100397] EXCEPTION:  NAME:NSInvalidArgumentException
REASON:[NSString+stringWithString:]: NULL string INFO:(null)
Feb 18 10:05:03 sogod [33719]: 41.215.134.216 "GET /SOGo/so/
ictsupp...@mydomain.name/Mail/0/folderINBOX/24/view HTTP/1.1" 501 0/0 0.885
- - -



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

Re: [SOGo] SOGo starting, but with a ton of errors

[Gordon Messmer]

On 2/11/19 11:37 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:
That is where I am at the moment. Webmail does NOT load the e-mails 
and I am not sure I can tell what is causing it.



If you watch the log ("tail -f /var/log/sogo/sogo.log" here) as you 
select the item in the mailbox, what do you see?  I see something like:


Feb 16 19:09:51 sogod [6088]: 10.1.10.163 "GET 
/SOGo/so/gordon/Mail/0/folderINBOX/314323/view HTTP/1.1" 200 739/0 0.931 
- - 12K


The server should log any errors to that file.


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Odhiambo Washington]

I doubt that is the problem.
I dropped all the sogo_* tables from my DB, except the sogo_auth_view,
which is created from my users table.
There is no /usr/share/doc/sogo:
[wash@waridi ~]$ ls -al  /usr/share/doc/
total 60
drwxr-xr-x  15 root  wheel   512 Jan 10  2017 .
drwxr-xr-x  32 root  wheel  1024 Mar 18  2018 ..
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 IPv6
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 atf
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 atm
drwxr-xr-x   3 root  wheel   512 Mar 18  2018 bind9
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 legal
drwxr-xr-x   3 root  wheel   512 Oct  8 22:45 llvm
drwxr-xr-x   2 root  wheel   512 Oct  8 22:44 ncurses
drwxr-xr-x   7 root  wheel  2560 Oct  8 22:46 ntp
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 papers
drwxr-xr-x   2 root  wheel   512 Oct  8 22:45 pjdfstest
drwxr-xr-x  22 root  wheel   512 Oct  8 22:45 psd
drwxr-xr-x  13 root  wheel   512 Oct  8 22:45 smm
drwxr-xr-x  15 root  wheel   512 Oct  8 22:45 usd

Similarly:
[wash@waridi ~]$ sudo find /usr/ -type d -name "sogo"
Password:
/usr/local/etc/sogo
/usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/Versions/4/sogo
/usr/local/GNUstep/Local/Library/Frameworks/SOGo.framework/sogo
/usr/local/GNUstep/Local/Library/Libraries/sogo

So, the files could be elsewhere, but I am still not sure I need any sql
update scripts, especially because I am only using
sogo-4.0.4 since 4.0.5 has not yet hit the FreeBSD ports. I am not
compiling manually, but using the ports.

My problem still lives :-)

Allow me to digress a little. Today while thinking about SOGo, I was
wondering why the developers cannot let us define custom
SQL queries within sogo.conf. For example, in my case I have to create a
view of my users table to be used by SOGo wherea
I could easily craft the queries dependent on my table structure.
The sogo_auth_view comprises a very small subset of the
columns that exist on my users table.

With the ability to define custom queries inside sogo.conf, I could only
use select X as A, Y as B from db.tableetc so that I do not have to
rely on a view. This would help with SOGoPasswordChangeEnabled  option to
operate directly on the main table instead of on the view.

root@localhost [exim4u]> desc sogo_auth_view;
+-+--+--+-+-+---+
| Field   | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| sogo_id | int(10) unsigned | NO   | | 0   |   |
| c_uid   | varchar(255) | NO   | | |   |
| c_name  | varchar(255) | NO   | | |   |
| c_password  | varchar(256) | YES  | | NULL|   |
| c_cn| varchar(255) | YES  | | NULL|   |
| mail| varchar(255) | NO   | | |   |
| displayName | varchar(255) | YES  | | NULL|   |
+-+--+--+-+-+---+
7 rows in set (0.25 sec)

root@localhost [exim4u]> desc users;
+--+-+--+-+-++
| Field| Type
  | Null | Key | Default | Extra  |
+--+-+--+-+-++
| user_id  | int(10) unsigned
  | NO   | PRI | NULL| auto_increment |
| domain_id| mediumint(8) unsigned
 | NO   | | 0   ||
| localpart| varchar(192)
  | NO   | MUL | ||
| username | varchar(255)
  | NO   | | ||
| clear| varchar(255)
  | YES  | | NULL||
| crypt| varchar(256)
  | YES  | | NULL||
| uid  | smallint(5) unsigned
  | NO   | | 65534   ||
| gid  | smallint(5) unsigned
  | NO   | | 65534   ||
| smtp | varchar(255)
  | YES  | | NULL||
| pop  | varchar(255)
  | YES  | | NULL||
| type |
enum('local','alias','catch','fail','piped','admin','site') | NO   | |
local   ||
| admin| tinyint(1)
  | NO   | | 0   ||
| on_avscan| tinyint(1)
  | NO   | | 0   ||
| on_blocklist | tinyint(1)
  | NO   | | 0   ||
| on_complexpass   | tinyint(1)
  | NO   | | 0   ||
| on_forward   | tinyint(1)
  | NO   | | 0   ||
| on_piped | tinyint(1)
  | NO   | | 0   ||
| on_spamassassin  | tinyint(1)
  | NO   | | 0   ||
| on_vacation  | tinyint(1)
  | NO   | | 0   ||
| enabled

Re: [SOGo] SOGo starting, but with a ton of errors

[Christian Mack]

Hello

There should be no breakage.
But you have to check, if there exists any sql update scripts between
the version you came from to the one you just installed.

Check /usr/share/doc/sogo/


Kind regards,
Christian Mack

Am 12.02.19 um 08:37 schrieb Odhiambo Washington (odhia...@gmail.com):
> Hello Gordon,
> 
> True, I was updating a previous install. How things got broken is what
> surprised me.
> After some clues, I was able to delete some rogue libraries, reinstalled
> all the SOGo related bits (sogo4, sope4, gnustep-make, gnustep-base)
> and now I am able to get sogod running again.
> The thing is, in FreeBSD we can do `portupgrade -a` to update all installed
> packages, like they do 'apt update && apt upgrade' in Linux.
> Somewhere in between, something might break for some reason, no?
> That is where I am at the moment. Webmail does NOT load the e-mails and I
> am not sure I can tell what is causing it.
> 
> 
> 
> 
> On Tue, 12 Feb 2019 at 07:29, Gordon Messmer  wrote:
> 
>> On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote:
>>> I thought SOGo is supposed to create the tables sogo_* itself.
>>
>>
>> I'm a little unclear on where you're at with your installation. I
>> thought you were updating a previous install.  If this is a new install,
>> make sure the sogo user has the rights required to make the tables that
>> it's complaining about.
>>
>>
>> --
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
>>
> 
> 


-- 
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] SOGo starting, but with a ton of errors

[Odhiambo Washington]

Hello Gordon,

True, I was updating a previous install. How things got broken is what
surprised me.
After some clues, I was able to delete some rogue libraries, reinstalled
all the SOGo related bits (sogo4, sope4, gnustep-make, gnustep-base)
and now I am able to get sogod running again.
The thing is, in FreeBSD we can do `portupgrade -a` to update all installed
packages, like they do 'apt update && apt upgrade' in Linux.
Somewhere in between, something might break for some reason, no?
That is where I am at the moment. Webmail does NOT load the e-mails and I
am not sure I can tell what is causing it.




On Tue, 12 Feb 2019 at 07:29, Gordon Messmer  wrote:

> On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote:
> > I thought SOGo is supposed to create the tables sogo_* itself.
>
>
> I'm a little unclear on where you're at with your installation. I
> thought you were updating a previous install.  If this is a new install,
> make sure the sogo user has the rights required to make the tables that
> it's complaining about.
>
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Gordon Messmer]

On 2/10/19 12:01 AM, Odhiambo Washington" (odhia...@gmail.com) wrote:

I thought SOGo is supposed to create the tables sogo_* itself.



I'm a little unclear on where you're at with your installation. I 
thought you were updating a previous install.  If this is a new install, 
make sure the sogo user has the rights required to make the tables that 
it's complaining about.



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

Re: [SOGo] SOGo starting, but with a ton of errors

[Odhiambo Washington]

I thought SOGo is supposed to create the tables sogo_* itself.


On Sun, 10 Feb 2019 at 02:12, Gordon Messmer  wrote:

> On 2/8/19 2:32 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:
> > I am wondering what else I have messed up this time round:
>
>
> Rather than looking at the log as a whole, let's look at errors from
> just one PID:
>
>
> Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load
> product: ContactsUI
> Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load
> product: SchedulerUI
>
> Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_user_profile' creation
> failed! Reason:  NAME:ExecutionFailed
> REASON:Table 'exim4u.sogo_user_profile' doesn't exist
> Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_folder_info' creation
> failed! Reason:  NAME:ExecutionFailed
> REASON:Table 'exim4u.sogo_folder_info' doesn't exist
> Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_store' creation
> failed! Reason:  NAME:ExecutionFailed
> REASON:Table 'exim4u.sogo_store' doesn't exist
> Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table
> 'sogo_quick_contact' creation failed! Reason:  0x80f960028> NAME:ExecutionFailed REASON:Table
> 'exim4u.sogo_quick_contact' doesn't exist
> Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table
> 'sogo_quick_appointment' creation failed! Reason:  0x80f9733d8> NAME:ExecutionFailed REASON:Table
> 'exim4u.sogo_quick_appointment' doesn't exist
>
>
> The first thing I'd check is your SQL configuration.  Make sure those
> tables exist, and make sure the sogo user can access them.
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>


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

Re: [SOGo] SOGo starting, but with a ton of errors

[Gordon Messmer]

On 2/8/19 2:32 PM, Odhiambo Washington" (odhia...@gmail.com) wrote:

I am wondering what else I have messed up this time round:



Rather than looking at the log as a whole, let's look at errors from 
just one PID:



Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load 
product: ContactsUI
Feb 09 01:24:07 sogod [43868]: [so-product-registry] could not load 
product: SchedulerUI


Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_user_profile' creation 
failed! Reason:  NAME:ExecutionFailed 
REASON:Table 'exim4u.sogo_user_profile' doesn't exist
Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_folder_info' creation 
failed! Reason:  NAME:ExecutionFailed 
REASON:Table 'exim4u.sogo_folder_info' doesn't exist
Feb 09 01:24:07 sogod [43868]: |SOGo| table 'sogo_store' creation 
failed! Reason:  NAME:ExecutionFailed 
REASON:Table 'exim4u.sogo_store' doesn't exist
Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table 
'sogo_quick_contact' creation failed! Reason: 0x80f960028> NAME:ExecutionFailed REASON:Table 
'exim4u.sogo_quick_contact' doesn't exist
Feb 09 01:24:07 sogod [43868]: |SOGo| sogo quick table 
'sogo_quick_appointment' creation failed! Reason: 0x80f9733d8> NAME:ExecutionFailed REASON:Table 
'exim4u.sogo_quick_appointment' doesn't exist



The first thing I'd check is your SQL configuration.  Make sure those 
tables exist, and make sure the sogo user can access them.


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