This is out dated and converted to a VIDEO tutorial!
Please view it here:
http://otland.net/f479/video-tutorial-nothing-fully-working-ot-server-website-shop-system-166818/
Thread closed.
//If you encounter any problems, check our Troubleshooting section HERE before replying.
Hello, there has been quite a while since I made a tutorial. But I figured this would be a good time.
I was searching the web, looking for alternatives to XAMPP, because using XAMPP for this Open Tibia community is a really bad habit!
XAMPP is for testing purposes mainly for your local machine, if you get into problems using XAMPP, and posting it at their forum, they will stamp you "IDIOT" in your head, and saying "XAMPP has never been made and probably will never be made for serious hosting".
XAMPP is made for testing purpose. And it is insecure, and heavy.
I was browsing the web, hoping to find an easier installation and use alternative to xampp.
And that is Uniform Server.
Why use Uniform Server instead of XAMPP?
1. Security
2. Lightweight (xampp 51MB, XAMPlite 28MB. Uniform Server 8.75MB).
3. Easier to use.
4. XAMPP got lots of unnecessary features, especially for the Open Tibia community. Despite the small size of Uniform Server, it has all we need.
Installing Uniform Server will give you:
MySQL database.
phpMyAdmin to administrate the MySQL database.
Apache hosting.
PHP 5.3.5+
eAccelerator to make website faster.
XAMPP + Modern AAC = Page rendered in: 0.0554 seconds.
Uniform Server + Modern AAC = Page rendered in: 0.0219 seconds.
Do I need to say more? So lets get started!
Getting Started:
First we need to download latest version of Uniform Server, download it at this link:
Version: 7.0.1 Windows 7/2008 32 & 64bit users.
7.0.1 download from SourceForge.net
Version: 5.7.5 Windows XP 32bit users.
5.7.5 download from SourceForge.net
If the links from sourceforge dont work, feel free to use my alternative uploads:
~Edit: alternative uploads temporarily unavailable~
If you are having problems with the sourceforge links above, reply on this thread and I will fix alternative mirrors again.
If you dont, I wont add alternative mirrors any longer. If people dont need it, then its waste of time for me.
[email protected] said:UniServer 7.0.1-Orion Released:
Core components:
Apache 2.2.17
MySQL 5.5.11 - Update
PHP 5.3.6
phpMyAdmin 3.3.10 - Update
Go-Pear 1.1.2
msmtp 1.4.23
eAccelerator 1.0-snv427
WinBinder 2010.10.14
OpenSSL 1.0.0d
Regards,
The Uniform Server Development Team
Code:
UniServer 5.7.5-Nano:
Core components:
Apache 2.2.17
MySQL 5.5.10 -- Update
PHP 5.3.5
phpMyAdmin 3.3.9.2
Go-Pear 1.1.2
msmtp 1.4.23
eAccelerator 1.0-snv427
OpenSSL 0.9.8q
When running the program, it will ask to install it to something bothersome like:
C:Usersprogram files
or something similar.
Don't install it there, you can do it, but windows filesystem is crap so we want to save it as close root as possible.
So install it directly to
C:
And click Extract.
Installation complete. That wasn't so hard?
But we still need to learn to configure and use it, lets get to that now:
Click Start.
Whohaw! You started it!
OMG! POPUP MSG; your computer will crash
Just kiddin.
The message simply says there will be an icon at the bot, the icon with "1".
That little icon is the configuration panel of Uniform server.
Right click = Services
Left click = Start without running as services.
Services = It will start automatic, if you restart your computer, it will automatic restart so you won't have to click "start".
start and Stop UniServer = start and stop the website and Mysql database.
If you click on Stop while your OT server is running your in problems. Since you close the MySQL database. So don't do that while OT is online!
What else is useful is phpMyAdmin, click on it and you will connect to phpMyAdmin, so you don't need to remember the address.
What else which is very useful is "Server Status". Lets click it:
Now that's awesome!
This tells you your global IP address, this is the IP you are suppose to paste in config.lua on your OT server!
Code:
Your Internet IP Address = 85.19.89.238
Can other players see your website? Have you opened the necessary ports and everything is working fine? On my school computer, NO!
Code:
Accessible from Internet = NO
Port 80 is default, if you choose another port, when you enter your website, you need to write :xxxx (depending on port). However, with port 80 this is not neccesary.
Make sure to port forward port 80.
Code:
Apache port = 80
Install status, if "as program" it is running, but it will not restart and such things automatic. If running as Services, it will boot automatic when computer restarts and such things.
Code:
install status = Installed as a standard program
This here is also good, it tells you if the ports are available, and if they are in use, what program is using them!
Code:
PORT STATUS:
Apache port = 80 In use by this server
Apache SSL port = 443 SSL Not enabled free to use
MySQL port = 3306 In use by this server
Code:
Now start uniserver, and click "Admin Panel"
Fix the security steps:
Once you have done the 4 steps click on "security console" on this message:
Code:
Run the Security Console and see if everything is OK.
Code:
Server Certificate and Key (SSL)
Unsecure indicates you do not have a server certificate or key. Create new ones by clicking the UNSECURE link.
UNSECURE
Don't secure php safe mode. Its no point in doing it.
Having this as "Unsecured" should not be a problem tho. Correct me if I am wrong if you know why we should keep it secured.
And thats it, you have secured the basics.
However, we can still do some fine tuning on phpmyadmin. Lets configure it now!
We don't need 2 root accounts, so we shall delete 1 of them. Lets keep 127.0.0.1 since it has bigger compatibility than localhost. (Does not matter much anyway, you can connect to 127.0.0.1 using localhost on windows anyway).
To avoid standard hijacking programs, lets rename the remaining root user into our own custom root username!
Thumb rule1: Never connect to database with a root user. Do not use this user when you connect your OT to your database. I will explain further later.
Ohh shit!
Don't worry! If you got this error, it means it WORKED PERFECTLY AS WE WANTED IT TO! So now is the time to say "Wohoo!".
But well, lets make sure we can access our secured phpmyadmin. D:
Enter
Code:
C:\UniServer\home\admin\www\phpMyAdmin
and look for file named:
config.inc.php
Open it in notepad++. Or regular notepad. (Text document).
Change from:
PHP:
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
TO:
PHP:
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
Don't change anything else here, don't change root to your new root name or anything like this. Just leave it root here, for security reasons.
Scroll a little down and you see:
PHP:
/* PMA User advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
change
PHP:
$cfg['Servers'][$i]['controlpass'] = '';
To a 8 numbered long password! Remember this password since we need to configure phpMyAdmin later with it!
Now we re-enter phpMyAdmin:
And you get this result, now login with your edited root account:
Problem shooting:
I got some problems here, i could not login with my new username.
How I fixed this:
Click "stop UniServer"
and then click
"start UniServer".
If that does not work, try to do a computer restart to clear out the cache. Or click ctrl + F5 to reload phpMyAdmin without cache.
If reloading site without cache does not work, reboot your computer,(to control check that the programs are properly turned off) And then login again. Make sure you login with your correct new username and password and not root!
After a computer reboot it worked for me, and I got in.
Remember we added a password to pma? Now add that password here, that way, even though pma 'might' be harmless, it is secured.
Last edited: