RazorBlade
Retired Snek
I'm also getting the above issue.
Have you copied what was in the box and inserted it in to you PHPMYADMIN SQL?Is this compatible with tfs 1.1? Because I can't get out of this place.
I actually fixed it by closing down Skype, VmWare and changing back all ports ^^Have you copied what was in the box and inserted it in to you PHPMYADMIN SQL?
Failed to connect to MySQL: (2002) Permission denied
I'm thinking this is a permissions error with something in the OS, not in the configuration. I've tried making mysql.mysql the owner of the mysql folder and subfolders, I've tried making a permanent firewalld entry for mysql, http and https, I've tried reinstalling mariadb and reconfiguring it, but nothing seems to be working. Just keeps giving me a permission denied error. If it was related to my connection details, it would say that, but this is a rather different error. Any thoughts @Znote ? running Fedora 22 minimal and operating as root. Using base httpd, not using nginx or another installation for my web server. Using mariadb (mysql-server) and phpmyadmin. I do have full access to phpmyadmin at localip/phpmyadmin but if I go to localip/*.php I just get permission denied.
Thats an interesting setup. My demo site is running Debian 7 with mysql-server and lighttpd with php5-cgi. Are you using digitalocean? If so then feel free to send me a snapshot of your droplet and I will check it out.
You are missing the Znote AAC database tables, in config.php try to deliberately write wrong mysql details, visit site and it will generate a schema for you to import into phpmyadmin. Once your done, write correct details and those errors should be fixed.Link didnt seem to work and cant find where to edit my post :O so trying again
https://imgur.com/9PrwLdR
Put this to trueHello, Znote. It is very nice. I need just one more thing. How to install captcha?
I don't know what vulnerable SQL injections is. But, trust me ZnoteAAC is one of the safest and securest AAC's released on OTLand. So don't be afraid.I have a question, is it vulnerable to SQL Injection? I do not see any prepared statements.
Error
SQL query:
CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
MySQL said:
#1005 - Can't create table 'otserv.znote_guild_wars' (errno: 150) (Details…)
In config.php search for townID.Update: Managed to fix everything now. I've been working with the [8.60] The Forgotten Server 0.3.6 (Crying Damson) V8
I ran into some troubles, where I was unable to loggin with the client but could loggin at the webpage. This was solved by changing the $config['TFSVersion'] = 'TFS_02'; to $config['TFSVersion'] = 'TFS_03';
So, everything's working now except that I don't have a map to actually play on right now, since the map in the "[8.60] The forg... " only consist of a mall island.
Help on how to "install" a proper map would be very, very much appreciated and if possible, I'd like to install a replica of the original Tibia map!
I also have one other small issue and that's when a character is created, it's spawn location gets set to something else than where a temple is, so I have to change it's position manually on the phpMyAdmin page every time. Advice on how to change this would also be greatly appreciated!