PtokaX wiki

Hub (server) for Direct Connect

User Tools

Site Tools


guides:unix_mysql_maria_basic_setup

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
guides:unix_mysql_maria_basic_setup [02/07/2015 19:01]
ppk
— (current)
Line 1: Line 1:
-====== Basic setup with MySQL or MariaDB database ====== +
-Before we run our compiled PtokaX executable we need to do at least minimal setup.\\ +
-In source we have config examples, we use them to setup your PtokaX hub.\\ +
-\\ +
-First we rename cfg.example directory to cfg with this command: **mv cfg.example cfg**\\ +
-Go to cfg dir with this command: **cd cfg** +
-==== a. Minimal settings ==== +
-To be able to run PtokaX we need to set at least hub name and hub address.\\ Open Setting.xml in text editor with this command (you can use any other text editor instead of **VIM**, for example **ee** on FreeBSD or **vi** on CentOS): **vim Settings.xml**\\ +
-  * **To change hub name:**\\ Search for this line **<String Name="HubName">&lt;Enter hub name here&gt;</String><!-- Hub name. Min length 1, max 256. -->** and change **&lt;Enter hub name here&gt;** to name of new hub.\\ Result can look like this: **<String Name="HubName">My first PtokaX hub</String><!-- Hub name. Min length 1, max 256. -->** +
-  * **To change hub address:**\\ Search for this line **<String Name="HubAddress">&lt;Enter hub address here&gt;</String><!-- Hub address. Min length 1, max 256. -->** and change **&lt;Enter hub address here&gt;** to address of new hub.\\ Result can look like this: **<String Name="HubAddress">some-address.some-domain.eu</String><!-- Hub address. Min length 1, max 256. -->** +
-==== b. Character encoding setting. ==== +
-To run with MySQL or MariaDB we need to have set correct character encoding. 1252 is western, 1250 is central european, 1251 is cyrillic etc. More code pages can be found on [[https://en.wikipedia.org/wiki/Windows_code_page|Wikipedia]]. Again we have opened **Settings.xml** in text editor.\\ +
-Search for this line **<String Name="Encoding">cp1252</String>** and change **cp1252** to your encoding.\\ Result can look like this: **<String Name="Encoding">cp1250</String>** +
-==== c. Database settings. ==== +
-To run with MySQL or MariaDB we need to have working MySQL or MariaDB with created database and user with password for PtokaX. Guide can be found on internet. We need to set up PtokaX to use those settings. Again we have opened **Settings.xml** in text editor.\\ +
-  * **When non-standard host is used:**\\ Search for this line **<String Name="MySQLHost">localhost</String>** and change **localhost** to your host.\\ Result can look like this: **<String Name="MySQLHost">127.0.0.1</String>** +
-  * **When non-standard port is used:**\\ Search for this line **<String Name="MySQLPort">3306</String>** and change **3306** to your host.\\ Result can look like this: **<String Name="MySQLPort">12345</String>** +
-  * **To set database name:**\\ Search for this line **<String Name="MySQLDBName">ptokax</String>** and change **ptokax** to your database name.\\ Result can look like this: **<String Name="MySQLDBName">my_ptokax</String>** +
-  * **To set database user:**\\ Search for this line **<String Name="MySQLUser">ptokax</String>** and change **ptokax** to your database user.\\ Result can look like this: **<String Name="MySQLUser">my_ptokax_user</String>** +
-  * **To set database password:**\\ Search for this line **<String Name="MySQLPass"></String>** and insert your database password.\\ Result can look like this: **<String Name="MySQLPass">my_ptokax_db_password</String>** +
-==== d. Creating registered user. (Optional) ==== +
-When we are here, it is good idea to create registered user with master account for yourself.\\ Open RegisteredUsers.xml in text editor with this command (you can use any other text editor instead of **VIM**, for example **ee** on FreeBSD or **vi** on CentOS): **vim RegisteredUsers.xml**\\ +
-  * **To set nick:**\\ Search for this line **<Nick>Example_Nick</Nick>** and change **Example_Nick** to your nick.\\ Result can look like this: **<Nick>MyNick</Nick>** +
-  * **To set password:**\\ Search for this line **<Password>Example_Password</Password>** and change **Example_Password** to your password.\\ Result can look like this: **<Password>MyPassword</Password>** +
-  * **To set profile:**\\ Search for this line **<Profile>3</Profile><!-- 0 for master, 1 for operator, 2 for vip, 3 for reg -->** and change **3** to your profile.\\ Result can look like this: **<Profile>0</Profile><!-- 0 for master, 1 for operator, 2 for vip, 3 for reg -->**+
guides/unix_mysql_maria_basic_setup.1435863690.txt.gz · Last modified: 02/07/2015 19:01 by ppk