• Re: Problem with tdbc::mysql on Mojave

    From rhobart/popple@21:1/5 to rhobart on Tue Sep 20 13:48:21 2022
    On Thursday, December 19, 2019 at 10:01:22 AM UTC-6, rhobart wrote:
    On Wednesday, December 18, 2019 at 12:07:17 PM UTC-6, Brad Lanam wrote:
    On Wednesday, December 18, 2019 at 10:00:25 AM UTC-8, rhobart wrote:
    Thank you your insight!
    This gives me at least a starting point.
    I believe after searching google, macports port site and oracle site; that this library may have been deprecated.
    It appears to me that the newest connector is libmysqlclient.dylib https://dev.mysql.com/downloads/c-api/
    The libmysql.dylib is not in my /opt/local/lib and cannot find a macports port for it.
    I see a lot of discussion of the windows dll version however.
    My mysql install was from oracles dmg package.
    My mysql version is 5.7.19.
    The file (libmysql.dylib) is not in that in installed /lib either. libmysqlclient.dylib and libmysqld.a are some of the files in the installed /lib
    Perhaps a symlink to match the name of libmysqlclient would work but I think its a c++ library.

    Yes, I think it has been named libmysqlclient for quite a while now.
    So my guess would be that the tdbc::mysql package is rather out of date.
    This worked as per your suggestion. Thank you!!!
    sudo ln -s /usr/local/mysql/lib/libmysqlclient.dylib /opt/local/lib/libmysql.dylib.15

    I have now moved to an M1 chip using Monterey and still had the same problem and fix using the symlink. However had to use create the directory /usr/local/lib and used below link :
    sudo ln -s /usr/local/mysql/lib/libmysqlclient.dylib /usr/local/lib/libmariadb.dylib

    for some reason I did not have to include the .15 part at the end such as libmariadb.dylib.15 as the error reported.

    This worked using Oracle community edition mysql 8 and fresh installs of tcl and libraries using macports.

    On problem however in this example:
    tdbc::mysql::connection create mysqlDB -database somedatabase etc.......
    puts "Mysql: [mysqlDB configure]" it throws Unknown system variable 'TX_ISOLATION'
    I tried finding this var in mysql workbench and cannot find it.
    Statement and queries so far are working.

    On a different mac using Monterey that call works as expected without error. Using Intel and mysql 5.7.19

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Harald Oehlmann@21:1/5 to All on Wed Sep 21 08:21:45 2022
    Am 20.09.2022 um 22:48 schrieb rhobart/popple:
    On Thursday, December 19, 2019 at 10:01:22 AM UTC-6, rhobart wrote:
    On Wednesday, December 18, 2019 at 12:07:17 PM UTC-6, Brad Lanam wrote:
    On Wednesday, December 18, 2019 at 10:00:25 AM UTC-8, rhobart wrote:
    Thank you your insight!
    This gives me at least a starting point.
    I believe after searching google, macports port site and oracle site; that this library may have been deprecated.
    It appears to me that the newest connector is libmysqlclient.dylib
    https://dev.mysql.com/downloads/c-api/
    The libmysql.dylib is not in my /opt/local/lib and cannot find a macports port for it.
    I see a lot of discussion of the windows dll version however.
    My mysql install was from oracles dmg package.
    My mysql version is 5.7.19.
    The file (libmysql.dylib) is not in that in installed /lib either.
    libmysqlclient.dylib and libmysqld.a are some of the files in the installed /lib
    Perhaps a symlink to match the name of libmysqlclient would work but I think its a c++ library.

    Yes, I think it has been named libmysqlclient for quite a while now.
    So my guess would be that the tdbc::mysql package is rather out of date.
    This worked as per your suggestion. Thank you!!!
    sudo ln -s /usr/local/mysql/lib/libmysqlclient.dylib /opt/local/lib/libmysql.dylib.15

    I have now moved to an M1 chip using Monterey and still had the same problem and fix using the symlink. However had to use create the directory /usr/local/lib and used below link :
    sudo ln -s /usr/local/mysql/lib/libmysqlclient.dylib /usr/local/lib/libmariadb.dylib

    for some reason I did not have to include the .15 part at the end such as libmariadb.dylib.15 as the error reported.

    This worked using Oracle community edition mysql 8 and fresh installs of tcl and libraries using macports.

    On problem however in this example:
    tdbc::mysql::connection create mysqlDB -database somedatabase etc.......
    puts "Mysql: [mysqlDB configure]" it throws Unknown system variable 'TX_ISOLATION'
    I tried finding this var in mysql workbench and cannot find it.
    Statement and queries so far are working.

    On a different mac using Monterey that call works as expected without error. Using Intel and mysql 5.7.19



    For tdbc::mysql, the current trunk has a lot of load fixes. Be sure to:
    - use the current trunk
    - post any observation as a ticket in the tdbc::mysql fossil repository.

    Thanks,
    Harald

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)