Hello everyone,
Im trying to put online a server , for play with my 2 brothers,
I configure a No Ip , the config, and the config.php with my Ip and/or the hostname from No Ip
When i try lunch console the error appears ' Mysql Error Message: Can't connect to Mysql Server on ' lunera.servegame.com ' ( i try the Ip )
And when i try localhost i got the error ,
Error ID:
More info: CANNOT CONNECT TO DATABASE: SQLSTATE[HY000] [2002] No connection could be established because the target computer expressly refused it.
File: C:\UniformServerZ\UniServerZ\www\classes/database_mysql.php Line: 22
File: C:\UniformServerZ\UniServerZ\www\classes/database.php Line: 199
File: C:\UniformServerZ\UniServerZ\www\pages/latestnews.php Line: 18
File: C:\UniformServerZ\UniServerZ\www\system/load.page.php Line: 7
File: C:\UniformServerZ\UniServerZ\www/index.php Line: 42
Changing all to Localhost, the server works great, without problems, just i remember from 8.0 version changing only the 'localhost ' for the Hostname or my Ip ( obviously ports are oppened )
The config lua;
The config.php
Maybe im wrong, i dont remember exactly, i check a numerous posts on forum about the error but nothing working
Thanks for your help and time
Im trying to put online a server , for play with my 2 brothers,
I configure a No Ip , the config, and the config.php with my Ip and/or the hostname from No Ip
When i try lunch console the error appears ' Mysql Error Message: Can't connect to Mysql Server on ' lunera.servegame.com ' ( i try the Ip )
And when i try localhost i got the error ,
Error ID:
More info: CANNOT CONNECT TO DATABASE: SQLSTATE[HY000] [2002] No connection could be established because the target computer expressly refused it.
File: C:\UniformServerZ\UniServerZ\www\classes/database_mysql.php Line: 22
File: C:\UniformServerZ\UniServerZ\www\classes/database.php Line: 199
File: C:\UniformServerZ\UniServerZ\www\pages/latestnews.php Line: 18
File: C:\UniformServerZ\UniServerZ\www\system/load.page.php Line: 7
File: C:\UniformServerZ\UniServerZ\www/index.php Line: 42
Changing all to Localhost, the server works great, without problems, just i remember from 8.0 version changing only the 'localhost ' for the Hostname or my Ip ( obviously ports are oppened )
The config lua;
Lua:
-- Combat settings
-- NOTE: valid values for worldType are: "pvp", "no-pvp" and "pvp-enforced"
worldType = "pvp"
hotkeyAimbotEnabled = true
protectionLevel = 7
pzLocked = 60 * 10
removeChargesFromRunes = false
removeChargesFromPotions = false
removeWeaponAmmunition = false
removeWeaponCharges = false
timeToDecreaseFrags = 1 * 24 * 60 * 60
whiteSkullTime = 15 * 60 * 1000
stairJumpExhaustion = 2 * 1000
experienceByKillingPlayers = false
expFromPlayersLevelRange = 75
dayKillsToRedSkull = 3
weekKillsToRedSkull = 5
monthKillsToRedSkull = 10
redSkullDuration = 1
blackSkullDuration = 3
orangeSkullDuration = 7
onlyInvitedCanMoveHouseItems = true
cleanProtectionZones = false
-- Connection Config
-- NOTE: maxPlayers set to 0 means no limit
-- NOTE: MaxPacketsPerSeconds if you change you will be subject to bugs by WPE, keep the default value of 25
ip = "lunera.servegame.com"
bindOnlyGlobalAddress = false
loginProtocolPort = 7171
gameProtocolPort = 7172
statusProtocolPort = 7171
maxPlayers = 0
motd = "Welcome to Lunera!"
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Realmap"
statusTimeout = 5 * 1000
replaceKickOnLogin = true
maxPacketsPerSecond = 25
maxItem = 2000
maxContainer = 100
--- Version
clientVersion = 1260
clientVersionStr = "12.60"
-- Depot Limit
freeDepotLimit = 2000
premiumDepotLimit = 10000
depotBoxes = 18
-- GameStore
gamestoreByModules = true
-- NOTE: Access only for Premium Account
onlyPremiumAccount = false
-- Customs
weatherRain = false
thunderEffect = false
freeQuests = false
-- Deaths
-- NOTE: Leave deathLosePercent as -1 if you want to use the default
-- death penalty formula. For the old formula, set it to 10. For
-- no skill/experience loss, set it to 0.
deathLosePercent = -1
-- Houses
-- NOTE: set housePriceEachSQM to -1 to disable the ingame buy house functionality
-- Periods: daily/weekly/monthly/yearly/never
housePriceEachSQM = 1000
houseRentPeriod = "never"
houseOwnedByAccount = false
-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000
-- Push Delay
pushDelay = 1000
pushDistanceDelay = 1500
-- Map
-- NOTE: set mapName WITHOUT .otbm at the end
-- NOTE: unzip the map world.rar
mapName = "Otserv"
mapAuthor = "Otserv"
-- Market
marketOfferDuration = 30 * 24 * 60 * 60
premiumToCreateMarketOffer = true
checkExpiredMarketOffersEachMinutes = 60
maxMarketOffersAtATimePerPlayer = 100
-- MySQL
mysqlHost = "lunera.servegame.com"
mysqlUser = "root"
mysqlPass = "123456"
mysqlDatabase = "realmap"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
-- Misc.
allowChangeOutfit = true
freePremium = false
kickIdlePlayerAfterMinutes = 15
maxMessageBuffer = 4
emoteSpells = false
classicEquipmentSlots = false
allowWalkthrough = true
coinPacketSize = 25
coinImagesURL = "http://127.0.0.1/images/store/"
classicAttackSpeed = false
showScriptsLogInConsole = false
-- Server Save
-- NOTE: serverSaveNotifyDuration in minutes
serverSaveNotifyMessage = true
serverSaveNotifyDuration = 5
serverSaveCleanMap = false
serverSaveClose = false
serverSaveShutdown = true
-- Rates
-- NOTE: rateExp, rateSkill and rateMagic is used as a fallback only
-- To configure rates see file data/stages.lua
rateExp = 50
rateSkill = 80
rateLoot = 4
rateMagic = 55
rateSpawn = 1
-- Monster rates
rateMonsterHealth = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0
-- Monsters
deSpawnRange = 2
deSpawnRadius = 50
-- Stamina
staminaSystem = false
-- Scripts
warnUnsafeScripts = true
convertUnsafeScripts = true
-- Startup
-- NOTE: defaultPriority only works on Windows and sets process
-- priority, valid values are: "normal", "above-normal", "high"
defaultPriority = "high"
startupDatabaseOptimization = true
-- Status server information
ownerName = ""
ownerEmail = ""
url = ""
location = "Spain"
The config.php
PHP:
<?PHP
if ( ! function_exists('is_https'))
{
function is_https()
{
if ( ! empty($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS']) !== 'off')
{
return TRUE;
}
elseif (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && strtolower($_SERVER['HTTP_X_FORWARDED_PROTO']) === 'https')
{
return TRUE;
}
elseif ( ! empty($_SERVER['HTTP_FRONT_END_HTTPS']) && strtolower($_SERVER['HTTP_FRONT_END_HTTPS']) !== 'off')
{
return TRUE;
}
return FALSE;
}
}
$is_https = is_https();
if ($is_https) {
$base_url = "https://" . $_SERVER['HTTP_HOST'];
$base_url .= str_replace(basename($_SERVER['SCRIPT_NAME']), "", $_SERVER['SCRIPT_NAME']);
} else {
$base_url = "http://" . $_SERVER['HTTP_HOST'];
$base_url .= str_replace(basename($_SERVER['SCRIPT_NAME']), "", $_SERVER['SCRIPT_NAME']);
}
$config['base_url'] = $base_url;
$config['site']['base_url'] = $base_url;
# Info Bar Config
$config['site']['info_bar_active'] = true;
# Using Ajax Field Validation, this is important if you want to use ajax check in your create account.
$config['site']['sqlHost'] = "lunera.servegame.com";
$config['site']['sqlUser'] = "root";
$config['site']['sqlPass'] = "123456";
$config['site']['sqlBD'] = "realmap";
# Config Shop
$outfits_list = array();
$loyalty_title = array(
50 => 'Scout',
100 => 'Sentinel',
200 => 'Steward',
400 => 'Warden',
1000 => 'Squire',
2000 => 'Warrior',
3000 => 'Keeper',
4000 => 'Guardian',
5000 => 'Sage
');
$config['shop']['newitemdays'] = 1;
# Configure your active payment method with this
$config['paymentsMethods'] = [
'pagseguro' => true,
'paypal' => false,
'transfer' => false
];
# Pagseguro configs
$config['pagseguro']['testing'] = true;
$config['pagseguro']['lightbox'] = true;
$config['pagseguro']['tokentest'] = "";
$config['pagseguro']['email'] = "";
$config['pagseguro']['token'] = "";
$config['pagseguro']['produtoNome'] = 'Tibia Coins';
$config['pagseguro']['urlRedirect'] = $config['base_url'];
$config['pagseguro']['urlNotification'] = $config['base_url'].'retpagseguro.php';
$config['donate']['offers'] = [
500=>50,
800=>125,
1500=>250,
2800=>500,
4900=>1000
];
# Bank transfer data
$config['banktransfer']['bank'] = "Caixa Econômica";
$config['banktransfer']['agency'] = "";
$config['banktransfer']['account'] = "";
$config['banktransfer']['name'] = "";
$config['banktransfer']['operation'] = 003;
# PayPal configs
$config['paypal']['email'] = "";
# Social Networks
$config['social']['facebook'] = "https://www.facebook.com/tibia";
$config['social']['discord'] = "";
# Character Former name, time in days to show the former names
$config['site']['formerNames'] = 10;
$config['site']['formerNames_amount'] = 10;
# PAGE: characters.php
$config['site']['quests'] = array(
"Demon Helmet" => 2213,
"In Service of Yalahar" => 12279,
"Pits Of Inferno" => 10544,
"The Ancient Tombs" => 50220,
"The Annihilator" => 2215,
"The Demon Oak" => 1010,
"Wrath Of The Emperor" => 12374
);
# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 0;
# Account Maker Config
$config['site']['serverPath'] = "C:/Users/inda/Desktop/Otserv/";
$config['site']['encryptionType'] = 'sha1';
$config['site']['useServerConfigCache'] = false;
$towns_list = array(
1 => 'Venore',
2 => 'Thais',
3 => 'Kazordoon',
4 => 'Carlin',
5 => 'Ab\'Dendriel',
6 => 'Rookgaard',
7 => 'Liberty Bay',
8 => 'Port Hope',
9 => 'Ankrahmun',
10 => 'Darashia',
11 => 'Edron',
12 => 'Svargrond',
13 => 'Yalahar',
14 => 'Farmine',
28 => 'Gray Beach',
29 => 'Roshamuul',
33 => 'Rathleton',
34 => 'Krailos',
51 => 'Dawnport',
52 => 'Feyrist'
);
# Create Account Options
$config['site']['one_email'] = true;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 360;
$config['site']['send_register_email'] = true;
$config['site']['flash_client_enabled'] = false;
# Create Character Options
$config['site']['newchar_vocations'] = array(0 => 'Rook Sample');
$config['site']['newchar_towns'] = array(1);
$config['site']['max_players_per_account'] = 7;
# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "";
$config['site']['mail_senderName'] = "";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "ssl://smtp.gmail.com";
$config['site']['smtp_port'] = 465;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "";
$config['site']['smtp_pass'] = "";
$config['site']['smtp_secure'] = true;
# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['email_time_change'] = 7;
$config['site']['daystodelete'] = 7;
# PAGE: guilds.php
$config['site']['guild_need_level'] = 150;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;
# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 6;
# PAGE: latestnews.php
$config['site']['news_limit'] = 6;
# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;
# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5);
# PAGE: highscores.php
$config['site']['groups_hidden'] = array(3, 4, 5);
$config['site']['accounts_hidden'] = array(1);
# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;
# Layout Config
$config['site']['layout'] = 'tibiacom';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
Maybe im wrong, i dont remember exactly, i check a numerous posts on forum about the error but nothing working
Thanks for your help and time