[ic] Interchange 4.6.1 and MySQL 3.23
Cameron B. Prince
cameron@akopia.com
Wed, 20 Dec 2000 12:37:20 -0600
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C06A81.98932740
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Can you confirm that you have the proper rights granted in the MySQL user
table? Something like this:
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
Grant_priv | References_priv | Index_priv |
Alter_priv |
| localhost | dgc | 470aee162402249e | Y | Y |
Y | Y | Y |
Y | N | N | N | Y | N
| N | Y | Y |
Good luck,
Cameron
-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Thomas McAlees
Sent: Wednesday, December 20, 2000 12:16 PM
To: interchange-users@lists.akopia.com
Subject: [ic] Interchange 4.6.1 and MySQL 3.23
I'm new to Interchange but I've found the install and configuration to be
very reasonable. I have encountered only one problem that I can't seem to
get past. When I create a new catalog and configure it to use MySQL, I'm
receiving error while trying to create the database indexes. The tables are
all created but I receive the following error for every table:
table xxxxxxx index failed: Access denied for user: 'dgc@localhost' to
database 'dgc'
I don't understand why I'm getting an access denied error for the index,
but the tables are being created just fine.
Additional Information:
The site is hosted by an ISP and I only have access to a single MySQL
database that is already created. I've provided the appropriate
login/password information to the makecat script and it IS creating the
tables so I know the connection to the database is working. Even with the
index creation error I can access the Interchange store and perform just
about every function. The only thing I've been unable to do is update the
inventory. When I try I get this error 'Sorry, there was an error in
processing this form action. Please report the error or try again later.
(You have an error in your SQL syntax near '= NULL where sku = 'os28113' '
at line 1 )'. I'm not sure if this is related to the index problem, but
that is where I'm starting.
Any help would be greatly appreciated!
Tom McAlees
tmcalees@rochester.rr.com
------=_NextPart_000_0006_01C06A81.98932740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2>Can=20
you confirm that you have the proper rights granted in the MySQL user =
table?=20
Something like this:</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2>|=20
Host &nb=
sp; =20
| User |=20
Password | Select_priv | =
Insert_priv | Update_priv | Delete_priv | Create_priv =
|</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2> Drop_priv | Reload_priv | Shutdown_priv | Process_priv | =
File_priv=20
| Grant_priv | References_priv | Index_priv |</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2> Alter_priv |</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2>|=20
localhost =
| dgc =20
| 470aee162402249e |=20
Y |=20
Y |=20
Y |=20
Y |=20
Y =20
|</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2> Y |=20
N |=20
N =
|=20
N |=20
Y |=20
N |=20
N =
=20
| Y |=20
Y =
|</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2>Good=20
luck,</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2>Cameron</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
interchange-users-admin@lists.akopia.com=20
[mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
</B>Thomas=20
McAlees<BR><B>Sent:</B> Wednesday, December 20, 2000 12:16 =
PM<BR><B>To:</B>=20
interchange-users@lists.akopia.com<BR><B>Subject:</B> [ic] Interchange =
4.6.1=20
and MySQL 3.23<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'm new to Interchange but I've found =
the install=20
and configuration to be very reasonable. I have encountered only =
one=20
problem that I can't seem to get past. When I create a new =
catalog and=20
configure it to use MySQL, I'm receiving error while trying to create =
the=20
database indexes. The tables are all created but I receive the =
following=20
error for every table:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>table xxxxxxx index failed: =
Access denied=20
for user: <A href=3D"mailto:'dgc@localhost'">'dgc@localhost'</A> to =
database=20
'dgc'</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I don't understand why I'm getting an =
access=20
denied error for the index, but the tables are being created just =
fine. =20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Additional Information:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The site is hosted by an ISP and I =
only have=20
access to a single MySQL database that is already created. I've =
provided=20
the appropriate login/password information to the makecat script and =
it IS=20
creating the tables so I know the connection to the database is =
working. =20
Even with the index creation error I can access the Interchange store =
and=20
perform just about every function. The only thing I've been =
unable to do=20
is update the inventory. When I try I get this error 'Sorry, =
there was=20
an error in processing this form action. Please report the error or =
try again=20
later. (You have an error in your SQL syntax near '=3D NULL where sku =
=3D=20
'os28113' ' at line 1 )'. I'm not sure if this is related to the =
index=20
problem, but that is where I'm starting.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any help would be greatly=20
appreciated!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tom McAlees</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>tmcalees@rochester.rr.com</FONT></DIV></BLOCKQUOTE></BODY></HTML=
>
------=_NextPart_000_0006_01C06A81.98932740--