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

[Carsten Grzemba]

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/20140926/0f49c412/attachment.html>