 Database integration 123 Live Help itself doesn't have any database, but it can integrate with most sorts of database, such as mysql, mssql, access, oracle or any other database which communicates with application via ODBC or JDBC. There are two methods for integrating 123 Live Help with database: direct method or auth-url.
(1) First, enter the Admin Panel and click the Preferences button in the menu bar
(2) When you finish the first step, a new panel will pop up.Click the Integrated Database button on the left side, then you can select the type of the integrated database on its right side.
(3) There are several database types for you to choose in the “Database Type” dropdown list. Selecting “None” means that you don’t want to integrate the 123 Live Help with any database.
(4) If you select the “URL”, it means that you want to integrate the database with an authentication URL. Enter the URL with two parameters, which are username and password, (such as http://www.yourhost.com/login_chat.php(asp)?username=%username%&password=%password% ) and click the Test button . After you get the success information for the previous settings, please click the “Apply” button. After that, when the user log on your website integrated with 123 Live Help, the values of those two parameters will be replaced with the logon user’s username and password. If the user failed to login, the website will pop up a window with a text to show the failure information.
(5) If you’d like to integrate the 123 Live Help with a database, not a URL or other forms, please select the database type and click the Configure button.
(6) After you have done the previous action, the corresponding attribute window will pop up. Just setup the relevant attributes in that window.
Two ways of integrating 123 Live Help with database: direct method or auth-url:
1). Integrate chat with existing database directly:
(1) Configure default.xml.
The modes of Integrated Other Database in default.xml include:
None - does not use an integrated database to authorize users
Mysql - uses a mysql database
Oracle - uses an oracle database
Common - uses all kinds of databases, advanced setting.
ODBC - uses the ODBC to connect to any database you want.
The default setting is None, which means your 123 Live Help doesn't use any database.
(2) Configure the database xml file.
It could be: | | Parameter | Type | Description | | database-host | string | The hostname of the database server. | | database-name | string | The database name you are using. | | database-user | string | The user name which is required to connect to the database. | | database-password | string | The password which is required to connect to the database. | | user-table | string | The table to store the user information. | | username-field | string | The column of names of the user names in the user-table. | | password-field | string | The column of names of passwords in the user- table. | | enable-md5 | string | It defines whether the password is encrypted with MD5.
On - encoded.
Off - not encoded.
Passwords in many
portal systems and
forum systems like php- nuke, post-nuke or phpBB, etc.
are encrypted with
MD5, thus you will need
to set this value "On". | | Parameter | Type | Description | | mode | string | It could be "thin" or "oci" only. It indicates the way to access the database.
The default value is "thin". If you choose "oci", then your server must have installed an oracle client. | | database-host | string | The hostname of the database server. | | database-port | number | The port of the database. | | database-sid | string | The sid of the database server. | | service-name | string | The service name to connect to oracle. It doesn't take effect
unless you choose the mode "oci". | | database-user | string | The user name which is required to connect to the database. | | password-field | string | The column of names of passwords in the user- table. | | database-password | string | The password which is required to connect to the database. | | username-field | string | The column name of user names in the user- table. | | password-field | string | The column name of passwords in the user- table. | | enable-md5 | string | It defines whether the password is encrypted with MD5.
On - encoded.
Off - not encoded.
Passwords in many
portal systems and
forum systems such as
php-nuke, post-nuke or
phpBB, etc. are
encrypted with MD5,
thus you will need to set
this value "On". | | Parameter | Type | Description | | jdbc-driver | string | The name of the jdbc driver. | | jdbc-url | string | The complete jdbc URL.
If the user name and password are required when the database is accessed, they must also be included. | | user-table | string | The table to store the user information. | | username-field | string | The column name of the user names in the user- table. | | password-field | string | The column name of passwords in the user- table. | | enable-md5 | string | The user name which is required to connect to the database. | | password-field | string | The column of names of passwords in the user- table. | | database-password | string | The password which is required to connect to the database. | | username-field | string | The column name of user names in the user- table. | | password-field | string | The column name of passwords in the user- table. | | enable-md5 | string | It defines whether the password is encrypted with MD5.
On - encoded.
Off - not encoded.
Passwords in many portal systems and forum systems such as php-nuke, post-nuke or phpBB, etc. are encrypted with MD5, thus you will need to set this value to "On". | (3) After configuration, please restart your chat server to make it activated. If failed, please recheck your integrating database configuration.
2). Integrate chat with existing database via auth-url
URL - uses a web URL to authorize a user's login information.
(1) configure login_livehelp.php/asp
You can authorize a users' log in information via a dynamic web application (we can provide this application, php or asp).
• php version(login_livehelp.php):
Open login_livehelp.php, you need to configure the following parameters. | | Parameter | Type | Description | | $dbhost | string | The hostname of the database server. | | $dbuser | string | The user name which is required to connect to the database. | | $dbpasswd | string | The password which is required to connect to the database. | | $dbname | string | The database name which is required to connect to the database. | | $usertable | string | The usertable name used in the database. | | $username_field | string | The column name of user names in the user- table. | | $password_field | string | The column name of passwords in the user- table. | | $dbms | string | Your database type, support Database type: mysql, mysql4 db2, msaccess, mssql-odbc, oracle, postgres7. When you decide to use certain, please include such file with login_livehelp.php, for example, if you try to use mysql4. Please put mysql4.php and login_livehlep.php in the same folder. | • asp version:
Open login_livehelp.asp, you will need to make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
If you decide to use certain type database integration method, just remove "'" at the beginning of this sentence.
• test if this login script working well
copy login_livehlep.php/asp to anywhere you can visit on internet and try to open this url in browser:
http://www.yourhost.com/login_chat.php(asp)?username=%username%&password=%password%
%username% means certain user's name in database; %password% means certain user's password in database. For example:
http://www.yourhost.com/login_chat.php(asp)?username=test%&password=test123.
Page will respond a value which has different meaning. | | Parameter | Description | | 0 | successfully login as ordinary user; | | 1 | wrong password; | | 2 | the username can't be used; | | 3 | login error, e.g. error in connecting database, please check your database configuration; | | 4 | username does not exist; | | 5 | successfully login as the administrator; | | 6 | guest login not allowed | (2) configure login_livehelp.php/asp
Please set <integrated-other-database> to URL, and set <auth-url>
to http://www.yourhost.com/login_chat.asp?username=%username%&password=%password%
Like: <integrated-other-database>URL</integrated-other-database>
<auth-url>http://www.yourhost.com/login_chat.asp?username=%username%&password=%password%</auth-url >
Then please restart your chat server to activate it. | |
|
