next »

[setman]

If I have my echelon database at a hosting company, and my b3 database on my local host machine, it asks for hostname that I would need to connect to my computer.
Would I put my ip in there, with something else?

[MordyT]

you would put your IP in there.

Make sure your webhosting has your ip in remote mysql in cpanel or you can't connect.

The default port is 3306, if you hosting company does not use that you may have issues also.

[setman]

I guess they block it and won't change it. Any ideas on a vps hosting company? I tryed that one in your video, but it won't let me order...

[MordyT]

burstnet is very good. Slightly more money, but great.

[setman]

Just to double check, this is what I had in.

## settings for the echelon database
$hostname_wwwvalidate = "66.112.19.6:3306";
$database_wwwvalidate = "b3echelon";
$username_wwwvalidate = "b3echelon";
$password_wwwvalidate = "xxxxxxx";

I just have hosting with them no dedicated server

Also on my database that i have running from home, I need to know what i need to put into the echelon database under Host Name... Any host, host table, test field

[MordyT]

Try
$hostname_wwwvalidate = "66.112.19.6";

For hosting on the same machine, you can use localhost or 127.0.0.1

[setman]

Now since I have everything running on 1 box (localhost) when I try to install echelon with using http://localhost/e107/echelon/index.php, it comes up with the echelon webpage and you can login, this error comes up

Object not found!

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.
Error 404
localhost
12/20/11 16:56:50
Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1

[SanKen]

change in echelon/Connections/inc_config.php

Code:

$path = "/echelon/";

for this

Code:

$path = "/e107/echelon/";

[setman]

Changed it to what you said, and now it comes up:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'echelon'@'localhost' (using password: YES) in C:\xampp\htdocs\e107\echelon\Connections\wwwvalidate.php on line 3
Access denied for user 'echelon'@'localhost' (using password: YES)

[SanKen]

I saw it yesterday and I knew that you ask about it: P

Bad data to the mysql connections ...

## settings for the echelon database
$hostname_wwwvalidate = "ipaddress";
$database_wwwvalidate = "namedatabase";
$username_wwwvalidate = "username";
$password_wwwvalidate = "password";

[setman]

Putting in the ip address still did not work. It seems like it does not open the file.

[setman]

Anyone?

[MordyT]

Seems like a closed/block port/connection.

[Toffees]

Hi Setman,

Go back to basics.  What platform have you installed b3 and echelon onto and what webserver is it running?  Is http://localhost/e107 really the root folder for your website?  What happens if you type http://localhost/e107 into a browser?  Does your site load ok?

I use a linux VPS running Apache and have created a folder called echelon at the root of it.  In the connections/inc_config.php file my Echelon site is referenced as :-

Code:

$path = "/echelon/";

I've created a database in mysql called 'echelon' and setup the tables by importing the .sql file.  I've also created a user called 'echelon' that has been granted full privileges to the same database.  This is all referenced within my connections/inc_config.php file as follows :-

Code:

## settings for the echelon database
$hostname_wwwvalidate = "localhost";
$database_wwwvalidate = "echelon";
$username_wwwvalidate = "echelon";
$password_wwwvalidate = "xxxxxxx";

I manually edited the entire inc_config.php file to match the number of servers I was using Echelon for at the time.  I'm not sure what your file looks like, but here's my original file for reference http://pastebin.com/Pbmv0z6H

Make sure you add your game server specific b3 database and user name/password to the servers array.  These are the same ones you used when installing b3.  Once thats done, all I did was go to http://ourclan.com/echelon and I was presented with the login screen.

I hope that helps.  Its sometimes useful to check what other people have done so you can compare and spot any parts you may have missed.

BR
Toffees