Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Locate the frevvoDS data source url parameter.url="jdbc:jtds:sqlserver://localhost/frevvo"/>. You can change the name "frevvo" to whatever you wish, "
    Frevvoproduct
    " for example. But it must match the database name you create in your SQL server. See verify connection Url below.
  2. Create a utf8 encoded database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
  3. In the
    Frevvoproduct
     installation locate the script <frevvo-home>/data/sql/forms-<database type>.sql. Ex: for mySQL the script is named <frevvo-home>/data/sql/forms-mysql5mysql.sql
  4. Run that script in your "
    Frevvoproduct
    " database. That will create all the tables required to persist submissions
  5. Set the frevvoDS data source parameters username and password to a user that has write permissions to the "
    Frevvoproduct
    " database.
  6. The submissions database setup is now complete.

...

2) Verify that the users and passwords required to connect to each database are correct.<br/>
3) Make sure that the users configured in the data sources have permissions to read and write to the respective databases.

...

  1. Open a Command Prompt window 
  2. cd to <frevvo installdir>\frevvo\data\sql
  3. execute the command: mysql <my_db_name> -u <user_name> -p < forms-mysql5mysql.sql

This will prompt you for the mysql password for <user_name> and then execute the script creating all the required tables.

...