Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: MySQL issues  (Read 2449 times)

0 Members and 1 Guest are viewing this topic.

Keiro

  • Anope User
  • Offline Offline
  • Posts: 35
MySQL issues
« on: October 24, 2015, 04:57:28 AM »

OK, so.

I installed every pre-requisites that're needed for Anope to function with mysql. I've also searched for results similar to my issue. However, I seem to be getting it wrong, still.

I am running with MariaDB 5.5. This is on Ubuntu 14.04.3 LTS.

Output of installing the final dependencies is as follows:

Quote
The following NEW packages will be installed:
  libmariadbclient-dev
0 upgraded, 1 newly installed, 0 to remove and 3 not upgraded.
Need to get 1,278 kB of archives.
After this operation, 7,358 kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu/ trusty-updates/universe libmariadbclient-dev amd64 5.5.44-1ubuntu0.14.04.1 [1,278 kB]
Fetched 1,278 kB in 1s (972 kB/s)
Selecting previously unselected package libmariadbclient-dev.
(Reading database ... 106460 files and directories currently installed.)
Preparing to unpack .../libmariadbclient-dev_5.5.44-1ubuntu0.14.04.1_amd64.deb ...
Unpacking libmariadbclient-dev (5.5.44-1ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up libmariadbclient-dev (5.5.44-1ubuntu0.14.04.1) ...

So this should work, right? NOPE. See below:

Quote
Saving configuration results in config.cache... done.
cmake  -DINSTDIR:STRING=/home/wolf/services  -DDEFUMASK:STRING=077 -DCMAKE_BUILD_TYPE:STRING=RELEASE -DUSE_RUN_CC_PL:BOOLEAN=ON -DUSE_PCH:BOOLEAN=ON    ..
CMake Error at cmake/Anope.cmake:468 (message):
  /home/wolf/anope-2.0.2/modules/m_mysql.cpp needs library mysqlclient but we
  were unable to locate that library! Check that the library is within the
  search path of your OS.
Call Stack (most recent call first):
  modules/CMakeLists.txt:36 (calculate_libraries)
  modules/CMakeLists.txt:165 (build_modules)


-- Configuring incomplete, errors occurred!
See also "/home/wolf/anope-2.0.2/build/CMakeFiles/CMakeOutput.log".
See also "/home/wolf/anope-2.0.2/build/CMakeFiles/CMakeError.log".

Now cd build, then run make to build Anope.

However, the presence of /usr/include/mysql and /usr/include/mysql/mysql.h tells me that MySQL is correctly set up as required and for some reason, this is not being picked up properly.

I've also written down the steps to resolve the stupid dependencies issues for the next time I need to set up Anope with MySQL support... *grumbles*
Logged

Keiro

  • Anope User
  • Offline Offline
  • Posts: 35
Re: MySQL issues
« Reply #1 on: October 26, 2015, 01:30:11 AM »

OK, resolved it.

Here's what I did:

Quote
cp -rf /etc/mysql /etc/mysql.bak
apt-get remove --purge mariadb*
mv /etc/mysql.bak /etc/mysql

Finally, I check to make sure /etc/apt/sources.list is updated to 10.1 for MariaDB.

apt-get install mariadb-server libmariadbclient-dev...

It installs everything and I rerun ./Config.

This time, success! I did not purge my databases or anything like that, they're still there.

Services is back in operation!

Edit: Dammit, I spoke too soon.

Error is now as follows:

Had to pastebin since the errors broke the post limit: https://pastebin.com/y9gP8tXc
« Last Edit: October 26, 2015, 01:33:03 AM by Keiro »
Logged
Pages: [1]   Go Up