• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

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

I got a problem with 'Accessible from Internet'.

I'd forwarded ports on my router's page but when I check it on http://www.yougetsignal.com/tools/open-ports/ its looked like just port 80 was open(7171 and 7172 are closed).

82e35d21e0.png



I've also downloaded program called 'PortForward Network Utilities' but is tells me that all ports are opened(7171, 7172 and 80).
d01d0552d7.png


What can I do with it?
 
hmmm paygol is not adding points to the account when i got the payment already.. hmm
how can i fix this?
 
My admin panel don`t work on my website!

Code:
    // WARNING! Account names written here will have admin access to web page!
    $config['page_admin_access'] = array(
        //'Emploria',
    );
 
My admin panel don`t work on my website!

Code:
    // WARNING! Account names written here will have admin access to web page!
    $config['page_admin_access'] = array(
        //'Emploria',
    );
Remove the "//" in front of your name, it means that it's a comment and is not counted as code.
Code:
// WARNING! Account names written here will have admin access to web page!
$config['page_admin_access'] = array(
'Emploria',
);
 
can you help me please?
this what comes out when I paste the schema in TFS database in phpmyadmin

# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE IF NOT EXISTS `znote` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
`installed` int(10) NOT NULL,
`cached` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `znote` (`version`, `installed`) VALUES
('1.5_SVN', '1419744671');# 1 row affected.
CREATE TABLE IF NOT EXISTS `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
`cooldown` int(10) DEFAULT 0,
`active` tinyint(4) NOT NULL DEFAULT '0',
`activekey` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1419744671');# 1 row affec[...]
 
can you help me please?
this what comes out when I paste the schema in TFS database in phpmyadmin

# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE IF NOT EXISTS `znote` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
`installed` int(10) NOT NULL,
`cached` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `znote` (`version`, `installed`) VALUES
('1.5_SVN', '1419744671');# 1 row affected.
CREATE TABLE IF NOT EXISTS `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
`cooldown` int(10) DEFAULT 0,
`active` tinyint(4) NOT NULL DEFAULT '0',
`activekey` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1419744671');# 1 row affec[...]
I have the exact same error..
 
Failed to connect to MySQL: (1045) Access denied for user 'Whiserv'@'localhost' (using password: YES)

I have been stuck on this for hours
username, password and host are correct. Why cant i get in??!

I have trailed off from tutorial course, can this be the access reason and when it is, can you explain why?
I am using latest AAC version: http://otland.net/threads/znote-aac-1-4-tfs-0-2-13-tfs-0-3-6-0-4.166722/
I am using the forgotten server 1.0 : https://github.com/otland/forgottenserver/releases/tag/v1.0

Config.lua:
-- MySQL
mysqlHost = "localhost" --127.0.0.1
mysqlUser = "Whiserv"
mysqlPass = "GeneratedPassword"
mysqlDatabase = "whiserv"
mysqlPort = 3300
mysqlSock = ""

Config.php:
// TFS 1.0 = TFS_10 (Under developement)
$config['TFSVersion'] = 'TFS_10';
$config['CustomVersion'] = false;

// Path to server folder without / Example: C:\Users\Alvaro\Documents\GitHub\forgottenserver
$config['server_path'] = 'C:\Users\whitevo\Desktop\Whi World\theforgottenserver-v1.0-win64';

$config['sqlUser'] = 'Whiserv';
$config['sqlPassword'] = 'GeneratedPassword';
$config['sqlDatabase'] = 'whiserv';
$config['sqlHost'] = 'localhost';

Picture of MyPhpAdmin:

http://tinypic.com/r/332nh95/8

My own idea:

Is it possible that ports does not match?
in myphpadmin it shows port 3300
in the config.lua i got 3300 port
But i don't know what kind of port/if any the website address is using.
 
@whitevo The default mysql port is 3306, why would you change that?
 
@whitevo The default mysql port is 3306, why would you change that?
well i knew nothing about ports and how they effect and when i isntalled uniserv it said: "port is in use". So i was like, no biggy i can change that. xD
But i reinstalled uniserv and all working now with your AAC
Currently doing mapping for server.
 
Yep, as title says.

46 minutes of my sexy voice <3

720p or 1080p for good quality! + fullscreen
Enjoy.

Ive heard the 0.4 rev 3884 should be the ultimate server to run on a windows pc.. I would like this with War system (With embelms) and 64bit gui.. Is that possible guys?
I will host a real map on the ot...

Money is not a problem.. Please help me guys searched for hours and i dont really get what i need..

I have the rev. 3884


Those question is not the prioritory but if u cant help me with /\ u maybe can answer this.
Things that confuses me is:

what is a distro
What is a Rev
What is sources?
Will i get any problem with 0.4 rev 3884 with an AAC with shop?

Kind regards Daniel! :)
 
Hi On Znote I am having an Admin problem I am putting the correct Account Name

// WARNING! Account names written here will have admin access to web page!
$config['page_admin_access'] = array(
//'kkkkkk',

I still can't get access to the admin account when i refresh.
 
Hi On Znote I am having an Admin problem I am putting the correct Account Name

// WARNING! Account names written here will have admin access to web page!
$config['page_admin_access'] = array(
//'kkkkkk',

I still can't get access to the admin account when i refresh.

Text after ( // ) is considered a comment. If you wrote your account name behind the two slashes then it is not valid. Try removing // from the line you wrote your account name.
 
I got my server up and running but i cant work out how to open it up to the public. Changing Connecting config to my IP in Config.lua doesnt seem to work, i believe that something else has to be changed maybe with the MYSQL settings?
 
I was doing everything just like in the video up to 13:58, but forgotten server still can't connect to SQL database, I changed user, password sqlite to mysql, and uploaded database, and nothing.
My config.lua: http://pastebin.com/xYN1tZW2
 
Last edited:
Back
Top