[ic] New catelogue with MySQL problems

[Greg Cope]

Dave Barr wrote:
> 
> >  > >Been playing withn interchange with a view to a production roll out.
> >  > >
> >>  >I made a cat yesterday with Mysql support - Interchange made the DB -
> >>  >but upon restart gives the following in the logs:
> >>  >
> >>  >- - - [03/October/2000:07:44:17 +0000] - - Config 'fooshop' at server
> >>  >startup
> >>  >- - - [03/October/2000:07:44:17 +0000] - - Using MySQL,
> >>  >DSN=dbi:mysql:fooshop.
> >>  >- - - [03/October/2000:07:44:18 +0000] - - fooshop config error: Table
> >>  >'fooshop.orderline' doesn't exist
> >>  >- - - [03/October/2000:07:44:18 +0000] - - fooshop: config error.
> >>  >Skipping.
> >>  >
> >>  >I looked through the docs and cannot find any info - this may sound,
> >  > >lame but do I need to create that table ?
> 
> >  > I had exactly the same thing happen when I created a new shop with
> >>  the same name as an older one after I had "dropped" that older shops
> >>  SQL database (mysqladmin)... you could have a different scenario but
> >>  I fixed it by giving the new catalog a new unique name (talk about
> >>  being lame  :-)
> 
> >Hum ... I missed out the bit about creating a shop and then deleteing
> >it.
> >
> >This sounds like a kludge - but a help non the less.
> >
> >Any any ideas why the recreation of a shop should cause this ?
> 
> ---
> 
> Actually no I don't... :(
> 
> But I figured after that that it wasn't a good idea to drop any SQL
> databases (I was trying to flush my system of *any* old files before
> upgrading to 4.5.6 latest CVS's). Have you ever created a shop on
> that particular machine with the name fooshop before?

Yup.

But I solved the problem.

MySQL permissions.

I operate a quite restrictive policy - i.e I gave the interchange user
too few permissions - Index and Delete privileges where needed - a quick
grant INDEX, DELETE ..... on ... fixed it.

Sounds easy ... but it raises onther question:

Why does interchange need "Creation style" priveleges such as index,
delete and create - would it be possible to remove these and have them
run at makecat time (under an admins privelege), so that interchange
cats run under the least privileges  ?

Also a minor bug but when doing the following with interchange running
(on an RPM install):

[root@localhost fooshop]# su -c "/usr/lib/interchange/bin/interchange
-r" interch
bash: /root/.bashrc: Permission denied
The Interchange server was not running
(/usr/lib/interchange/etc/interchange.pid).

Which is suggest at the end of makecat, to restart the beast.

The server starts and stops normally tho (just gets a bit confused)

Anyway Thanks Dave.

Greg

> 
> Dave
> --
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Dave Barr        eCommerce Technical Manager      CricInfo Ltd
> www.cricinfo.com   dave.barr@cricinfo.com    Tel: 01249 700748
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users