Installing MySQL in a Linux environment
Create the database tables manually
Run the Push Service SDK setup application to install either the distribution package with Apache Tomcat or the distribution package without Apache Tomcat.
If you want to create database tables using the Push Service SDK setup application, you can skip this task.
If you choose not to let the setup application create the database tables, the setup application displays the SQL scripts that you can copy and use to create the database tables manually. To retrieve the SQL scripts you can also navigate to the pushsdk_schema_mysql.sql file after you run the setup application.
- On the Home screen for the MySQL Workbench, in the SQL Development section, double-click the new connection that you created.
- On your computer, navigate to the folder containing the database scripts. For Windows the default location is C:/BPSS/pushsdk/database-scripts/mysql).
- Double-click pushsdk_schema_mysql.sql and copy the contents of the file.
- On the SQL Editor screen, in the SQL Statements section, paste the contents of pushsdk_schema_mysql.sql.
- Click Execute.
Download a JDBC driver for MySQL
- Download a JDBC driver for MySQL (for example, the Connector/J driver from www.mysql.com).
- If the file that you downloaded is in an archive format (for example, .zip, .tar.gz, and so on), extract its contents.
Copy the .jar file from the extracted contents to a location on
your hard disk drive.
Remember the location where you copy the .jar file to. The Push Service SDK setup application prompts you to specify the JDBC driver for MySQL. When prompted, you must locate this .jar file and specify it to the setup application.
ORA-01882: timezone region not found
This message appears when you try to install the Push Service SDK on a Linux operating system, and you have an Oracle database installed for use with the SDK, but a time zone was not configured on the Linux installation. The complete error message includes the following:
Install Action: SQL Script 'pushsdk_schema_oracle.sql' (Oracle) Status: ERROR Additional Notes: ERROR - ZeroGaf8 - An error occurred while trying to establish a connection with the database server: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
Before you install the SDK, do the following:
- Navigate to the etc directory as the root user.
- Create a symbolic link named localtime that
points to the time zone applicable for you. For example, to create a symbolic
link to the UTC time zone, use the following command:
ln -sf /usr/share/zoneinfo/UTC localtime