Page 1 of 1

Cannot Connect SQL Database

Posted: 06 Jan 2021, 03:21
by macattack365
I have successfully connected my new servers database to the Heidisql and updated it today. The problem is that when I attempt to connect the Feudal Tools it says it cannot connect to the database. I have checked everything I can think of and looked in forums here and with my provider. I cannot find a solution to the issue.

Also as second problem. I installed the Trade Post Mod on the server and within my client yet I still cannot use it. I tried another server that had it installed and I was able to use it so I know I at least installed it correctly on my machine. I will attach the correct files for your consideration.

Thanks.

Main.cs:

// Process command line arguments
exec("core/parseArgs.cs");

// Parse the executable arguments with the standard
// function from core/main.cs
defaultParseArgs();

function compileFiles(%pattern)
{
%path = filePath(%pattern);

%saveDSO = $Scripts::OverrideDSOPath;
%saveIgnore = $Scripts::ignoreDSOs;

$Scripts::OverrideDSOPath = %path;
$Scripts::ignoreDSOs = false;
%mainCsFile = "main.cs";//makeFullPath("main.cs");
%localConfigFile = "config_local.cs";
%ddctdConfigFile = "ddctd_config.cs";

for (%file = findFirstFileMultiExpr(%pattern); %file !$= ""; %file = findNextFileMultiExpr(%pattern))
{
// we don't want to try and compile the primary main.cs
if(%mainCsFile !$= %file && %localConfigFile !$= %file && %ddctdConfigFile !$= %file)
compile(%file, true);
}

$Scripts::OverrideDSOPath = %saveDSO;
$Scripts::ignoreDSOs = %saveIgnore;
}

if($compileAll)
{
echo(" --- Compiling all files ---");
compileFiles("*.cs");
compileFiles("*.gui");
compileFiles("*.ts");
echo(" --- Exiting after compile ---");
quit();
}

else
{
exec("scripts/root.cs");
}
exec("TTmod/init.cs");


Most Recent log: https://1drv.ms/u/s!AhIjHStc9l21g-hDeBU ... g?e=dZGco5

Re: Cannot Connect SQL Database

Posted: 06 Jan 2021, 09:27
by Nyuton
Hello,
what's your provider? Can you connect to your lif database from your home computer using HeidiSQL or similar tool?

In your main.cs you're missing the line to load the Tradepost Mod. Please follow the install instructions.

Re: Cannot Connect SQL Database

Posted: 06 Jan 2021, 14:07
by macattack365
I was able to connect the database last night. I worked with my provider. Apparently of the million things I tried I missed one and had the database name incorrect even though I was able to connect via my pc. Anyway.

According to your site (https://nyuton.net/ttmod-lifyo-server-mod/) and the readme in the zip the install instructions are as follows:

Unpack the contents of the downloaded zip file into the LiF:YO server directory. This is where the main server executable is located. Make sure NOT to rename the TTmod folder or else it won’t load.
Make your changes to the “TTmod/config.cs” file if necessary (see configuration section)
Add this command to the end of the main.cs file to auto-load the mod on server startup:
exec("TTmod/init.cs");
Restart your server

Isn't the line (exec("TTmod/init.cs");) starting the TTMod? or is there another set of install instructions that I cannot seem to find?

Re: Cannot Connect SQL Database

Posted: 06 Jan 2021, 14:12
by Nyuton
macattack365 wrote: 06 Jan 2021, 14:07Isn't the line (exec("TTmod/init.cs");) starting the TTMod? or is there another set of install instructions that I cannot seem to find?
You were talking about Trading Posts. Which mod are you trying to run? TTmod or Tradeposts?

Re: Cannot Connect SQL Database

Posted: 06 Jan 2021, 14:22
by macattack365
I got it now. I'm an idiot. I spent 14 hours trying to get all this working yesterday I forget to finish the TP mod and install it. So needless to say I never saw the instructions and it should work. With any luck and a great amount of coffee. lolz.

Thanks for your help.