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

[Znote]

I'm rly sry that I'm bothering you. but what do u mean with ''set in modern aac''?
I have followed all your steps, I downloaded Modern AAC | v0.2 installed it removed all files from the www folder and what now? :S

edit: I was trying around some and now I get this error instead when im trying to connect to my website: A Database Error Occurred

ok, weird, send teamviewer access over PM

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
:S
Followed all steps and tried to login at pma

Reboot your computer after you have changed from config to cookie in the phpmyadmin configuration file.

 

[Robwin]

aight I just need to start my laptop and download it

 

[tansolounamirad]

just to mention - you'd better alter your footer, Znote. US does not work on 64bit. if you're so proud of something, better check if it's true. going back maybe heavier, but much easier, less time-consuming and WORKING xampp

 

[Znote]

just to mention - you'd better alter your footer, Znote. US does not work on 64bit. if you're so proud of something, better check if it's true. going back maybe heavier, but much easier, less time-consuming and WORKING xampp

I got Uniform Server working perfectly on 3 different 64bit computers. You are wrong. Don't blame your mistakes on me.

edit: just to test for the 4th time to be 110% sure you are terrible wrong, HERE is proof:
http://188.126.219.138/tibia/

That server is hosted on Windows 7 64bit.

Btw, Windows Vista is not suitable to host on.

 

[Oif Oif Oif]

Help please,

It says in Crying Damson.exe that my server is online but I can't seem to log into it even with 1/1 Account Manager
and I'm using client 8.54 and everything.

My problem is I can't log into my server :/
What do I need to do?

Thanks,

[13/04/2010 18:28:20] >> Loading config (config.lua)
[13/04/2010 18:28:20] > Using MD5 encryption
[13/04/2010 18:28:20] >> Checking software version... up to date!
[13/04/2010 18:28:20] >> Fetching blacklist
[13/04/2010 18:28:20] >> Loading RSA key
[13/04/2010 18:28:20] >> Starting SQL connection
[13/04/2010 18:28:20] >> Running Database Manager
[13/04/2010 18:28:21] > No tables were optimized.
[13/04/2010 18:28:21] >> Loading items
[13/04/2010 18:28:21] >> Loading groups
[13/04/2010 18:28:21] >> Loading vocations
[13/04/2010 18:28:21] >> Loading script systems
[13/04/2010 18:28:21] [Error - LuaScriptInterface::loadFile] data/actions/scripts/quests/annihilator.lua:5: '}' expected (to close '{' at line 1) near 'entry'
[13/04/2010 18:28:21] [Warning - Event::loadScript] Cannot load script (data/actions/scripts/quests/annihilator.lua)
[13/04/2010 18:28:21] data/actions/scripts/quests/annihilator.lua:5: '}' expected (to close '{' at line 1) near 'entry'
[13/04/2010 18:28:21] >> Loading chat channels
[13/04/2010 18:28:21] >> Loading outfits
[13/04/2010 18:28:21] >> Loading experience stages
[13/04/2010 18:28:21] >> Loading monsters
[13/04/2010 18:28:21] >> Loading mods...
[13/04/2010 18:28:21] > Loading buypremium_command.xml... done.
[13/04/2010 18:28:21] > Loading changender_command.xml... done.
[13/04/2010 18:28:21] > Loading custommonsters.xml... done.
[13/04/2010 18:28:21] > Loading customspells.xml... done.
[13/04/2010 18:28:21] > Loading firstitems.xml... done.
[13/04/2010 18:28:21] > Loading highscorebook.xml... done.
[13/04/2010 18:28:21] > 6 mods were loaded.
[13/04/2010 18:28:21] >> Loading map and spawns...
[13/04/2010 18:28:21] > Map size: 1000x1000.
[13/04/2010 18:28:21] > Map descriptions:
[13/04/2010 18:28:21] "Saved with Remere's Map Editor 1.1.8"
[13/04/2010 18:28:21] "The Forgotten Server"
[13/04/2010 18:28:22] > Map loading time: 0.783 seconds.
[13/04/2010 18:28:22] > Data parsing time: 0.07 seconds.
[13/04/2010 18:28:22] > Houses synchronization time: 0.022 seconds.
[13/04/2010 18:28:22] > Content unserialization time: 0.316 seconds.
[13/04/2010 18:28:22] >> Checking world type... PvP
[13/04/2010 18:28:22] >> Initializing game state modules and registering services...
[13/04/2010 18:28:22] > Global address: 127.0.0.1
[13/04/2010 18:28:22] > Local ports: 7171 7172
[13/04/2010 18:28:22] >> All modules were loaded, server is starting up...
[13/04/2010 18:28:22] >> Forgotten server Online!
[/php]
Working! :thumbup:

Now lets try to LOGIN!

[13/04/2010 18:30:22] Account Manager has logged in.
[13/04/2010 18:30:22] > Broadcasted message: "New record: 1 players are logged in.".

I got my server running and online but I'm stuck at the part where you need to log in, help please

I can't log in my server! I don't know why!

 

[Robwin]

I have 2computers, on 1 of my comps I got this working and on my other comp the password just stop working after some time, whats the problem? :S

 

[kingi96]

fuck i deleted my accc how i can get it back!!!!!
i cant log in on phpadmin now!!!
can anyone help me
i come give rep++ if you help me!!!

 

[Znote]

Help please,

It says in Crying Damson.exe that my server is online but I can't seem to log into it even with 1/1 Account Manager
and I'm using client 8.54 and everything.

My problem is I can't log into my server :/
What do I need to do?

Thanks,



I got my server running and online but I'm stuck at the part where you need to log in, help please

I can't log in my server! I don't know why!

Weird, try to download just plain TFS 0.3.6pl1 and make database "test" with pass "test" and check "create database with same name and give full rights"

Then import mysql schema

then edit config.lua and write mysql instead of sqlite

username test
pass test
database test

and try to run the server and see if it work.

If it does not work, send teamviewer details to me over PM and I will try to fix it as fast as I can.

I have 2computers, on 1 of my comps I got this working and on my other comp the password just stop working after some time, whats the problem? :S

Hmmm, I had almost same problem, I tried to enter phpmyadmin, but I couldn't it asked for username and password, and i wrote my mysql password.

If you etc restart your computer and such things, and enter phpmyadmin, you FIST have to write the apanel password.

Then you get to phpmyadmin and then you write your mysql password.

fuck i deleted my accc how i can get it back!!!!!
i cant log in on phpadmin now!!!
can anyone help me
i come give rep++ if you help me!!!

Enter apanel, and in the menu to the left, click on "Restore MySQL Password" below "Tools" box.

 

[kingi96]

but modern acc doesnt work when i try to install it

it says:
# Website address could not be established, tried to connect to http://Shadowblade.no-ip.org/API/isValid.php if the link is valid check if this server is allowed to use local API.

do you now why it says so???

 

[Znote]

but modern acc doesnt work when i try to install it

it says:
# Website address could not be established, tried to connect to http://Shadowblade.no-ip.org/API/isValid.php if the link is valid check if this server is allowed to use local API.

do you now why it says so???

Seem to be modern aac issue post it at this link_:
http://otland.net/f118/modern-aac-v0-2-a-84165/

 

[kingi96]

hmm

i cant login on my server its only loading do you now why??

 

[Znote]

hmm

i cant login on my server its only loading do you now why??

Please print your console so I can see the problem.

 

[Trader]

Hey,

Can you show us how to import a custom made map to the server?
And When is the tutorial for making a website gonna come up?

Thanks in Advance!

 

[Znote]

Hey,

Can you show us how to import a custom made map to the server?
And When is the tutorial for making a website gonna come up?

Thanks in Advance!

If you want to import a custom made map into a server you have to keep in mind of many factors.

You have to change the map, add correct actions, movements, globalevents, creaturescript that comes along with that map.

 

[Trader]

Sounds so time consuming and difficult :S

Wait, but I still don't understand how to incorporate it in the server.

Do I go to phpMyAdmin and Import the map?

 

[Znote]

No, you enter data/world

And place map there.

Then you enter config.lua

And change set the new mapname there.

 

[soul4soul]

[9:56:44.515] The Forgotten Server, version 0.4_DEV ()
[9:56:44.515] Compiled with GNU C++ version 3.4.5 (mingw special) at May 2 2010
, 17:33:45.
[9:56:44.515] A server developed by Elf, Talaturen, KaczooH, Stian and Kornholij
o.
running 0.4
[9:56:44.515] Visit our forum for updates, support and resources: http://otland.
net.

[9:56:44.515] >> Loading config (config.lua)
[9:56:44.515] >> Opening logs
[9:56:44.515] > Using SHA1 encryption
[9:56:44.796] >> Checking software version... running sub version, please mind i
t's unstable and only for testing purposes!
[9:56:44.796] > Current version information - version: 0.4_DEV, patch: 0, build:
0, timestamp: 1272813899.
[9:56:44.796] > Latest version information - version: 0.3.6, patch: 0, build: 32
93, timestamp: 1260652199.
[9:56:44.796] >> Loading RSA key
[9:56:44.812] >> Starting SQL connection
[9:56:44.812] >> Running Database Manager

server freezes there and then crashes.


trying to install the webserver

# Could not connect to database.
# Could not find your database.

any idea what is wrong? i had everything working perfectly with 0.3.6 now that i tried updating im getting these problems.

 

[Znote]

@up

Use 127.0.0.1 instead of localhost

Create a new user on phpmyadmin for your 0.4 server, and use the 0.4 mysql schema.

See if that works.

 

[soul4soul]

im using 0.4 schema. and i created a new user -> "otland"

oh i got the web to work now thanks.


just reupload 0.4 schema

Import has been successfully finished, 71 queries executed.

0.4 still has the same problem freezing and crashing at the same place.

 

[Znote]

@up

It is most likely an issue by your custom files not the TFS distro.