mrmike Posted October 2, 2014 Share Posted October 2, 2014 Does anyone have a Life Is Feudal config please. Greets Mike Link to comment Share on other sites More sharing options...
Raizio Posted October 2, 2014 Share Posted October 2, 2014 There already is a thread about this, 2-3 threads down. Link to comment Share on other sites More sharing options...
mrmike Posted October 2, 2014 Author Share Posted October 2, 2014 Ok i now. But i have creatid now a file for you guys And have fun. Keep in mind to change the steamcmd usernamelif - Windows.xml Link to comment Share on other sites More sharing options...
Raizio Posted October 2, 2014 Share Posted October 2, 2014 Don't forget people; LIF:YO does require a MariaDB server, 5.5 at that(although 10 works too). Each server it's own database. Link to comment Share on other sites More sharing options...
CloudNine Posted October 6, 2015 Share Posted October 6, 2015 Is there a way to make LIF circumvent Maria to use mysql instead? Link to comment Share on other sites More sharing options...
marcelokruk Posted October 6, 2015 Share Posted October 6, 2015 MariaDB is the successor of MySQL so is basically the same Link to comment Share on other sites More sharing options...
Raizio Posted October 7, 2015 Share Posted October 7, 2015 MariaDB does do a few things differently. I wager LIF tuned into that. Use MySQL on your own risk. Devs ask for MariaDB. Link to comment Share on other sites More sharing options...
CloudNine Posted October 7, 2015 Share Posted October 7, 2015 MariaDB does do a few things differently. I wager LIF tuned into that. Use MySQL on your own risk. Devs ask for MariaDB. Yes, that's most likely true, just means having MariaDB run alongside mysql. Link to comment Share on other sites More sharing options...
thevisad Posted October 23, 2015 Share Posted October 23, 2015 (edited) The config provided previously is for a minimal setup, this config has the configs setup, variables created, database creation scripts and configuration manager working. This comes from a working setup which I created and is on our servers. Edit the scripts to provide the correct database username, password, ip etc.lif - Windows .xml Edited October 24, 2015 by thevisad Link to comment Share on other sites More sharing options...
DreadPirate Posted November 5, 2015 Share Posted November 5, 2015 My advice is to not attempt to use MySQL. MariaDB is not the future of MySQL, it is a flavor of MySQL that is optimized for a different transaction set. There are special features/commands that are in MariaDB that are not in MySQL, the developers use these features/commands with their interface. We use MariaDB 10 and it works very well. You may need to write some custom scripting for service creation and backup / restore... but those core functions are very similar to MySQL functions and processes. Link to comment Share on other sites More sharing options...
aurum5000 Posted March 30, 2016 Share Posted March 30, 2016 The config provided previously is for a minimal setup, this config has the configs setup, variables created, database creation scripts and configuration manager working. This comes from a working setup which I created and is on our servers. Edit the scripts to provide the correct database username, password, ip etc. I am using this config with Maria 5.5, I was trying to tune up some things, but it was just horrible fail. I am using this from this config: create user script: @echo off set dbname=%ThisGame_ShortName%_%ThisService_ServiceId% set dbuser=%ThisUser_UserName%_%ThisGame_ShortName%_%ThisService_ServiceId% set dbpassword=%ThisUser_Password% set mysqluser=tcadmin set mysqlpassword=secure_pass set mysqlhost=127.0.0.1 set mysqlport=mariadb_port "C:\Program Files\MariaDB 5.5\bin\mysql" -h %mysqlhost% -u %mysqluser% -p%mysqlpassword% -P %mysqlport% -e "CREATE USER '%dbuser%'@'localhost';" "C:\Program Files\MariaDB 5.5\bin\mysql" -h %mysqlhost% -u %mysqluser% -p%mysqlpassword% -P %mysqlport% -e "SET PASSWORD FOR '%dbuser%'@'localhost' = PASSWORD('%dbpassword%');" "C:\Program Files\MariaDB 5.5\bin\mysql" -h %mysqlhost% -u %mysqluser% -p%mysqlpassword% -P %mysqlport% -e "GRANT ALL PRIVILEGES ON `lif_%ThisService_ServiceId%` . * TO '%dbuser%'@'localhost';" delete database script: set dbname=%ThisGame_ShortName%_%ThisService_ServiceId% set dbuser=%ThisUser_UserName%_%ThisUser_UserId%_%ThisService_ServiceId% set mysqluser=tcadmin set mysqlpassword=secure_pass set mysqlhost=127.0.0.1 set mysqlport=mariadb_port "C:\Program Files\MariaDB 5.5\bin\mysql" -h %mysqlhost% -u %mysqluser% -p%mysqlpassword% -P mysqlport%% -e "DROP USER '%dbuser%'@'localhost';" "C:\Program Files\MariaDB 5.5\bin\mysql" -h %mysqlhost% -u %mysqluser% -p%mysqlpassword% -P mysqlport%% -e "DROP DATABASE IF EXISTS %dbname%;" none of them is working for me If I want to run LiF gameservice, I have to manualy add user and DB into mariaDB, then the config is working for me I was looking for script to backup database for user with a button in game panel, but I didnt have luck for it. Link to comment Share on other sites More sharing options...
Raizio Posted March 30, 2016 Share Posted March 30, 2016 Is the MariaDB on the same server? C:\Program Files\MariaDB 5.5\bin\mysql Is this path correct and existing? Link to comment Share on other sites More sharing options...
aurum5000 Posted March 30, 2016 Share Posted March 30, 2016 Thank you for response. Yes, Mariadb is on same server and path is correct, I checked everything like 20 times. Link to comment Share on other sites More sharing options...
Spillvert.no Posted June 17, 2016 Share Posted June 17, 2016 Looks like you have an uninteded space in your set dbuser value (line 3) "%T hisService_ServiceId%" - Did you manage to get this working? Link to comment Share on other sites More sharing options...
djotabr Posted March 23, 2017 Share Posted March 23, 2017 (edited) Would it be possible for someone to post the updated XML with information on how to properly set up MariaDB, as I'm having trouble adding this game to my TC Admin. Sorry for my bad english. Edited March 23, 2017 by djotabr Link to comment Share on other sites More sharing options...
Amadeux Posted January 20, 2018 Share Posted January 20, 2018 (edited) Just started a few days ago but managed to get this working using the helpful IronPython examples in the manual and the previous Config which saved some time editing. Figured I would share the love since I've downloaded a few from the forums myself. It uses MySQL as the database so if you are using MariaDB you may have to change things a bit. I haven't found any issues with this yet but it's still early You will need to edit the scripts to properly connect to your database. It will create lif_1, lif_2, etc. based on the Server #. If you find any errors in what I've done please let me know and I'll try to correct them.lif - Windows.xml Edited January 21, 2018 by Amadeux Link to comment Share on other sites More sharing options...
Ebarker Posted December 28, 2021 Share Posted December 28, 2021 (edited) can you help me understand this error: 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 'IDENTIFIED BY '1040vdow86'' at line 1 Edited December 28, 2021 by Ebarker changed question Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now