Sorry about the red box, but we really need you to update your browser. Read this excellent article if you're wondering why we are no longer supporting this browser version. Go to Browse Happy for browser suggestions and how to update.

Installing MySQL in a Linux environment

Create the database tables manually

Before you begin:

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.

  1. On the Home screen for the MySQL Workbench, in the SQL Development section, double-click the new connection that you created.
  2. On your computer, navigate to the folder containing the database scripts. For Windows the default location is C:/BPSS/pushsdk/database-scripts/mysql).
  3. Double-click pushsdk_schema_mysql.sql and copy the contents of the file.
  4. On the SQL Editor screen, in the SQL Statements section, paste the contents of pushsdk_schema_mysql.sql.
  5. Click Execute.

Download a JDBC driver for MySQL

  1. Download a JDBC driver for MySQL (for example, the Connector/J driver from www.mysql.com).
  2. If the file that you downloaded is in an archive format (for example, .zip, .tar.gz, and so on), extract its contents.
  3. 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.

Error messages

ORA-01882: timezone region not found

Description

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

Possible solution

Before you install the SDK, do the following:

  1. Navigate to the etc directory as the root user.
  2. 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