Tag Archives: mariadb

Zabbix + MariaDB + Nginx

Hello there my Friend,

This blog is a personal documentation of my work. So if you like it or you have any suggestions or questions, leave them in the comment section.

The idea: Monitoring my server + my raspberry Pi machine at home (temp + availability because of power shortages).
The hardware: At first I used a cheap VPS (1core, 2G ram, 15G hdd, 100mbps ) which was totally fine. Now I’m documenting this and redoing it on a low end box (2core, 2G ram, 500G hdd, 100mbps) just because of the migration.
OS of choice: Debian GNU/Linux 8 (jessie), just because I like it.
Http server of choice: Nginx, cuz I wanted to learn it.
DB of choice: MariaDB, I wanted to learn it and like the ‘idea’ of it.

 

1) Get Zabbix packages

It’s explained well enough here – just do the “installing repository configuration package” and continue with:

apt install zabbix-frontend-php nginx-full php5-fpm zabbix-server-mysql php5-mysql php5 mariadb-client-10.0 mariadb-client-core-10.0 mariadb-server mariadb-server-10.0 mariadb-server-core-10.0 

2) Prepare the database

as root:

 mysql_secure_installation 

and follow the questions that appear.

After that we have to create a database and user that will operate on that DB.

login to the mysql shell as root:

 mysql -uroot -p 

than we shall create the database, I’ll call mine zabbix (it’s easier to use the scripts afterwards)


CREATE DATABASE zabbix character set utf8 collate utf8_bin;

Than we create the user that will operate on the database. Mine is called zabbix and will be able to log to the database from the host ‘localhost’. The user is identified by a password set in the ‘password’ value.


CREATE USER ‘zabbix’@’localhost’ IDENTIFIED BY ‘password’;

and now we’ll allow the user ‘zabbix’ to have all possible privileges on the database ‘zabbix’


GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' IDENTIFIED BY 'password'; 

now we can ‘quit;’ the database shell and create the database structure using the script provided by the Zabbix crew!

As root we do such a command:


zcat create.sql.gz | mysql -uzabbix -p<password> zabbix

This will read the config file from the gz and pass it to the pipe. The mysql command is quite simple

-u is for user

-p is for password (you can leave it blank and the prompt will ask you for it or fill it if you’re shure no one is peeking 😉 )

zabbix is the database name that will be populated

3) The Http server

My conf.d for zabbix:


server {
listen 80;
root /var/www;
index index.html index.php;
server_name <name_of_your_server>;

access_log /var/log/nginx/access.log;
gzip on;
gzip_min_length 1000;
gzip_types text/plain application/xml text/css text/js text/xml application/x-javascript text/javascript application/json application/xml+rss;
gzip_comp_level 4;
gzip_proxied any;

tcp_nopush on;
tcp_nodelay on;

#keepalive_timeout 0;
keepalive_timeout 10;
fastcgi_read_timeout 10m;
proxy_read_timeout 10m;
client_header_timeout 10m;
client_body_timeout 10m;
send_timeout 10m;
large_client_header_buffers 16 32k;

location /{
root /var/www/html;
}

location /zabbix {
# try_files $uri $uri/ /index.html = 404;

index index.php index.html index.htm;
#try_files $uri $uri/ index.php;
expires 30d;
}

#error_page 500 502 503 504 /50x.html;
#location = /50x.html {
# root /usr/share/nginx/html;
#}

location ~* \.php$ {
expires off;
if (!-f $request_filename) { return 404; }
fastcgi_split_path_info ^(.+\.php)(/.+)$;
#fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_index index.php;
fastcgi_read_timeout 300;
include fastcgi_params;
}
}

4) Edit the php.ini file

In Debian that file is located in: /etc/php5/fpm/php.ini

Set such values

 
<pre>post_max_size = 16M
max_execution_time = 300
max_input_time = 300
date.timezone = Continent/City
always_populate_raw_post_data = -1 

and restart php5-fpm

 systemctl restart php5-fpm 

5) I’ve copied the zabbix directory to /var/www/zabbix:

cp -R /usr/share/zabbix/ /var/www/zabbix 

6) After that install the server providing the data (database name, database username, database password, database host)

7) The default login credentials are: Admin / password

 

Cheers,
Wizard

SunwellCore Server

SunwellCore is an early fork of Trinity Core, a World of Warcraft emulator for one of the expansions – Wrath of the Lich King. It’s mainly known by beeing used on a international server – Sunwell, which was closed somwhere at the end of 2015 (or maybe early 2016, can’t remember). But enough of the whining about the server, let’s do the business.

For this server you’ll need (the same as for TrinityCore):
– the code (I just git cloned https://github.com/Kittnz/Sunwell.git)

– a database – Sunwell Core Crew have done it on MySQL, I’m doing it on MariaDB;

– a machine that will handle everything;

– A will to make it work.

  1. Meet the requirements for TrinityCore
  2. Get the code
    git clone https://github.com/Kittnz/Sunwell.git 
  3. For SunwellCore you should also get libACE, libtool, autoconf and those packages which are in the “dep” folder in my case I had to
    apt install libace-dev autoconf libtool libemalloc-dev libgsoap-dev libutfcpp-dev libg3d-dev
  4. To compile the source with map tools you need to get libmpq. It’s provided in Sunwell/dep/libmpq  I didin’t get this part working. I have compiled my version without map tools.
    You need to run:

    sh ./autoconf.sh
    ./configure
    make -j $(nproc)
    and as root, to install for the whole system: make install
  5. In the cloned repo create a build folder and change dir into it:
     mkdir build && cd build 
  6. After that we have to prepare our files for make and make install. To do that I’ve used:
    cmake ../ -DCMAKE_INSTALL_PREFIX=/home/<username>/sunwell_server -DCONF_DIR=/home/<username>sunwell <del>-DTOOLS=1</del>
  7. I’ve had some problems with the cmake so I made a small change in the file:
    /home/<username>/Sunwell/src/server/shared/Packets/ByteBuffer.h

    I’ve edited the line

     return uint32(mktime(&lt) + _timezone);

    to

    return uint32(mktime(&lt)); 
  8.  If we’ve done everything correctly we should be able to compile and install our files. If you have a multicore machine you can use
    make -j $(nproc) 

    to use all the cores. Otherwise you can use

     make 

    or if you don’t want all the cores to be involved, you can use

     make -j <numberofcores> 

    and set the desired number of cores. Of course the same thing works for

     make install 

    or

     make -j $(nproc) 
  9. If you have problems with swap and RAM during compilation – keep on reading. Otherwise continue to the next step. During the install of my machine, I have set my swap partition too small. Apparently it was causing problems during the compilation (all ram and swap was full) so I’ve created a swapfile.

All these commands are supposed to be done as root or sudo

9.1 Create a file. I’ve created a 1 gigabyte file:

 dd if=/dev/zero of=/tmp/swap bs=1M count=1000

 

 

9.2 Format the swap file:

 mkswap /tmp/swap 

9.3  Change the chmod to 0600

 chmod 0600 /tmp/swap 

9.4 Add the file to /etc/fstab

/tmp/swap swap swap defaults 0 0 

9.5 Run

 swapon -a 

to activate the swap

 

9.6 Redo the compilation & installation process.

10. Database

The fabulous creators of Sunwell Core have actually provided us with the database. It’s full of their fixes (or hacks and temp solutions, as the creators of creators of TC like to call it on their IRC channel).

First of all you need to create a user and some databases, I’ve changed a bit the script provided by the TC crew:


GRANT USAGE ON * . * TO 'sunwell'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

CREATE DATABASE `sc_world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `sc_characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `sc_auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON `sc_world` . * TO 'sunwell'@'localhost' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `sc_characters` . * TO 'sunwell'@'localhost' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `sc_auth` . * TO 'sunwell'@'localhost' WITH GRANT OPTION;

after that you need to “fill” the database with data. The Sunwell crew provided all changes and all you need to do is:

 mysql -usunwell -p databasename < file_to_import.sql 

or if you have more files you cant also use:

 cat *.sql | mysql -usunwell -p databasename 

As you can guess you need to import the files to the right database. They mostly go to the *world database.

11. Maps

Because I wasn’t able to compile the core with tools, I had to use the provided maps. All you need to do is to unpack them to the right folder (pointed in the worldserver.conf). Here are the files: DbcMapsMMapsVMaps

12. Config

Once again, the Sunwell Crew thought about us and prepared a config. They’re located in the extras folder in the cloned git repo. After compilation copy them into the /etc folder. You need to edit the part about connecting to the database (in both, worldserver and authserver), RealmName (in worldserver), DataDir (well, you can leave it, but I create a seperate one) and your LogsDir (also in worldserver). For example, check the Trinity Core Documentation

13. Hey ho, let’s go!

1. Get screen
2. go to your compiled folder
3. start on seperate screen sessions:

 bin/authserver

and

bin/worldserver 

If you have don everything right, you should start your own server. If you want to set it public / lan than follow Realmlist Table paragraph

This little tutorial is not perfect. It might contain mistakes. But I hope it helped you.

If you have any questions or suggestions post them in the comment section. I’m not a developer. I’m not an expert. But I’m someone who spent some time on this server and I am very grateful to Xinef, Pussywizard, Jajcer and rest of the crew for allowing me to meet all the awesome people and spend great nights and evenings. I hope you guys are doing well.

Cheers,
Wizard