zarb-ml/mageia-dev/2011-November/009619.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
 <HEAD>
   <TITLE> [Mageia-dev] HEADSUP: mariadb available for testing
   </TITLE>
   <LINK REL="Index" HREF="index.html" >
   <LINK REL="made" HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20HEADSUP%3A%20mariadb%20available%20for%20testing&In-Reply-To=%3C4EC6D838.1080100%40colin.guthr.ie%3E">
   <META NAME="robots" CONTENT="index,nofollow">
   <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
   <LINK REL="Previous"  HREF="009615.html">
   <LINK REL="Next"  HREF="009620.html">
 </HEAD>
 <BODY BGCOLOR="#ffffff">
   <H1>[Mageia-dev] HEADSUP: mariadb available for testing</H1>
    <B>Colin Guthrie</B> 
    <A HREF="mailto:mageia-dev%40mageia.org?Subject=Re%3A%20%5BMageia-dev%5D%20HEADSUP%3A%20mariadb%20available%20for%20testing&In-Reply-To=%3C4EC6D838.1080100%40colin.guthr.ie%3E"
       TITLE="[Mageia-dev] HEADSUP: mariadb available for testing">mageia at colin.guthr.ie
       </A><BR>
    <I>Fri Nov 18 23:12:08 CET 2011</I>
    <P><UL>
        <LI>Previous message: <A HREF="009615.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
        <LI>Next message: <A HREF="009620.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#9619">[ date ]</a>
              <a href="thread.html#9619">[ thread ]</a>
              <a href="subject.html#9619">[ subject ]</a>
              <a href="author.html#9619">[ author ]</a>
         </LI>
       </UL>
    <HR>  
<!--beginarticle-->
<PRE>'Twas brillig, and JA Magallon at 18/11/11 14:29 did gyre and gimble:
&gt;<i> 
</I>&gt;<i> On 2011.11.18, at 13:15, Maarten Vanraes wrote:
</I>&gt;<i> 
</I>&gt;&gt;<i> Op vrijdag 18 november 2011 12:55:36 schreef Sam Bailey:
</I>&gt;&gt;<i> [...]
</I>&gt;&gt;&gt;<i> I was testing on mga1 with basic rebuild only. I'll be setting up a
</I>&gt;&gt;&gt;<i> cauldron test environment this weekend though to compare.
</I>&gt;&gt;<i>
</I>&gt;&gt;<i> awesome
</I>&gt;&gt;<i>
</I>&gt;&gt;<i> meanwhile, i hear from mariadb, that next week they'll be merging the latest 
</I>&gt;&gt;<i> changes from 5.3 branch into it, and that should be the last big push for 5.5 
</I>&gt;&gt;<i> branch.
</I>&gt;<i> 
</I>&gt;<i> 
</I>&gt;<i> I got the problem in /etc/rc.d/init.d/mysqld, line 329:
</I>&gt;<i> 
</I>&gt;<i>     # Check if the system database should be updated and alert the user.
</I>&gt;<i>     NEW_VER=&quot;`$libexecdir/mysqld --version | awk '{ print $3}'`&quot;
</I>&gt;<i>     OLD_VER=&quot;`cat $datadir/mysql_upgrade_info`&quot;
</I>&gt;<i> 
</I>&gt;<i>     get_mysql_id() {
</I>&gt;<i>     MAJOR=&quot;`echo $1|cut -d. -f1`&quot;; MINOR=&quot;`echo $1|cut -d. -f2`&quot;; PATCH=&quot;`echo $1|cut -d. -f3`&quot;
</I>&gt;<i>     expr 10000 \* ${MAJOR} + 100 \* ${MINOR} + ${PATCH}
</I>&gt;<i>     }
</I>&gt;<i> 
</I>&gt;<i> Original MySQL gives (tested on CentOS):
</I>&gt;<i> 
</I>&gt;<i> nada:~&gt; /usr/libexec/mysqld --version
</I>&gt;<i> /usr/libexec/mysqld  Ver 5.1.52 for unknown-linux-gnu on x86_64 (Source distribution)
</I>&gt;<i> nada:~&gt; /usr/libexec/mysqld --version | awk '{ print $3}'
</I>&gt;<i> 5.1.52
</I>&gt;<i> 
</I>&gt;<i> MariaDB:
</I>&gt;<i> 
</I>&gt;<i> werewolf:~# /usr/sbin/mysqld --version
</I>&gt;<i> /usr/sbin/mysqld  Ver 5.5.15-MariaDB for Linux on x86_64 (Mageia - MariaDB Community Edition (GPL))
</I>&gt;<i> werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}'
</I>&gt;<i> 5.5.15-MariaDB
</I>&gt;<i> werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}' | cut -d. -f3
</I>&gt;<i> 15-MariaDB
</I>&gt;<i> 
</I>&gt;<i> See the -MariaDB tail in version ? This makes expr fail because PATCH is
</I>&gt;<i> not a number.
</I>&gt;<i> 
</I>&gt;<i> Quick Hack: change awk to:
</I>&gt;<i> 
</I>&gt;<i> /usr/sbin/mysqld --version | cut -d' ' -f4 | cut -d- -f 1
</I>&gt;<i> 
</I>&gt;<i> Works both in MySQL and MariaDB.
</I>
Nice.

I had it in my head that it was a thing to do with version numbers as I
mentioned earlier... this seems like a valid enough fix :)

Col


-- 

Colin Guthrie
colin(at)mageia.org
<A HREF="http://colin.guthr.ie/">http://colin.guthr.ie/</A>

Day Job:
  Tribalogic Limited <A HREF="http://www.tribalogic.net/">http://www.tribalogic.net/</A>
Open Source:
  Mageia Contributor <A HREF="http://www.mageia.org/">http://www.mageia.org/</A>
  PulseAudio Hacker <A HREF="http://www.pulseaudio.org/">http://www.pulseaudio.org/</A>
  Trac Hacker <A HREF="http://trac.edgewall.org/">http://trac.edgewall.org/</A>
</PRE>


<!--endarticle-->
    <HR>
    <P><UL>
        <!--threads-->
	<LI>Previous message: <A HREF="009615.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
	<LI>Next message: <A HREF="009620.html">[Mageia-dev] HEADSUP: mariadb available for testing
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#9619">[ date ]</a>
              <a href="thread.html#9619">[ thread ]</a>
              <a href="subject.html#9619">[ subject ]</a>
              <a href="author.html#9619">[ author ]</a>
         </LI>
       </UL>

<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-dev">More information about the Mageia-dev
mailing list</a><br>
</body></html>