MySQL From nothing to a fully working, secured OT server. [Uniform Server] + [TFS 0.3.6]

[johanivarsson]

After i deal with the Modern AAC creation i get this error message, anyone that can help me with it. Id appreciate it and repp u

A Database Error Occurred
Error Number: 1146

Table 'otserver.poll_votes' doesn't exist

SELECT * FROM poll_votes WHERE answer_id = 0

 

[wildcatk23]

Forbidden

You don't have permission to access / on this server.

When other people try to access it.

 

[stelli]

I did everything like in the tutorial in if I try to login on my 9.1 Server I get to the Character List - try to login with the account manager - and get a connection timeout error...anyone knows a solution?

 

[milkys]

How do i make server reset on my server the easiest way, you know all chars and etc?<_<

 

[TheMaX]

E-P-I-C TUTORIAL!!!

That's all.
Like.

 

[Sentielo]

Hello, I got this error message when I go the the admin pannel after doing the steps your tutorial told me to do:

Forbidden
You don't have permission to access /apanel/ on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 Server at localhost Port 80

What's this problem? Anybody knows?

 

[Air The Star]

Hello, I got this error message when I go the the admin pannel after doing the steps your tutorial told me to do:

Forbidden
You don't have permission to access /apanel/ on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 Server at localhost Port 80

What's this problem? Anybody knows?

Permission or/and owner issues.

Best Regards.

 

[Sentielo]

Thanks for your reply. What to do against it?

 

[Msokolov]

"Quote Originally Posted by Znote View Post
The install status is Undefined!

This means the problem might be:
Your firewall. Try to disable it.
Your antivirus program. Maybe you have norton, which think the server is suspicious and have removed the program permission to run other services.
(turn it off)

Maybe you are not logged in as Administrator, but a regular user? Make sure you have administrators rights.

Maybe you installed it at wrong place? It should be installed in C:/ not C:/users/desktop (which may have lower file priority).

Try to be logged in as administrator, and try to run the program as administrator.

Status: Undefined! Basically means, the program is not having the permission to check the status on mysql and apache.

If you still have problems, try to enter your task manager, click on processes, search after mysqld.exe and apache.exe and see if those programs are running. If they are, select them and click end process. Once you have ended both of them, try to start Uniform Server again and see what happens"

done all of that , but they are still undefined, bouth apache and mysql

 

[Evil Puncker]

time to update that tutorial, isn't? the latest version of uniform server is quite different now

 

[mrtruko]

if i dont do this step
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).


it works fine for me if i do it
it wont work saying
Welcome to phpMyAdmin

#1045 Cannot log in to the MySQL server
Language


Connection for controluser as defined in your configuration failed.

so if i dont do that step would something go wrong latter?

 

[Mogex]

if i dont do this step
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).


it works fine for me if i do it
it wont work saying
Welcome to phpMyAdmin

#1045 Cannot log in to the MySQL server
Language


Connection for controluser as defined in your configuration failed.

so if i dont do that step would something go wrong latter?

Only, close sesion or Restart your computer, then it will work, log with you admin user.not with pma user! Then u can change it there.

 

[Znote]

Yeah i noticed :X But I am currently to busy at this moment.

 

[Keram]

Thank you so much for the tutorial

I had many problems with it but they didn't "really" concern your tutorial ;p

It was because my mysql.sql file was kind of "outdated" because I deleted few lines BY MISTAKE while editing it

Anyway, great job. I finally don't have to use that bad xampp which is sooo bad ;p

 

[Goo Goo]

Loved the Tut!! But not the uniserver so much .. (seems to create more lag for me playing locally) Alot easier than Xampp though but that could have been your pro tut Thanks again..

 

[killing]

hey can you just make a video how to put server to site

 

[Mogex]

Update tuto plaz xD!

 

[An2oneriksson]

wounderful! it workes perfect, its just that, i got an Account manger on every single account. how do i get rid of him?

 

[Andrea14]

Great work, Thanks!

Edit: Really nice, tryed it out and worked 100% fine.

 

[Zuma Master]

every time i do the 4 security steps , 3 are done correctly and on the "Change the root password for mysql by editing here" one i get this error after i press change : "Error connecting to mysql".. also if i try connecting to phpmyadmin i get this error "Error

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed."

EDIT : im using windows xp sp3, uniserv 5.7.5 , clean installation , any way to fix? ;(
EDIT 2 : Fix failed :/ need someone to help here plx..