[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] New catelogue with MySQL problems
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
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
