VIDEO TUTORIAL: From nothing to a fully working OT server, website and shop system

[killing]

Answer

 

[skrm]

Hello, I cannot access my AAC from another computer on the LAN, I'm not sure what address I should be using but I've tried localhost, 127.0.0.1, 192.168.0.1/2 and a variety of combinations. I'm not sure if not having any ports opened is affecting this, but I need some help :S

thanks in advance

 

[Erimyth]

I just like Jonas Erik Alberg's voice D: Im in love (L)_(L) xD

 

[Skaxx]

Thank you for this tutorial, I just have one question if you wouldn't mind answering it.
I have everything set up and working (as far as I know), I haven't actually logged into my tibia OT server yet as i can't find a tibia 9.6 ip changer that works.
Anyway, back to my question - 'my' website as far as i know works but it flickers between being on for 20 seconds, being off for 20 seconds (only tested on a PC on lan), is there a reason for that and will the results be different for a PC that isn't connected to the lan?
Thanks in advance!
Skaxx

 

[Znote]

Thank you for this tutorial, I just have one question if you wouldn't mind answering it.
I have everything set up and working (as far as I know), I haven't actually logged into my tibia OT server yet as i can't find a tibia 9.6 ip changer that works.
Anyway, back to my question - 'my' website as far as i know works but it flickers between being on for 20 seconds, being off for 20 seconds (only tested on a PC on lan), is there a reason for that and will the results be different for a PC that isn't connected to the lan?
Thanks in advance!
Skaxx

Ummh, website should be online as long as the apache is running.

When you enter your website (assuming you are using Znote AAC), click on downloads, and download the IP changer. That works with all client versions.

 

[demonica01]

done everything but when i goto logon to the site acc it wont reconize the one made earlier, than when i goto create one it says i have a invaild ipv4 adress, any help please?

 

[TibiaBooa]

[05/05/2013 19:48:10] The Forgotten Server - Version 0.2.14 (Mystic Spirit).
[05/05/2013 19:48:10] Compilied on Aug 27 2012 03:59:08 for arch x64

[05/05/2013 19:48:10] A server developed by Talaturen, Kornholijo, Elf and Tryller.
[05/05/2013 19:48:10] Visit our forum for updates, support, and resources: http://otland.net/.

[05/05/2013 19:48:10] >> Loading config
[05/05/2013 19:48:10] >> Loading database driver...Failed to connect to database. MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061)
[05/05/2013 19:48:11] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SQLite which doesn't require any connection.

What shall i do? :O

 

[Znote]

done everything but when i goto logon to the site acc it wont reconize the one made earlier, than when i goto create one it says i have a invaild ipv4 adress, any help please?

use 127.0.0.1 instead of localhost.

You need to convert the acc you made before you installed znote aac by visiting the converter script in the /special/ folder.

[05/05/2013 19:48:10] The Forgotten Server - Version 0.2.14 (Mystic Spirit).
[05/05/2013 19:48:10] Compilied on Aug 27 2012 03:59:08 for arch x64

[05/05/2013 19:48:10] A server developed by Talaturen, Kornholijo, Elf and Tryller.
[05/05/2013 19:48:10] Visit our forum for updates, support, and resources: http://otland.net/.

[05/05/2013 19:48:10] >> Loading config
[05/05/2013 19:48:10] >> Loading database driver...Failed to connect to database. MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061)
[05/05/2013 19:48:11] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SQLite which doesn't require any connection.

What shall i do? :O

Write correct mysql details.

Try to create a user on phpmyadmin with hostname: 127.0.0.1 instead of localhost, and connect to that one.

 

[Spankarn]

[06/05/2013 20:33:20] Failed connecting to database - MYSQL ERROR: Unknown MySQL server host 'otserv' (0) (2005)

[06/05/2013 20:33:20] > ERROR: Couldn't estabilish connection to SQL database!

Why do i always get that error!?!?!?...
This sh*t makes me so mad...
i've working on my ot for a long time now and today i decided to make a website because i'm soon going to open it..
then i get that error when i'm gonna start my server...

I use uniserver..
and i don't have forgotten server.sql i took schemas->mysql.sql that file...

then i get Import has been successfully finished, 71 queries executed. (mysql.sql)

but when i'm going to start as i said i get that freaking error up there...

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "otserv"
	sqlPass = "mohahaha wont tell ya...:P"
	sqlDatabase = "otserv"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

that's my config.lua

 

[Alan Alosh]

[06/05/2013 20:33:20] Failed connecting to database - MYSQL ERROR: Unknown MySQL server host 'otserv' (0) (2005)

[06/05/2013 20:33:20] > ERROR: Couldn't estabilish connection to SQL database!

Why do i always get that error!?!?!?...
This sh*t makes me so mad...
i've working on my ot for a long time now and today i decided to make a website because i'm soon going to open it..
then i get that error when i'm gonna start my server...

I use uniserver..
and i don't have forgotten server.sql i took schemas->mysql.sql that file...

then i get Import has been successfully finished, 71 queries executed. (mysql.sql)

but when i'm going to start as i said i get that freaking error up there...

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "otserv"
	sqlPass = "mohahaha wont tell ya...:P"
	sqlDatabase = "otserv"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

that's my config.lua

You have the wrong SQL file typed in config. Should be sqlFile = "mysql.sql", or whatever your MySQL file is called on the distrobution you have.

 

[Spankarn]

You have the wrong SQL file typed in config. Should be sqlFile = mysql.sql, or whatever your MySQL file is called on the distrobution you have.

in phpmyadmin i import mysql.sql then i changed sqltype = "mysql" to sqltype = "mysql.sql..
But now my server just crash
it says, Forgotten server has stoped working..

znote please help me!
write to me in pm and i can send you teamviewer or something!

 

[Alan Alosh]

in phpmyadmin i import mysql.sql then i changed sqltype = "mysql" to sqltype = "mysql.sql..
But now my server just crash
it says, Forgotten server has stoped working..

znote please help me!
write to me in pm and i can send you teamviewer or something!

You should not change the sqlType.. I told you that your sqlFile is wrong, not the sqlType, it's a huge difference.

 

[Spankarn]

You should not change the sqlType.. I told you that your sqlFile is wrong, not the sqlType, it's a huge difference.

IT'S WORKING THANKS OMG THANK YOU SOO FREAKING MUUCH ! !!!
REP++++++++++++++++ for you!!!!!!
Thaaank yooou!

 

[jimmy90]

i have to problems maby u can help me first. Failed to recognize your IP address. (Not a valid IPv4 address). wen i try to do account but i can do account from other computers but not my own.
and my other question is i try to access localhost/special but i get the reply .Forbidden
You don't have permission to access /special on this server.

help me plz

 

[tufangoker]

Hi there, I have a issue with account creating. It is possible to create accounts at the website but these accounts wont appear when I am trying to login with Tibia.
Please help me, thank you.

 

[DemonMithos]

there are no npc's? so im stuck in rook?

 

[drksys3]

jeje tuve el mismo problema amigo y lo que ise fue enves de tener localhost lo quiete y puse 127.0.0.1 y funciono

 

[UpInSmoke]

So i have my ports opened on my computer; 443, 7171, 7172, 80, 3306.
but for some reason its saying accessible from internet: no.

I came here because well ive made a server before (long time back) but it was at my other house where there was just one computer (the main one, plugged directly internet the Modem). the computer im using however is wireless, as is all the computers in my house (5 of them)... so i know my ports are open; ive checked them in a port website. But for some reason i get the status timeout when trying to connect to my server with my IP address. I can connect fine with my static Ip but clearly thats no good cause no one else can... do i need to open the ports on all my computers since im wireless or something? im really confused; please help.

 

[wengelin]

Hi when i try to start the server with the sqltype:mysql the server just crashes but with sqlite it works..
why doesn't it work with mysql.

 

[Znote]

Hi when i try to start the server with the sqltype:mysql the server just crashes but with sqlite it works..
why doesn't it work with mysql.

Any error messages on the console before the crash appear?