Mysql hickups. (was The Python web apps throw 500s)

[Carsten Grzemba]

Am 26.09.14 schrieb Laurent Blume  <laurent at opencsw.org>:
> I will look into it.
> For now, be careful that I'm going to push a new package that will overwrite it (now that MySQL works, the MySQL packages could be created :-)
> 
> My first idea is that it could be handled automatically, following this rough outline:
>  - CSW package installs cswservice:default
>  - users can create cswservice:otherinstance if they wish
>  - on package removal, cswservice:* are handled by CAS (instead of just the :default)
>  - so on updates, all are stopped/restarted. Only :default is updated, the others stay of course the responsibility of their creators
> 
> Makes sense?
> 
Yes, this sounds good.

> 
> 
> Laurent
> 
> Le 2014/09/26 16:15 +0200, Carsten Grzemba a écrit:
> >mysql trac is online again.
> >
> >I have changed /etc/opt/csw/init.d/cswmysql5 for support instances:
> >
> >root at mysql [mysql]:/etc/opt/csw/init.d > diff cswmysql5.org cswmysql5
> >41c41,42
> >< datadir=
> >---
> > > datadir=`/bin/svcprop -p config/datadir ${SMF_FMRI} 2>/dev/null`
> > > defaults=`/bin/svcprop -p config/defaults ${SMF_FMRI} 2>/dev/null`
> >293a295,299
> > > if [ ! -z "$defaults" ]
> > > then
> > > defaults_args="--defaults-file=$defaults"
> > > extra_args="$defaults_args $extra_args"
> > > fi
> >323c329
> >< $bindir/mysqld_safe --datadir="$datadir"
> >--pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
> >---
> > > $bindir/mysqld_safe $defaults_args --datadir="$datadir"
> >--pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
> >
> >I don't if it is the best place for do this but this kind is a usual way.
> >@ Laurent: what do you mean, would you incorporate this script change in
> >your package?
> >
> >Am 26.09.14 schrieb *Jan Holzhueter * <jh at opencsw.org>:
> >>Hi,
> >>had some time to debug it :)
> >>
> >>Simple problem someone somehow updated the mysql Packege on our mysql
> >>zone.
> >>
> >>That caused an update from Mysql Version 5.0 to 5.5 (all praise whom
> >>they like that this did not cause any database problems )
> >>
> >>But with this the my.cnf file moved from /opt/csw/mysql5 to /etc/opt/csw
> >>but without any migration script. So some default was loaded with did
> >>not fit our environment. I fixed that now.
> >>It should not give those errors anymore I hope.
> >>
> >>@Carsten your mysql trac database needs to be looked at. To do the
> >>update the cswmysql5:trac Service is broken now and starts not your
> >>database anymore. I disabled it for now. If you have the time please
> >>fix it.
> >>
> >>Greetings
> >>Jan
> >>
> >>
> 
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencsw.org/pipermail/maintainers/attachments/20140929/ce2e6c29/attachment.html>