MySQL From nothing to a fully working, secured OT server. [Uniform Server] + [TFS 0.3.6]
- Thread starter Znote
- Start date
- Status
LoLaye
Active Member
Thats what i get after typing
http://localhost/apanel/phpmyadmin/
Any idea?
http://localhost/apanel/phpmyadmin/
PHP:
phpMyAdmin - Error
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.Any idea?
OP
OP
and
The cache on your web browser got messed up when you changed your phpmyadmin from config to cookie/httpd.
Use another browser, or reboot your computer. Or clear the browsers cache.
Example: If you got this error on google chrome, use firefox or IE. If you got this message on Firefox or IE, use google chrome.
Hi Znote!
I can't connect to my admin panel "localhost/apanel/"
But i found this in "server status"
I don't no the problem so please help
rep++
Apparently Apache and Mysql is not running on your system. Click "Start UniServer" in the tray menu.
andWhat scripting language does OPEN TIBIA use?
Could not connect to database.
Could not find your database
Modern AAC install
[/URL][/IMG]
1. Never use localhost. Use the IP 127.0.0.1
2. Make a new user in phpmyadmin, make sure to write 127.0.0.1 in host instead of the default localhost (see my tutorial for more detailed information on how to do this)
3. write the correct information for this user you just made when installing website.
I have updated the troubleshooting section. Everybody are advised to check it out before replying. Since your question has most likely been answered 10+ times already in this thread.
Check the troubleshooting section HERE.
Last edited:
LoLaye
Active Member
Uhm, on my router i've got all 3 (start port:7171 end port:7171 start port:7172 end port:7172 start port:80 end port:80)
But on vapus.net/canihost it tells me that only port 80 is working.. any idea Znote?
But on vapus.net/canihost it tells me that only port 80 is working.. any idea Znote?
OP
OP
TCP - Start port: 7170 End Port: 7180
TCP - Start Port: 80 End Port: 80
UDP - Start port: 7170 End Port: 7180
UDP - Start Port: 80 End Port: 80
LoLaye
Active Member
Hi, I've got problem. When I import mysql file i have:
Error SQL query:
DROP TRIGGER IF EXISTS `oncreate_players` ;
MySQL said: Documentation
#1046 - No database selected
Can you help me? Maybe i have wrong mysql file? This is important to me.
Sry for my bad english.
Error SQL query:
DROP TRIGGER IF EXISTS `oncreate_players` ;
MySQL said: Documentation
#1046 - No database selected
Can you help me? Maybe i have wrong mysql file? This is important to me.
Sry for my bad english.
OP
OP
Well I cant help you any further since I am not well known with your router.
Or wait, if you browse around in your router panel, you should find "DMZ host".
Set it to your local IP. By doing this all ports are being ported to your computer.
For security reasons you should avoid this, but if no other options are working, this is the way.
Use Modern AAC.
You forgot to click on the database name before you clicked Import. Select the database name located in the left panel in phpmyadmin.
config.lua is set completely well, server connects to the db easily but the ACC still can't do that why? :/
FIXED - but the reason why it didnt work is still hmmm at least strange
solution:
using xampp, phpmyadminn looks as below:
using uniServ, phpmyadmin looks as below:
when I changed in config.lua
to
IT WORKS, F*****G WEIRD ENNIT
one more issue
uniServ or xampp
apache from time to time crashes on win7 that is only me or someone's got it as well?
FIXED - but the reason why it didnt work is still hmmm at least strange
solution:
using xampp, phpmyadminn looks as below:
using uniServ, phpmyadmin looks as below:
when I changed in config.lua
Code:
sqlHost = "localhost"
Code:
sqlHost = "127.0.0.1"IT WORKS, F*****G WEIRD ENNIT
one more issue
uniServ or xampp
apache from time to time crashes on win7 that is only me or someone's got it as well?
Last edited:
Exiled Pain
Fervid Learner
- Joined
- Jan 8, 2008
- Messages
- 552
- Reaction score
- 4
Sup, at the beggining of the post you comment that: For security reasons, do NOT port/open MySQL port. We don't want outsiders to sneak in our database.
So... that was only for the start before securing everything or at all-time, even after everything is done? And will the players be able to use the website?
So... that was only for the start before securing everything or at all-time, even after everything is done? And will the players be able to use the website?
OP
OP
Perhaps Apache is more stable if your running Modern AAC instead of Gesior. I have never had any problems with apache after I moved over to Uniform Server.
(But at this time I also moved over to Modern AAC).
1. Don't use root, but a user you made on phpmyadmin.
2. Dont use localhost, use 127.0.0.1
3. After installing Uniform Server, do a computer reboot to clear cache properly.
Still having problems, give me more specific what you do to reproduce it. What you have done, what you have installed, what you are using.
Opening the ports will make it easy to use an own installed program to bruteforce themselves into your database by attempting to do thousands of different passwords every second until they finally manages to detect the correct password. Then your in problems.
Thats why we rather use phpmyadmin than having the mysql port open. That way nobody have direct access to the database, only through a 3rd party program like phpmyadmin.
Phpmyadmin will only allow a few attempts and then abort the connection. So bruteforcing programs wont work.
Last edited:
E
Evil Puncker
Guest
lol, i forgot my "root(username)" password, how to do now? xD i need to create a table, but i have only the OT user password
OP
OP
lol, i forgot my "root(username)" password, how to do now? xD i need to create a table, but i have only the OT user password
Enter apanel ( http://127.0.0.1/apanel )
In the menu, click restore mysql root.
Dankoo
Active Member
- Joined
- Sep 4, 2010
- Messages
- 1,007
- Reaction score
- 27
My problem:
My database:
Is is correct?
My database:
Lua:
/*Database information*/
$config['database']['host'] = "127.0.0.1";
$config['database']['login'] = "MY USERNAME";
$config['database']['password'] = "MY PASSWORD";
$config['database']['database'] = "MY DATABASE";Is is correct?
OP
OP
No, you haven't followed my tutorial properly.
You are trying to access your database using administrator mysql account ,bad bad bad!
When using Modern AAC, dont login with root/admin account. In priviledges, click "Add a new User" restrict this user to only have access to 1 database, use this database user on both config.lua in your OT and in config.php in Modern AAC.
make sure to follow my tutorial properly!
Also, I see the error message "Connection for controluser as defined in your configuration failed."
This should also be fixed. Go back to the guide, click CTRL + F and search for etc controluser and follow my guide properly.
If there would be things not necessarily to do, I would not write it in the guide.
Dankoo
Active Member
- Joined
- Sep 4, 2010
- Messages
- 1,007
- Reaction score
- 27
No, you haven't followed my tutorial properly.
You are trying to access your database using administrator mysql account ,bad bad bad!
When using Modern AAC, dont login with root/admin account. In priviledges, click "Add a new User" restrict this user to only have access to 1 database, use this database user on both config.lua in your OT and in config.php in Modern AAC.
make sure to follow my tutorial properly!
Also, I see the error message "Connection for controluser as defined in your configuration failed."
This should also be fixed. Go back to the guide, click CTRL + F and search for etc controluser and follow my guide properly.
aaah I've jumped step 2
didn't see the tutorial continues in post 2 haha, gonna continue with it... =o
- Status
Similar threads
