Need A small bit of help with this

09/14/2012 04:56 Andy20081#1
Right i will put the information here what i think will be needed firstly

im using XAMMP Version 2.5 only running Apache as im using WinMySQLadmin for my database for client the client is hocked up-to hamachi it all works the website is hocked up-to hamachi
this is the client/db im using
[Only registered and activated users can see links. Click Here To Register...]

ive tryed loads of ports tryed sorting out ip and i got help changing config file in the website side

the config is with changed bits to hide my info

Quote:
<?php
require_once './inc/class.captcha.php';
// Configurations
$myhost="localhost";
$mypass="test"; //your server login password
$myuser="root"; //your server login username
$mydbacc="account"; //your server account database
$mydbdata="my"; //your server my database name
$serveraddress="5.178.52.11"; //your server ip
$serverport=5816; //your server connection port
$mydb="my"; //your server my database
$servername="KittenChaosEo";

$page = basename($_SERVER['SCRIPT_FILENAME']);
$page = str_replace('_',' ',$page);
$page = str_replace('.php','',$page);
$page = ucfirst($page);

// Dont Edit after this
//Added By Gekru - Just changed the connecting ip
mysql_connect($serveraddress,$myuser,$mypass);
mysql_select_db($mydb);
?>
i still get line errors i know what they mean but i cannot find the issue

Quote:
Warning: mysql_connect() [function.mysql-connect]: [2002] No connection could be made because the target machine actively (trying to connect via tcp://5.178.52.11:3306) in C:\xampp\htdocs\config.php on line 21

Warning: mysql_connect() [function.mysql-connect]: No connection could be made because the target machine actively refused it. in C:\xampp\htdocs\config.php on line 21

Warning: mysql_select_db() [function.mysql-select-db]: [2002] No connection could be made because the target machine actively (trying to connect via tcp://localhost:3306) in C:\xampp\htdocs\config.php on line 22

Warning: mysql_select_db() [function.mysql-select-db]: No connection could be made because the target machine actively refused it. in C:\xampp\htdocs\config.php on line 22

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\xampp\htdocs\config.php on line 22
09/14/2012 10:02 Timore[PM]#2
$serveraddress="5.178.52.11"; //your server ip
If hosting on your own computer use 127.0.0.1
09/14/2012 13:11 Gekru#3
Quote:
Originally Posted by Timore[PM] View Post
$serveraddress="5.178.52.11"; //your server ip
If hosting on your own computer use 127.0.0.1
They're using hamachi to host it, localhost/127.0.0.1 gave the same errors.
09/14/2012 21:57 Andy20081#4
ive been working on loads of different solutions either something on my PC literately hates XAMMP or the website coding dose not link up-to the database
09/14/2012 22:23 funhacker#5
try using a mysql client (navicat for example) to connect on that computer using the exact same credentials, if you connect no problem, then it's definitely something to do with php
if you are refused connection (1060 or 1061) then clearly your database host is refusing the connection
It could be that the firewall won't allow it
It could be that the user is not allowed at that host
It could be that the database is actually not active
09/14/2012 22:32 Andy20081#6
A) my fire wall is turned of
B) im using mysqladmin for database with navicat
C) on xammp im only running Apache for server as the MySQL on it would have a (war) against mysqladmin as there both MySQL based
D) the database must be active as i can play on my server and use query to create accounts for me and my fellow staff..

p.s. this message is not to be rude or nothing if it comes across like that :)
09/14/2012 23:02 PowerChaos#7
if i provide you a version of mysql/apache that can be started with a single button
do you want to try that out and see if you still got the same errors ??

normaly it should be root/test or test/test as login pass/username
i forgot what exactly it was , but i do a guess on root/test

if you are willing to try that solution then it should work

from the error messages you get does it seems like funhacker says

from what i read does it says that the server refuse the connection , so it could be a mysql setting to prevent new connections to be made (or you edited that part and it actual hide the exact error )

check your database and allow a wildcard for root ( wildcard = % in mysql )

restart mysql , and try it again , if it fails then it is not the solution below
else it is probaly the solution i describe below

because you use hamachi is it possible that you do not use localhost but the hamachi ip instead to connect to mysql

as mysql checks where the connection is coming from ( server) and checks if it is in the allowed list is it possible that mysql gets the hamachi ip as server ip and not 127.0.0.1 aka localhost

if you use winsqladmin or the normal mysql is the same , winsqladmin is just a program like you have phpadmin , it starts up a mysql version that you configured to start up
so you can even use it with a other mysql instance then the 1 it started up for you

if those things are failing then i want to make a deal for you to set it up
but then the register page will also be public
this is what i going do then

put the register page on my webserver (subdomain or free domain)
put nodns on your computer to get a static domain name that fits your dynamic ip adress
setup mysql this way that it allows the website to connect to mysql only from my server (so no other acces can be on it )
make sure that the register page works like it need to be

only thing that i ask for this is that you use the webhosting :D

Greetings From PowerChaos
09/14/2012 23:21 Andy20081#8
chaos would i be able to add you on msn as it will make time abit easier as yesterday i spent 24 hours non stop trying to sort register as well as trying to sort out and change things on server for the greater good if this is OK my msn is listed on my profile thanks your being a star ATM im so tired its unreal

i would like to try out the other appach mysql if that is ok

ok im abit baffled here on the config.ini

Quote:
<?php
require_once './inc/class.captcha.php';
// Configurations
$myhost="localhost";
$mypass="test"; //your server login password
$myuser="root"; //your server login username
$mydbacc="account"; //your server account database
$mydbdata="my"; //your server my database name
$serveraddress="127.0.0.1"; //your server ip
$serverport=5816; //your server connection port
$mydb="my"; //your server my database
$servername="KittenChaosEo";

$page = basename($_SERVER['SCRIPT_FILENAME']);
$page = str_replace('_',' ',$page);
$page = str_replace('.php','',$page);
$page = ucfirst($page);

// Dont Edit after this
//Added By Gekru - Just changed the connecting ip
mysql_connect($myhost,$mypass,$myuser);
mysql_select_db($mydb);
?>
when i remove the code what i have made red the error of connection goes
09/15/2012 09:56 funhacker#9
Quote:
Originally Posted by Andy20081 View Post
A) my fire wall is turned of
B) im using mysqladmin for database with navicat
C) on xammp im only running Apache for server as the MySQL on it would have a (war) against mysqladmin as there both MySQL based
D) the database must be active as i can play on my server and use query to create accounts for me and my fellow staff..

p.s. this message is not to be rude or nothing if it comes across like that :)
not rude, just ignorant
You do these tests to narrow down the reasons as to why you can't connect
I suggest that when you ask for help, and it's supplied you use it or you'll never solve your problem.
09/15/2012 21:23 Andy20081#10
i have been trying the steps but i found a problem which i state above ^_^ p.s love acme but how come the update client dosont work no more i been wondering whats happend to acme
09/16/2012 00:15 Timore[PM]#11
Simple put, Your User and Password for MYSQL is wrong.

Code:
mysql_connect($myhost,$mypass,$myuser);
Calls for 3 things
$myhost="localhost";
$mypass="test"; //your server login password
$myuser="root"; //your server login username
The queries above check Connection. 
IP
Password
User
If you removed the User and Password and it connects, Than you have an issue with your User Name and Password. Try checking through Navicat to make sure you have
User: root
Pass: test
With all privelages on localhost

Code:
GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY 'test';

GRANT USAGE ON *.* TO 'root'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0;

GRANT GRANT OPTION ON *.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON *.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE TEMPORARY TABLES, LOCK TABLES ON `mysql`.* TO 'root'@'localhost';

GRANT GRANT OPTION ON `mysql`.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE TEMPORARY TABLES, LOCK TABLES ON `my`.* TO 'root'@'localhost';

GRANT GRANT OPTION ON `my`.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE TEMPORARY TABLES, LOCK TABLES ON `account`.* TO 'root'@'localhost';

GRANT GRANT OPTION ON `account`.* TO 'root'@'localhost';
Run that as a query, It should fix your issue with
root/test being the issue

#Off Topic
Read Acme Forums and Connect with the Connection Patch and Run Acme Center
09/16/2012 11:53 funhacker#12
Quote:
Originally Posted by Andy20081 View Post
i have been trying the steps but i found a problem which i state above ^_^ p.s love acme but how come the update client dosont work no more i been wondering whats happend to acme
Which ones suceeded and which ones failed? (if any)
As for acme, you need to download one of the clients from the forums and then use the newly updated acme center to patch the client.
It's like this for now to prevent too many players that can't figure out the forum system from joining, makes bug fixing a lot faster for now until we have a better base for people to play.
09/16/2012 17:15 Andy20081#13
ahh ok i just miss playing acme i played it alot back in the days even donated to help out and i would love to be able to play again thanks for that Big-Mac

and i have run that query and made sure the settings were all set properly still has the error just about to try what chaos has told me to do via messenger and i will update this post on information
09/18/2012 16:58 funhacker#14
if other applications work no problem it has to do with either:
  • Your login information
  • Firewall related
  • PHP issues

To test for issue with login information, I suggest you use the exact same login info (so use copy and paste, don't assume you didn't type something wrong) to login to the database using navicat.

If this works no problem and you're not testing on the same machine as your php server I then suggest testing if it's a firewall issue by still using the exact same login information but use navicat and connect from the same machine as your php server.

Finally if both work without issue, I suggest checking your php version apache version and mysql version, then check if you have compatible versions. I'd also suggest checking if you can connect using another library withing php, like PDO for example.