 |
|
|
|
Next: Creative Oddballs
|
| Author |
Message |
External
Since: Jun 30, 2003
Posts: 59
|
(Msg. 1) Posted: Fri Aug 29, 2003 6:23 pm
Post subject: Am I being stupid, or is my host?
Archived from groups: alt>www>webmaster (more info?)
|
|
|
I kept getting the following error message when trying to create tables:
Can't connect to local MySQL through socket '/var/run/mysqld/mysqld.sock' (2)
A search online yielded nothing that I thought I could do anything about
myself. The docs on this page mention nothing about script errors:
http://www.mysql.com/doc/en/Can_not_connect_to_server.html
I emailed my host, 1&1, twice but got no reply. Then I phoned, and the tech
support guy told me it was a script error, and there was nothing they could do.
Anyway, I got it to work by putting the connection in the same file as the
script, instead of externally. So it seems it was a script error, but why is
there nothing in the docs about it? I found plenty about MIT - pthreads, Linux
core dumps, incorrect permissions and other incomprehensible stuff. Also Mysql
might need to be reinstalled. I should explain that the script worked fine on
my local test system.
--
Alice Woolley
http://www.insidethebubble.co.uk/
Inside the Bubble - autism information |
|
| Back to top |
|
 | |
External
Since: Aug 13, 2003
Posts: 40
|
(Msg. 2) Posted: Fri Aug 29, 2003 6:23 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Foxglove54321" <foxglove54321 DeleteThis @aol.comblahblah> wrote in message
news:20030829112356.03375.00000164@mb-m11.aol.com...
> I kept getting the following error message when trying to create tables:
Does your host have phpMyAdmin available for you to use? Try working with
your database that way.
> I should explain that the script worked fine on
> my local test system.
It really doesn't matter if it worked fine on your computer or a different
host's server - machines can be configured differently. 
--Tina
--
<a style='text-decoration: underline;' href="http://www.AffordableHOST.com" target="_blank">http://www.AffordableHOST.com</a>
LiveChat: <a style='text-decoration: underline;' href="http://chat.affordablehost.com" target="_blank">http://chat.affordablehost.com</a>
20% Discount Code: newsgroup
Serving the web since 1997<!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Jun 28, 2003
Posts: 1662
|
(Msg. 3) Posted: Fri Aug 29, 2003 10:57 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Foxglove54321" <foxglove54321.RemoveThis@aol.comblahblah> wrote in message
news:20030829112356.03375.00000164@mb-m11.aol.com...
> I kept getting the following error message when trying to create tables:
>
> Can't connect to local MySQL through socket '/var/run/mysqld/mysqld.sock'
(2)
>
> A search online yielded nothing that I thought I could do anything about
> myself. The docs on this page mention nothing about script errors:
>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font" target="_blank">http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font</a>>
>
> I emailed my host, 1&1, twice but got no reply. Then I phoned, and the
tech
> support guy told me it was a script error, and there was nothing they
could do.
>
>
> Anyway, I got it to work by putting the connection in the same file as the
> script, instead of externally. So it seems it was a script error, but why
is
> there nothing in the docs about it? I found plenty about MIT - pthreads,
Linux
> core dumps, incorrect permissions and other incomprehensible stuff. Also
Mysql
> might need to be reinstalled. I should explain that the script worked fine
on
> my local test system.
For my needs, I always put the connection information in the scipt that's
using it. Perhaps that is normal, and that's why you don't see the error so
much?
--
Charles Sweeney
<a style='text-decoration: underline;' href="http://www.CharlesSweeney.com" target="_blank">www.CharlesSweeney.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Aug 12, 2003
Posts: 16
|
(Msg. 4) Posted: Sat Aug 30, 2003 6:08 am
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
foxglove54321.RemoveThis@aol.comblahblah (Foxglove54321) wrote in
news:20030829112356.03375.00000164@mb-m11.aol.com:
> I kept getting the following error message when trying to create
> tables:
>
> Can't connect to local MySQL through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> A search online yielded nothing that I thought I could do anything
> about myself. The docs on this page mention nothing about script
> errors:
>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font" target="_blank">http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font</a>>
>
> I emailed my host, 1&1, twice but got no reply. Then I phoned, and
> the tech support guy told me it was a script error, and there was
> nothing they could do.
>
>
> Anyway, I got it to work by putting the connection in the same
> file as the script, instead of externally. So it seems it was a
> script error, but why is there nothing in the docs about it? I
> found plenty about MIT - pthreads, Linux core dumps, incorrect
> permissions and other incomprehensible stuff. Also Mysql might
> need to be reinstalled. I should explain that the script worked
> fine on my local test system.
>
>
> --
> Alice Woolley
<font color=purple> > <a style='text-decoration: underline;' href="http://www.insidethebubble.co.uk/</font" target="_blank">http://www.insidethebubble.co.uk/</font</a>>
> Inside the Bubble - autism information
Bet your host is running php in safe mode. Includes and requires fail
when php is running in safe mode, iirc, and I believe it is a known
bug.
--
Pixel McGee
"The world is coming to an end. Please log off."<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 30, 2003
Posts: 285
|
(Msg. 5) Posted: Sat Aug 30, 2003 12:01 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Charles Sweeney" <me RemoveThis @charlessweeney.com> wrote in message
news:bio7mn$bmv9f$1@ID-162618.news.uni-berlin.de...
> "Foxglove54321" <foxglove54321 RemoveThis @aol.comblahblah> wrote in message
> news:20030829112356.03375.00000164@mb-m11.aol.com...
> > I kept getting the following error message when trying to create tables:
> >
> > Can't connect to local MySQL through socket
'/var/run/mysqld/mysqld.sock'
> (2)
> >
> > A search online yielded nothing that I thought I could do anything about
> > myself. The docs on this page mention nothing about script errors:
> >
<font color=green> > > <a style='text-decoration: underline;' href="http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font" target="_blank">http://www.mysql.com/doc/en/Can_not_connect_to_server.html</font</a>>
> >
> > I emailed my host, 1&1, twice but got no reply. Then I phoned, and the
> tech
> > support guy told me it was a script error, and there was nothing they
> could do.
> >
> >
> > Anyway, I got it to work by putting the connection in the same file as
the
> > script, instead of externally. So it seems it was a script error, but
why
> is
> > there nothing in the docs about it? I found plenty about MIT - pthreads,
> Linux
> > core dumps, incorrect permissions and other incomprehensible stuff. Also
> Mysql
> > might need to be reinstalled. I should explain that the script worked
fine
> on
> > my local test system.
>
> For my needs, I always put the connection information in the scipt that's
> using it. Perhaps that is normal, and that's why you don't see the error
so
> much?
If the connect stuf is built into a function and kept as an .inc and the
same with a variable file containing amounst other things, the connect vars
like u/name P/wd dbname etc once it is got working on one site it will work
correctly on all sites - only the vars then need to be changed.
Then in any scrip that needs it one only has to require say, connect.inc and
vars.php
Where vars.php has the variables changed to reflect the current site.<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 30, 2003
Posts: 59
|
(Msg. 6) Posted: Sat Aug 30, 2003 12:01 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>> For my needs, I always put the connection information in the scipt that's
>> using it. Perhaps that is normal, and that's why you don't see the error
>so
>> much?
Bill Logan wrote:
>If the connect stuf is built into a function and kept as an .inc and the
>same with a variable file containing amounst other things, the connect vars
>like u/name P/wd dbname etc once it is got working on one site it will work
>correctly on all sites - only the vars then need to be changed.
>
>Then in any scrip that needs it one only has to require say, connect.inc and
>vars.php
>
>Where vars.php has the variables changed to reflect the current site.
This is the odd bit: in other scripts on other sites at the same host, I put
all the connection stuff in one file for simplicity, and it worked. Just this
time round there was a problem. And I pretty much copy and pasted the file, so
it wasn't that the connection scripts were different. Why it even went wrong is
a puzzle.
It's not the script itself that I'm worried about, so much as I'm wondering
whether my host could be less reliable than I thought. In other words, is their
response clueful? I don't know enough about MySQL to be able to judge.
--
Alice Woolley
<a style='text-decoration: underline;' href="http://www.insidethebubble.co.uk/" target="_blank">http://www.insidethebubble.co.uk/</a>
Inside the Bubble - autism information<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Aug 24, 2003
Posts: 28
|
(Msg. 7) Posted: Sat Aug 30, 2003 2:50 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Foxglove54321 wrote:
> I kept getting the following error message when trying to create tables:
> Can't connect to local MySQL through socket '/var/run/mysqld/mysqld.sock' (2)
> Anyway, I got it to work by putting the connection in the same file as the
> script, instead of externally.
If it works inside the script but not as an external file, perhaps your
connection file is not getting included into the main file.
How is the connection file being included? using a scripting function -
which language? or by Server Side Includes (SSI).
If SSI the line should look similar to
<!--#include virtual="myfile.inc" -->
Cheers,
Ste W<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 28, 2003
Posts: 171
|
(Msg. 8) Posted: Sat Aug 30, 2003 2:50 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"SteW" <stephen.wardill.TakeThisOut@btopenworld.com> wrote in message
news:biq31v$o1j$1@titan.btinternet.com...
> Foxglove54321 wrote:
>
> > I kept getting the following error message when trying to create tables:
> > Can't connect to local MySQL through socket
'/var/run/mysqld/mysqld.sock' (2)
> > Anyway, I got it to work by putting the connection in the same file as
the
> > script, instead of externally.
>
> If it works inside the script but not as an external file, perhaps your
> connection file is not getting included into the main file.
> How is the connection file being included? using a scripting function -
> which language? or by Server Side Includes (SSI).
>
> If SSI the line should look similar to
> <!--#include virtual="myfile.inc" -->
>
> Cheers,
> Ste W
>
Just a note:
Chances are, if the person is trying to connect to MySQL, it isn't going to
be an ASP file that they're calling with an include.
It is probably being called from php include();
--
Karl Core
Charles Sweeney says my sig is fine as it is.<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Aug 24, 2003
Posts: 28
|
(Msg. 9) Posted: Sat Aug 30, 2003 3:32 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
EightNineThree wrote:
> Just a note:
> Chances are, if the person is trying to connect to MySQL, it isn't going to
> be an ASP file that they're calling with an include.
> It is probably being called from php include();
>
ASP never even crossed my mind 
The <!--#include is SSI.
Could be using php, perl, python, c...
Cheers
Ste W<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 30, 2003
Posts: 59
|
(Msg. 10) Posted: Sat Aug 30, 2003 3:46 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Karl Core wrote:
>Chances are, if the person is trying to connect to MySQL, it isn't going to
>be an ASP file that they're calling with an include.
>It is probably being called from php include();
It was a php require();
Pixel's suggestion that it's running in safe mode is a possibility. I just wish
they would put real tech support people on the phones.
--
Alice Woolley
<a style='text-decoration: underline;' href="http://www.insidethebubble.co.uk/" target="_blank">http://www.insidethebubble.co.uk/</a>
Inside the Bubble - autism information<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Aug 24, 2003
Posts: 28
|
(Msg. 11) Posted: Sat Aug 30, 2003 4:12 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Foxglove54321 wrote:
> Pixel's suggestion that it's running in safe mode is a possibility. I just wish
> they would put real tech support people on the phones.
>
Just checked, this is not the case - php safe mode and sql.safe mode are
both turned off at 1&1.
Have to go out now but I'll look a bit further tonight when I get back.
Ste W<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Aug 24, 2003
Posts: 28
|
(Msg. 12) Posted: Sat Aug 30, 2003 8:53 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Tested with my 1&1 account using these files and all works fine.
require.php:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
<p>the start</p>
<?php require("middle.inc"); ?>
<p>the end</p>
<?php
require("connect.inc");
if ($link)
echo "<p>connected</p>";
else
echo "<p>NOT connected</p>";
?>
</body>
</html>
=============================
middle.inc:
<p>the middle</p>
===============================
connect.inc:
<?php
$link = mysql_connect("mydbhostname","mydbusername","mydbpassword");
?>
===============================
results:
the start
the middle
the end
connected
Try the files on your 1&1 and let me know the outcome
Cheers,
Ste W >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 30, 2003
Posts: 59
|
(Msg. 13) Posted: Sat Aug 30, 2003 9:32 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>Try the files on your 1&1 and let me know the outcome
If most of the files weren't working correctly, I would have a problem. They
are, except for this one action at this time. So it could be a glitch on a
single machine rather than something global that affects all users.
--
Alice Woolley
<a style='text-decoration: underline;' href="http://www.insidethebubble.co.uk/" target="_blank">http://www.insidethebubble.co.uk/</a>
Inside the Bubble - autism information<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jun 30, 2003
Posts: 285
|
(Msg. 14) Posted: Sat Aug 30, 2003 10:02 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Foxglove54321" <foxglove54321.RemoveThis@aol.comblahblah> wrote in message
news:20030829172255.17956.00000123@mb-m05.aol.com...
> >> For my needs, I always put the connection information in the scipt
that's
> >> using it. Perhaps that is normal, and that's why you don't see the
error
> >so
> >> much?
> Bill Logan wrote:
> >If the connect stuf is built into a function and kept as an .inc and the
> >same with a variable file containing amounst other things, the connect
vars
> >like u/name P/wd dbname etc once it is got working on one site it will
work
> >correctly on all sites - only the vars then need to be changed.
> >
> >Then in any scrip that needs it one only has to require say, connect.inc
and
> >vars.php
> >
> >Where vars.php has the variables changed to reflect the current site.
>
> This is the odd bit: in other scripts on other sites at the same host, I
put
> all the connection stuff in one file for simplicity, and it worked. Just
this
> time round there was a problem. And I pretty much copy and pasted the
file, so
> it wasn't that the connection scripts were different. Why it even went
wrong is
> a puzzle.
>
> It's not the script itself that I'm worried about, so much as I'm
wondering
> whether my host could be less reliable than I thought. In other words, is
their
> response clueful? I don't know enough about MySQL to be able to judge.
>
No replies to e-mails?
Determination the script is at fault over the phone? How could they tell
without actually seeing the script? A phone description is guesswork at
best.<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
External
Since: Jul 04, 2003
Posts: 93
|
(Msg. 15) Posted: Sat Aug 30, 2003 10:02 pm
Post subject: Re: Am I being stupid, or is my host? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Bill Logan" <blogan.DeleteThis@clear.net.nz> wrote in message news:<3f504ac5.DeleteThis@clear.net.nz>...
> "Foxglove54321" <foxglove54321.DeleteThis@aol.comblahblah> wrote in message
> news:20030829172255.17956.00000123@mb-m05.aol.com...
> > >> For my needs, I always put the connection information in the scipt
> that's
> > >> using it. Perhaps that is normal, and that's why you don't see the
> error
> so
> > >> much?
> Bill Logan wrote:
> > >If the connect stuf is built into a function and kept as an .inc and the
> > >same with a variable file containing amounst other things, the connect
> vars
> > >like u/name P/wd dbname etc once it is got working on one site it will
> work
> > >correctly on all sites - only the vars then need to be changed.
> > >
> > >Then in any scrip that needs it one only has to require say, connect.inc
> and
> > >vars.php
> > >
> > >Where vars.php has the variables changed to reflect the current site.
> >
> > This is the odd bit: in other scripts on other sites at the same host, I
> put
> > all the connection stuff in one file for simplicity, and it worked. Just
> this
> > time round there was a problem. And I pretty much copy and pasted the
> file, so
> > it wasn't that the connection scripts were different. Why it even went
> wrong is
> > a puzzle.
> >
> > It's not the script itself that I'm worried about, so much as I'm
> wondering
> > whether my host could be less reliable than I thought. In other words, is
> their
> > response clueful? I don't know enough about MySQL to be able to judge.
> >
> No replies to e-mails?
> Determination the script is at fault over the phone? How could they tell
> without actually seeing the script? A phone description is guesswork at
> best.
If you mean of this - possibly. If you mean a phone description of
ANY problems and it's resolution being given via phone, not so! It's
perfectly possiblw doe rwxh ro diganose and correctly determine
faults over the phone.<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Am I being stupid, or is my host? |
|
| Back to top |
|
| |
| Related Topics: | Recomend me a host - I'm looking for a host, with the following requirements, any suggestions? o Host .com & .co.uk with domain transfer in o No release fee ooLow annual cost (preferably ~ £35 for the first year, probably <£50 max) o ~ 100mb webspace o 1gb/month + ba...
web host reviews - Can anyone recommend some good, independent sites which review web hosts? I've been looking at some (e.g. www.100best-web-hosting.com) and have no idea if they are unbiased or even competent. TIA Peggy McCall
Web Host Recommendations? - I am looking for a new web host that can get me in for less that $29.95 per month paid quarterly that also has either Listserv or Majordomo. Because I provide mailing lists (5-7 at any given time) for third party developers, I must have either/or...
HELP!! My host's evaporated - Hi all, In January 2002 I registered the domain 3gsite.net, bought in a package deal with basic web and email hosting from Totalise Hosting (www.domainnamesales.co.uk). I renewed the 12 month deal in January this year, because I was pleased with the....
How to host my own website? - I hope someone out there can help me with this. I have a website that has been up for the past several years with the same provider. Recently, I have gotten myself set up with DSL and have had my provider assign me a static IP. I have a machine runnin... |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
