User Manual

Home HomePre page For Mac Users | Server Requirements Next page

Storing Data in MySQL


If you need to store your data (such as user information or chat history) in MySQL and you have installed 123 Web Messenger Chat Software on your server, please follow the instructions below:

4.1 Create database.

Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:

<mysql installation directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE 123webmessenger CHARACTER SET utf8 COLLATE utf8_bin;"

The [user] and [password] here are used for MySQL account.

4.2 Import 123 Web Messenger table.

Enter the following commands in command prompt: <mysql installation directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 123webmessenger < <123webmessenger installation directory>/server/etc/mysql.sql.

4.3 Modify wmserver.xml.

4.3.1 Open this file: <123webmessenger installation directory>/server/etc/wmserver.xml.

4.3.2 Find this node: <database-mode> Derby </database-mode>, and change " Derby " to MySQL.

4.3.3 Find this node: <database-server port="20208" ip="127.0.0.1" enable="On"></database-server>, and change enable="On" to enable="Off".

4.4 Configure Mysql.xml

Open this file: <123webmessenger installation directory>server/etc/Mysql.xml, and configure the relevant parameters according to the instructions, the section between <connection-pool>...</connection-pool> is database connection pool configuration and may be not need to be modified.

5. Start your 123WebMessenger server.

Related links:

For Windows Users

For Linux Users


Home HomePre page For Mac Users | Server Requirements Next page

About Us | Contact us | Company Blog | Partnership | Affiliate | Forum | Privacy policy | Terms of Use | SiteMap | Links

Call Sales Now! USA +1 315 636 6657, UK +972 59 9380061, HK +970 56 8169833

Share 123 Flash Chat:

Copyright © TopCMM Software Limited 2001-2016 All Rights Reserved.

Error: Table '123flashchat201311.ip_countries' doesn't exist