Thelasthero

L2Liberators server. 500 ppl on.

Can't login. Pff closed already.

Does this server have relationship with this: http://www.maxcheaters.com/forum/index.php?topic=146734.0 ???

Anyway good luck.

P.S: Title should be: [L2J]L2LostPlanet

BUMP!

Are you sure you've forwarded the port properly?

Also, you're not behind a firewall?

[gr]File, dn fteei to port to exw kanei forward, einai ola opos eprepe na einai[/gr]

Your port is not forwarded.

Configure your router.

ok i did but still error the same.

your line 3 is this

 

$L2JBS_config["mysql_port"]=3306; // MySQP port

 

are you use that your mysql port is 3306?

line 3 in _config_procs.php it says not in config.php

i am trying to install my database in navicat and i have errors. very strange. it says it doesn't recognize InnoDB in some sqls like auto_chat.sql. Even with a database restore i have this error. Ps. I didn't had it before

sorry, I missed this one:

$L2JBS_config["mysql_host"]="localhost"; (change localhost to WAN IP)

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '94.64.246.117' (4) in /home/a9522426/public_html/config/_config_procs.php on line 3

Everything's ok, where's the problem?

You want: l2unique.net84.net (REMOTE MACHINE) to connect to your MySQL server and get data from it.

 

But this machine needs your IP to find you over the internet.(WAN IP, get it here)

 

 

You're still confused...

 

 

 

$hserver="YOUR IP"

:(

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thelasthero'@'localhost' (using password: YES) in /home/a9522426/public_html/config/_config_procs.php on line 3

with my wan ip to hserver

You want to connect to the MySQL server, right?

 

 

Now, tell me where the mysql server is installed...(home?)

Ok listen.

I installed mysql and configured and to allow remote connections.

Installed my database etc.

Made new user as you told me to.

Then i put these in config.php and can't connect.

Mysql is to home, and i want to check out the site etc.

localhost? are you crazy?

 

change:

$hserver="your IP/no-ip";

I want to connect to site not OTHERS. www.l2unique.net84.net

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thelasthero'@'localhost' (using password: YES) in /home/a9522426/public_html/config/_config_procs.php on line 3

Don't ignore me. You MUST create another user to connect.

user 'root' is only for local connections.

i made use thelasthero can't you see????????

i have an upload script, why would you need it for? D:

 

You just didnt add the right password on your configs

Everything is as it should be.

config.php file:

<?php
$L2JBS_config["mysql_host"]="";	// MySQL IP
$L2JBS_config["mysql_port"]=3306;		// MySQP port
$L2JBS_config["mysql_db"]="l2jdb";		// l2jdb or your lineage 2 server database name
$L2JBS_config["mysql_login"]="thelasthero";		// MySQL Login name	
$L2JBS_config["mysql_password"]="mypass";		// MySQL Password
$htitle="L2 Unique";				// Site Title
$fut="Napas © Unique <br>2007";		// You can change only server name . You must leave Napas © 
$top="100";					// How many players must be in top100
$hserver="127.0.0.1";				// Server IP
$portgame="7777";				// Game Server Port
$portlogin="2106";				// Server Port
$where='1=1';					
$shat="C:\workspace\thelasthero\gameserver\log\chat.txt"; // bale edo ston fakelo logs t gameserver to arxio chat.log


// Original by Picassoo
//Skin
$skin1="heven";					

//Serever Rates
$exp="1000";
$sp="1000";
$adena="1000";
$items="7";
$spoil="20";


include("_config_procs.php");
error_reporting(0);
?>

(Note: I want to connect to site, not others that's why i have 127.0.0.1 to hserver)

_config_procs.php:

<?php
$L2JBS_config["javascript_sort_method"]="bubble";
  $link = mysql_connect($L2JBS_config['mysql_host'].":".$L2JBS_config['mysql_port'], $L2JBS_config['mysql_login'], $L2JBS_config['mysql_password']);
  if (!$link)
    die("Couldn't connect to MySQL");
  @mysql_select_db($L2JBS_config['mysql_db'], $link)
    or die ('Error '.mysql_errno().': '.mysql_error());

?>

1st) ports are opened

2nd) i add my no-ip to hserver

Error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/a9522426/public_html/config/_config_procs.php on line 3

Free Web Hosting

Couldn't connect to MySQL

Extreme please give me an example of yours config.php file to understand.

127.0.0.1 and 192.168.1 are LOCAL hosts.

 

 

None can connect there but you, also you cant add a localhost on a website.

so what must i do

You have on hserver 127.0.0.1

 

-.-"

yes, with this ip i have the server.

<?php
$L2JBS_config["mysql_host"]="localhost";	// MySQL IP
$L2JBS_config["mysql_port"]=3306;		// MySQP port
$L2JBS_config["mysql_db"]="l2jdb";		// l2jdb or your lineage 2 server database name
$L2JBS_config["mysql_login"]="root";		// MySQL Login name	
$L2JBS_config["mysql_password"]="my pass here";		// MySQL Password
$htitle="L2 Unique";				// Site Title
$fut="Napas © Unique <br>2007";		// You can change only server name . You must leave Napas © 
$top="100";					// How many players must be in top100
$hserver="127.0.0.1";				// Server IP
$portgame="7777";				// Game Server Port
$portlogin="2106";				// Server Port
$where='1=1';					
$shat="C:\workspace\thelasthero\gameserver\log\chat.txt"; // bale edo ston fakelo logs t gameserver to arxio chat.log


// Original by Picassoo
//Skin
$skin1="heven";					

//Serever Rates
$exp="1000";
$sp="1000";
$adena="1000";
$items="7";
$spoil="20";


include("_config_procs.php");
error_reporting(0);
?>

my config.php file

you have to create a new user from navicat that handles remote connections.

well, can you help me how to do that..?

You have to configure the mysql server so it can accept remote connections(this can be done through navicat).

ofc i did that when i configured my mysql, at security settings, added my pass and ticked allow access from remote machines. any ideas?

Where is the mysql server?

 

It's not a webhosts' problem.

what do you mean man. i have mysql installed & configured and database on navicat, i have added my info to config.php file but still can't connect.

I have a free hosting website from 000webhost.com and i can connect to mysql normally.

yes but domain or subdomain? because if you host your domain (.com ex) you can i think. oh and man, how you connect, i get this error check it out: www.l2unique.net84.net

es muy bien la pagina

speak english.

/ontopic

Awesome website

Μετά με τον sorcer του κάνετε αιμορραγία και στέλνετε το pet πρως αυτον που έχει το reflect buff και θα πάρει Pk.

aimoragia leei XAXA :D pantos kalo trick thanks.