sxqueryadmin password expired

Discuss Scalix Management Services ( formerly Scalix Admin Console )

Moderator: ScalixSupport

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

sxqueryadmin password expired

Postby chrisj_0 » Fri May 19, 2006 5:20 pm

Hey,
is there a quick fix for this problem. I couldn't log into my SAC today and discovered that the password for the sxqueryadmin expired. I've followed the instruction to unlock the account and change the password. I really need access to this today and don't really have the time to upgrade scalix. where can I tell scalix/SAC about the new password?
Thanks,
chris

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Fri May 19, 2006 5:58 pm

Hi Chris,

What version of Scalix are you currently using?

Thanks,
Rachel

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Fri May 19, 2006 6:02 pm

10.0

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Fri May 19, 2006 8:05 pm

this is the bug in listed in the 10.0.1 release notes. I had been working with a vendor that was supposed to keep track of things like this, but hasn't.
Is my only fix to install the update? There has to be some way to let the system know that I've changed the password.

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Fri May 19, 2006 11:22 pm

Hi Chris,

So, first, can you post the output from omshowu -n sxqueryadmin. Next, what commands have you run already against the sxqueryadmin mailbox? What you need to do run is:

Code: Select all

ommodu -o sxqueryadmin -E -k


The -E unexpires the password the -k unlocks it (assuming it was locked).

Thanks,
Rachel

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 12:23 pm

I ran the ommodu -o sxqueryadmin -k
and then with -p to change the password. there were other posting on the problem that I looked up but didn't see one using the -E option.
I looked over the knowlegebase and didn't see anything.

Code: Select all

scalix:~ # omshowu -n sxqueryadmin
Authentication ID: sxqueryadmin_at_notanemail-scalix.sekoworldwide.com
User Name : sxqueryadmin /CN=sxqueryadmin
MailNode : scalix,sekoworldwide
Internet Address : sxqueryadmin-scalix_at_notanemail-sekoworldwide.com
System Login : 60534
Password : set
Admin Capabilities : YES
Mailbox Admin Capabilities : NO
Language : C
Virtual Vault : Enabled (default)
Mail Account: Unlocked
Last Signon : Never.
Receipt of mail : ENABLED
Service level : 0
Excluded from Tidying : NO
User Class : Limited

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Sat May 20, 2006 12:59 pm

Hi Chris,

Okay, since you've changed your password, the best route is to uninstall SAC, delete the sxqueryadmin account, then re-install SAC. You can do the uninstall/reinstall using the scalix-installer. You can delete sxqueryadmin by typing:

omdelu -n sxqueryadmin

when you do the reinstall of SAC, it will automatically recreate the sxqueryadmin account with the correct password.

Thanks,
Rachel

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 1:39 pm

Rachel,
I got a license error when reinstalling, during the creation of the sxqureyadmin user.

Code: Select all

2006-05-20 12:32:32,130 CRITICAL Operation failed: Web apps config function conf
igure_res failed: Failed to add "query admin" user sxqueryadmin_at_notanemailscalix.sekoworld
wide.com. /opt/scalix/bin/omaddu reported the following error: omaddu : [OM 8114
] Could not get a license to configure this user.


I can post the entire log if you'd like.
thanks,
chris
Last edited by chrisj_0 on Sat May 20, 2006 2:02 pm, edited 1 time in total.

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 1:58 pm

I checked the forum and saw this can happen if the license sever is not working.
omstat shows that it's running.

Code: Select all

scalix:~/scalix-core-intel-suse-10.0.0 # omstat -a
PC Monitor                    Started        NON-STOP       0
Directory Relay Server        Started        04.11.06
Notification Server           Started        04.11.06       0
Shared memory daemon          Started        NON-STOP
Notification Monitor          Started        NON-STOP
Session Monitor               Started        NON-STOP
Container Access Monitor      Started        NON-STOP
Item Structure Server         Stopped
Database Monitor              Started        04.11.06
Licence Monitor Daemon        Started        NON-STOP
LDAP Daemon                   Started        04.11.06
Queue Manager                 Started        NON-STOP
Item Delete Daemon            Started        NON-STOP
IMAP Server Daemon            Started        04.11.06
SMTP Relay                    Started        04.11.06
Mime Browser Controller       Started        04.11.06


what is the "Item Structure Server"??

thanks,
chris

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 2:36 pm

Rachel,
It looks like the sac was installed but without the sxqueryadmin user; the login page just hangs at "Attempting to Log In"...
we have an 800 user license for this server.
thanks,
chris

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Sat May 20, 2006 4:32 pm

Hi Chris,

Could you run sxlicense -u and verify that the system thinks you still have at least one premium license available. Assuming you do, go ahead and uninstall and reinstall SAC again as it should be able to create the sxqueryadmin login.

Thanks,
Rachel

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 4:34 pm

Rachel,
looks the license isn't being "seen" by the system.

Code: Select all

scalix:~/scalix-core-intel-suse-10.0.0 # sxlicense -u
   Scalix License Usage

Local Usage

  Premium Users:     17
  Standard Users:      1

Totals
  Premium Users:     17
  Standard Users:      1



I've already tried the install again but had no luck.
thanks,
chris

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Sat May 20, 2006 9:02 pm

Hi Chris,

That's not actually your license limits, it's the number of actual premium and standard users on your system. So, even if you were community edition, you would still have some room left to add the sxqueryadmin. Can you post the results from:

omsearch -e cn=sxqueryadmin -m @all-attr@ -v

and

omsearch -e cn=sxqueryadmin -m @all-attr@ -v -t h -d userlist

Could you also post the most recent /var/log/scalix-installer-xxxxxxx.log file?

Thanks,
Rachel

chrisj_0
Posts: 107
Joined: Mon Apr 17, 2006 4:47 pm

Postby chrisj_0 » Sat May 20, 2006 9:10 pm

Code: Select all

scalix:~ # omsearch -e cn=sxqueryadmin -m @all-attr@ -v
[OM 16954] Entry not in the Directory


Code: Select all

scalix:~ # omsearch -e cn=sxqueryadmin -m @all-attr@ -v -t h -d userlist
[OM 16954] Entry not in the Directory


and this is the most recent entry in the log.

Code: Select all

2006-05-20 13:18:28,770 INFO Packages installed: {'scalix-sac': ['10.0.0.354', '10135520', 'noarch', 'linux', '1', '(none)', '(none)'], 'scalix-res': ['10.0.0.354', '1898785', 'noarch', 'li
nux', '1', '(none)', '(none)'], 'scalix-server': ['10.0.0.175', '71254084', 'i586', 'linux', '1.sles9', 'SLES9', '(none)'], 'scalix-swa': ['10.0.0.343', '3708837', 'noarch', 'linux', '1', '
(none)', '(none)']}
2006-05-20 13:18:29,547 INFO Obsolete packages installed: {}
2006-05-20 13:18:54,624 INFO Operation passed: OS release check SUSE LINUX Enterprise Server 9 (i586)
2006-05-20 13:18:54,624 INFO Operation passed: Memory check 16111752
2006-05-20 13:18:54,625 INFO No Disk space check performed as scalix-server is already installed
2006-05-20 13:18:54,676 INFO Tomcat was running when we started: False
2006-05-20 13:18:56,814 INFO Saving installation directory: /root/scalix-core-intel-suse-10.0.0/software/scalix_server
2006-05-20 13:18:58,544 INFO Searching /root/scalix-core-intel-suse-10.0.0/software/scalix_server for relevant Scalix packages
2006-05-20 13:18:58,546 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-swa-10.0.0.343-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:18:58,546 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.sles9.i586.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:18:58,547 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:18:58,547 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-res-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:18:58,548 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:18:58,548 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:19:14,992 INFO Saving installation directory: /root/scalix-core-intel-suse-10.0.0/software/scalix_server
2006-05-20 13:19:16,720 INFO Searching /root/scalix-core-intel-suse-10.0.0/software/scalix_server for relevant Scalix packages
2006-05-20 13:19:16,721 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-swa-10.0.0.343-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:19:16,722 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.sles9.i586.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:19:16,722 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:19:16,723 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-res-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:19:16,723 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:19:16,723 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:19:27,807 INFO Ending CLI Scalix Installer - interrupted by user
2006-05-20 13:24:21,988 INFO Initializing Scalix Installer version 10.0.0.351
2006-05-20 13:24:22,113 INFO Platform is: SUSE LINUX Enterprise Server 9 (i586) on i386 : supported.
2006-05-20 13:24:22,113 INFO Starting Scalix Installer in CLI mode
2006-05-20 13:24:22,237 INFO Current locale is  and default is en_US
2006-05-20 13:24:22,563 INFO Packages installed: {'scalix-sac': ['10.0.0.354', '10135520', 'noarch', 'linux', '1', '(none)', '(none)'], 'scalix-res': ['10.0.0.354', '1898785', 'noarch', 'li
nux', '1', '(none)', '(none)'], 'scalix-server': ['10.0.0.175', '71254084', 'i586', 'linux', '1.sles9', 'SLES9', '(none)'], 'scalix-swa': ['10.0.0.343', '3708837', 'noarch', 'linux', '1', '
(none)', '(none)']}
2006-05-20 13:24:23,337 INFO Obsolete packages installed: {}
2006-05-20 13:24:36,319 INFO Tomcat was running when we started: True
2006-05-20 13:24:36,320 INFO Packages installed: {'scalix-sac': ['10.0.0.354', '10135520', 'noarch', 'linux', '1', '(none)', '(none)'], 'scalix-res': ['10.0.0.354', '1898785', 'noarch', 'li
nux', '1', '(none)', '(none)'], 'scalix-server': ['10.0.0.175', '71254084', 'i586', 'linux', '1.sles9', 'SLES9', '(none)'], 'scalix-swa': ['10.0.0.343', '3708837', 'noarch', 'linux', '1', '
(none)', '(none)']}
2006-05-20 13:24:43,773 INFO Components to uninstall: ['scalix-sac']
2006-05-20 13:24:45,264 INFO Java home directory is /usr/java/jre1.5.0_04
2006-05-20 13:24:45,265 INFO Tomcat home directory is /opt/scalix-tomcat
2006-05-20 13:24:46,220 INFO Stopped Tomcat using command /opt/scalix-tomcat/bin/shutdown.sh
2006-05-20 13:24:49,265 INFO Tomcat is stopped True
2006-05-20 13:24:49,362 INFO Uninstall start
2006-05-20 13:24:49,362 INFO Starting uninstallation of scalix-sac
2006-05-20 13:24:49,436 INFO Operation passed: Uninstall /bin/rpm -e scalix-sac: (0) ['']
2006-05-20 13:24:50,437 INFO Removing the directory /etc/opt/scalix and empty subdirectories
2006-05-20 13:24:50,440 INFO Cleaning up Tomcat working directory and cache (CATALINA_HOME= /opt/scalix-tomcat )
2006-05-20 13:24:50,440 INFO Removing Tomcat directory /opt/scalix-tomcat/webapps/caa
2006-05-20 13:24:50,451 INFO Removing Tomcat directory /opt/scalix-tomcat/work/Catalina/localhost/caa
2006-05-20 13:24:50,452 INFO Removing Tomcat directory /opt/scalix-tomcat/webapps/sac
2006-05-20 13:24:50,534 INFO Removing Tomcat directory /opt/scalix-tomcat/work/Catalina/localhost/sac
2006-05-20 13:24:50,536 INFO Removing Tomcat context file /opt/scalix-tomcat/conf/Catalina/localhost/scalix-caa.xml
2006-05-20 13:24:50,536 INFO Removing Tomcat context file /opt/scalix-tomcat/conf/Catalina/localhost/scalix-admin.xml
2006-05-20 13:24:50,537 INFO Uninstall end
2006-05-20 13:24:50,610 INFO Tomcat is not running so cannot stop it
2006-05-20 13:25:00,197 INFO Initializing Scalix Installer version 10.0.0.351
2006-05-20 13:25:00,299 INFO Platform is: SUSE LINUX Enterprise Server 9 (i586) on i386 : supported.
2006-05-20 13:25:00,300 INFO Starting Scalix Installer in CLI mode
2006-05-20 13:25:00,424 INFO Current locale is  and default is en_US
2006-05-20 13:25:00,750 INFO Packages installed: {'scalix-res': ['10.0.0.354', '1898785', 'noarch', 'linux', '1', '(none)', '(none)'], 'scalix-server': ['10.0.0.175', '71254084', 'i586', 'l
inux', '1.sles9', 'SLES9', '(none)'], 'scalix-swa': ['10.0.0.343', '3708837', 'noarch', 'linux', '1', '(none)', '(none)']}
2006-05-20 13:25:01,529 INFO Obsolete packages installed: {}
2006-05-20 13:25:12,793 INFO Operation passed: OS release check SUSE LINUX Enterprise Server 9 (i586)
2006-05-20 13:25:12,793 INFO Operation passed: Memory check 16111752
2006-05-20 13:25:12,794 INFO No Disk space check performed as scalix-server is already installed
2006-05-20 13:25:12,845 INFO Tomcat was running when we started: False
2006-05-20 13:25:14,003 INFO Saving installation directory: /root/scalix-core-intel-suse-10.0.0/software/scalix_server
2006-05-20 13:25:15,725 INFO Searching /root/scalix-core-intel-suse-10.0.0/software/scalix_server for relevant Scalix packages
2006-05-20 13:25:15,727 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-swa-10.0.0.343-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:25:15,728 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.sles9.i586.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:25:15,728 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:25:15,729 INFO File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-res-10.0.0.354-1.noarch.rpm is a Scalix file, for this platform and valid version
2006-05-20 13:25:15,729 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:25:15,730 WARNING File /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-server-10.0.0.175-1.suse100.i586.rpm is not for this platform
2006-05-20 13:25:24,478 INFO Components selected to install: {'scalix-sac': ['10.0.0.354', '10135520', 'noarch', 'linux', '1', '(none)', '(none)', '/root/scalix-core-intel-suse-10.0.0/softw
are/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm']}
2006-05-20 13:25:24,479 INFO Components to upgrade: {}
2006-05-20 13:25:24,479 INFO System check start
2006-05-20 13:25:24,479 INFO Operation passed: Environment check passed.
2006-05-20 13:25:24,480 INFO Operation passed: Filesystem check passed.
2006-05-20 13:25:24,525 INFO Network interface is  eth0
2006-05-20 13:25:24,531 INFO Operation passed: Network check passed.
2006-05-20 13:25:24,708 INFO Apache 2.x appears to be installed.
2006-05-20 13:25:24,708 INFO Operation passed: Dependency check passed.
2006-05-20 13:25:24,709 INFO Operation passed: Running services check passed.
2006-05-20 13:25:24,709 INFO System check end
2006-05-20 13:25:24,709 INFO System check result: 0
2006-05-20 13:25:26,860 INFO Install start
2006-05-20 13:25:27,031 INFO Starting installation of RPM files [('/root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm', 'scalix-sac')]
2006-05-20 13:25:27,432 INFO Operation passed: Install /bin/rpm -U -v --percent /root/scalix-core-intel-suse-10.0.0/software/scalix_server/scalix-sac-10.0.0.354-1.noarch.rpm: (0) ['Preparin
g packages for installation...', 'scalix-sac-10.0.0.354-1', 'Scalix Administration Console (SAC) successfully installed.', 'Please configure Scalix Administration Console (SAC) using', 'the
 Scalix Installer for configuration.', 'Have fun!']
2006-05-20 13:25:27,433 INFO Checking if any deprecated packages are installed.
2006-05-20 13:25:27,535 INFO Install end
2006-05-20 13:25:37,193 INFO Setting JAVA_HOME environment variable to /usr/java/jre1.5.0_04
2006-05-20 13:25:42,025 INFO Getting generation rule: general.inet_domain_rule = sekoworldwide.com
2006-05-20 13:25:42,048 INFO inet_domain_rule domain sekoworldwide.com has a valid MX record so using it as default
2006-05-20 13:25:58,975 INFO Found permanent license file: /var/opt/scalix/LicenseKeys/permanent.lic
2006-05-20 13:25:58,976 INFO Found permanent license file: /var/opt/scalix/LicenseKeys/permanent.lic
2006-05-20 13:26:08,955 INFO Mailnode is scalix,sekoworldwide
2006-05-20 13:26:09,231 INFO Cleaning up Tomcat working directory and cache (CATALINA_HOME= /opt/scalix-tomcat )
2006-05-20 13:26:09,232 INFO Configuring SAC...
2006-05-20 13:26:09,301 INFO Mailnode is scalix,sekoworldwide
2006-05-20 13:26:09,302 INFO Server's existing mailnode is scalix,sekoworldwide
2006-05-20 13:26:09,478 INFO Configuring / installing SAC
2006-05-20 13:26:09,504 INFO Configuring RES...
2006-05-20 13:26:09,747 INFO Mailnode is scalix,sekoworldwide
2006-05-20 13:26:09,747 INFO Server's existing mailnode is scalix,sekoworldwide
2006-05-20 13:26:09,791 INFO Configuring / upgrading RES
2006-05-20 13:26:09,917 ERROR Aborting...!
2006-05-20 13:26:09,917 CRITICAL Operation failed: Web apps config function configure_res failed: Failed to add "query admin" user sxqueryadmin_at_notanemail-scalix.sekoworldwide.com. /opt/scalix/bin/oma
ddu reported the following error: omaddu : [OM 8114] Could not get a license to configure this user.
.Please check that the domain sekoworldwide.com is licensed.
2006-05-20 13:26:09,918 ERROR Operation failed: Aborting web apps configuration

ScalixSupport
Scalix
Scalix
Posts: 5503
Joined: Thu Mar 25, 2004 8:15 pm

Postby ScalixSupport » Sat May 20, 2006 11:36 pm

Problem solved. It turned out to be an old Limited Release license. A new license was generated and installed and now SAC is working once again.

Thanks,
Rachel


Return to “Scalix Management Services”



Who is online

Users browsing this forum: No registered users and 1 guest