Compile error: gsc_mysql.cpp:5:25: fatal error: mysql/mysql.h

Hi all, long time no see!

I'm compiling libcod for cod2 again, but i run into this error:

Code:

---

##### COMPILE cod2_1_0 GSC_MYSQL.CPP #####
gsc_mysql.cpp:5:25: fatal error: mysql/mysql.h: No such file or directory
 #include <mysql/mysql.h>

---

And later

Code:

---

##### LINKING libcod2_1_0.so #####
/usr/bin/ld: cannot find -lmysqlclient
collect2: error: ld returned 1 exit status

---

Somehow I'm not able to install this: libmysqlclient-dev:i386

Working on Debian 6 and using maxdamage's libcod

dpkg --add-architecture i386
apt-get update
apt-get install libmysqlclient-dev:i386

Also: you should really consider upgrading.

https://www.debian.org/News/2016/20160212

after apt-get update

Code:

---

Err https://packages.sury.org jessie/main amd64 Packages
  HttpError404
Get:91 https://packages.sury.org jessie/main i386 Packages
Err https://packages.sury.org jessie/main i386 Packages
  HttpError404
Fetched 26.2 MB in 4s (5,568 kB/s)
W: Failed to fetch https://packages.sury.org/php/dists/jessie/main/binary-amd64/Packages  HttpError404

W: Failed to fetch https://packages.sury.org/php/dists/jessie/main/binary-i386/Packages  HttpError404

E: Some index files failed to download. They have been ignored, or old ones used instead.

---

and after apt-get install libmysqlclient-dev:i386

Code:

---

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libmysqlclient-dev:i386 : Depends: zlib1g-dev:i386 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

---

So i guess i have to use a more stable debian version?

The mirror you're using for your libmysqlclient is updated. It does only have buster and stretch distro packages listed now.

Also, you were using a jessie package from there, while jessie is not the version of debian that you're running.

Update your server (best through a full reinstall at this point)

Debian 10?

apt install libmariadb-dev-compat:i386
apt install libmysqlclient-dev:i386