[ic] Interchange 4.6.1 and MySQL 3.23
Eric Hull
eric@webuildpcs.com
Wed, 20 Dec 2000 12:51:22 -0600
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C06A83.8E3A0140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Also all priv must be Y in order for IC to write to the dir.
Eric Hull
-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Cameron B.
Prince
Sent: Wednesday, December 20, 2000 12:37 PM
To: interchange-users@lists.akopia.com
Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
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_0008_01C06A83.8E3A0140
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.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D790395018-20122000><FONT face=3DArial size=3D2>Also =
all priv must=20
be Y in order for IC to write to the dir.</FONT></SPAN></DIV>
<DIV><SPAN class=3D790395018-20122000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D790395018-20122000><FONT face=3DArial size=3D2>Eric=20
Hull</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 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>Cameron=20
B. Prince<BR><B>Sent:</B> Wednesday, December 20, 2000 12:37 =
PM<BR><B>To:</B>=20
interchange-users@lists.akopia.com<BR><B>Subject:</B> RE: [ic] =
Interchange=20
4.6.1 and MySQL 3.23<BR><BR></FONT></DIV>
<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=20
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 =
|=20
Insert_priv | Update_priv | Delete_priv | Create_priv =
|</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
size=3D2> Drop_priv | Reload_priv | Shutdown_priv | Process_priv =
|=20
File_priv | Grant_priv | References_priv | Index_priv =
|</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
size=3D2> Alter_priv |</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff size=3D2>|=20
localhost =20
| dgc | 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=20
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=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
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=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Cameron</FONT></SPAN></DIV>
<DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
color=3D#0000ff=20
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=20
install and configuration to be very reasonable. I have =
encountered=20
only one problem that I can't seem to get past. When I create =
a new=20
catalog and configure it to use MySQL, I'm receiving error while =
trying to=20
create the database indexes. The tables are all created but I =
receive=20
the following 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=20
fine. </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=20
provided the appropriate login/password information to the makecat =
script=20
and it IS creating the tables so I know the connection to the =
database is=20
working. Even with the index creation error I can access the=20
Interchange store and perform just about every function. The =
only=20
thing I've been unable to do is update the inventory. When I =
try I get=20
this error 'Sorry, there was an error in processing this form =
action. Please=20
report the error or try again later. (You have an error in your SQL =
syntax=20
near '=3D NULL where sku =3D 'os28113' ' at line 1 )'. I'm not =
sure if=20
this is related to the index problem, but that is where I'm=20
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></BLOCKQUOTE>=
</BODY></HTML>
------=_NextPart_000_0008_01C06A83.8E3A0140--