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

[Laurent Blume]

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?

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
>>
>>