1.1.1 Connecting through JDBC

If you plan to use JDBC to connect the chat server to database, do the following steps :

A. Acquire a JDBC driver for your database engine. If driver classes is stored in a compressed file like a ".jar" file, first decompress it then copy the classes with full directory structure ( commonly directory structure is in form : com/company/product ) into "classes" subdirectory in Glassroom installation directory.

B. Use proper driver class name and database URL in "Server Configuration" page of Glassroom control panel. You can find the proper values and syntax of specific database URL from your JDBC driver's documentations.

Built-in support for "My SQL" :

  As My SQL is a major database engine widely used in user registration systems, Chat essentials included a JDBC driver for My SQL from FirstSQL, Inc in Glassroom package. If you plan to use My SQL database engine, follow these steps to connect it to your chat server :

A. Install My SQL database engine.

B. Run Glassroom chat server

C. Open your web browser and point it to Glassroom control panel pages. Enter "Server Configuration" page.

D. Edit these values in "Server Configuration" page : (Suppose that you have created "glassroom" database in My SQL for your chat server)

You can enter username and password for your database connection if it's required.

F. Go to main page of Glassroom control panel and select "Server Control" page. Turn the chat server off and wait for a while then turn it on.

G. At the first time you turn the chat on, Glassroom will make built-in accounts automatically :

H. Open log files and verify the process of creation of built-in accounts. If any problem occurred during the process of  connecting to database, you can inspect the problem by errors reported in log files.