ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

    I need data source driver to connect to a mysql database on iSeries(IBM i) model 270 V5R4.
    I installed and running Zend Server 5.6.0, PHP 5.3.8, MySQL 5.0.45.

    I need to create a data source on my Windows 7 pro system but can?t find
    driver and instructions on what and how to download, setup driver and
    datasource connection.

    Does anyone know what driver I would need and where to download it from.
    also any instructions would be helpful.

    I am trying to create a connection for WebSmart PHP V10.1 to a mysql database on system i.

    Thanks.


    James
    James R. Martin
    jmartin@jmartinassociates.net

  • #2
    Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

    Surely MySQL support is included with PHP?!

    Comment


    • #3
      Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

      Originally posted by Scott Klement View Post
      Surely MySQL support is included with PHP?!

      I installed Zend Server 5.0 the upgraded to 5.6 and I thought it had the the MySQL support
      included with PHP but when I look for the files:

      To enable TCP access:

      1. Backup and edit '/usr/local/zend/mysql/data/my.cnf'.
      2. Comment out the Skip-Networking line, and save changes.
      3. Restart MySQL by running '/usr/local/zend/bin/zendctl.sh restart-mysql'.

      Port 3306 should be open for MySQL client access.

      the path is not the same in the IFS it has:

      \usr\local\mysql\data\mysql which is empty

      \usr\local\zendsvr but no /usr/local/zend/mysql/data/my.cnf

      I do see all the databases under: \usr\local\mysqldata\

      that I want to connect to but no place do I find my.cfg to open up port 3306
      for connection.

      I do see: \usr\local\mysql-5.1.35-i5os-power-64bit\support-files
      folder that has:

      my-huge.cnf
      my-innodb-heavy-4G.cnf
      my-large.cnf
      my-medium.cnf
      my-small.cnf

      but no my.cfg

      James


      Comment


      • #4
        Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

        You have to customize one of the .cnf files to meet your needs and call it my.cnf.

        Chris...

        Comment


        • #5
          Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

          When you need to connect to the MySQL data base on the IBMi you need to open up the MySQL database on the IBMi to accept remote connections and ensure the firewall (if any) will allow the IBMi to accept requests on the above port. Best place to get information is the MySQL website, then convert the path information to match your IBMi installation paths.

          Zend Server is not needed on the IBMi, MySQL jobs can just run standalone?

          Chris...

          Comment


          • #6
            Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

            Originally posted by chris_hird View Post
            When you need to connect to the MySQL data base on the IBMi you need to open up the MySQL database on the IBMi to accept remote connections and ensure the firewall (if any) will allow the IBMi to accept requests on the above port. Best place to get information is the MySQL website, then convert the path information to match your IBMi installation paths.

            Zend Server is not needed on the IBMi, MySQL jobs can just run standalone?

            Chris...
            Chris:

            I am using Zend Server to run PHP apps which access MySQL database on the iSeries(IBM i) 270.

            I found: http://www.ovaistariq.net/490/a-step...-to-mysql-5-5/
            and will copy my-large.cnf from \usr\local\mysql-5.1.35-i5os-power-64bit\support-files
            but where do I put it?
            the path is not the same in the IFS it has:

            \usr\local\mysql\data\mysql which is empty and

            \usr\local\zendsvr but no /usr/local/zend/mysql/data/ to put the file my-large.cnf renamed to my.cnf
            ?

            James

            Comment


            • #7
              Re: data source driver to connect to mysql database iSeries(IBM i) 270 V5R4

              James

              This is the information from the MySQL site


              You will see a link to Linux,Unix,MAC etc. The program will go through each of those directories so just put it in one and you should be good to go.

              Chris...

              Comment

              Working...
              X