Page 1 of 1
mySQL
Posted: 17 Oct 2011, 18:50
by Yuri20
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:
http://wiki.themanaworld.org/index.php/How_to_Develop
and here:
http://wiki.themanaworld.org/index.php/ ... stallation
So i can't understand why that file is missing... And in which configuration file i can switch txt server into mysql server?
Re: mySQL
Posted: 17 Oct 2011, 19:54
by Crush
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.
Re: mySQL
Posted: 18 Oct 2011, 14:16
by Yuri20
So could you give me guide for creating sql game server?
Re: mySQL
Posted: 18 Oct 2011, 15:22
by Yuri20
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).
Re: mySQL
Posted: 18 Oct 2011, 18:08
by Bjørn
Yuri20 wrote:-- 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.
Re: mySQL
Posted: 20 Oct 2011, 19:56
by i
Bjørn wrote:I've
just changed the README file to mention this library.
Indeed. That may help ;)
Re: mySQL
Posted: 22 Oct 2011, 18:16
by Yuri20
Ok, everything is okay except...:
[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'
WTF is mysql version 16? The newest I can see here:
http://www.mysql.com/
Is 5.5, so i don't understand what is 16...
Re: mySQL
Posted: 22 Oct 2011, 19:12
by o11c
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.
Re: mySQL
Posted: 23 Oct 2011, 01:26
by Crush
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.
Re: mySQL
Posted: 23 Oct 2011, 12:33
by Yuri20
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:
https://github.com/mana/manaserv/tree/m ... ql/updates
update from 14 to 15. There's only 13->14 and 15->16.
Re: mySQL
Posted: 26 Oct 2011, 17:37
by Bjørn
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:
https://github.com/mana/manaserv/commit ... 8b798fa7ab