This shows you the differences between two versions of the page.
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 **< | + | |
- | * **To change hub address: | + | |
- | ==== 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:// | + | |
- | Search for this line **< | + | |
- | ==== 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 **< | + | |
- | * **When non-standard port is used:**\\ Search for this line **< | + | |
- | * **To set database name:**\\ Search for this line **< | + | |
- | * **To set database user:**\\ Search for this line **< | + | |
- | * **To set database password: | + | |
- | ==== 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 **< | + | |
- | * **To set password: | + | |
- | * **To set profile: | + |