[ic] New catelogue with MySQL problems
Tue, 03 Oct 2000 14:00:42 +0000
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
> >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?
But I solved the problem.
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
bash: /root/.bashrc: Permission denied
The Interchange server was not running
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.
> Dave Barr eCommerce Technical Manager CricInfo Ltd
> www.cricinfo.com email@example.com Tel: 01249 700748
> Interchange-users mailing list