/[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.37 - (hide annotations) (download)
Thu Sep 5 14:09:41 2024 UTC (2 months ago) by jpp
Branch: MAIN
CVS Tags: smeserver-mysql-2_7_0-21_el7_sme, HEAD
Changes since 1.36: +2 -2 lines
* Thu Sep 05 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-21.sme
- fix typo for user privileges backup [SME: 12145]

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

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