MySQL From nothing to a fully working, secured OT server. [Uniform Server] + [TFS 0.3.6]
- Thread starter Znote
- Start date
- Status
I have done like in your turial but i cant go to webside like phpmyadmin and admin panel why ?
And when i check my server its say that sql not are installed, do i need to downlode them to ? or is sql and everything in this program, and if some one know how to fix this problem how i do it ?
And when i check my server its say that sql not are installed, do i need to downlode them to ? or is sql and everything in this program, and if some one know how to fix this problem how i do it ?
OP
OP
Everything should be in this program.
If you click on server status, does it say that mysql and apache is runned by this program, or something else?
If you click on server status, does it say that mysql and apache is runned by this program, or something else?
- Joined
- Jun 19, 2009
- Messages
- 1,852
- Reaction score
- 5
When I check "Server Status" it says that Apache and MySQL is running by *this* program.
edit: u were talking to zarn xd I'm stupid when I wake up..
edit: u were talking to zarn xd I'm stupid when I wake up..
OP
OP
I just compared XAMPP with Uniform Server with Modern AAC and the result:
Uniform server is generating pages more than double the fast as XAMPP.
I will create a "How to add Modern AAC to Uniform server" once TFS 0.4 and Modern AAC is public. _
I just recently tested it and it works great on Uniform Server.
Uniform server is generating pages more than double the fast as XAMPP.
I will create a "How to add Modern AAC to Uniform server" once TFS 0.4 and Modern AAC is public. _
I just recently tested it and it works great on Uniform Server.
D
Deleted member 12419
Guest
I just compared XAMPP with Uniform Server with Modern AAC and the result:
Uniform server is generating pages more than double the fast as XAMPP.
I will create a "How to add Modern AAC to Uniform server" once TFS 0.4 and Modern AAC is public. _
I just recently tested it and it works great on Uniform Server.
Znote Modern AAC is now officially public
http://otland.net/f37/modern-aac-open-beta-80739/#post829903
Id love to know How to add Modern AAC to Uniform server and secure it in the best way possible
eace:
Can't get it to connect my MySQL database. I get this error message in browser :
and if I change my database information to an other username and password this appears :
Code:
Can't connect to MySQL database.and if I change my database information to an other username and password this appears :
Code:
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Code:
[04/05/2010 09:43:06] >> Loading config (config.lua)
[04/05/2010 09:43:06] > Using SHA1 encryption
[04/05/2010 09:43:06] >> Checking software version... up to date!
[04/05/2010 09:43:06] >> Fetching blacklist
[04/05/2010 09:43:07] >> Loading RSA key
[04/05/2010 09:43:07] >> Starting SQL connection
[04/05/2010 09:43:07] >> Running Database Manager
[04/05/2010 09:43:08] > No tables were optimized.
[04/05/2010 09:43:08] >> Loading items
[04/05/2010 09:43:09] >> Loading groups
[04/05/2010 09:43:09] >> Loading vocations
[04/05/2010 09:43:09] >> Loading script systems
[04/05/2010 09:43:10] [Warning - Actions::registerEvent] Duplicate registered item aid: 2000
[04/05/2010 09:43:10] [Warning - Actions::registerEvent] Duplicate registered item aid: 2001
[04/05/2010 09:43:12] >> Loading chat channels
[04/05/2010 09:43:12] >> Loading outfits
[04/05/2010 09:43:12] >> Loading experience stages
[04/05/2010 09:43:12] >> Loading monsters
[04/05/2010 09:43:22] >> Loading mods...
[04/05/2010 09:43:22] > Loading buypremium_command.xml... done.
[04/05/2010 09:43:22] > Loading changender_command.xml... done.
[04/05/2010 09:43:22] > Loading custommonsters.xml... done.
[04/05/2010 09:43:22] > Loading customspells.xml... done.
[04/05/2010 09:43:22] > Loading firstitems.xml... done.
[04/05/2010 09:43:22] > Loading highscorebook.xml... done.
[04/05/2010 09:43:22] > 6 mods were loaded.
[04/05/2010 09:43:22] >> Loading map and spawns...
[04/05/2010 09:43:24] > Map size: 1000x1000.
[04/05/2010 09:43:24] > Map descriptions:
[04/05/2010 09:43:24] "Saved with Remere's Map Editor 1.1.11"
[04/05/2010 09:43:24] "Mintwalllin Map"
[04/05/2010 09:43:37] > Map loading time: 14.75 seconds.
[04/05/2010 09:43:43] [Error - LuaScriptInterface::loadFile] cannot open data/npc/scripts/rashid.lua: No such file or directory
[04/05/2010 09:43:44] [Warning - NpcScript::NpcScript] Cannot load script: data/npc/scripts/rashid.lua
[04/05/2010 09:43:44] cannot open data/npc/scripts/rashid.lua: No such file or directory
[04/05/2010 09:43:48] [Spawn::addMonster] Cannot find "Jungle Maw"
[04/05/2010 09:43:48] [Spawn::addMonster] Cannot find "Jungle Maw"
[04/05/2010 09:43:48] [Spawn::addMonster] Cannot find "Jungle Maw"
[04/05/2010 09:43:48] [Spawn::addMonster] Cannot find "Jungle Maw"
[04/05/2010 09:43:49] > Data parsing time: 11.14 seconds.
[04/05/2010 09:43:52] > Houses synchronization time: 3.579 seconds.
[04/05/2010 09:43:57] > Content unserialization time: 4.984 seconds.
[04/05/2010 09:43:58] >> Checking world type... PvP
[04/05/2010 09:43:58] >> Initializing game state modules and registering services...
[04/05/2010 09:44:00] > Global address: 127.0.0.1
[04/05/2010 09:44:03] > Local ports: 7171 7172
[04/05/2010 09:44:03] >> All modules were loaded, server is starting up...
[04/05/2010 09:44:03] >> Mintwallin server Online!But when i try to log in on my character it says that the password it's incorrect even the account manager. I don't know what's wrong..
OP
OP
Enter phpmyadmin, and set password for account manager (1) to:
356a192b7913b04c54574d18c28d46e6395428ab
Then it should work fine, login with 1/1.
Enter:
UniServer\usr\local\php
Open the file "php" or "php.ini" in a text document and search for:
;extension=php_pdo_mysql.dll
Then remove the (
so the result is:extension=php_pdo_mysql.dll
Then click "Stop Uniserver".
Wait 5 - 10 sec, and then click "Start Uniserver".
And it should work fine. ^^
Yep it worked, thank you. I'm giving rep, you really deserve it.
D
Deleted member 12419
Guest
Znote how is the tutorial going? you promised to make it by today
I wanna make so donation system works in my server but I have no clue how to make it work with uniserver and Modern AAC its completly different it seems. Dunno which donation system is best? Prefer to have a donation system that is international meaning all can donate.
I wanna make so donation system works in my server but I have no clue how to make it work with uniserver and Modern AAC its completly different it seems. Dunno which donation system is best? Prefer to have a donation system that is international meaning all can donate.
OP
OP
To busy today, so can't.
But here is a quick guide to do it until I finish the detailed version:
After you have configured Uniform Server properly as I described in this thread.
Download latest rev of Modern AAC
Remove everything in the folder named "www" and put in the Modern AAC files there.
Then enter website OtLand and you will get to modern aac installation website.
After installation, remove everything in www/install.
And it should be working.
But here is a quick guide to do it until I finish the detailed version:
After you have configured Uniform Server properly as I described in this thread.
Download latest rev of Modern AAC
Remove everything in the folder named "www" and put in the Modern AAC files there.
Znote said:Enter:
UniServer\usr\local\php
Open the file "php" or "php.ini" in a text document and search for:
;extension=php_pdo_mysql.dll
Then remove the (
extension=php_pdo_mysql.dll
Then click "Stop Uniserver".
Wait 5 - 10 sec, and then click "Start Uniserver".
Then enter website OtLand and you will get to modern aac installation website.
After installation, remove everything in www/install.
And it should be working.
Enter:
UniServer\usr\local\php
Open the file "php" or "php.ini" in a text document and search for:
;extension=php_pdo_mysql.dll
Then remove the (
extension=php_pdo_mysql.dll
Then click "Stop Uniserver".
Wait 5 - 10 sec, and then click "Start Uniserver".
And it should work fine. ^^
Thank you, it worked!
D
Deleted member 12419
Guest
Znote I am at beginning of your tutorial the part that I need install apache and mysql as services or install them normally.
I have tried pretty much everything I use windows 7 64 bit have disabled UAC and running the start.exe as adminstrator. Yet when I right click and Install and run all services or using individual service controll method. Still a black window quickly opens and close I barely have time to see what's written in it. Then I open "server status"
And it says
Edit: Managed somehow to get the program to install MYSQL however This error happens
Edit2: Finally was able to fix it you gotta love google lol.
http://techreviews.in/port-80-unava...t-80-and-make-it-available-for-apache-server/
By his guide I was able to stop the proccess that was using port 80 and successfully installed Apache and MYSQl. You should put this link or the instructions in first post because I'm sure many ppl that use windows 7 have this problem. It was really frustrating thought it was something wrong with my computer almost did a clean install (reformat and everything)
I have tried pretty much everything I use windows 7 64 bit have disabled UAC and running the start.exe as adminstrator. Yet when I right click and Install and run all services or using individual service controll method. Still a black window quickly opens and close I barely have time to see what's written in it. Then I open "server status"
And it says
Code:
================== UNIFORM SERVER STATUS ==================
Your Internet IP Address = XXX.XXX.XXX.XXX
Accessible from Internet = NO
Cron run status = Not running
PHP INI: php.ini file = Production
APACHE SERVER:
Apache port = 80
Apache SSL port = 443
Apache executable name = Apache.exe
Apache service name = ApacheS1
Apache SSL server = Disabled
Apache run status = Not running
Apache install status = Free to install
MySQL SERVER:
MySQL port = 3306
MySQL executable name = mysqld-opt.exe
MySQL service name = MySQLS1
MySQL run status = Running
MySQL install status = Installed as a standard program
PORT STATUS:
Apache port = 80 In use by another program.
Apache SSL port = 443 Is free to use
MySQL port = 3306 In use by this server.Edit: Managed somehow to get the program to install MYSQL however This error happens
Code:
Apache port = 80 - Failed port already in use!
SSL not enabled skipping port test.
Failed! To install Apache service both ports must be free!
Apache Syntax check - Syntax OKEdit2: Finally was able to fix it you gotta love google lol.
http://techreviews.in/port-80-unava...t-80-and-make-it-available-for-apache-server/
By his guide I was able to stop the proccess that was using port 80 and successfully installed Apache and MYSQl. You should put this link or the instructions in first post because I'm sure many ppl that use windows 7 have this problem. It was really frustrating thought it was something wrong with my computer almost did a clean install (reformat and everything)
Last edited by a moderator:
OP
OP
Try and compare it with Uniform Server to see what's most effective. Compared with xampp and uniform server is more than double the fast.
Nice Znote
- Status
