Most likely strict mode is enabled on MySQL

adam.

On 13/04/2016 09:25:36, Jeffrey d'Ambly <jeffrey.dambly@jasper.com> wrote:

So starting with a 100% new db I’m still getting these errors

mysql> CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘*******';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
You have new mail in /var/spool/mail/root
[root@sjc-corp-net01 observium]# ./discovery.php -u
MySQL Error 1045: Access denied for user 'observium'@'localhost' (using password: YES)
[root@sjc-corp-net01 observium]# vi config.php
[root@sjc-corp-net01 observium]# ./discovery.php -u

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                         Observium Professional 0.16.4.7747
                                   http://www.observium.org

Install initial database schema ... FALSE.
-- Updating database/file schema
000 -> 001 ... (db) done.
001 -> 002 ... (db) done (13 errors).
002 -> 003 ... (db) done (6 errors).
003 -> 004 ... (db) done (22 errors).
004 -> 005 ... (db) done (8 errors).
005 -> 006 ... (db) done (2 errors).
006 -> 007 ... (db) done.
007 -> 008 ... (db) done (1 errors).
008 -> 009 ... (db) done (9 errors).
009 -> 010 ... (db) done (1 errors).
010 -> 011 ... (db) done.
011 -> 012 ... (db) done.
012 -> 013 ... (db) done (1 errors).
013 -> 014 ... (db) done.
014 -> 015 ... (db) done (1 errors).
015 -> 016 ... (db) done (5 errors).
016 -> 017 ... (db) done (1 errors).
017 -> 018 ... (db) done (3 errors).
018 -> 019 ... (db) done.
019 -> 020 ... (db) done (6 errors).
020 -> 021 ... (db) done (3 errors).
021 -> 022 ... (db) done (1 errors).
022 -> 023 ... (db) done (2 errors).
023 -> 024 ... (db) done (2 errors).
024 -> 025 ... (db) done (8 errors).
025 -> 026 ... (db) done.
026 -> 027 ... (db) done (1 errors).
027 -> 028 ... (db) done (8 errors).
028 -> 029 ... (db) done.
029 -> 030 ... (db) done.
030 -> 031 ... (db) done (1 errors).
031 -> 032 ... (db) done (2 errors).
032 -> 033 ... (db) done.
033 -> 034 ... (db) done.
034 -> 035 ... (db) done.
035 -> 036 ... (db) done (1 errors).
036 -> 037 ... (db) done (2 errors).
037 -> 038 ... (db) done (1 errors).
038 -> 039 ... (db) done (1 errors).
039 -> 040 ... (db) done.
040 -> 041 ... (db) done.
041 -> 042 ... (db) done (3 errors).
042 -> 043 ... (db) done (7 errors).
043 -> 044 ... (db) done (2 errors).
044 -> 045 ... (db) done (2 errors).
045 -> 046 ... (db) done.
046 -> 047 ... (db) done.
047 -> 048 ... (db) done (1 errors).
048 -> 049 ... (db) done (1 errors).
049 -> 050 ... (db) done (1 errors).
050 -> 051 ... (db) done.
051 -> 052 ... (db) done (1 errors).
052 -> 053 ... (db) done (1 errors).
053 -> 054 ... (db) done (1 errors).
054 -> 055 ... (db) done (3 errors).
055 -> 056 ... (db) done (1 errors).
056 -> 057 ... (db) done (1 errors).
057 -> 058 ... (db) done (1 errors).
058 -> 059 ... (db) done (2 errors).
059 -> 060 ... (db) done (1 errors).
060 -> 061 ... (db) done (1 errors).
061 -> 062 ... (db) done (1 errors).
062 -> 063 ... (db) done (5 errors).
063 -> 064 ... (db) done (3 errors).
064 -> 065 ... (db) done (2 errors).
065 -> 066 ... (db) done (1 errors).
066 -> 067 ... (db) done (1 errors).
067 -> 068 ... (db) done (2 errors).
068 -> 069 ... (db) done (4 errors).
069 -> 070 ... (db) done (2 errors).
070 -> 071 ... (db) done (1 errors).
071 -> 072 ... (db) done (1 errors).
072 -> 073 ... (db) done.
073 -> 074 ... (php) Updating netscaler service RRDs
074 -> 075 ... (db) done (1 errors).
075 -> 076 ... (db) done (1 errors).
076 -> 077 ... (db) done (3 errors).
077 -> 078 ... (db) done.
078 -> 079 ... (db) done.
079 -> 080 ... (db) done (35 errors).
080 -> 081 ... (db) done (2 errors).
081 -> 082 ... (db) done (9 errors).
082 -> 083 ... (db) done.
083 -> 084 ... (db) done (2 errors).
084 -> 085 ... (db) done (3 errors).
085 -> 086 ... (db) done (1 errors).
086 -> 087 ... (db) done (2 errors).
087 -> 088 ... (db) done (1 errors).
088 -> 089 ... (db) done (5 errors).
089 -> 090 ... (db) done (3 errors).
090 -> 091 ... (db) done (1 errors).
091 -> 092 ... (db) done (1 errors).
092 -> 093 ... (db) done (3 errors).
093 -> 094 ... (db) done (1 errors).
094 -> 095 ... (php) Converting alert serialize() arrays to JSON:
095 -> 096 ... (db) done (1 errors).
096 -> 097 ... (db) done.
097 -> 098 ... (db) done (1 errors).
098 -> 099 ... (db) done (1 errors).
099 -> 100 ... (db) done (1 errors).
100 -> 101 ... (db) done (1 errors).
101 -> 102 ... (db) done (1 errors).
102 -> 103 ... (db) done (1 errors).
103 -> 104 ... (db) done (2 errors).
104 -> 105 ... (db) done.
105 -> 106 ... (db) done (2 errors).
106 -> 107 ... (db) done (1 errors).
107 -> 108 ... (db) done (1 errors).
108 -> 109 ... (db) done (1 errors).
109 -> 110 ... (db) done (3 errors).
110 -> 111 ... (db) done.
111 -> 112 ... (db) done.
112 -> 113 ... (db) done.
113 -> 114 ... (db) done (1 errors).
114 -> 115 ... (db) done (1 errors).
115 -> 116 ... (db) done (1 errors).
116 -> 117 ... (db) done.
117 -> 118 ... (db) done (1 errors).
118 -> 119 ... (db) done (19 errors).
119 -> 120 ... (db) done (1 errors).
120 -> 121 ... (db) done.
121 -> 122 ... (db) done (3 errors).
122 -> 123 ... (db) done (4 errors).
123 -> 124 ... (db) done.
124 -> 125 ... (db) done.
125 -> 126 ... (db) done (2 errors).
126 -> 127 ... (php) Converting FDB count RRD ds fdb->value:
127 -> 128 ... (php) Rename old storage RRDs and DB:
128 -> 129 ... (php) Rename old mempools RRDs and DB:
129 -> 130 ... (db) done.
130 -> 131 ... (db) done (1 errors).
131 -> 132 ... (db) done (1 errors).
132 -> 133 ... (db) done.
133 -> 134 ... (db) done (1 errors).
134 -> 135 ... (db) done (1 errors).
135 -> 136 ... (db) done (1 errors).
136 -> 137 ... (db) done.
137 -> 138 ... (db) done.
138 -> 139 ... (db) done (5 errors).
139 -> 140 ... (db) done (1 errors).
140 -> 141 ... (db) done (3 errors).
141 -> 142 ... (db) done (4 errors).
142 -> 143 ... (db) done (2 errors).
143 -> 144 ... (db) done (1 errors).
144 -> 145 ... (db) done.
145 -> 146 ... (db) done (1 errors).
146 -> 147 ... (db) done (1 errors).
147 -> 148 ... (db) done (3 errors).
148 -> 149 ... (db) done (3 errors).
149 -> 150 ... (db) done (7 errors).
150 -> 151 ... (db) done.
151 -> 152 ... (db) done.
152 -> 153 ... (php)
153 -> 154 ... (db) done.
154 -> 155 ... (db) done (1 errors).
155 -> 156 ... (db) done.
156 -> 157 ... (db) done (1 errors).
157 -> 158 ... (db) done (4 errors).
158 -> 159 ... (db) done (1 errors).
159 -> 160 ... (db) done (1 errors).
160 -> 161 ... (db) done.
161 -> 162 ... (db) done.
162 -> 163 ... (db) done (1 errors).
163 -> 164 ... (php) Superseded by update 165
164 -> 165 ... (php) Adding MIN RRA to very old RRD files:
  * hr_processes:
  * hr_users:
  * ucd_contexts:
  * ucd_load:
  * ucd_interrupts:
165 -> 166 ... (db) done (1 errors).
166 -> 167 ... (db) done (2 errors).
167 -> 168 ... (db) done.
168 -> 169 ... (db) done (2 errors).
169 -> 170 ... (php) Move old GEO data if exist:
170 -> 171 ... (db) done (1 errors).
171 -> 172 ... (db) done.
172 -> 173 ... (db) done (1 errors).
173 -> 174 ... (db) done (3 errors).
174 -> 175 ... (db) done (2 errors).
175 -> 176 ... (php) Clean incorrect syslog entries:
176 -> 177 ... (php) Clean incorrect manual geolocation:
177 -> 178 ... (db) done (7 errors).
178 -> 179 ... (db) done (2 errors).
179 -> 180 ... (db) done.
180 -> 181 ... (db) done (1 errors).
181 -> 182 ... (db) done.
182 -> 183 ... (db) done.
183 -> 184 ... (db) done (17 errors).
184 -> 185 ... (db) done.
185 -> 186 ... (db) done (10 errors).
186 -> 187 ... (php)
187 -> 188 ... (db) done (2 errors).
188 -> 189 ... (db) done (2 errors).
189 -> 190 ... (db) done (1 errors).
190 -> 191 ... (php) Migrating state sensors to status entries:
191 -> 192 ... (db) done (3 errors).
192 -> 193 ... (db) done (1 errors).
193 -> 194 ... (db) done (1 errors).
194 -> 195 ... (db) done.
195 -> 196 ... (db) done (2 errors).
196 -> 197 ... (db) done (1 errors).
197 -> 198 ... (db) done (1 errors).
198 -> 199 ... (db) done.
199 -> 200 ... (db) done (6 errors).
200 -> 201 ... (db) done (1 errors).
201 -> 202 ... (db) done (7 errors).
202 -> 203 ... (db) done.
203 -> 204 ... (db) done.
204 -> 205 ... (db) done.
205 -> 206 ... (db) done.
206 -> 207 ... (db) done.
207 -> 208 ... (db) done (1 errors).
208 -> 209 ... (db) done (7 errors).
209 -> 210 ... (php)
210 -> 211 ... (db) done (1 errors).
211 -> 212 ... (php)
212 -> 213 ... (db) done (3 errors).
213 -> 214 ... (db) done (1 errors).
214 -> 215 ... (db) done.
215 -> 216 ... (db) done (1 errors).
216 -> 217 ... (db) done.
217 -> 218 ... (db) done.
218 -> 219 ... (db) done.
219 -> 220 ... (db) done (1 errors).
220 -> 221 ... (db) done (1 errors).
221 -> 222 ... (db) done.
222 -> 223 ... (db) done (1 errors).
223 -> 224 ... (db) done.
224 -> 225 ... (db) done (2 errors).
225 -> 226 ... (db) done.
226 -> 227 ... (db) done (2 errors).
227 -> 228 ... (db) done (10 errors).
228 -> 229 ... (db) done.
229 -> 230 ... (db) done (1 errors).
230 -> 231 ... (db) done (1 errors).
231 -> 232 ... (db) done (1 errors).
232 -> 233 ... (db) done (2 errors).
233 -> 234 ... (db) done (1 errors).
234 -> 235 ... (db) done (2 errors).
235 -> 236 ... (db) done.
236 -> 237 ... (db) done.
237 -> 238 ... (db) done.
238 -> 239 ... (db) done (1 errors).
239 -> 240 ... (db) done (1 errors).
240 -> 241 ... (db) done.
241 -> 242 ... (db) done.
242 -> 243 ... (db) done.
243 -> 244 ... (db) done.
244 -> 245 ... (db) done (1 errors).
245 -> 246 ... (db) done.
246 -> 247 ... (db) done (1 errors).
247 -> 248 ... (db) done.
248 -> 249 ... (db) done (1 errors).
249 -> 250 ... (db) done (1 errors).
250 -> 251 ... (db) done.
251 -> 252 ... (db) done (5 errors).
252 -> 253 ... (db) done (1 errors).
253 -> 254 ... (db) done (1 errors).
254 -> 255 ... (db) done.
255 -> 256 ... (php)
256 -> 257 ... (php)
257 -> 258 ... (php)
258 -> 259 ... (db) done.
259 -> 260 ... (php)
260 -> 261 ... (db) done (5 errors).
261 -> 262 ... (php)
262 -> 263 ... (db) done (1 errors).
263 -> 264 ... (db) done (9 errors).
264 -> 265 ... (db) done.
265 -> 266 ... (db) done.
266 -> 267 ... (db) done (1 errors).
267 -> 268 ... (php)
268 -> 269 ... (php)
269 -> 270 ... (db) done.
270 -> 271 ... (db) done (3 errors).
271 -> 272 ... (db) done.
272 -> 273 ... (db) done (1 errors).
273 -> 274 ... (php)
-- Done.
[root@sjc-corp-net01 observium]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_sjccorpnet01-lv_root
                       50G  3.9G   43G   9% /
tmpfs                 127G     0  127G   0% /dev/shm
/dev/sda1             477M   68M  384M  15% /boot
/dev/mapper/vg_sjccorpnet01-lv_home
                      359G  282G   60G  83% /home
[root@sjc-corp-net01 observium]#

From: observium <observium-bounces@observium.org> on behalf of Adam Armstrong <adama@memetic.org>
Reply-To: Observium Network Observation System <observium@observium.org>
Date: Tuesday, April 12, 2016 at 11:48 PM
To: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] errors on upgrade

Yes. That looks like everything failed, and your database is probably now not something observium can properly interact with.

Adam.

Sent from BlueMail

On Apr 13, 2016, at 07:46, Jeffrey d'Ambly <jeffrey.dambly@jasper.com> wrote:
Should I be worried about these errors?


[root@sjc-corp-net01 observium]# ./discovery.php -u

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                         Observium Professional 0.16.4.7747
                                   http://www.observium.org

-- Updating database/file schema
195 -> 196 ... (db) done.
196 -> 197 ... (db) done.
197 -> 198 ... (db) done.
198 -> 199 ... (db) done.
199 -> 200 ... (db) done.
200 -> 201 ... (db) done.
201 -> 202 ... (db) done (1 errors).
202 -> 203 ... (db) done.
203 -> 204 ... (db) done.
204 -> 205 ... (db) done.
205 -> 206 ... (db) done.
206 -> 207 ... (db) done.
207 -> 208 ... (db) done.
208 -> 209 ... (db) done (4 errors).
209 -> 210 ... (php)
210 -> 211 ... (db) done (5 errors).
211 -> 212 ... (php)
212 -> 213 ... (db) done (11 errors).
213 -> 214 ... (db) done (2 errors).
214 -> 215 ... (db) done (3 errors).
215 -> 216 ... (db) done (1 errors).
216 -> 217 ... (db) done (1 errors).
217 -> 218 ... (db) done (1 errors).
218 -> 219 ... (db) done (1 errors).
219 -> 220 ... (db) done (4 errors).
220 -> 221 ... (db) done (1 errors).
221 -> 222 ... (db) done.
222 -> 223 ... (db) done (1 errors).
223 -> 224 ... (db) done.
224 -> 225 ... (db) done (2 errors).
225 -> 226 ... (db) done.
226 -> 227 ... (db) done (2 errors).
227 -> 228 ... (db) done (10 errors).
228 -> 229 ... (db) done (3 errors).
229 -> 230 ... (db) done (1 errors).
230 -> 231 ... (db) done (1 errors).
231 -> 232 ... (db) done (1 errors).
232 -> 233 ... (db) done (2 errors).
233 -> 234 ... (db) done (1 errors).
234 -> 235 ... (db) done (3 errors).
235 -> 236 ... (db) done (1 errors).
236 -> 237 ... (db) done.
237 -> 238 ... (db) done (1 errors).
238 -> 239 ... (db) done (1 errors).
239 -> 240 ... (db) done (3 errors).
240 -> 241 ... (db) done (1 errors).
241 -> 242 ... (db) done (4 errors).
242 -> 243 ... (db) done (1 errors).
243 -> 244 ... (db) done (6 errors).
244 -> 245 ... (db) done (1 errors).
245 -> 246 ... (db) done (1 errors).
246 -> 247 ... (db) done (2 errors).
247 -> 248 ... (db) done (2 errors).
248 -> 249 ... (db) done (1 errors).
249 -> 250 ... (db) done (1 errors).
250 -> 251 ... (db) done (1 errors).
251 -> 252 ... (db) done (5 errors).
252 -> 253 ... (db) done.
253 -> 254 ... (db) done.
254 -> 255 ... (db) done (2 errors).
255 -> 256 ... (php)
256 -> 257 ... (php)
257 -> 258 ... (php)
258 -> 259 ... (db) done.
259 -> 260 ... (php)
260 -> 261 ... (db) done (6 errors).
261 -> 262 ... (php)
262 -> 263 ... (db) done (1 errors).
263 -> 264 ... (db) done (9 errors).
264 -> 265 ... (db) done (1 errors).
265 -> 266 ... (db) done (2 errors).
266 -> 267 ... (db) done (1 errors).
267 -> 268 ... (php)
268 -> 269 ... (php)
269 -> 270 ... (db) done (1 errors).
270 -> 271 ... (db) done (10 errors).
271 -> 272 ... (db) done (5 errors).
272 -> 273 ... (db) done (2 errors).
273 -> 274 ... (php)
-- Done.
You have new mail in /var/spool/mail/root
[root@sjc-corp-net01 observium]#


observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium