Problem with session

[badgoat]

Hello!

I'm using authentication and sessions to log in to an area of my site. I can log in fine, but when I try to use a script to add data, I get an error:

Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/url.com/admin/make_added.php on line 25

Warning: mysql_query(): A link to the server could not be established in /home/www/url.com/admin/make_added.php on line 25
Could not execute mysql query 1!

An excerpt from the script which posts data:

session_start();
if(!session_is_registered(user)){
header("location:login.php");
}
include  ("config.php");

And my simple config.php:

$host="******";
$username="badgoat";
$password="******";
$db_name="badgoat";
$tbl_name="members";

What am I doing wrong?

[L0j1k]

A search on google.com for "MySQL Can't connect to local MySQL server through socket" has revealed several links directly to problems of this nature, the first of which (http://www.tech-recipes.com/mysql_tips762.html) tells us:

A frequent error message received when using the mysql command line utility is: Can't connect to local MySQL server through socket '/tmp/mysql.sock' While this error message can be frustrating, the solution is simple.

Obviously, you probably aren't trying to use the command-line utility if you're using PHP to connect to MySQL. However, further down in the above text, we encounter the following text:

To make your life easier, you can make a simple change to the MySQL configuration file /etc/my.cnf that will permanently set the socket file used by the mysql client. After making a backup copy of /etc/my.cnf, open it in your favorite editor.

. . .

If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:

[client]
socket=/var/lib/mysql/mysql.sock

If there is already a [client] section in the my.cnf file, add or edit the socket line as appropriate. You won't need to restart your server or any other processes. Subsequent uses of the mysql client will use the proper socket file.

If the above solution doesn't work, there are many, many other links available on Google. Hope this helps.

[badgoat]

Unfortunately I do not have access to the cnf file and my provider will not change/grant me access to it. Is there another way to do sessions which circumnavigates this problem? I always Google first, when I googled my error I got 100's of sites which appear to have the same problem as I.

[bradgrafelman]

How are you trying to connect to the MySQL database? Show us that line.