Setting up an ODBC connection to PopChart's example MySQL data

These instructions will help you set up a Chilisoft-MySQL connection to the example database included under the mysql directory. You must have mySQL properly installed for this to work. The instructions assume you are using a Linux/UNIX-compatible system, but the instructions can easily be adapted for other platforms.

  1. Copy the devcon folder in the mysql directory to the data folder of your MySQL installation. Typically, MySQL stores its data in /var/lib/mysql.
  2. Start your mysql client (open a command prompt and type 'mysql') and grant permissions for the user 'root' to access this database from the machine running Chilisoft ASP. For these demos, the password "popchart" should be used. For example, you could do this with the following command, assuming your computer is in the "corda.com" domain.
    3. grant all on devcon.* to 'root@%.corda.com' identified by 'popchart';

    NOTE: Because Chilisoft ASP will appear to be running from the fully qualified host + domain name of your computer, simply setting permissions to "localhost" is not sufficient. For example, if your computer is named "bob.mycompany.com" and your user name is "root", you would need to grant permission to "root@bob.mycompany.com". Alternatively, you can use wildcards and grant access to your entire domain (e.g. "root@%.mycompany.com").

  3. Make sure that PopChart Server, mySQL, and Chilisoft ASP have been installed correctly. Make sure that Chilisoft ASP has been started.
  4. Login to the Chilisoft Administrator. Usually, you can get to this by going to http://localhost:5100.
  5. Go to Server Management > ASP Server > Databases.
  6. From Global Data Source Names select Add New DSN.
  7. Enter "employees" into the DSN box.
  8. Select "MySQL" from the Database type pull-down menu. New options should appear below.
  9. Enter the address of your computer (e.g. "127.0.0.1") into the Server box.
  10. Enter "devcon" into the Database box.
  11. Enter the user name (from step 2) for mySQL access into the User box.
  12. Enter this user's password (from step 2)into the Password box. If you have never set a password, the password will be blank. Re-enter the password in the Confirm Password box.
  13. Click Save

You should now see an entry for employees under the Global Data Source Names list. If you want to make sure it has been set up correctly, click on test.