/[smeserver]/rpms/smeserver-mysql/sme10/smeserver-mysql.spec
ViewVC logotype

Annotation of /rpms/smeserver-mysql/sme10/smeserver-mysql.spec

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph


Revision 1.30 - (hide annotations) (download)
Mon Jul 11 15:56:58 2022 UTC (2 years, 3 months ago) by jpp
Branch: MAIN
CVS Tags: smeserver-mysql-2_7_0-16_el7_sme
Changes since 1.29: +7 -1 lines
* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme
- use dedicated log file for *mysql.init [SME: 11953]

1 jpp 1.1 Summary: Koozali SME Server specific mysql configuration and templates.
2     %define name smeserver-mysql
3     Name: %{name}
4     %define version 2.7.0
5 jpp 1.30 %define release 16
6 jpp 1.1 Version: %{version}
7     Release: %{release}%{?dist}
8     License: GPL
9     Group: Networking/Daemons
10     Source: %{name}-%{version}.tar.xz
11 jpp 1.3 Patch0: smeserver-mysql-2.7.0-bz11899-sclo.patch
12 jpp 1.24 Patch1: smeserver-mysql-2.7.0-bz11922-mysqlinit.patch
13 jpp 1.25 Patch2: smeserver-mysql-2.7.0-bz11936.patch
14 jpp 1.30 Patch3: smeserver-mysql-2.7.0-bz11953-mysql.init-logging.patch
15 jpp 1.1
16     BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
17     BuildArchitectures: noarch
18     Requires: mariadb-server
19 jpp 1.19 # mariadb after 5.5 /in Centos 8 will package mysql_upgrade in mariadb-server-utils
20     # Requires: /usr/bin/mysql_upgrade
21 jpp 1.1 Requires: mariadb
22     Requires: e-smith-base
23     Requires: e-smith-lib >= 1.15.1-19
24     Provides: e-smith-mysql = 2.7.0
25     Obsoletes: e-smith-mysql < 2.7.0
26     BuildRequires: e-smith-devtools >= 1.13.1-03
27     AutoReqProv: no
28    
29     %description
30     This package adds necessary startup and configuration items for
31     mysql.
32    
33    
34     %prep
35     %setup
36 jpp 1.3 %patch0 -p1
37 jpp 1.24 %patch1 -p1
38 jpp 1.25 %patch2 -p1
39 jpp 1.30 %patch3 -p1
40 jpp 1.1
41     %build
42     for ver in 101 102 103 105
43     do
44     mkdir root$ver
45     done
46     perl createlinks
47    
48     #########################################
49     # full job to create all needed version
50     #########################################
51     declare -A versions=([101]="10.1" [102]="10.2" [103]="10.3" [105]="10.5")
52     declare -A ports=([101]="3310" [102]="3311" [103]="3312" [105]="3313")
53    
54     for ver in 101 102 103 105
55     do
56     ##TODO seen those
57    
58     # default values from /etc/opt/rh/rh-mariadb101/my.cnf.d/mariadb-server.cnf
59     basedir="/opt/rh/rh-mariadb$ver/root/usr"
60     datadir="/var/opt/rh/rh-mariadb$ver/lib/mysql"
61 jpp 1.8 socket="/var/lib/mysql/mariadb$ver.sock"
62 jpp 1.1 logerror="/var//log/mariadb$ver/mariadb.log"
63     #"/var/opt/rh/rh-mariadb$ver/log/mariadb/mariadb.log"
64     pidfile="/var/run/rh-mariadb$ver-mariadb/mariadb.pid"
65     vers="${versions[$ver]}"
66     port="${ports[$ver]}"
67    
68     # we could choose to override /etc/opt/rh/rh-mariadb101/my.cnf or to force to share /etc/mariadb.log
69    
70     ##Folders
71     mkdir -p root$ver/etc/e-smith/sql/init$ver
72     mkdir -p root$ver/home/e-smith/db/mariadb$ver
73     mkdir -p root$ver/var/log/mariadb$ver
74     mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver
75     mkdir -p root$ver/etc/e-smith/events/actions
76    
77     # create configuration db default
78     #rm -rf etc/e-smith/db/configuration
79     mkdir -p root$ver/etc/e-smith/db/configuration/{defaults/mariadb$ver-mariadb,defaults/mariadb$ver-mysql.init,migrate}
80     echo "yes" > root$ver/etc/e-smith/db/configuration/defaults/mariadb$ver-mariadb/LocalNetworkingOnly
81     echo "enabled" > root$ver/etc/e-smith/db/configuration/defaults/mariadb$ver-mariadb/status
82     echo "service" > root$ver/etc/e-smith/db/configuration/defaults/mariadb$ver-mariadb/type
83     echo "enabled" > root$ver/etc/e-smith/db/configuration/defaults/mariadb$ver-mysql.init/status
84     echo "service" > root$ver/etc/e-smith/db/configuration/defaults/mariadb$ver-mysql.init/type
85    
86     # create templates.metadata
87     ## for /etc/e-smith/templates/etc/my.cnf/ => /etc/opt/rh/rh-mariadb$ver/my.cnf
88     mkdir -p root$ver/etc/e-smith/templates.metadata/etc/opt/rh/rh-mariadb$ver
89     echo 'TEMPLATE_PATH="/etc/my.cnf"' > root$ver/etc/e-smith/templates.metadata/etc/opt/rh/rh-mariadb$ver/my.cnf
90    
91     # rename/move files
92    
93     #TODO /etc/e-smith/events
94     mv root/etc/e-smith/events/smeserver-mariadb$ver-update root$ver/etc/e-smith/events/
95     #bootstrap-console-save templates + actions
96     mkdir -p root$ver/etc/e-smith/events/bootstrap-console-save/templates2expand/etc/e-smith/sql/
97     mkdir -p root$ver/etc/e-smith/events/bootstrap-console-save/templates2expand/etc/opt/rh
98     mv root/etc/e-smith/events/bootstrap-console-save/S40mariadb$ver-load-tables root$ver/etc/e-smith/events/bootstrap-console-save/
99     mv root/etc/e-smith/events/bootstrap-console-save/templates2expand/etc/e-smith/sql/init$ver root$ver/etc/e-smith/events/bootstrap-console-save//templates2expand/etc/e-smith/sql/
100     mv root/etc/e-smith/events/bootstrap-console-save/templates2expand/etc/opt/rh/rh-mariadb$ver root$ver/etc/e-smith/events/bootstrap-console-save//templates2expand/etc/opt/rh/
101     #pre-backup actions
102     mkdir -p root$ver/etc/e-smith/events/pre-backup
103     mv root/etc/e-smith/events/pre-backup/S*mariadb$ver-* root$ver/etc/e-smith/events/pre-backup/
104     #post-backup actions
105     mkdir -p root$ver/etc/e-smith/events/post-backup
106     mv root/etc/e-smith/events/post-backup/S*mariadb$ver-* root$ver/etc/e-smith/events/post-backup/
107     #pre-restore actions + service
108     mkdir -p root$ver/etc/e-smith/events/pre-restore
109     mv root/etc/e-smith/events/pre-restore/S*mariadb$ver-* root$ver/etc/e-smith/events/pre-restore/
110     #timezone-update service
111    
112    
113     #/etc/e-smith/events/actions
114     #TODO
115     cp rootscl/etc/e-smith/events/actions/mariadb_VER_-delete-db-files root$ver/etc/e-smith/events/actions/mariadb${ver}-delete-db-files
116     cp rootscl/etc/e-smith/events/actions/mariadb_VER_-delete-dumped-tables root$ver/etc/e-smith/events/actions/mariadb${ver}-delete-dumped-tables
117     cp rootscl/etc/e-smith/events/actions/mariadb_VER_-dump-tables root$ver/etc/e-smith/events/actions/mariadb${ver}-dump-tables
118     cp rootscl/etc/e-smith/events/actions/mariadb_VER_-load-tables root$ver/etc/e-smith/events/actions/mariadb${ver}-load-tables
119     sed -i root$ver/etc/e-smith/events/actions/mariadb${ver}-delete-db-files \
120     -i root$ver/etc/e-smith/events/actions/mariadb${ver}-delete-dumped-tables \
121     -i root$ver/etc/e-smith/events/actions/mariadb${ver}-dump-tables \
122     -i root$ver/etc/e-smith/events/actions/mariadb${ver}-load-tables \
123 jpp 1.20 -e "s_!!!VER!!!_${ver}_g" \
124     -e "s_!!!SOCKET!!!_${socket}_g"
125 jpp 1.1
126     ##metadata
127 jpp 1.22 mkdir -p root$ver/etc/e-smith/templates.metadata/etc/e-smith/sql
128 jpp 1.21 cp -a root/etc/e-smith/templates.metadata/etc/e-smith/sql/init root$ver/etc/e-smith/templates.metadata/etc/e-smith/sql/init$ver
129 jpp 1.1
130    
131     ##templates
132     mkdir -p root$ver/etc/e-smith/templates/etc/e-smith/sql/init$ver
133     cp root/etc/e-smith/templates/etc/e-smith/sql/init/* root$ver/etc/e-smith/templates/etc/e-smith/sql/init$ver
134     sed -i root$ver/etc/e-smith/templates/etc/e-smith/sql/init$ver/00_restore_dumped_dbs -i root$ver/etc/e-smith/templates/etc/e-smith/sql/init$ver/10mysql_upgrade \
135     -e "s_e-smith/db/mysql_e-smith/db/mariadb${ver}_g" \
136     -e "s_/usr/bin/mysql_/opt/rh/rh-mariadb${ver}/root/usr/bin/mysql_g" \
137 jpp 1.25 -e "s_mariadb.service_mariadb$ver-mariadb.service_" \
138 jpp 1.1 -e "s_/var/run/mariadb/mariadb.pid_${pidfile}_g" \
139 jpp 1.26 -e "s_mysqld_mariadb$ver-mariadb_g" \
140 jpp 1.1 -e "s_| mysql |_| /opt/rh/rh-mariadb${ver}/root/usr/bin/mysql --socket=$socket |_g" \
141     -e "s_mysql\_upgrade_mysql\_upgrade --socket=$socket _g"
142     mkdir -p root$ver/etc/e-smith/templates/etc/my.cnf
143     echo "
144     [mariadb-$vers]" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-05mariadb
145     echo "basedir=$basedir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-07basedir
146     echo "datadir=$datadir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-08datadir
147     cp -a root/etc/e-smith/templates/etc/my.cnf/009socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket
148     sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-09socket \
149     -e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \
150     -e "s_^socket.*_socket=${socket}_"
151     cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-10port root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port
152     sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port \
153     -e "s_!!!VER!!!_${ver}_g" \
154     -e "s_!!!PORT!!!_${port}_g"
155    
156     cp -a root/etc/e-smith/templates/etc/my.cnf/014server_system_variables root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-14server_system_variables
157     sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-14server_system_variables \
158     -e "s_mariadb_mariadb${ver}\-mariadb_"
159     cp -a root/etc/e-smith/templates/etc/my.cnf/015logerror root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-15logerror
160     sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-15logerror \
161     -e "s_^log\_error.*_log\_error=${logerror}_"
162    
163     ## /sbin/e-smith
164     mkdir -p root$ver/sbin/e-smith/systemd
165     #!!!VER!!!
166     cp rootscl/sbin/e-smith/systemd/mariadb_VER_-initialize root$ver/sbin/e-smith/systemd/mariadb${ver}-initialize
167     cp rootscl/sbin/e-smith/systemd/mariadb_VER_-mysql.init root$ver/sbin/e-smith/systemd/mariadb${ver}-mysql.init
168     cp rootscl/sbin/e-smith/mariadb_VER_-preload root$ver/sbin/e-smith/mariadb${ver}-preload
169     sed -i root$ver/sbin/e-smith/systemd/mariadb${ver}-initialize -i root$ver/sbin/e-smith/systemd/mariadb${ver}-mysql.init \
170     -i root$ver/sbin/e-smith/mariadb${ver}-preload \
171     -e "s_!!!VER!!!_${ver}_g" \
172 jpp 1.16 -e "s_!!!SOCKET!!!_${socket}_g"
173     if [ $ver -ge 104 ]
174     then
175     cp rootscl/sbin/e-smith/systemd/mariadb_VER_-post root$ver/sbin/e-smith/systemd/mariadb${ver}-post
176     sed -i root$ver/sbin/e-smith/systemd/mariadb${ver}-post -e "s_!!!VER!!!_${ver}_g" -e "s_!!!SOCKET!!!_${socket}_g"
177     fi
178    
179 jpp 1.1
180     ## logrotate
181     mkdir -p root$ver/etc/logrotate.d/
182 jpp 1.3 sed rootscl/etc/logrotate.d/mariadb_VER_ -e "s_!!!VER!!!_${ver}_g" \
183     -e "s_!!!SOCKET!!!_${socket}_g" > root$ver/etc/logrotate.d/mariadb${ver}
184 jpp 1.1
185    
186     #systemd service
187     mkdir -p root$ver/usr/lib/systemd/system/
188     ### the upstream service is called rh-mariadb$ver-mariadb.service
189     # we use our own /usr/lib/systemd/system/mariadb$ver-mariadb
190     cp rootscl/usr/lib/systemd/system/mariadb_VER_-mariadb.service root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service
191     cp rootscl/usr/lib/systemd/system/mariadb_VER_-mysql.init.service root$ver/usr/lib/systemd/system/mariadb${ver}-mysql.init.service
192     sed -i root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service -i root$ver/usr/lib/systemd/system/mariadb${ver}-mysql.init.service \
193     -e "s_!!!VER!!!_${ver}_g"
194 jpp 1.3 if [ $ver -ge 102 ]
195     then
196     sed -i root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service \
197 jpp 1.27 -e "s/_safe//" \
198     -e "s/^ExecStopPost.*//";
199 jpp 1.3 fi
200 jpp 1.12 if [ $ver -ge 104 ]
201     then
202     sed -i root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service \
203 jpp 1.16 -e 's_set.password$_set.password2_'
204     sed -i root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service \
205     -e "/^#ExecStartPost=/ i ExecStartPost=\/sbin\/e-smith\/systemd\/mariadb${ver}-post"
206    
207 jpp 1.12 fi
208 jpp 1.3
209 jpp 1.1 #### TODO check it is similar to rh one and functional !
210    
211 jpp 1.16 #/usr/bin to ease user
212 jpp 1.1 mkdir root$ver/usr/bin
213     for i in mysql mysqlshow mysqladmin mysqldump mysqlimport mysqlbinlog
214     do
215 jpp 1.11 echo "/opt/rh/rh-mariadb${ver}/root/usr/bin/$i --socket=/var/lib/mysql/mariadb${ver}.sock \"\$@\"" >root$ver/usr/bin/$i${ver}
216 jpp 1.1 done
217 jpp 1.4
218     #phpMyAdmin template
219 jpp 1.7 mkdir -p root$ver/etc/e-smith/templates/etc/phpMyAdmin/config.inc.php/
220 jpp 1.4 sed rootscl/etc/e-smith/templates/etc/phpMyAdmin/config.inc.php/11configMysql_VER_ \
221 jpp 1.15 -e "s_!!!SOCKET!!!_${socket}_g" \
222 jpp 1.6 -e "s_!!!VER!!!_${ver}_g" > root$ver/etc/e-smith/templates/etc/phpMyAdmin/config.inc.php/11configMysql${ver}
223 jpp 1.4
224 jpp 1.1 done
225    
226     ###################################################
227     # end of per version generation
228     ##################################################
229    
230    
231     %install
232     rm -rf $RPM_BUILD_ROOT
233     (cd root ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT)
234     /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \
235     --file "/sbin/e-smith/systemd/mariadb-initialize" 'attr(0554,root,root)' \
236     --file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \
237     --dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \
238     --dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \
239 jpp 1.30 --dir "/var/log/mysql.init" 'attr(0750,root,root)' \
240 jpp 1.1 > %{name}-%{version}-filelist
241     echo "%doc COPYING" >> %{name}-%{version}-filelist
242    
243     for ver in 101 102 103 105
244     do
245     #rm -rf $RPM_BUILD_ROOT
246     (cd root$ver ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT)
247     /sbin/e-smith/genfilelist root$ver/ \
248     --file "/sbin/e-smith/systemd/mariadb$ver-initialize" 'attr(0554,root,root)' \
249     --file "/sbin/e-smith/systemd/mariadb$ver-mysql.init" 'attr(0554,root,root)' \
250 jpp 1.18 --file "/sbin/e-smith/systemd/mariadb$ver-post" 'attr(0554,root,root)' \
251 jpp 1.1 --dir "/home/e-smith/db/mariadb$ver" 'attr(0750,root,root)' \
252     --dir "/var/log/mariadb$ver" 'attr(0750,mysql,mysql)' \
253 jpp 1.3 --file "/usr/bin/mysql$ver" 'attr(0554,root,root)' \
254     --file "/usr/bin/mysqladmin$ver" 'attr(0554,root,root)' \
255     --file "/usr/bin/mysqlbinlog$ver" 'attr(0554,root,root)' \
256     --file "/usr/bin/mysqldump$ver" 'attr(0554,root,root)' \
257     --file "/usr/bin/mysqlimport$ver" 'attr(0554,root,root)' \
258     --file "/usr/bin/mysqlshow$ver" 'attr(0554,root,root)' \
259 jpp 1.1 | grep -vE '/home/e-smith/db/mysql$' \
260     > %{name}-%{version}-filelist-mariadb$ver
261     echo "%doc COPYING" >> %{name}-%{version}-filelist-mariadb$ver
262     done
263    
264    
265     %clean
266     rm -rf $RPM_BUILD_ROOT
267    
268     %pre
269     if [ $1 -gt 1 ] ; then
270     if [ -e /var/service/mariadb/run ] ; then
271     /usr/bin/sv d mariadb
272     /usr/bin/sv d mariadb/log
273     fi
274     fi
275    
276     %post
277    
278     %postun
279    
280     %files -f %{name}-%{version}-filelist
281     %defattr(-,root,root)
282    
283     #----------------------------------------------------
284     %package -n smeserver-mariadb101
285     Summary: Koozali SME Server mariadb 10.1
286     Group: Database
287     Requires: rh-mariadb101
288     Requires: rh-mariadb101-mariadb
289     Requires: rh-mariadb101-mariadb-server
290     BuildRequires: e-smith-devtools >= 1.13.1-03
291    
292     %description -n smeserver-mariadb101
293     Koozali SME Server configuration package for mariadb101 RH SCLo
294    
295     %files -n smeserver-mariadb101 -f %{name}-%{version}-filelist-mariadb101
296     %defattr(-,root,root)
297    
298     #----------------------------------------------------
299     %package -n smeserver-mariadb102
300     Summary: Koozali SME Server mariadb 10.2
301     Group: Database
302     Requires: rh-mariadb102
303     Requires: rh-mariadb102-mariadb
304     Requires: rh-mariadb102-mariadb-server
305     BuildRequires: e-smith-devtools >= 1.13.1-03
306    
307     %description -n smeserver-mariadb102
308     Koozali SME Server configuration package for mariadb102 RH SCLo
309    
310     %files -n smeserver-mariadb102 -f %{name}-%{version}-filelist-mariadb102
311     %defattr(-,root,root)
312    
313     #----------------------------------------------------
314     %package -n smeserver-mariadb103
315     Summary: Koozali SME Server mariadb 10.3
316     Group: Database
317     Requires: rh-mariadb103
318     Requires: rh-mariadb103-mariadb
319     Requires: rh-mariadb103-mariadb-server
320 jpp 1.19 Requires: rh-mariadb103-mariadb-server-utils
321 jpp 1.1 BuildRequires: e-smith-devtools >= 1.13.1-03
322    
323     %description -n smeserver-mariadb103
324     Koozali SME Server configuration package for mariadb103 RH SCLo
325    
326     %files -n smeserver-mariadb103 -f %{name}-%{version}-filelist-mariadb103
327     %defattr(-,root,root)
328    
329     #----------------------------------------------------
330     %package -n smeserver-mariadb105
331     Summary: Koozali SME Server mariadb 10.5
332     Group: Database
333     Requires: rh-mariadb105
334     Requires: rh-mariadb105-mariadb
335     Requires: rh-mariadb105-mariadb-server
336 jpp 1.19 Requires: rh-mariadb105-mariadb-server-utils
337 jpp 1.1 BuildRequires: e-smith-devtools >= 1.13.1-03
338 jpp 1.13 Requires: smeserver-mysql >= 2.7.0-5
339 jpp 1.1 %description -n smeserver-mariadb105
340     Koozali SME Server configuration package for mariadb105 RH SCLo
341    
342     %files -n smeserver-mariadb105 -f %{name}-%{version}-filelist-mariadb105
343     %defattr(-,root,root)
344    
345    
346     #----------------------------------------------------
347    
348    
349     %changelog
350 jpp 1.30 * Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme
351     - use dedicated log file for *mysql.init [SME: 11953]
352    
353 jcrisp 1.28 * Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme
354 jcrisp 1.29 - Fix init for MariaDB 104+ [SME:11991]
355 jcrisp 1.28
356 jpp 1.27 * Sun Apr 10 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-14.sme
357     - /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936]
358    
359 jpp 1.25 * Sat Apr 09 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-13.sme
360     - fix few typos [SME: 11936]
361    
362 jpp 1.24 * Sat Apr 02 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-12.sme
363     - remove SourcePath from mysql-init service file [SME: 11922]
364    
365 jpp 1.23 * Wed Mar 16 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-11.sme
366     - fix mariadb*-mysql.init path in service file [SME: 11899]
367    
368 jpp 1.22 * Wed Mar 16 2022 Jean-Philipe Pialasse <tests@pialasse.com> 2.7.0-10.sme
369 jpp 1.21 - fix sclo metadata path for sql/init templated scripts [SME: 11899]
370    
371 jpp 1.20 * Wed Mar 16 2022 Jean-Philipe Pialasse <tests@pialasse.com> 2.7.0-8.sme
372     - missing sockets for backup of db [SME: 11899]
373    
374 jpp 1.19 * Mon Mar 14 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-7.sme
375     - adding requirement for mariadb-server-utils (105 and 103) [SME: 11899]
376    
377 jpp 1.16 * Mon Mar 14 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-6.sme
378 jpp 1.17 - fix password for mariadb 105 [SME: 11899]
379 jpp 1.16
380 jpp 1.11 * Sun Mar 13 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-5.sme
381 jpp 1.8 - fix typo in socket, seen with phpmyadmin [SME: 11899]
382 jpp 1.9 - fix permissions for mariadb105 [SME: 11899]
383 jpp 1.12 create a dedicated set.password for mariadb>103
384 jpp 1.8
385 jpp 1.4 * Sun Mar 13 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-3.sme
386 jpp 1.5 - missing phpMyAdmin fragments [SME: 11899]
387 jpp 1.4
388 jpp 1.3 * Sun Mar 13 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-2.sme
389     - fix few sclo issues [SME: 11899]
390     missing +x for binaries shortcut
391     mariadb105 passwordless root access
392     mysqld_safe-scl-helper vs mysqld-scl-helper
393    
394 jpp 1.1 * Fri Mar 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-1.sme
395     - prepare spec for multiple version support [SME: 11899]
396     - package renamed from e-smith-mysql to smeserver-mysql [SME: 11897]
397     - remove duplicate logrotate and remove unsused template [SME: 11467]
398     - move scripts /etc/rc.d/init.d/mysql-init to /sbin/e-smith/systemd [SME: 11898]
399 jpp 1.2 - add rh-mariadb101 support [SME: 11901]
400     - add rh-mariadb102 support [SME: 11902]
401     - add rh-mariadb103 support [SME: 11903]
402     - add rh-mariadb105 support [SME: 11904]
403 jpp 1.1
404     * Tue Aug 17 2021 John Crisp <jcrisp@safeandsoundit.co.uk> 2.6.0-22.sme
405     - Remove template and set default max_allowed_packet=16M
406    
407     * Thu Mar 18 2021 Jean-Philippe Pialasse <tests@pialasse.com> 2.6.0-21.sme
408     - fix wrong path for set password [SME: 11468]
409    
410     * Sat Mar 13 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-20.sme
411     - fix restore of sme9 backup fails to start mysql.init [SME: 11453]
412    
413     * Thu Mar 04 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-19.sme
414     - add property to enable mysqld slow queries log [SME: 455]
415     simply use SlowQueries as the amount of second and it is enabled
416     remove property to stop logging
417     - more mysqld/mariadb parameter available with properties /templates [SME: 4606]
418     - ease 4 databit characters with innodb [SME: 11404]
419     - redirect mariadb log from systemd to file [SME: 11425]
420    
421     * Wed Jan 27 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-18.sme
422     - fix backup fails in pre-backup in mysqldump [SME: 7827]
423    
424     * Sun Dec 13 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-17.sme
425     - expand 10mysql_upgrade and restart mysql.init on e-smith-mysql-update [SME: 11120]
426     this to make sure mariadb upgrade fully and prevent residual 10mysql_upgrade stay in the way
427    
428     * Wed Dec 09 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-16.sme
429     - fix issue with 10mysql_upgrade crashing mariadb [SME: 11120]
430     also removed noise from spec file
431    
432     * Mon Dec 07 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-15.sme
433     - e-smith-update event [SME: 11145]
434     - mariadb systemd integration [SME: 11021]
435     move set.password and template
436     create /usr/lib/systemd/system/mariadb.service.d/sme.conf
437     create /sbin/e-smith/systemd/mariadb-initialize + chmod
438     cleanup and remove old /var/service/mariadb
439     - mysql.init systemd integration [SME: 11120]
440     create mysql_init.service
441    
442    
443     * Sun Jul 24 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-13.sme
444     - systemd skip redirect [SME: 9688]
445    
446     * Sat Jul 23 2016 stephane de Labrusse <stephdl@de-labrusse.fr> 2.6.0-12.sme
447     - Corrected a typo in e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch
448     - [SME: 9671]
449    
450     * Thu Jul 21 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-11.sme
451     - fix broken link /etc/init.d/supervise/mariadb [SME: 9686]
452    
453     * Mon Jul 18 2016 stephane de Labrusse <stephdl@de-labrusse.fr> 2.6.0-10.sme
454     - Remove Dummy database from backup and restoration [SME: 9671]
455     - Added e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch
456    
457     * Mon Jul 18 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-8.sme
458     - fix forgotten mysqld variables in various scripts [SME: 9438]
459     - e-smith-mysql-2.6.0-mariadb_forgotten_var.patch
460    
461     * Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-7.sme
462     - Use default InnoDB settings [SME: 9439]
463    
464     * Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-6.sme
465     - Rename mysqld to mariadb [SME: 9438]
466    
467     * Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-5.sme
468     - Remove uneeded scriplets %post and %postun [SME: 9422]
469    
470     * Thu Mar 31 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-4.sme
471     - new path for pid file with mariadb [SME: 9407]
472     - my.cnf : Innodb needs to be active for mariadb [SME: 9406]
473    
474     * Fri Mar 18 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-2.sme
475     - fix mysql-server not found [SME: 9345]
476     - now using mariadb-server and mariadb
477     - Eliminated rpmbuild "bogus date" warnings due to inconsistent weekday,
478     by assuming the date is correct and changing the weekday.
479     Wed Mar 23 2001 --> Wed Mar 21 2001 or Fri Mar 23 2001 or Wed Mar 28 2001 or ....
480    
481     * Fri Feb 05 2016 stephane de Labrusse <stephdl@de-labrusse.fr> 2.6.0-1.sme
482     - Initial release to sme10
483    
484     * Sat Apr 26 2014 Ian Wells <esmith@wellsi.com> 2.4.0-9.sme
485     - Move mysql logging to multilog [SME: 8358]
486    
487     * Mon Apr 14 2014 Ian Wells <esmith@wellsi.com> 2.4.0-8.sme
488     - Remove the information_schema [SME: 8325]
489    
490     * Mon Mar 17 2014 Ian Wells <esmith@wellsi.com> 2.4.0-7.sme
491     - Use mysql_upgrade in 00_restore_dumped_dbs, by Terje Edseth [SME: 8166]
492     - Rename 10fix_privilege_tables to 10mysql_upgrade to reduce confusion.
493    
494     * Sun Feb 2 2014 Ian Wells <esmith@wellsi.com> 2.4.0-6.sme
495     - Use mysql_upgrade --force due to upgrade to MySQL 5.1 [SME: 8166]
496    
497     * Thu Jun 6 2013 Daniel Berteaud <daniel@firewall-services.com> 2.4.0-5.sme
498     - Ignore mysql.event table [SME: 7603]
499    
500     * Wed Mar 20 2013 Ian Wells <esmith@wellsi.com> 2.4.0-4.sme
501     - Use --single-transaction in mysql-dump-tables [SME: 7497]
502    
503     * Sat Mar 16 2013 Ian Wells <esmith@wellsi.com> 2.4.0-3.sme
504     - Use mysql_upgrade instead of fix_privilege_tables [SME: 7467]
505    
506     * Mon Feb 18 2013 Daniel Berteaud <daniel@firewall-services.com> 2.4.0-2.sme
507     - Remove obsolete innodb_log_arch_dir directive [SME: 7363]
508    
509     * Wed Feb 13 2013 Shad L. Lords <slords@mail.com> 2.4.0-1.sme
510     - Roll new stream for sme9
511    
512     * Tue Mar 1 2011 Jonathan Martens <smeserver-contribs@snetram.nl> 2.2.0-6.sme
513     - Cater for open_files_limit option my.cnf through database and template [SME: 6438]
514    
515     * Thu Oct 28 2010 Shad L. Lords <slords@mail.com> 2.2.0-5.sme
516     - Fix stripping of starting numbers from script [SME: 6316]
517    
518     * Mon Jun 7 2010 Filippo Carletti <filippo.carletti@gmail.com> 2.2.0-4.sme
519     - Fix %postun typo [SME: 6030]
520    
521     * Mon Feb 23 2009 Jonathan Martens <smeserver-contribs@snetram.nl> 2.2.0-3.sme
522     - Rework log-error logic [SME: 4807]
523    
524     * Tue Dec 2 2008 Jonathan Martens <smeserver-contribs@snetram.nl> 2.2.0-2.sme
525     - Fix log-error detection algorithm [SME: 4807]
526    
527     * Tue Oct 7 2008 Shad L. Lords <slords@mail.com> 2.2.0-1.sme
528     - Roll new stream to separate sme7/sme8 trees [SME: 4633]
529    
530     * Mon Oct 06 2008 Charlie Brady <charlie_brady@mitel.com> 1.13.0-2
531     - Capture mysql.init error logs to syslog. [SME: 2918]
532    
533     * Mon Oct 6 2008 Stephen Noble <support@dungog.net> 1.13.0-1
534     - Roll new dev stream [SME: 4627]
535    
536     * Wed Jan 09 2008 Stephen Noble <support@dungog.net> 1.12.0-15
537     - quote "$1" in post uninstall script [SME: 349]
538    
539     * Sun Apr 29 2007 Shad L. Lords <slords@mail.com>
540     - Clean up spec so package can be built by koji/plague
541    
542     * Sat Apr 21 2007 Shad L. Lords <slords@mail.com> 1.12.0-14
543     - Force upgrade script to run even with errors. [SME: 2530]
544    
545     * Mon Apr 9 2007 Stephen Noble <Support@dungog.net> 1.12.0-13
546     - Add db settings to max_allowed_packet in my.cnf [SME: 2149]
547    
548     * Mon Apr 9 2007 Stephen Noble <Support@dungog.net> 1.12.0-12
549     - Add to my.cnf [SME: 2149]
550    
551     * Thu Jan 11 2007 Shad L. Lords <slords@mail.com> 1.12.0-11
552     - Move user to mysql section. [SME: 1474]
553    
554     * Wed Dec 27 2006 Shad L. Lords <slords@mail.com> 1.12.0-10
555     - Split backups out by database name [SME: 1677]
556    
557     * Thu Dec 07 2006 Shad L. Lords <slords@mail.com>
558     - Update to new release naming. No functional changes.
559     - Make Packager generic
560    
561     * Thu Nov 9 2006 Charlie Brady <charlie_brady@mitel.com> 1.12.0-08
562     - Ensure that failed restore is detected during mysql.init. [SME: 1652]
563    
564     * Mon Sep 25 2006 Charlie Brady <charlie_brady@mitel.com> 1.12.0-07
565     - Fix pre-backup failure if mysqld is disabled in config db. [SME: 1937]
566    
567     * Tue Jun 27 2006 Filippo Carletti <carletti@mobilia.it> 1.12.0-06
568     - Execute mysql_install_db using sh [SME: 1654]
569    
570     * Sun Apr 30 2006 Charlie Brady <charlie_brady@mitel.com> 1.12.0-05
571     - Make innodb optional, and configure it as recommended, if enabled.
572     [SME: 1013]
573    
574     * Tue Apr 18 2006 Gordon Rowell <gordonr@gormand.com.au> 1.12.0-04
575     - Add missing semi-colon to FLUSH PRIVILEGES statement [SME: 1229]
576    
577     * Mon Apr 10 2006 Gordon Rowell <gordonr@gormand.com.au> 1.12.0-03
578     - Revise last patch - it backed out the db restore [SME: 1229]
579    
580     * Mon Apr 10 2006 Gordon Rowell <gordonr@gormand.com.au> 1.12.0-02
581     - Move expansion of user table into set.password so it works
582     for command line runs as well as db restores [SME: 1229]
583    
584     * Thu Mar 16 2006 Gordon Rowell <gordonr@gormand.com.au> 1.12.0-01
585     - Roll stable stream version. [SME: 1016]
586    
587     * Mon Feb 13 2006 Charlie Brady <charlie_brady@mitel.com> 1.11.1-16
588     - Update dependencies to include mysql-server RPM. Remove obsolete
589     dependency on e-smith-packetfilter. [SME: 737]
590    
591     * Fri Jan 6 2006 Gordon Rowell <gordonr@gormand.com.au> 1.11.1-15
592     - Remove explicit permission setting for /home/e-smith/db from
593     genfilelist call [SME: 371]
594    
595     * Sun Jan 1 2006 Charlie Brady <charlieb@e-smith.com> 1.11.1-14
596     - Ensure that mysql is restarted after restore, and avoid race conditions
597     during mysqld restart during fix_privilege_tables. [SME: 73]
598     - Remove unnecessary mkdirs in build section - they're done by createlinks
599     script.
600    
601     * Wed Dec 14 2005 Gordon Rowell <gordonr@gormand.com.au> 1.11.1-13
602     - Call fix_privilege_tables much earlier and call mysqladmin shutdown
603     after doing so - Thanks Paul Floor [SME: 73]
604    
605     * Wed Nov 30 2005 Gordon Rowell <gordonr@gormand.com.au> 1.11.1-12
606     - Call mysql fix_privilege_tables in mysql.init [SME: 73]
607    
608     * Wed Nov 30 2005 Gordon Rowell <gordonr@gormand.com.au> 1.11.1-11
609     - Bump release number only
610    
611     * Tue Nov 15 2005 Gordon Rowell <gordonr@e-smith.com>
612     - [1.11.1-10]
613     - Reset the format of the MySQL root password for old dumps [SF: 1325378]
614    
615     * Wed Aug 31 2005 Charlie Brady <charlieb@e-smith.com>
616     - [1.11.1-09]
617     - Avoid error from db-delete action if db files are not present
618     (e.g. because they have already been deleted). [SF: 1273797]
619    
620     * Mon Aug 29 2005 Charlie Brady <charlieb@e-smith.com>
621     - [1.11.1-08]
622     - Fix restore of dumped tables after restore from backup.
623     Reset root password after restore of dumped dbs. [SF: 1273797]
624    
625     * Thu Jun 16 2005 Charlie Brady <charlieb@e-smith.com>
626     - [1.11.1-07]
627     - Ensure that 'status' property of mysql.init is honoured at
628     startup. [MN00061795]
629    
630     * Tue Jun 14 2005 Charlie Brady <charlieb@e-smith.com>
631     - [1.11.1-06]
632     - Work around race condition between mysql startup and
633     mysql.init. [SF: 1217966]
634    
635     * Fri Apr 29 2005 Charlie Brady <charlieb@e-smith.com>
636     - [1.11.1-05]
637     - Use -f flag in mysql-delete-dumped-tables so that backup
638     doesn't fail if the file is missing.
639    
640     * Fri Apr 15 2005 Charlie Brady <charlieb@e-smith.com>
641     - [1.11.1-04]
642     - Change /root/.my.cnf template to use esmith::util::LdapPassword
643     rather than read of ldap.pw file, to eliminate ordering
644     depenendence on ldap.pw template expansion.
645    
646     * Fri Apr 15 2005 Charlie Brady <charlieb@e-smith.com>
647     - [1.11.1-03]
648     - Restore old mysql.init behaviour, to leave any failed scripts
649     behind for a later attempt, or for admin investigation. [MN00079643]
650    
651     * Wed Apr 13 2005 Charlie Brady <charlieb@e-smith.com>
652     - [1.11.1-02]
653     - Fix up import of tables after a restore. Remove a few bogus
654     symlinks.
655    
656     * Wed Apr 13 2005 Charlie Brady <charlieb@e-smith.com>
657     - [1.11.1-01]
658     - Roll new development stream - 1.11.1
659    
660     * Mon Apr 11 2005 Charlie Brady <charlieb@e-smith.com>
661     - [1.11.0-16]
662     - Fix typo and runtime error in run script. Detect table dump
663     to be restored and set it up for mysql.init to restore it.
664    
665     * Sun Apr 10 2005 Charlie Brady <charlieb@e-smith.com>
666     - [1.11.0-15]
667     - Remove trap stuff in run script (which works around mysqld brokenness)
668     and add custom control/{t,q,d,i} scripts.
669    
670     * Sun Apr 10 2005 Charlie Brady <charlieb@e-smith.com>
671     - [1.11.0-14]
672     - Remove obsolete e-smith-packetfilter Requires: header.
673     - Do db initialisation in run script, as required, rather than via
674     special action script.
675     - Replace all restart-, start- and reload- actions with calls to
676     'adjust-services'. Update e-smith-lib version dependency. [MN00065576]
677     - Use generic_template_expand action where possible, in place
678     of specific actions. Update e-smith-lib dependency. [MN00064130]
679    
680     * Wed Dec 29 2004 Charlie Brady <charlieb@e-smith.com>
681     - [1.11.0-13]
682     - Fix permissions on log/run script. Add missing /var/log/mysqld dir.
683     [charlieb MN00061220]
684    
685     * Wed Dec 29 2004 Charlie Brady <charlieb@e-smith.com>
686     - [1.11.0-12]
687     - Add missing down file in service directory.. Fix permissions
688     on run script. [charlieb MN00061220]
689    
690     * Tue Dec 28 2004 Charlie Brady <charlieb@e-smith.com>
691     - [1.11.0-11]
692     - Add missing /service/mysqld symlink [charlieb MN00061220]
693    
694     * Mon Dec 20 2004 Charlie Brady <charlieb@e-smith.com>
695     - [1.11.0-10]
696     - Run mysqld under supervise. [charlieb MN00061220]
697     - Replace deprecated Copyright header with License. [charlieb]
698    
699     * Tue Jan 6 2004 Michael Soulier <msoulier@e-smith.com>
700     - [1.11.0-09]
701     - Added restart to valid arguments to mysql.init. [msoulier 10866]
702    
703     * Tue Jan 6 2004 Michael Soulier <msoulier@e-smith.com>
704     - [1.11.0-08]
705     - Fixed mysql.init leaving behind failed scripts, and the lack of proper
706     initscript command-line arguments. [msoulier 10866]
707    
708     * Wed Dec 24 2003 Tony Clayton <apc@e-smith.com>
709     - [1.11.0-07]
710     - Updating comments in my.cnf [tonyc 10862]
711     - Don't show redundant log-error option in mysqld_safe [tonyc 10862]
712    
713     * Mon Dec 22 2003 Tony Clayton <apc@e-smith.com>
714     - [1.11.0-06]
715     - fixing initscript symlink [tonyc 10862]
716    
717     * Mon Dec 22 2003 Tony Clayton <apc@e-smith.com>
718     - [1.11.0-05]
719     - Add /var/run/mysqld dir for mysql.com compatibility [tonyc 10862]
720     - Fix initscript symlink [tonyc 10862]
721    
722     * Mon Dec 22 2003 Tony Clayton <apc@e-smith.com>
723     - [1.11.0-04]
724     - Add initscript symlink for mysql.com compatibility [tonyc 10862]
725     - Adding /etc/logrotate.d/mysqld templates [tonyc 8662]
726    
727     * Thu Dec 18 2003 Tony Clayton <apc@e-smith.com>
728     - [1.11.0-03]
729     - Clean up /etc/my.cnf templates and add comments [tonyc 10862]
730     - Add a more --user=mysql options to actions for 100% coverage [tonyc 10862]
731     - Remove redundant basedir/datadir options from actions [tonyc 10862]
732     - Clean up mysql-preload fork/exec stuff [tonyc 10862]
733    
734     * Tue Dec 16 2003 Tony Clayton <apc@e-smith.com>
735     - [1.11.0-02]
736     - Add --user=mysql to mysqld args in conf-mysql-password [tonyc 10853]
737     - Future-proof /etc/my.cnf for s/safe_mysqld/mysqld_safe/ change [tonyc 8662]
738    
739     * Tue Dec 16 2003 Tony Clayton <apc@e-smith.com>
740     - [1.11.0-01]
741     - Changing version to development stream number - 1.11.0
742    
743     * Thu Jun 26 2003 Charlie Brady <charlieb@e-smith.com>
744     - [1.10.0-01]
745     - Changing version to stable stream number - 1.10.0
746    
747     * Wed Apr 23 2003 Charlie Brady <charlieb@e-smith.com>
748     - [1.9.0-03]
749     - Remove stray " in mysql-dump-tables. [charlieb 8475]
750    
751     * Tue Apr 1 2003 Charlie Brady <charlieb@e-smith.com>
752     - [1.9.0-02]
753     - Restrict mysql by default to use only unix domain socket. [charlieb 6430]
754     - Change mysql dump in pre-backup to use quotes, to fix backup/restore problem.
755     [charlieb 7953]
756     - Remove conf-mysql-startup - use db initialisation fragments instead
757     [charlieb 5665]
758    
759     * Tue Apr 1 2003 Charlie Brady <charlieb@e-smith.com>
760     - [1.9.0-01]
761     - Roll development version to 1.9.0
762    
763     * Mon Mar 17 2003 Lijie Deng <lijied@e-smith.com>
764     - [1.8.0-03]
765     - Deleted template-begin/end file [lijied 3295]
766    
767     * Thu Jan 23 2003 Charlie Brady <charlieb@e-smith.com>
768     - [1.8.0-02]
769     - Fix typo in mysql-restart action script (mysql => mysqld). [charlieb 4774]
770    
771     * Fri Oct 11 2002 Charlie Brady <charlieb@e-smith.com>
772     - [1.8.0-01]
773     - Rolling stable version number to 1.8.0
774    
775     * Fri Oct 11 2002 Charlie Brady <charlieb@e-smith.com>
776     - [1.8.0-01]
777     - Rolling stable version number to 1.8.0
778    
779     * Wed Sep 25 2002 Charlie Brady <charlieb@e-smith.com>
780     - [1.7.4-10]
781     - Reverse the recent logic change in mysql.init, now that action() function
782     in /etc/rc.d/init.d/functions is repaired. Replace deprecated use
783     of backticks. [charlieb 4728]
784    
785     * Mon Sep 23 2002 Charlie Brady <charlieb@e-smith.com>
786     - [1.7.4-09]
787     - Actually expand /etc/my.cnf template - that's what it's for! [charlieb 4731]
788    
789     * Mon Sep 23 2002 Charlie Brady <charlieb@e-smith.com>
790     - [1.7.4-08]
791     - Fix logic problem in mysql.init [charlieb 4728]
792    
793     * Tue Sep 10 2002 Charlie Brady <charlieb@e-smith.com>
794     - [1.7.4-07]
795     - Add fragment to my.cnf template to disable (for now) innoDB tables, and
796     hence prevent log file noise. [charlieb 4731]
797    
798     * Mon Sep 9 2002 Charlie Brady <charlieb@e-smith.com>
799     - [1.7.4-06]
800     - Update mysql-restart action and link into timezone-update event
801     [charlieb 4774]
802    
803     * Mon Sep 9 2002 Charlie Brady <charlieb@e-smith.com>
804     - [1.7.4-05]
805     - Set $HOME in mysql.init script itself, otherwise it's not set when
806     run from the rc run script. Fix filenames displayed in progress message.
807     [charlieb 4782]
808     - Remove redundant mysql.conf action script [charlieb 4782]
809    
810     * Fri Sep 6 2002 Charlie Brady <charlieb@e-smith.com>
811     - [1.7.4-04]
812     - Create newly required email-update event directory. [charlieb 4782]
813    
814     * Fri Sep 6 2002 Charlie Brady <charlieb@e-smith.com>
815     - [1.7.4-03]
816     - Change mysql-dump-tables and mysql-delete-dumps events to pre-backup and
817     post-backup events. [charlieb 2745]
818     - Add mysql-start-if-required action, which checks if mysqld is running,
819     and start it, then runs mysql.init, if not. Linked into email-update event.
820     [charlieb 4782]
821     - Redo conf-mysql-startup using ConfigDB and remove no longer necessary
822     serviceControl() calls. [charlieb 4782]
823     - Redo mysql-conf using esmith::templates. [charlieb 4782]
824     - Change mysql.init script so that it can run programs or just load sql.
825     [charlieb 4782]
826    
827     * Wed Aug 28 2002 Charlie Brady <charlieb@e-smith.com>
828     - [1.7.4-02]
829     - Create missing /etc/e-smith/sql/init directory [charlieb 4333]
830    
831     * Thu Aug 22 2002 Charlie Brady <charlieb@e-smith.com>
832     - [1.7.4-01]
833     - Remove 45DenyMySQL template fragment - it's no longer needed since we
834     are using connection tracking. [charlieb 4499]
835    
836     * Tue Aug 20 2002 Charlie Brady <charlieb@e-smith.com>
837     - [1.7.3-01]
838     - Add rc7.d symlinks and don't set obsolete InitscriptsOrder property
839     of services. [charlieb 4458]
840    
841     * Wed Jul 17 2002 Charlie Brady <charlieb@e-smith.com>
842     - [1.7.2-01]
843     - Change masq script fragment to use iptables. [charlieb 1268]
844    
845     * Wed Jun 5 2002 Charlie Brady <charlieb@e-smith.com>
846     - [1.7.1-01]
847     - Test build to verify CVS conversion
848    
849     * Wed Jun 5 2002 Charlie Brady <charlieb@e-smith.com>
850     - [1.7.0-01]
851     - rollRPM: Rolled version number to 1.7.0-01. Includes patches up to 1.6.0-01.
852    
853     * Tue Dec 11 2001 Jason Miller <jay@e-smith.com>
854     - [1.6.0-01]
855     - rollRPM: Rolled version number to 1.6.0-01. Includes patches up to 1.5.0-03.
856    
857     * Thu Dec 6 2001 Adrian Chung <adrianc@e-smith.com>
858     - [1.5.0-03]
859     - Adding more verbose error messages to mysql-dump-tables.
860     - It should exit 0 if an error occurs, it should exit 1, and complain.
861    
862     * Wed Oct 31 2001 Adrian Chung <adrianc@e-smith.com>
863     - [1.5.0-02]
864     - mysql-restart now restarts mysql if it is running, rather
865     than only starting it if it is stopped.
866     - mysql-shutdown has been added
867     - conf-mysql is now mysql-initialize-db
868     - new template /etc/my.cnf added
869     - new action mysql-conf which expands /etc/my.cnf linked to
870     bootstrap-console-save
871    
872     * Mon Oct 29 2001 Adrian Chung <mac@e-smith.com>
873     - [1.5.0-01]
874     - Rolled version number to 1.5.0-01. Includes patches upto 1.4.0-03.
875     - Removed directive to remove post-restore event.
876    
877     * Tue Aug 28 2001 Gordon Rowell <gordonr@e-smith.com>
878     - [1.4.0-03]
879     - Removed deprecated post-restore event directory
880    
881     * Fri Aug 17 2001 gordonr
882     - [1.4.0-02]
883     - Autorebuild by rebuildRPM
884    
885     * Wed Aug 8 2001 Charlie Brady <charlieb@e-smith.com>
886     - [1.4.0-01]
887     - Rolled version number to 1.4.0-01. Includes patches upto 1.3.0-18.
888    
889     * Wed Aug 08 2001 Tony Clayton <tonyc@e-smith.com>
890     - [1.3.0-18]
891     - force mysql.init to sort files in init directory
892    
893     * Tue Aug 7 2001 Charlie Brady <charlieb@e-smith.com>
894     - [1.3.0-17]
895     - Fix uninitialised variable problem in masq fragment.
896    
897     * Wed Jul 04 2001 Gordon Rowell <gordonr@e-smith.com>
898     - [1.3.0-16]
899     - Added use esmith::util to mysql-dump-tables
900    
901     * Wed Jul 04 2001 Gordon Rowell <gordonr@e-smith.com>
902     - [1.3.0-15]
903     - Use esmith::util::LdapPassword rather than direct file read
904    
905     * Tue May 29 2001 Tony Clayton <tonyc@e-smith.com>
906     - [1.3.0-14]
907     - fixed actions that had tied %conf when calling serviceControl (2 actions)
908    
909     * Sat Apr 07 2001 Gordon Rowell <gordonr@e-smith.com>
910     - [1.3.0-13]
911     - Forward port patches from 1.2.0-05 to 1.2.0-08
912    
913     * Fri Apr 06 2001 Tony Clayton <tonyc@e-smith.com>
914     - [1.2.0-08]
915     - fixed mkdir calls in mysql-delete-dumped-tables (arguments in wrong order)
916    
917     * Thu Apr 05 2001 Tony Clayton <tonyc@e-smith.com>
918     - [1.3.0-12]
919     - force mysql.init to print to stderr instead of stout
920    
921     * Fri Mar 23 2001 Tony Clayton <tonyc@e-smith.com>
922     Wed Mar 23 2001 --> Wed Mar 21 2001 or Fri Mar 23 2001 or Wed Mar 28 2001 or ....
923     - [1.3.0-11]
924     - fixed uninitialized value error in conf-mysql-startup
925    
926     * Wed Mar 21 2001 Tony Clayton <tonyc@e-smith.com>
927     - [1.3.0-10]
928     - fixed error on empty glob in mysql.init
929    
930     * Wed Mar 21 2001 Tony Clayton <tonyc@e-smith.com>
931     - [1.3.0-09]
932     - fixed harmless errors thrown by mysql.init
933    
934     * Wed Mar 21 2001 Tony Clayton <tonyc@e-smith.com>
935     - [1.3.0-08]
936     - fixed tie bug in conf-mysql-startup script which prevented the mysqld service
937     from being initialized properly.
938    
939     * Thu Mar 15 2001 Tony Clayton <tonyc@e-smith.com>
940     - [1.3.0-07]
941     - created mysql.init initscript
942     - added serviceControl code for mysql.init in conf-mysql-startup
943    
944     * Sat Mar 10 2001 Tony Clayton <tonyc@e-smith.com>
945     - [1.3.0-06]
946     - fixed mysql call in /sbin/e-smith/mysql-preload
947    
948     * Sat Mar 10 2001 Tony Clayton <tonyc@e-smith.com>
949     - [1.3.0-05]
950     - fixed bugs in /sbin/e-smith/mysql-preload
951    
952     * Fri Mar 9 2001 Adrian Chung <adrianc@e-smith.com>
953     - [1.3.0-04]
954     - added /sbin/e-smith/mysql-preload
955    
956     * Sat Mar 3 2001 Charlie Brady <charlieb@e-smith.com>
957     - [1.2.0-07]
958     - add packetfilter template fragment to deny tcp/3306
959     Make packet filter fragment depend on the service db. Only block
960     TCP SYN packets.
961     - add Requires for e-smith-packetfilter.
962     - Add required permissions parameter to mkdir calls.
963    
964     * Thu Mar 1 2001 Charlie Brady <charlieb@e-smith.com>
965     - [1.3.0-03]
966     - Make packet filter fragment depend on the service db. Only block
967     TCP SYN packets.
968     - Add required permissions parameter to mkdir calls.
969    
970     * Thu Mar 1 2001 Adrian Chung <adrianc@e-smith.com>
971     - [1.3.0-02]
972     - add packetfilter template fragment to deny tcp/3306
973     - add Requires for e-smith-packetfilter.
974    
975     * Thu Mar 1 2001 Adrian Chung <adrianc@e-smith.com>
976     - [1.3.0-01]
977     - Development stream, includes all patches up to and including
978     1.2.0-05.
979     - Ported Charlie's MySQL->mysql requires change to development
980     stream. Was 1.2.0-06, but not built.
981    
982     * Fri Feb 16 2001 Adrian Chung <adrianc@e-smith.com>
983     - [1.2.0-05]
984     - changed -C option to useradd to a -c for comments.
985    
986     * Thu Feb 8 2001 Adrian Chung <adrianc@e-smith.com>
987     - Rolling release number for GPG signing.
988    
989     * Thu Jan 25 2001 Adrian Chung <adrianc@e-smith.com>
990     - [1.2.0-03]
991     - changed conf-mysql-account to 08 instead of 05.
992    
993     * Thu Jan 25 2001 Adrian Chung <adrianc@e-smith.com>
994     - [1.2.0-02]
995     - remove rc0.d/rc6.d symlinks and replace with links to
996     e-smith-service instead.
997    
998     * Thu Jan 25 2001 Peter Samuel <peters@e-smith.com>
999     - [1.2.0-01]
1000     - Rolled version number to 1.2.0-01. Includes patches upto 1.1.0-31.
1001    
1002     * Thu Jan 25 2001 Adrian Chung <adrianc@e-smith.com>
1003     - [1.1.0-31]
1004     - take expansion of logrotate.d/mysqld template out
1005     of conf-mysqld
1006    
1007     * Wed Jan 24 2001 Adrian Chung <adrianc@e-smith.com>
1008     - [1.1.0-30]
1009     - leave logrotate.d/mysqld alone now, back out patch
1010     - expanding /root/.my.cnf with the password alleviates
1011     need to pass -p to mysqladmin
1012    
1013     * Wed Jan 24 2001 Adrian Chung <adrianc@e-smith.com>
1014     - [1.1.0-29]
1015     - expand logrotate.d/mysqld template
1016     - add template directory for logrotate.d/mysqld
1017    
1018     * Wed Jan 24 2001 Charlie Brady <charlieb@e-smith.com>
1019     - [1.1.0-28]
1020     - Create new mysql-conf-account script - set up mysql account and add it
1021     to the accounts db. Called from post-install and post-upgrade
1022    
1023     * Wed Jan 17 2001 Adrian Chung <adrianc@e-smith.com>
1024     - [1.1.0-27]
1025     - default mysql to enabled
1026    
1027     * Wed Jan 17 2001 Peter Samuel <peters@e-smith.com>
1028     - [1.1.0-26]
1029     - added mysql-delete-dumped-tables action to post-upgrade event
1030    
1031     * Wed Jan 17 2001 Peter Samuel <peters@e-smith.com>
1032     - [1.1.0-25]
1033     - mysql-dump-tables and mysql-import-tables actions do nothing if mysqld
1034     is not running.
1035     - mysql-dump-tables action does nothing if the dump directory does
1036     not exist.
1037     - mysql-import-tables action does nothing if there is no dump file from
1038     which to import.
1039     - created 2 new events - mysql-delete-dumps and mysql-dump-tables
1040     - removed mysql-import-tables action from post-restore
1041     - added mysql-import-tables action to post-upgrade
1042     - created new action mysql-delete-dumped-tables
1043     - added patch22 to list of patches to be applied - must have been
1044     missed in 1.1.0-24.
1045    
1046     * Sat Jan 13 2001 Adrian Chung <adrianc@e-smith.com>
1047     - [1.1.0-24]
1048     - typo $action => restart
1049    
1050     * Sat Jan 13 2001 Adrian Chung <adrianc@e-smith.com>
1051     - [1.1.0-23]
1052     - mysql-{import,dump}-tables checks for enabled status of mysqld
1053     before attempting to dump/import
1054    
1055     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1056     - [1.1.0-22]
1057     - changed "Couldn't $action mysqld" to "Couldn't restart mysqld".
1058    
1059     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1060     - [1.1.0-21]
1061     - $ in front of ENV{'PATH'}
1062    
1063     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1064     - [1.1.0-20]
1065     - add PATH setting to conf-mysql
1066    
1067     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1068     - [1.1.0-19]
1069     - get rid of --no-defaults
1070    
1071     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1072     - [1.1.0-18]
1073     - --force mysql_install_db
1074    
1075     * Fri Jan 12 2001 Tony Clayton <tonyc@e-smith.com>
1076     - [1.1.0-17]
1077     - converted to using serviceControl
1078    
1079     * Fri Jan 12 2001 Adrian Chung <adrianc@e-smith.com>
1080     - [1.1.0-16]
1081     - conf-mysql needs to run even if the service isn't enabled
1082     so that during runtime, it can be enabled, and just go.
1083    
1084     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1085     - [1.1.0-15]
1086     - datadir check should be /var/lib/mysql/mysql.
1087    
1088     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1089     - [1.1.0-14]
1090     - conf-mysql-password checks for MySQL datadir first
1091     - mysql-{dump,import}-tables moved to
1092     /etc/e-smith/events/actions
1093     - mysql-import-tables added to post-restore action
1094    
1095     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1096     - [1.1.0-13]
1097     - conf-mysql-password resets the root password, and
1098     gets rid of two blank account entries
1099     - /sbin/e-smith/mysql-dump-tables has been added
1100     which dumps mysql.dump to /home/e-smith/db/mysql
1101     - /sbin/e-smith/mysql-import-tables has been added
1102     which imports a mysql.dump text file back into a
1103     running system
1104    
1105     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1106     - [1.1.0-12]
1107     - conf-mysql-password now runs in console-save as well.
1108     - if the system is started up without mysqld enabled,
1109     a password won't be set, since there are no mysql tables
1110     initialized yet.
1111    
1112     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1113     - [1.1.0-11]
1114     - conf-mysql-password runs without checking whether mysql
1115     is enabled. It does not require mysqld to be started, and
1116     should always at least keep the root password in sync, in
1117     case mysqld is enabled, and started during a running system
1118     session.
1119    
1120     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1121     - [1.1.0-10]
1122     - add mysql-conf-startup to post-install/upgrade.
1123    
1124     * Thu Jan 11 2001 Adrian Chung <adrianc@e-smith.com>
1125     - [1.1.0-9]
1126     - make conf-mysql-password set the mysql password, instead of
1127     setting up a once-run script.
1128    
1129     * Wed Jan 10 2001 Charlie Brady <charlieb@e-smith.com>
1130     - [1.1.0-8]
1131     - Create new mysql-conf-startup script - split from mysql-conf
1132     - Create new bootstrap-console-save event and install mysql-conf into it
1133    
1134     * Mon Dec 18 2000 Adrian Chung <adrianc@e-smith.com>
1135     - [1.1.0-7]
1136     - added configuration database to db command.(typo).
1137    
1138     * Mon Dec 18 2000 Adrian Chung <adrianc@e-smith.com>
1139     - [1.1.0-6]
1140     - added UnsavedChanges wrapper around script so that it resets
1141     UnsavedChanges flag appropriately.
1142    
1143     * Fri Dec 15 2000 Adrian Chung <adrianc@e-smith.com>
1144     - Added chmod 0755 for mysqld-password init script.
1145     - Moved /etc/etc/rc.d to /etc/rc.d
1146    
1147     * Fri Dec 15 2000 Adrian Chung <adrianc@e-smith.com>
1148     - Added conf-mysql-password to post-install which sets
1149     up mysqld-password in rc7.d to be run once to set the
1150     password. The mysqld-password script removes it's link
1151     from runlevel 7 and updates the configuration/services
1152     database.
1153    
1154     * Fri Nov 24 2000 Adrian Chung <adrianc@e-smith.com>
1155     - Changed mysql to mysqld.
1156    
1157     * Wed Nov 22 2000 Adrian Chung <adrianc@e-smith.com>
1158     - Minor modifications to conf-mysql script to make it work
1159     with the RH7.0 version of mysql.
1160    
1161     * Wed Nov 22 2000 Adrian Chung <adrianc@e-smith.com>
1162     - Rolled to 1.1.0, for 4.1/7.0 stream. Changed mysql to mysqld.
1163    
1164     * Tue Nov 14 2000 Adrian Chung <adrianc@e-smith.com>
1165     - initial release
1166    

admin@koozali.org
ViewVC Help
Powered by ViewVC 1.2.1 RSS 2.0 feed