Rumor

If you can make it run on linux, sure. Otherwise you may choose to run website/patcher or other things on it that are needed for your server such as a seedbox for torrents or another http download mirror.

This is a Debian 7 nginx, MariaDB, and PHP-FPM (+phpMyAdmin) installation guide. Note on MariaDB: This is meant to be a REPLACEMENT of MySQL. It should work where MySQL works. 1. Installing and configuring nginx. # apt-get install nginx # service nginx start Now if you open your IP address or website address in your browser you should see a "Welcome to nginx!" page. This means you've successfully installed nginx. Now to configure... # nano /etc/nginx/sites-available/default Under the Server section set your "server_name" to your FQDN (fully qualified domain name). Don't forget to include "index.php" on the "index" line. It should look somewhat like this when finished: server { listen 80 default_server; listen [::]:80 default_server ipv6only=on; root /usr/share/nginx/html; index index.php index.html index.htm; # Make site accessible from [Hidden Content] server_name mywebsitedomain.com; Scroll down to the Location section and uncomment the necessary lines. Make modifications as shown: location ~ .php$ { try_files $uri =404; fastcgi_split_path_info ^(.+.php)(/.+)$; # # NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini # # # With php5-cgi alone: # fastcgi_pass 127.0.0.1:9000; # # With php5-fpm: fastcgi_pass unix:/var/run/php5-fpm.sock; fastcgi_index index.php; include fastcgi_params; } CTRL+X, Y, Enter. Now you need to edit the nginx.conf file: # nano /etc/nginx/nginx.conf Set your "worker_processes" equal to your amount of cores. In this case I'll be using 4. Set your "worker_connections" equal to the input of the following command: # ulimit -n Change "keepalive_timeout 65;" to "keepalive_timeout 15;" then add these lines under the http block: client_body_buffer_size 10K; client_header_buffer_size 1k; client_max_body_size 8m; large_client_header_buffers 2 1k; client_body_timeout 12; client_header_timeout 12; send_timeout 10; CTRL+X, Y, Enter. You can test your configuration before proceeding, and if there are any mistakes you will be notified what they are and on which line. # nginx -t A correct modification of the configuration should output this data: nginx: the configuration file /etc/nginx/nginx.conf syntax is ok nginx: configuration file /etc/nginx/nginx.conf test is successful Restart nginx: # service nginx restart 2. Installation of MariaDB. # apt-get install python-software-properties # apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db # add-apt-repository 'deb [Hidden Content] wheezy main' # apt-get update # apt-get install mariadb-server mariadb-client -y Set the root user password for mysql when prompted. This is how you enter the prompt, when finished just type "quit": # mysql -v -u root -p Enter the root sql password you just chose. It will look like this, and you can figure out more things by following the notes: Welcome to the MariaDB monitor. Commands end with ; or g. Your MariaDB connection id is 2579 Server version: 10.1.1-MariaDB-1~wheezy-wsrep-log mariadb.org binary distribution, wsrep_25.10.r4123 Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Reading history-file /root/.mysql_history Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. MariaDB [(none)]> You can check the status of the server like this: # service mysql status Example output of command: [info] /usr/bin/mysqladmin Ver 9.1 Distrib 10.1.1-MariaDB, for debian-linux-gnu on x86_64 Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Server version 10.1.1-MariaDB-1~wheezy-wsrep-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 11 hours 8 min 3 sec Threads: 1 Questions: 44634 Slow queries: 0 Opens: 431 Flush tables: 1 Open tables: 113 Queries per second avg: 1.113. 3. Installation of PHP-FPM # apt-get install php5 php5-fpm php5-mysql # nano /etc/php5/fpm/php.ini Scroll down to the line "cgi.fixpathinfo=1" and uncomment it. Change the value from 1 to 0. Restart the service: # service php5-fpm restart Create a phpinfo page: # nano /usr/share/nginx/html/phpinfo.php Here are the contents of the file you've created: <?php phpinfo(); ?> CTRL+X, Y, Enter. Now in your browser, navigate to your IP address or domain followed by the phpinfo.php file. Here's an example: [Hidden Content] 4. Installation of phpMyAdmin # apt-get install phpmyadmin Select either option and hit OK. Even though we aren't using apache2 or lighttpd, we can make this work with nginx. Select "<Yes>" when prompted to configure database for phpmyadmin with dbconfig-common. Enter the SQL password you chose earlier as the "administrative user" password. Now enter a password for use with phpMyAdmin. Now to make it work with nginx we're going to use a symlink: # ln -s /usr/share/phpmyadmin/ /usr/share/nginx/html # service nginx restart Navigate in your browser to your IP/domain name and append a "/phpmyadmin" to the end like this: [Hidden Content] You can now login with the username root and password chosen earlier. You can use phpMyAdmin to easily setup databases and user accounts for anything you want to install that requires SQL.

Thankfully, we have the tutorial for FreeBSD by Shogun here: [Hidden Content] Today's example should work on Unbuntu and some other OS as well. This example is based off Debian 7 Wheezy. It's almost an identical process. 1. Add the new user account and restrict sudo usage. Be root user before continuing! # adduser roman This will prompt the user for input, you can leave it all default. Type in a password when prompted. # nano /etc/pam.d/su Go down and uncomment the following line: #auth required pam_wheel.so CTRL+X, Y, Enter. 2. Permit the new user account to use the wheel group with root privileges: # groupadd wheel # usermod -G wheel roman 3. Create your private key and configure WinSCP to use it. # cd /home # chown -R roman:wheel roman/ # su roman # ssh-keygen Accept all defaults with enter. # cd roman/.ssh # mv id_rsa.pub authorized_keys # cat id_rsa Copy the entire output (including the comments) by highlighting it in PuTTy then paste it into a text file and save it. Download this program: [Hidden Content] Run puttygen and click "Load" then select "All Files" from the file dialog and select the text file you saved the key to. Click "Save Private Key" and select "Yes" on the popup regarding password. Now open WinSCP and add a new connection with the same IP address but with the new user name (in our example, "roman"). Click "Advanced" then click "Authentication". Click the three dots ("...") and select the ppk file you saved using puttygen. Click "OK" then save your connection. 4. Disable root login and password authentication. # su root Enter the root password when prompted. # nano /etc/ssh/sshd_config Go down to the line called "PermitRootLogin" and change it's value to "no". Go down to the line called "PasswordAuthentication" and change it's value to "no". Uncomment this line. CTRL+X, Y, Enter. Now restart the ssh service and you're done. # service ssh restart If you're unsure about what you're doing, I recommend leaving an extra root terminal open in PuTTy so if something goes wrong you can reverse your changes.

Ignore annotation..

Moved to own thread. This: [Hidden Content] not the correct place to post your question.

make another folder for your new server.. for example.. /home/server1 <- current server files /home/server2 <- new server files make a copy of your db and rename the databases with a 2 on the end or some other unique identifier to indicate it's for the new server. you can still put these copies in the /var/db/mysql directory. In the config files for the new server, be sure to link the database names correctly, appending the identifier for your new server to match the database names. Assuming your start script is relative to the directory the server files are in, you don't have to modify it; otherwise you need to adjust this as well as the other scripts to deal with the new files.

He said before the bruteforce

I've been wanting to see this since I saw the trailers when I was on vacation. I have downloaded a few copies but I'm waiting for a quality copy Chloe<3 There is a 1080p BluRay copy xD I couldn't find one back then. I downloaded one yesterday in 1080p and watched it. It wasn't too interesting honestly :/ but she's cute. lol.

which is from my tut

I'm 25, but as I've said I lost patience for his attitude.. People like this in general just really annoy me. They can barely type and they argue the most ridiculous points over and over despite showing them they're wrong. It's just too much to take sometimes when people won't accept the truth.

Just like anywhere else, my dear. Using this all the time. Twig is good. However, even Symfony (which is the number one framework to use Twig) offers PHP "templating". BTW, props to the OP for showering in only eight minutes. Seems like getting an account on that server got you quite excited. Hennink's script was pretty fine back when it was written. It is "designed" like many not-so-optimal scripts, and there were quite some critical flaws, which eventually got patched individually over time. It was also back then (and still, to some extent, is today) when php-mysql was simply the most common MySQL API in PHP with the highest likelyness to be available on almost any PHP installation and hosting provider. The PHP landscape changed a lot in recent years and frameworks as well as object orientation are omnipresent now. Yeah I'm not a chick I do what needs to be done and have no reason to waste time or spend hours in the shower. Don't be jelly cuz im efficient lol.

beat you to it in Feb 2014 [Hidden Content]

I see your point, however I lost all patience with this kid after waiting for him for 4 days and having him insult my intelligence every time I told him it doesn't work.

I've been wanting to see this since I saw the trailers when I was on vacation. I have downloaded a few copies but I'm waiting for a quality copy Chloe<3

[Hidden Content]

Judging by the way you're typing and the ridiculous story you expect people to believe I'm gonna have to call bullshit on this one and say you're trying to get into someone else's server.

Maybe your game core isn't using the txt-based proto files? in CONFIG add this line: PUBLIC_IP: x.x.x.x Only belongs in channels and auth. The x's represent the public IP on your server.

Please tell me you're kidding..

nobody expected you to have that long folder directory but FYI you can use tab to autocomplete things in putty. type "ps" and make sure processes are running because the protos should populate with the data from the txt files in the server files. Also about being unable to delete the table, post the exact error please.

exactly, says 6 but even with 8 it doesn't work..lol Just because some people can do it doesn't mean it works. For it to be considered working everyone should be able to register. The error is on the website end because it has nothing to do with the page not loading correctly. It's spitting out an error about the registration each time.