Question is, can you connect via the mysql client. This looks like an authentication issue as opposed to something specific to PHP.
Bhavin. ----- Original Message ----- From: "Ingrid Kast Fuller" <[EMAIL PROTECTED]> To: "chuck amadi" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 5:59 AM Subject: RE: MySql 3.23 to version 4 upgrade > Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost. > I use PhpMyAdmin to do any modifications. I did make the nameserver changes > in: > > Database ShoppingCart - table stores > Database mysql - table db > Database mysql - table host > Database mysql - table user > > I reset mysql and apache and still get Internal Server errors and here's > whats in the logs: > > DBI->connect(toyotaecommerce:ns1.cityscope.net) failed: Access denied for > user: '[EMAIL PROTECTED]' (Using password: YES) at > /usr/local/www/data/cart/toyotaecommerce.cgi line 33 > [Wed Jul 24 07:44:37 2002] [error] Can't call method "prepare" on an > undefined value at > /usr/local/lib/perl5/site_perl/5.005/CityScope/ShoppingCart.pm line 267. > > this is line 33... > > my $dbh = > DBI->connect("DBI:mysql:$toyotaecommerce{dbname}:$toyotaecommerce{dbhostname > }", $toyotaecommerce{dbuser}, $toyotaecomm > > > this is line 267 > > sub getIDdb { > my ($self, $dbh, $id, $store) = @_; > my ($check, $sth, @cart); > $check = 'select * from carts where(id = "' . $id . '");'; > $sth = $dbh->prepare($check) or $self->Error('Could not prepare > select statement in sub getIDdb(); ' . $dbh->errstr); > > > > Ingrid Kast Fuller > CityScope Net > 3910 Fairmont Parkway #264 > Pasadena, TX 77504-3066 > (713) 477-6161 > > -----Original Message----- > From: chuck amadi [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 7:14 AM > To: Ingrid Kast Fuller > Subject: Re: MySql 3.23 to version 4 upgrade > > > Ingrid Kast Fuller wrote: > > >Hey Chuck, since you're up at this time, could I ask you for some MySQL > >help? > >I changed my name server names and IP addresses and having trouble getting > >them put in the database and my ecommerce sites are currently down. I have > >phpAdmin and went into one file and changed all the cs1.cityscope.net to > >ns1.cityscope.net but that didn't help. Where else would I change the info > >so the database will work. I keep getting "Internal Server Error"'s? > >Your help is appreciated. > > > >Ingrid Kast Fuller > >CityScope Net > >3910 Fairmont Parkway #264 > >Pasadena, TX 77504-3066 > >(713) 477-6161 > > > >-----Original Message----- > >From: chuck amadi [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, July 24, 2002 3:33 AM > >To: mysql > >Subject: MySql 3.23 to version 4 upgrade > > > > > >Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any > >issues that should be addressed ie uninstall v3 prior to installing v4 > >or can i just install over v3. > > > >Any suggested sites' ,FAQ regarding my question. > > > >-- > >Regards > > > >Chuck Amadi > >ICT Dept Systems Programmer > >Rhaglenydd Systemau Adran ICT > > > > > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > Hi There Plz could explain what O/s and Server as I'm currently running > Apache v1 with PhpMyAdmin (maintenace purposes only) running on my Win > Box 98 for testing & development etc. > > Work stuff is linux based environment & System Administrator sorts that > stuff out. > > Thus i edited C:\Program Files \ Apache Group\Apache\Conf\httpd.conf and > look for # ServerName new.host.name > > and add your ipAddress thus if your'e running virutally hosts go to the > bottom - #NameVirtualHost > > <VirtualHost> > ServerName > DocumentRoot > ServerName > Also check your'e WebAppConnection Conn Warp yourHost:8008 (your port) > > Best thing to do is C & P to list altering of cause your ipAddress details. > > I hope this helps or someone with more exp continue's the thread. > > -- > Regards > > Chuck Amadi > ICT Dept Systems Programmer > Rhaglenydd Systemau Adran ICT > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php