Ok, i have another question I'd like to make my server based on mySQL (it's more comfortable and it have many of advantages), so i read that i must import table schemas into database, but i can't find this file (createtables.sql or something like that)! I was doing everything what is described there:
The first article is about the current server (tmwAthena), the second one about Manaserv (the new server in development). The guides are about completely different applications.
former Manasource Programmer
former TMW Pixel artist
NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Ok, i am now compiling test server. I have already completed file manaserv.xml (with configuration mysql) and i uncommented mysql part of this file. While compilation with cmake i used:
To set mysql, and unset sqlite, and while configuring cmake is returning:
-- MySQL not found.
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.
Please set them or make sure they are set and tested correctly in the CMake files:
MYSQL_INCLUDE_DIR (ADVANCED)
used as include directory in directory /home/jerzy/Pulpit/manaserv/src
MYSQL_LIBRARIES (ADVANCED)
linked by target "manaserv-account" in directory /home/jerzy/Pulpit/manaserv/src
linked by target "manaserv-game" in directory /home/jerzy/Pulpit/manaserv/src
Why? I installed all needed packages: mysql and phpmyadmin (phpmyadmin needs mysql).
-- MySQL not found.
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.
Please set them or make sure they are set and tested correctly in the CMake files:
MYSQL_INCLUDE_DIR (ADVANCED)
used as include directory in directory /home/jerzy/Pulpit/manaserv/src
MYSQL_LIBRARIES (ADVANCED)
linked by target "manaserv-account" in directory /home/jerzy/Pulpit/manaserv/src
linked by target "manaserv-game" in directory /home/jerzy/Pulpit/manaserv/src
Why? I installed all needed packages: mysql and phpmyadmin (phpmyadmin needs mysql).
Probably because installing mysql is not the same as installing the files required to compile against the mysql client library. You'll want to make sure you've got libmysqlclient-dev installed.
I've just changed the README file to mention this library.
[20:06:37] [INF] Connection to mySQL was sucessfull.
[20:06:37] [ERR] Database version is not supported. Needed version: '16', current version: '14'
[20:06:37] [FTL] Error opening the database: Database version is not supported. Needed version: '16', current version: '14'
From my understanding, this number is just a version used by the Mana project, since they're not yet stable, so they need to keep changing the table format.
The database version number is the version number of the schema. The directory src/sql should include update scripts to upgrade the schema to the newest state. When there are not, beat the guys on IRC.
former Manasource Programmer
former TMW Pixel artist
NOT a game master
Please do not send me any inquiries regarding player accounts on TMW.
You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Crush wrote:The database version number is the version number of the schema. The directory src/sql should include update scripts to upgrade the schema to the newest state. When there are not, beat the guys on IRC.
It seems to I will have to do it. Anyway, Bjorn or someone should add here:
update from 14 to 15. There's only 13->14 and 15->16.
Version 15 was somebody's local version that was skipped by accident in the main repository. To avoid confusion, I've renamed the 15->16 update script to 14->16:
I'd like to make my server based on mySQL (it's more comfortable and it have many of advantages), so i read that i must import table schemas into database, but i can't find this file (createtables.sql or something like that)! I was doing everything what is described there:
