How do I integrate the 123flashchat into my mysql database

Q:How do I integrate the 123flashchat into my mysql database?

A:1) Create database.

Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"

The [user],[password] here is MySQL account.

(2) Import 123FlashChat table.

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

(3) Modify fcserver.xml.
3.1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
3.2 Find this node: <database-mode>Default</database-mode>, and change "Default" to MySQL.
3.3 Find this node: <database-server port="9001" ip="localhost" enable="On"></database-server>, and change enable="On" to enable="Off".

(4) Configure Mysql.xml
Open this file: <123flashchat installed 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.

Keywords:flash chat, flash chat client, flash chat room, flash chat script, flash chat software, flashchat

[phillychris]

Newbie. If I intergrate 123flashchat per instructions this into mysql will this only allow members to your site to chat on 123 Flashchat? And having 123flashchat as the host.

[admin]

@guna2009, thanks for your passion on our 123 Flash Chat and maybe your two ways are good enough. But you know our technical staff are very professional, and we trust our customer prefer to receive our integration service. Please don't popularize yourself in the community.

Thank you.

[ciosdjk]

I have found two way for you to create an "always on top" chat, while both of them are not perfect.

[admin]

Originally Posted by ciosdjk

I have found two way for you to create an "always on top" chat, while both of them are not perfect.

Please tell me the two ways of such integration. Thank you! Learn more about 123 flash chat:

Flash Chat Software, Online Webcam Chat Scripts, Video / Audio Chat, Java Chat, Messenger Software, Live Help Chat, Online Chat Software

[tree1891]

Originally Posted by michaelxu

Q:How do I integrate the 123flashchat into my mysql database?

A:1) Create database.

Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"

The [user],[password] here is MySQL account.

(2) Import 123FlashChat table.

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

(3) Modify fcserver.xml.
3.1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
3.2 Find this node: <database-mode>Default</database-mode>, and change "Default" to MySQL.
3.3 Find this node: <database-server port="9001" ip="localhost" enable="On"></database-server>, and change enable="On" to enable="Off".

(4) Configure Mysql.xml
Open this file: <123flashchat installed 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.

Keywords:flash chat, flash chat client, flash chat room, flash chat script, flash chat software, flashchat

How to set port of mysql?

[admin]

If your chat uses MySQL database, you can follow the following:

1) Create database.
Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"
The [user],[password] here is MySQL account.

2) Import 123FlashChat table.
Enter the following commands in command prompt: <mysql installed directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installed directory>/server/etc/mysql.sql.

3) Modify fcserver.xml.
1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
2 Find this node: <database-mode>Derby</database-mode>, and change "Derby" to MySQL.
3 Find this node: <database-server port="10702" ip="localhost" enable="On"></database-server>, and change enable="On" to enable="Off".

4) Configure Mysql.xml
Open this file: <123flashchat installed 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.

[tree1891]

Originally Posted by admin

If your chat uses MySQL database, you can follow the following:

1) Create database.
Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:
<mysql installed directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE flashchat CHARACTER SET utf8 COLLATE utf8_bin;"
The [user],[password] here is MySQL account.

2) Import 123FlashChat table.
Enter the following commands in command prompt: <mysql installed directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 flashchat < <123flashhcat installed directory>/server/etc/mysql.sql.

3) Modify fcserver.xml.
1 Open this file: <123flashchat installed directory>/server/etc/fcserver.xml.
2 Find this node: <database-mode>Derby</database-mode>, and change "Derby" to MySQL.
3 Find this node: <database-server port="10702" ip="localhost" enable="On"></database-server>, and change enable="On" to enable="Off".

4) Configure Mysql.xml
Open this file: <123flashchat installed 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.

I can't find port setting in Mysql.xml.

[admin]

Hello,

you can set port like IPort

Sample
<database-host>127.0.0.1:123</database-host>

[Abiblay11]

As i read the thread i don't have to write because i have the same issue with it but now i figured it out because of the post. well ty for the conversation the admin been doing a good job.