Install MySQL ODBC on Solaris

The MySQL ODBC connector can be installed on Solaris 10 and 11 (sparc and x86).

To install the database/server, follow the MySQL instructions (or see above on Linux).

PMUL binaries are 32-bit. You must ensure a 32-bit version of ODBC is installed on Solaris 10 and 11.

1. Install the MySQL package (output of the command is in the attached file):

   # pkgadd -d http://get.opencsw.org/now
   # /opt/csw/bin/pkgutil -U -u -y
   # /opt/csw/bin/pkgutil -y -i myodbc

Mysql-connector-odbc version 5.3.14 is not supported.

2. In pb.settings set:

   eventdestinations authevt=odbc=MySQL
   odbcinidir  /opt/pbul/etc

   If you are using mysql-connector-odbc version 5.3.x with SSL enabled on MySQL server or mysql-connector-odbc version 8.0.x (with or without SSL), in pb.settings file, you need to configure the setting loadssllibs to yes.

   cat /etc/pb.settings | grep loadssllibs
   loadssllibs                         yes
           

3. Configure Odbc.ini:

   [MySQL]
   Description = ODBC for MySQL
   Driver = MySQL
   server = <ip_of_MYSQL_host>
   port = 3306
   user = root
   password = <passwd>
   database = <database>

4. Create /opt/pbul/etc/odbc.ini:

   [MySQL]
   Description  = ODBC for MySQL
   Driver = /opt/csw/lib/libmyodbc3.so
   FileUsage = 1
   UsageCount = 3
   trace = no
   tracefile = stderr

5. Set LD_LIBRARY_PATH to:

   LD_LIBRARY_PATH=/opt/csw/lib:/usr/lib:/lib:/usr/local/lib

6. Restart pblighttpd.