LoginLogin About

Support » Knowledge Base » General questions » Tips for scripts owners »

In what files are stored database connection credentials?

We recommend viewing and editing database connection data in WebAsyst Installer's sections "Settings -> MySQL server" and "Settings -> Database". If you have no access to these sections, then you can view or edit connection credentials in the following files:

  • kernel/wbs.xml

    In this file database server name is stored in the line of the form

    <SQLSERVER HOST="localhost" PORT="" DBCHARSET="UTF8" WEBASYST_HOST=""
    ADMIN_USERNAME="admin" ADMIN_ADMINRIGHTS="TRUE" NAME="wadbserver"
    ADMIN_PASSWORD="RbCzCYasEz3q"><LANGUAGES><LANGUAGE ID="eng" NAME="English"/>
    </LANGUAGES></SQLSERVER>
  • dblist/DATABASE_KEY.xml

    In this file database name, database user name and password are stored in the line of the form

    <DBSETTINGS SIGNUP_DATETIME="2010-11-01 10:50:41"
    CREATE_DATE="2010-11-01 10:51:01" DEFAULT_ENCODING="" EXPIRE_DATE=""
    READONLY="0" DATE_FORMAT="DD.MM.YYYY" DBSIZE_LIMIT="" FIRSTLOGIN="1"
    MAX_USER_COUNT="" SQLSERVER="wadbserver" DB_NAME="webasyst_db"
    DB_PASSWORD="wkRekIQbvhci" DB_USER="wa_admin" SOURCE=""
    DB_CREATE_OPTION="new" TEMPORARY="" MYSQL_CHARSET="UTF8" PLAN=""
    FREE_APPS="" SESSION_EXPIRE_PERIOD=""/>
  • temp/scdb/.settings.DATABASE_KEY

    This is a temporary cache file from which current database credentials are retrieved. If this file is missing, connection credentials are first retrieved from the above mentioned XML files and are saved to the cache file. Be sure to delete the database cache file after you change the connection credentials either manually or by using the cache clearing section in WebAsyst Installer!