Changing sync and admin database passwords

When you install M-Business Server, the following accounts are created for accessing the SQL Anywhere database, agdb.db:

  • ui – M-Business Admin Server uses this account when the administration pages access database information.

  • sync – M-Business Admin Server uses this account to access the database as part of a user synchronization process.

  • reports – M-Business Server uses this account to generate reports. This user can only read data

  • agdb – Use this account to create users, channels, and groups. Use this account only as directed in this documentation. For most database maintenance tasks, log in as the default database administrator, dba.

M-Business Server assigns a default password to each of these accounts upon creation. To ensure the security of your data, it is important that you change the default passwords for the accounts listed above. The instructions below explain how to change the dba, ui, sync, reports, and agdb user passwords. Each password can be different. To change the M-Business Server admin user’s password, see Creating or changing the admin user's password.

To change passwords for database users

  1. Make sure the SQL Anywhere software is running.

    Windows: SQL Anywhere - AGDB service

    UNIX: asa server process

    See Starting, stopping, and restarting M-Business Server.

  2. Open a command line window.

    Windows: Choose Start » Programs » Command Prompt.

    UNIX: Open a UNIX shell window.

  3. Change to the <M-Business_Home>/conf directory.

  4. Edit these directives in the <M-Business_Home>conf/defaults file:

    • To change the ui password, edit the @@StoreUIAuth@@ variable.
    • To change the sync password, edit the @@StoreSyncAuth@@ variable.
    • To change the reports password, edit the @@StoreReportsAuth@@ variable.

  5. Run the defaults_setup script located in the <M-Business_Home>/conf directory.

    Windows: defaults_setup.bat

    UNIX: defaults_setup

  6. Run the changePassword script located in the <M-Business_Home>/conf directory.

    Windows: changePassword.bat

    UNIX: changePassword

  7. Stop and restart M-Business Server services.

    See Starting, stopping, and restarting M-Business Server.

For more information about changing database passwords, see the SQL Anywhere Database Administration Guide, referenced in Related publications.

Copyright © 2008, iAnywhere Solutions, Inc.