MySQL plugin question

Discuss anything related to product development
Post Reply
seasoned_geek
Posts: 223
Joined: Thu Jun 11 2020 12:18 pm

MySQL plugin question

Post by seasoned_geek »

Dug through all of the documentation on the Web site and a few Ubuntu forums. How does one stop this if they wish to build the plugin.

Code: Select all

-- Looking for mysql/mysql.h
-- Looking for mysql/mysql.h - found
-- Looking for net/if.h
...
-- MySQL was not found, CopperSpice plugin will not be built
I know you are looking for a FindMySQL.cmake and you have one in your cmake directory but it appears you are looking for a cmake file provided by MySQL which the project doesn't provide . . . correct?

Granted most of the known universe ceased caring about MySQL after Oracle purchased InnoDB, but the build documentation on the Web site should like necessary dependencies for building the plugins on Unix/linux platforms at least. I assume someone has actually built this?
ansel
Posts: 143
Joined: Fri Apr 10 2015 8:23 am

Re: MySQL plugin question

Post by ansel »

Yes, building this plugin has been tested on several Unix systems and it does build as expected.

The FindMySQL.cmake in our cmake directory will be invoked and then PkgConfig will be used by CMake to search for MySQL. We can see by your output that “mysql/mysql.h” was found, which is a good start.

However, your output does not indicate if the libraries were found. Can you supply a bit more of the output log?
Ansel Sermersheim
CopperSpice Cofounder
seasoned_geek
Posts: 223
Joined: Thu Jun 11 2020 12:18 pm

Re: MySQL plugin question

Post by seasoned_geek »

ansel wrote: Thu Aug 17 2023 2:31 am Yes, building this plugin has been tested on several Unix systems and it does build as expected.

The FindMySQL.cmake in our cmake directory will be invoked and then PkgConfig will be used by CMake to search for MySQL. We can see by your output that “mysql/mysql.h” was found, which is a good start.

However, your output does not indicate if the libraries were found. Can you supply a bit more of the output log?
Not until the next time I build. It also doesn't change the fact that the build dependencies listed on the Web site do not list the dependencies necessary for any of the SQL plugins.

Removing my home directory and the snap directories. Yes, this is after I installed the generated Debian so you see CopperSpice stuff in the system directories.

MySQL does not support CMake.

Code: Select all

roland@roland-HP-EliteDesk-800-G2-SFF-gen6:/$ sudo find -iname *mysql*
[sudo] password for roland: 
./run/mysqld
./run/mysqld/mysqld.sock
./run/mysqld/mysqld.sock.lock
./run/mysqld/mysqlx.sock
./run/mysqld/mysqlx.sock.lock
find: ‘./run/user/1000/doc’: Permission denied
find: ‘./run/user/1000/gvfs’: Permission denied
./run/systemd/units/invocation:mysql.service
./usr/lib/mysql
./usr/lib/mysql/plugin/component_mysqlbackup.so
./usr/lib/mysql/plugin/mysql_no_login.so
./usr/lib/mysql/plugin/mysql_clone.so
./usr/lib/python3/dist-packages/pygments/lexers/_mysql_builtins.py
./usr/lib/python3/dist-packages/pygments/lexers/__pycache__/_mysql_builtins.cpython-310.pyc
./usr/lib/x86_64-linux-gnu/libmysqlclient.so
./usr/lib/x86_64-linux-gnu/libmysqlservices.a
./usr/lib/x86_64-linux-gnu/libmysqlclient.a
./usr/lib/x86_64-linux-gnu/libmysqlcppconn.so
./usr/lib/x86_64-linux-gnu/libmysqlcppconn-static.a
./usr/lib/x86_64-linux-gnu/libmysqlpp.so
./usr/lib/x86_64-linux-gnu/libmysqlpp.so.3.2.5
./usr/lib/x86_64-linux-gnu/libmysqlcppconn.so.7
./usr/lib/x86_64-linux-gnu/libcppdb_mysql.so.0
./usr/lib/x86_64-linux-gnu/libcppdb_mysql.so.0.3.1
./usr/lib/x86_64-linux-gnu/libmysqlpp.so.3
./usr/lib/x86_64-linux-gnu/libcppdb_mysql.a
./usr/lib/x86_64-linux-gnu/libmysqlclient.so.21
./usr/lib/x86_64-linux-gnu/libcppdb_mysql.so
./usr/lib/x86_64-linux-gnu/libmysqlcppconn.so.7.1.1.12
./usr/lib/x86_64-linux-gnu/pkgconfig/mysqlclient.pc
./usr/lib/x86_64-linux-gnu/libmysqlcppconn.a
./usr/lib/x86_64-linux-gnu/libmysqlclient.so.21.2.34
./usr/lib/systemd/system/mysql.service
./usr/share/mysql
./usr/share/mysql/mysql-log-rotate
./usr/share/mysql/mysqld_multi.server
./usr/share/mysql/mysql-systemd-start
./usr/share/apport/package-hooks/source_mysql-8.0.py
./usr/share/bash-completion/completions/mysql
./usr/share/bash-completion/completions/mysqladmin
./usr/share/doc/mysql-server-core-8.0
./usr/share/doc/default-mysql-client
./usr/share/doc/mysql-server-8.0
./usr/share/doc/mysql-server-8.0/mysqld.sym.gz
./usr/share/doc/libmysqlclient21
./usr/share/doc/libcppdb-mysql0
./usr/share/doc/libmysql++3v5
./usr/share/doc/libmysql++-dev
./usr/share/doc/default-libmysqlclient-dev
./usr/share/doc/libmysqlcppconn7v5
./usr/share/doc/mysql-common
./usr/share/doc/libmysqlclient-dev
./usr/share/doc/libmysqlcppconn-dev
./usr/share/doc/mysql-client-core-8.0
./usr/share/doc/default-mysql-server
./usr/share/doc/mysql-client-8.0
./usr/share/nmap/scripts/mysql-audit.nse
./usr/share/nmap/scripts/mysql-dump-hashes.nse
./usr/share/nmap/scripts/mysql-variables.nse
./usr/share/nmap/scripts/mysql-vuln-cve2012-2122.nse
./usr/share/nmap/scripts/mysql-enum.nse
./usr/share/nmap/scripts/mysql-users.nse
./usr/share/nmap/scripts/mysql-empty-password.nse
./usr/share/nmap/scripts/mysql-brute.nse
./usr/share/nmap/scripts/mysql-info.nse
./usr/share/nmap/scripts/mysql-databases.nse
./usr/share/nmap/scripts/mysql-query.nse
./usr/share/nmap/nselib/mysql.lua
./usr/share/nmap/nselib/data/mysql-cis.audit
./usr/share/lintian/overrides/mysql-server-8.0
./usr/share/lintian/overrides/libcppdb-mysql0
./usr/share/lintian/overrides/libmysql++3v5
./usr/share/lintian/overrides/mysql-common
./usr/share/lintian/overrides/mysql-client-8.0
./usr/share/mysql-common
./usr/share/man/man1/mysql_secure_installation.1.gz
./usr/share/man/man1/mysqldump.1.gz
./usr/share/man/man1/mysqloptimize.1.gz
./usr/share/man/man1/mysqlman.1.gz
./usr/share/man/man1/mysqlimport.1.gz
./usr/share/man/man1/mysqlshow.1.gz
./usr/share/man/man1/mysqld_safe.1.gz
./usr/share/man/man1/mysqladmin.1.gz
./usr/share/man/man1/mysqlslap.1.gz
./usr/share/man/man1/mysql_ssl_rsa_setup.1.gz
./usr/share/man/man1/mysqlcheck.1.gz
./usr/share/man/man1/mysqlpump.1.gz
./usr/share/man/man1/mysqlbinlog.1.gz
./usr/share/man/man1/mysql_upgrade.1.gz
./usr/share/man/man1/mysqlreport.1.gz
./usr/share/man/man1/mysqld_multi.1.gz
./usr/share/man/man1/mysqldumpslow.1.gz
./usr/share/man/man1/mysql.1.gz
./usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
./usr/share/man/man1/mysqlanalyze.1.gz
./usr/share/man/man1/mysql_config.1.gz
./usr/share/man/man1/mysqlrepair.1.gz
./usr/share/man/man1/mysql_config_editor.1.gz
./usr/share/man/man8/mysqld.8.gz
./usr/share/aclocal/mysql.m4
./usr/include/mysql
./usr/include/mysql/mysqlx_version.h
./usr/include/mysql/mysqlx_error.h
./usr/include/mysql/mysql.h
./usr/include/mysql/mysql_version.h
./usr/include/mysql/mysqlx_ername.h
./usr/include/mysql/mysql_time.h
./usr/include/mysql/mysqld_error.h
./usr/include/mysql/mysql_com.h
./usr/include/copperspice/QtSql/QMYSQLResult
./usr/include/copperspice/QtSql/qsql_mysql.h
./usr/include/copperspice/QtSql/qmysqlresult.h
./usr/include/copperspice/QtSql/qmysqldriver.h
./usr/include/copperspice/QtSql/QMYSQLDriver
./usr/include/mysql++
./usr/include/mysql++/mysql++.h
./usr/include/mysql_driver.h
./usr/include/mysql_error.h
./usr/include/mysql_connection.h
./usr/sbin/mysqld
./usr/bin/mysql
./usr/bin/mysqldump
./usr/bin/mysqlcheck
./usr/bin/mysqlbinlog
./usr/bin/mysqldumpslow
./usr/bin/mysqlimport
./usr/bin/mysql_config_editor
./usr/bin/mysql_config
./usr/bin/mysql_ssl_rsa_setup
./usr/bin/mysqlpump
./usr/bin/mysqlrepair
./usr/bin/mysqlreport
./usr/bin/mysqld_multi
./usr/bin/mysql_migrate_keyring
./usr/bin/mysql_upgrade
./usr/bin/mysqlanalyze
./usr/bin/mysql_tzinfo_to_sql
./usr/bin/mysqloptimize
./usr/bin/mysqld_safe
./usr/bin/mysqlslap
./usr/bin/mysql_secure_installation
./usr/bin/mysqlshow
./usr/bin/mysqladmin
./sys/fs/cgroup/system.slice/mysql.service
./etc/apparmor.d/usr.sbin.mysqld
./etc/apparmor.d/abstractions/mysql
./etc/apparmor.d/local/usr.sbin.mysqld
./etc/mysql
./etc/mysql/mysql.conf.d
./etc/mysql/mysql.conf.d/mysql.cnf
./etc/mysql/mysql.conf.d/mysqld.cnf
./etc/mysql/conf.d/mysql.cnf
./etc/mysql/conf.d/mysqldump.cnf
./etc/mysql/mysql.cnf
./etc/logrotate.d/mysql-server
./etc/rc5.d/S01mysql
./etc/logcheck/ignore.d.server/mysql-server-8_0
./etc/logcheck/ignore.d.workstation/mysql-server-8_0
./etc/logcheck/ignore.d.paranoid/mysql-server-8_0
./etc/rc2.d/S01mysql
./etc/rc3.d/S01mysql
./etc/init.d/mysql
./etc/rc1.d/K01mysql
./etc/init/mysql.conf
./etc/rc6.d/K01mysql
./etc/rc4.d/S01mysql
./etc/systemd/system/multi-user.target.wants/mysql.service
./etc/rc0.d/K01mysql
./var/log/mysql
./var/lib/mysql
./var/lib/mysql/mysql
./var/lib/mysql/mysql.ibd
./var/lib/mysql/mysql_upgrade_info
./var/lib/mysql-keyring
./var/lib/mysql-upgrade
./var/lib/dpkg/info/default-mysql-server.md5sums
./var/lib/dpkg/info/mysql-server-8.0.md5sums
./var/lib/dpkg/info/libmysql++-dev:amd64.list
./var/lib/dpkg/info/mysql-common.postrm
./var/lib/dpkg/info/libmysql++3v5:amd64.shlibs
./var/lib/dpkg/info/mysql-client-core-8.0.list
./var/lib/dpkg/info/mysql-server-8.0.preinst
./var/lib/dpkg/info/mysql-common.list
./var/lib/dpkg/info/mysql-client-8.0.list
./var/lib/dpkg/info/mysql-server-8.0.list
./var/lib/dpkg/info/libcppdb-mysql0:amd64.list
./var/lib/dpkg/info/mysql-server-8.0.templates
./var/lib/dpkg/info/libmysqlcppconn-dev:amd64.list
./var/lib/dpkg/info/libmysqlcppconn7v5:amd64.md5sums
./var/lib/dpkg/info/libmysqlclient21:amd64.symbols
./var/lib/dpkg/info/libmysqlcppconn-dev:amd64.md5sums
./var/lib/dpkg/info/mysql-client-core-8.0.md5sums
./var/lib/dpkg/info/default-mysql-client.md5sums
./var/lib/dpkg/info/default-libmysqlclient-dev:amd64.md5sums
./var/lib/dpkg/info/libmysqlclient21:amd64.triggers
./var/lib/dpkg/info/mysql-server-core-8.0.list
./var/lib/dpkg/info/libcppdb-mysql0:amd64.triggers
./var/lib/dpkg/info/libmysqlclient21:amd64.md5sums
./var/lib/dpkg/info/libmysqlclient21:amd64.shlibs
./var/lib/dpkg/info/mysql-server-8.0.postrm
./var/lib/dpkg/info/mysql-client-8.0.md5sums
./var/lib/dpkg/info/libmysql++-dev:amd64.md5sums
./var/lib/dpkg/info/mysql-server-8.0.conffiles
./var/lib/dpkg/info/mysql-server-8.0.prerm
./var/lib/dpkg/info/libmysql++3v5:amd64.list
./var/lib/dpkg/info/mysql-common.conffiles
./var/lib/dpkg/info/libcppdb-mysql0:amd64.shlibs
./var/lib/dpkg/info/libmysqlcppconn7v5:amd64.triggers
./var/lib/dpkg/info/default-mysql-server.list
./var/lib/dpkg/info/libmysqlcppconn7v5:amd64.shlibs
./var/lib/dpkg/info/mysql-common.md5sums
./var/lib/dpkg/info/mysql-server-8.0.postinst
./var/lib/dpkg/info/mysql-common.preinst
./var/lib/dpkg/info/libmysqlclient-dev.list
./var/lib/dpkg/info/mysql-server-8.0.config
./var/lib/dpkg/info/libmysql++3v5:amd64.triggers
./var/lib/dpkg/info/default-libmysqlclient-dev:amd64.list
./var/lib/dpkg/info/libmysqlcppconn7v5:amd64.list
./var/lib/dpkg/info/libmysqlclient-dev.md5sums
./var/lib/dpkg/info/mysql-common.prerm
./var/lib/dpkg/info/libmysqlclient21:amd64.list
./var/lib/dpkg/info/mysql-common.postinst
./var/lib/dpkg/info/mysql-server-core-8.0.md5sums
./var/lib/dpkg/info/libmysql++3v5:amd64.md5sums
./var/lib/dpkg/info/libcppdb-mysql0:amd64.md5sums
./var/lib/dpkg/info/default-mysql-client.list
./var/lib/mysql-files
./var/lib/systemd/deb-systemd-helper-enabled/mysql.service.dsh-also
./var/lib/systemd/deb-systemd-helper-enabled/multi-user.target.wants/mysql.service
./var/cache/apparmor/30d07b40.0/usr.sbin.mysqld
roland@roland-HP-EliteDesk-800-G2-SFF-gen6:/$ 
If the dependency list on the Web site was complete, this could all be avoided.

https://www.copperspice.com/docs/cs_overview/requirements-unix.html

Has nothing for the SQL plugins.
barbara
Posts: 417
Joined: Sat Apr 04 2015 2:32 am
Contact:

Re: MySQL plugin question

Post by barbara »

We are making a few changes to the FindMySQL.cmake file and the plugin to accommodate a wider range of MySQL versions. These modifications will be available and pushed to github within the next two weeks.

Barbara
Post Reply