• Announcements

    • jhxp

      Forums are online again after a maintenance.   18/03/17

      MTA Forums maintenance is completed, although some automatic time-heavy tasks are still in process and will be finished eventually in background. Expect some features such as Forum Search to not display all results until all processes are finished. Please let us know if you spot a forum feature that worked correctly before the maintenance but does not work anymore now. Thanks. --MTA Team
Sign in to follow this  
Followers 0
SHC//Sniper

[TUT] How to get the MySQL module working on Debian6.0 64bit

7 posts in this topic

How to get the MySQL module working on Debian 6.0 64bit

EDIT: Download available again

Introduction and Thanks to MaddDogg:

Before trying to run MTA 1.0.X on a 64bit Debian system ensure that you have read and done this:

Thanks to MaddDogg for the great tutorial.

It is possible to run MTA 1.0.5 with the 32bit emulator on a 64bit Debian Squeeze system by my own experience.

Since several users had problems running the MTA MySQL module by ryden I decided to make this small tutorial as extension to the one made by MaddDogg.

Requirements:

You need a 64bit Debian Squeeze (6.0) system with a 32bit emulator and basic knowledge of linux systems. If you've read MaddDogg's tutorial you will know what I mean. It is required to have the MySQL module by ryden in the "modules" folder and added to the mtaserver.conf. You also need a SFTP protocol supporting FTP program to upload those files (FileZilla).

The Problem:

People that have a linux system with 64bit Debian Squeeze and the 32bit emulator aren't able to run the MySQL module by ryden. This is the the error message written into the server logs when the server starts.

MODULE: Unable to find modules/mtamysql.so (libmysqlclient.so.15: cannot open shared object file: No such file or directory)! 

This means that the MySQL module is looking for a library (libmysqlclient.so.15) that does not exist in our system. As I started to search for that file in my system I found a pretty similar file called "libmysqlclient.so.16" in /usr/lib. That means ryden's module is looking for an old library that does not exist anymore in Debian Squeeze. To solve this problem we need the 32bit library from a Debian Lenny (5.0) system. Fortunately I still had a 32bit Debian Lenny (5.0) VPS running so I could find that file easily.

Uploading the Files:

First of all I am sorry that I didn't find a way to download the file via SSH to your server. Instead we will use the SFTP protocoll. First of all ensure that you have a user with full access to the system files on your system (default user is: root). Now open your FTP program (in this case FileZilla) and type in:

Server: <Your server IP> 
User: root (if you didn't disable the root login) 
Password: <Your password> 
Port: 22 

Now you are logged in into your root server via SFTP protocoll and you are able to move/edit/upload/download/delete files. After that browse the the directory /usr/lib32 on your server that contains all 32bit libraries.

After that you have to download the following file to your PC:

http://www.2shared.com/file/mklzX0am/li ... entso.html

This is the old 32bit library that is needed in order to run the MySQL module by ryden. Now simply upload the downloaded file by using your FTP program to the /usr/lib32 folder (FileZilla: Right click then "Upload").

Running the server

After you've done everything just start your server in known manner and the MySQL module should work properly.

Other:

If you find any mistakes in this tutorial or you still have problems then please let me know.

Greetings

SHC//Sniper

Share this post


Link to post

As far as I know its possible to softlink the libmysqlclient.so.15 to libmysqlclient.so.16 without much of an issue.

But thats something for advanced linux users who know where to look at if an error occurs.

I haven't tried it yet.

Share this post


Link to post

I've already tried that. The mysql module by ryden doesn't like the .so.16 library.

Share this post


Link to post
This tutorial also works for MTA 1.3!

Yep I used it on 1.3, thanks a lot for this tut :D

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.