/[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.29 - (hide annotations) (download)
Tue Jun 7 12:39:31 2022 UTC (2 years, 4 months ago) by jcrisp
Branch: MAIN
Changes since 1.28: +1 -1 lines
* Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme
- Fix init for MariaDB 104+ [SME:11991]

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

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