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
