Error and warnings when trying to install m_mysql

[JorgeMostiga]

Hello o/! Good day everyone. I'm trying to install this module in Anope with Unralircd, but I'm getting the following error. I don't know what to do. My goal is to connect to a remote MySQL server to save the data there. Does anyone have any ideas on this?

CMake Deprecation Warning at CMakeLists.txt:2 (cmake_minimum_required):
  Compatibility with CMake < 2.8.12 will be removed from a future version of
  CMake.

  Update the VERSION argument <min> value or use a ...<max> suffix to tell
  CMake that the project does not need compatibility with older versions.


CMake Deprecation Warning at CMakeLists.txt:6 (cmake_policy):
  The OLD behavior for policy CMP0026 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:9 (cmake_policy):
  The OLD behavior for policy CMP0007 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Error at cmake/Anope.cmake:411 (message):
  /home/user/ircd/anope-2.0.17/modules/m_mysql.cpp needs header file
  mysql/mysql.h but we were unable to locate that header file! Check that the
  header file is within the search path of your OS.
Call Stack (most recent call first):
  modules/CMakeLists.txt:63 (calculate_depends)
  modules/CMakeLists.txt:203 (build_modules)


-- Configuring incomplete, errors occurred!
See also "/home/user/ircd/anope-2.0.17/build/CMakeFiles/CMakeOutput.log".
See also "/home/user/ircd/anope-2.0.17/build/CMakeFiles/CMakeError.log".

Now cd build, then run make to build Anope.

[sadiepowell]

You haven't installed the MySQL development headers. If you're using MariaDB rather than MySQL you might need to install an additional compatibility package to get the right headers (on Debian derived distros this is usually libmariadb-dev-compat).

[JorgeMostiga]

Okay, that was the mistake. Now I've added it as it says here:
https://wiki.anope.org/index.php/2.0/Modules/m_mysql
And now what else do I have to do to create the tables and records?

[JorgeMostiga]

Thanks for your reply. I only have access to the remote MySQL server with IP, user, password and port 3306. Is anything else needed? .

I'm still getting the message in the #services channel: DB_FLATFILE: Finished saving databases and no tables have been created on the external MYSQL server yet, nor has anything been imported from the anope.db file. What steps should I follow?

[sadiepowell]

You need to load db_sql with the SQL engine name set to the name of your profile (this is probably mysql/main) the import option enabled for it to import to SQL.

https://github.com/anope/anope/blob/2.0.17/data/example.conf#L1154-L1197

If its still not importing with that module loaded and that setting enabled you probably have some kind of problem with your SQL database settings. It will write a log message saying why it can't connect. If you don't have logging enabled or you can't see a log message you can start with --support to log to stdout.

[JorgeMostiga]

The part that says

#module
{
name = "db_sql"

"#module" is commented out. Do I have to remove the #? And should I also set the part that says "import = false" to true?

I'll try it and let you know. Thanks for your response and patience.

[sadiepowell]

Yeah #, // and /* foo */ are all comments. You should remove that to enable the module.

You should also set import to yes. Make sure to read the full comment above it which describes how to perform an import.

https://github.com/anope/anope/blob/2.0/data/example.conf#L1186-L1197

[JorgeMostiga]

Thank you very much. I was able to import the database from the anope.db file to my external MySQL server. However, the message in the OperServ #Service channel keeps appearing: " DB_FLATFILE: Finished saving databases." Does anyone have any idea why this message keeps appearing?

[sadiepowell]

If db_flatfile is still loaded it will continue to save database to the flatfile on a timer.

[JorgeMostiga]

Thank you very much, your responses are always timely!