Ive followed this guide but I have som problems. Im hoping someone can give me a tip on how to solve them.
MySQL: I already have a MySQL server running, so i would like to avoid using MariaDB. Ive gotten so far that i have pointed my configuration to the my.ini, ive created a scheme with the stated uft8 character set. I imported the sql script in one go, but here it starts to go wrong.
I get the data in correctly, then when i reach line 140819 and it fails with this error message:
ERROR 1064 (42000) at line 140819: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
The line at that place is:
CREATE DEFINER=`root`@`localhost` PROCEDURE `f_deleteContainer`(IN `InContainerID` INT UNSIGNED)
Ive tried to change the user name in that line to the lif user ive recreated, but that doesnt help.
And it seems like it get the data in correctly, but not the stored procedures. Because when i start the server its mostly green, but when it after a while does "something" it gets a lot of error saying that it cant find the procedure.
Second problem is that my server doesnt apear on the steam server list. I wanted to try to connect, just to see if it was possible but i cant. Does you have to do something to get it to show? Ive forwarded port 28000, 26001, 26002 and 26003 (read in another guide) and ive waited an hour or so, but it doesnt apear on the steam list.
Is it possible to access a server via an ip? Or is the only way throw the steam list?
I would really really like to get this running. But i will prefer to use my MySQL server as the database.