Help! Cannot view users after 11.0.3 upgrade

[wolf7901]

After upgrading to the latest version of Scalix, I cannot view the users in the admin console. My FQDN entries match.

Any ideas?

[smellis]

Here is the log message I think is associated with our problem. Taken from scalix-caa.log

872 ERROR [GetMemberAccessGroupList.createSOAPResponseMessage:246]

Anyone have any ideas?

[ScalixSupport]

Hi!

Could you please reply with the result of the command:
omstat -a
omstat -s
ps ax | grep ldap
ps ax | grep post
rpm -qa | grep scalix

Also send the un-commented lines from the file:
/var/opt/scalix/??/postgres/data/pg_hba.conf

Do you get any error in catalina.<date>.log that you find in /var/opt/scalix/??/tomcat/logs folder when you try to access SAC?

Thanks,
Subir

[smellis]

Code: Select all

[root@mail-ng logs]# omstat -a
PC Monitor                    Started        NON-STOP       0
Directory Relay Server        Started        03:38:38       
Notification Server           Started        03:38:38       0
Shared memory daemon          Started        NON-STOP       
Notification Monitor          Started        NON-STOP       
Session Monitor               Started        NON-STOP       
Indexer                       Started        NON-STOP       
Stats Daemon                  Started        NON-STOP       
Container Access Monitor      Started        NON-STOP       
Item Structure Server         Stopped        01.15.07       
Database Monitor              Started        03:38:38       
Licence Monitor Daemon        Started        NON-STOP       
LDAP Daemon                   Started        03:38:38       
Queue Manager                 Started        NON-STOP       
Item Delete Daemon            Started        NON-STOP       
IMAP Server Daemon            Started        03:38:38       
SMTP Relay                    Started        03:38:38       
Mime Browser Controller       Started        03:38:38       
Event Server                  Started        03:38:38


Code: Select all

[root@mail-ng logs]# omstat -s
Service Router                Started        03:38:40       0         
Local Delivery                Started        03:38:40       0         
Internet Mail Gateway         Started        03:38:40       0         
Sendmail Interface            Started        03:38:40       0         
Local Client Interface        Enabled        03:38:40       0         
Remote Client Interface       Enabled        03:38:40       18       
Test Server                   Started        03:38:40       0         
Request Server                Started        03:38:40       0         
Print Server                  Started        03:38:40       0         
Directory Synchronization     Started        03:38:40       0         
Bulletin Board Server         Started        03:38:40       0         
Background Search Service     Started        03:38:40       0         
Dump Server                   Started        03:38:40       0         
CDA Server                    Started        03:38:40       0         
POP3 interface                Started        03:38:40       0         
Omscan Server                 Started        03:38:40       0         
Archiver                      Started        03:38:40       0   


Code: Select all

[root@mail-ng logs]# ps ax | grep ldap
23471 ?        Ss     2:27 /opt/scalix/bin/ldapmapper --pidfile /var/run/ldapmapper.pid
15976 pts/0    S+     0:00 grep ldap


Code: Select all

[root@mail-ng logs]# ps ax | grep post
28223 ?        S      0:16 /usr/bin/postmaster -i -h mail.esascorp.com -p 5733 -D /var/opt/scalix/mg/postgres/data -k /var/opt/scalix/mg/postgres/data
28225 ?        S      0:03 postgres: stats buffer process                                                                                             
28226 ?        S      0:03 postgres: stats collector process                                                                                         
16055 pts/0    S+     0:00 grep post


Code: Select all

[root@mail-ng logs]# rpm -qa | grep scalix
scalix-text-extractors-1.0-1.rhel4
scalix-res-11.0.3.31-1
scalix-mobile-11.0.3.31-1
scalix-tomcat-5.5.16-226
scalix-server-11.0.3.10719-1.rhel4
scalix-platform-11.0.3.31-1
scalix-swa-11.0.3.31-1
scalix-sis-11.0.3.31-1
scalix-tomcat-connector-11.0.3.31-1.rhel4
scalix-postgres-11.0.3.31-1
scalix-sac-11.0.3.31-1


Code: Select all

pg_hba.conf - Uncommented line

local  all    all             ident   sameuser


Also, I did not see any errors in the catalina.2007-04-16.log file after logging into the sac, Nor after changing the filter to scalix premium users, etc..

Thanks for the response!

[ScalixSupport]

Hi!

pg_hba.conf - Uncommented line

local all all ident sameuser

Scalix DB seems not to be fully configured, I would request you to add a line as shown
below to your pg_hba.conf file and restart scalix-postgres service.

local all all ident sameuser
# List of Scalix Platform hosts begins here
host scalix scalix 192.168.103.112/32 md5

Note: 192.168.103.112 is the IP address of my Scalix Server

Try logging into SAC again, see if you get the proper results.

Thanks,
Subir

[smellis]

I missed a couple of lines at the top:

Code: Select all

host    scalix      scalix      127.0.0.1/32   md5
host    scalix      scalix      192.168.0.40/32   md5


Still Nothing, any ideas?

Also, the scalix-caa.log show the same error, and the pgstartup.log show that the config is ok.

[ScalixSupport]

Hi!

Make sure that the file /etc/httpd/conf.d/scalix-tomcat-connector.conf has lines:

Code: Select all

Include /etc/opt/scalix-tomcat/connector/jk/instance-*.conf
Include /etc/opt/scalix-tomcat/connector/jk/workers.conf

Now check in the file /etc/opt/scalix-tomcat/connector/jk/instance-<your-instance>.conf file
has entries within the VirtualHost tags have lines that look like:

Code: Select all

Include /etc/opt/scalix-tomcat/connector/jk/app-subir-rhel4.*.conf

If you are feeling confused, send the contents of the files:
/etc/httpd/conf.d/scalix-tomcat-connector.conf, and
/etc/opt/scalix-tomcat/connector/jk/instance-<your-instance>.conf

Check if there is only one instance of Tomcat running on your server, by issuing the
command:

Code: Select all

ps ax | grep tomcat

If more than one instance of tomcat are running, kill each of them and start tomcat again,
see if this helps.

Thanks,
Subir

[smellis]

Hi Subir!

I just want to take a second to thank you for your help.

Ok, on to business:

I checked /etc/httpd/conf.d/scalix-tomcat-connector.conf and it does have the lines you were looking for.

I checked /etc/opt/scalix-tomcat/connector/jk/instance-mail-ng.conf, but it did not have the include you asked me to look for. I also inspected that directory, and there are no app-subdir-rhel4.*.conf files, at least not in the path of the include you provided. Could the installer failed to install those files?


Also, I checked and only one instance of tomcat is running.

Here is a directory listing:

Code: Select all

[root@mail-ng jk]# pwd
/etc/opt/scalix-tomcat/connector/jk
[root@mail-ng jk]# ls -a
.                     app-mail-ng.m.conf    app-mail-ng.webmail.conf
..                    app-mail-ng.res.conf  instance-mail-ng.conf
app-mail-ng.api.conf  app-mail-ng.sac.conf  workers.conf
app-mail-ng.caa.conf  app-mail-ng.sis.conf


Here is scalix-tomcat-connector.conf

Code: Select all

# ---------------------------------------------------------------------------
# Load deflate and JK modules used by Scalix:
# ---------------------------------------------------------------------------

<IfModule !mod_deflate.c>
LoadModule deflate_module modules/mod_deflate.so
</IfModule>

<IfModule !mod_jk.c>
LoadModule jk_module modules/mod_jk.so
</IfModule>

# ---------------------------------------------------------------------------
# Configure on-the-fly deflate compression of the pages:
# ---------------------------------------------------------------------------

<Location />
  AddOutputFilterByType DEFLATE text/xml text/html text/css
  AddOutputFilterByType DEFLATE application/x-javascript
</Location>

# ---------------------------------------------------------------------------
# mod_jk connector configuration (part common to all platforms)
# ---------------------------------------------------------------------------

# Setup JK connector needed to run Tomcat under Apache server:

<IfModule mod_jk.c>

# Set the jk log level [debug/error/info]
JkLogLevel          info
# Select the log format
JkLogStampFormat   "[%a %b %d %H:%M:%S %Y] "
# JkOptions indicate to send SSL KEY SIZE,
JkOptions          +ForwardKeySize +ForwardURICompat -ForwardDirectories
# JkRequestLogFormat set the request format
JkRequestLogFormat "%w %V %T"

Include /etc/opt/scalix-tomcat/connector/jk/instance-*.conf
Include /etc/opt/scalix-tomcat/connector/jk/workers.conf

</IfModule>

# ---------------------------------------------------------------------------
# mod_jk connector configuration (part specific to RedHat)
# ---------------------------------------------------------------------------

<IfModule mod_jk.c>
# Where to put jk logs
# Update this path to match your logs directory location
# (put mod_jk.log next to access_log)
JkLogFile     /var/log/httpd/mod_jk.log
</IfModule>


Here is instance-mail-ng.conf

Code: Select all

<VirtualHost mail.esascorp.com:80>
        Include /etc/opt/scalix-tomcat/connector/jk/app-mail-ng.*.conf
</VirtualHost>
<VirtualHost mail.esascorp.com:443>
       SSLEngine on

       SSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP
       SSLCertificateFile /etc/httpd/conf/ssl.crt/server.crt
       SSLCertificateKeyFile /etc/httpd/conf/ssl.key/server.key
       Include /etc/opt/scalix-tomcat/connector/jk/app-mail-ng.*.conf
</VirtualHost>
JkWorkerProperty worker.mail-ng.type=ajp13
JkWorkerProperty worker.mail-ng.host=mail-ng.esascorp.com
JkWorkerProperty worker.mail-ng.port=8009
JkWorkerProperty worker.mail-ng.lbfactor=50
JkWorkerProperty worker.mail-ng.cachesize=10
JkWorkerProperty worker.mail-ng.cache_timeout=600
JkWorkerProperty worker.mail-ng.socket_keepalive=1
JkWorkerProperty worker.mail-ng.recycle_timeout=300


Thanks again...

[ScalixSupport]

Hi!

Ok these files look fine to me.

and there are no app-subdir-rhel4.*.conf files

Actually I wanted to ask to look for app-<instance>.*.conf files, subir-rhel4 is instance
of my test server.

Anyways, can check if the result of the command:
omshowu -m all
give all existing users.

Do you see any error in error_log of Apache. Do you use Proxy in your network. Does SWA
work fine. Are you able to login there.

Thanks,
Subir

[smellis]

Hello Subir

Ok, omshowu -m all shows my users just fine.

The error_log (more specifically ssl_error_log) shows this line

Code: Select all

[Wed Apr 18 10:25:36 2007] [error] [client 192.168.0.40] File does not exist: /var/www/html/sis


Not sure if that is anything. Other than that line, nothing out of the ordinary, just a bunch of failures to find favicon.ico and such.

I don't use a proxy on my network, everyone just connects directly to the mail server for everything. SWA works, people can log in, however it is really slow since the upgrade.

What do you think? Thanks again!

[ScalixSupport]

Hi!

Have you tried restarting the Server, at times basics are done just by restarting the server,
use commands below to restart Scalix Server:

Code: Select all

omshut
omrc

Thanks,
Subir

[smellis]

OK, I will have to do that tonight. I will let you know what happens. -stephan

[smellis]

Hey Subir,

Still no luck after a reboot. Any other ideas?

[ScalixSupport]

Hi!

Check if changing default LDAP port helps:
http://www.scalix.com/wiki/index.php?ti ... t_from_389

Thanks,
Subir

[smellis]

Hello Subir!

I followed the howto, however it's still not working. One interesting thing I found was that /etc/sysconfig/ldapmapper has this:

LDAPMAPPER_OPTIONS=""


I put what the howto suggested, which is:

LDAPMAPPER_OPTIONS="-L ldap://%s:3890"

But no luck. Still doesn't work. Any other ideas? Thanks for the help thus far! have a great weekend.

-stephan