Hi Eduardo,

 you do a clean install?

Please do some debug steps:

drop database (if exist), recreate it and run DB schema update dut with debug flag and pipe output to file
./discovery.php -dd -u > /tmp/update_debug.txt

Than send to me this file (update_debug.txt)


On Sat, Dec 5, 2015 at 7:31 AM, Eduardo Schoedler <listas@esds.com.br> wrote:
Adam,

Take a deep look in log, you will see the process stops on update 150 from database. I don't even know if entire database is there.

Even if I create entire database from the db_schema_mysql.sql file, there is a lot of errors in db.log from discovery and poller.

I'm installing a fresh copy of Observium in a Freebsd with mysql (I've tried 5.6 and switched to 5.5 to see if the version was the problem).

I sent in private an e-mail with the errors.

Thank you.


2015-12-05 1:29 GMT-02:00 Adam Armstrong <adama@observium.org>:

These updates were a long time ago. The failing queries were probably fixing earlier changes.

I'm fairly sure you can ignore them!

Adam.

Sent with AquaMail for Android
http://www.aqua-mail.com

On 4 December 2015 11:16:33 pm Eduardo Schoedler <listas@esds.com.br> wrote:

# php includes/update/update.php
-- Updating database/file schema
000 -> 001 ... (db) done.
001 -> 002 ... (db) done.
002 -> 003 ... (db) done.
003 -> 004 ... (db) done.
004 -> 005 ... (db) done.
005 -> 006 ... (db) done.
006 -> 007 ... (db) done.
007 -> 008 ... (db) done.
008 -> 009 ... (db) done.
009 -> 010 ... (db) done.
010 -> 011 ... (db) done.
011 -> 012 ... (db) done.
012 -> 013 ... (db) done.
013 -> 014 ... (db) done.
014 -> 015 ... (db) done.
015 -> 016 ... (db) done.
016 -> 017 ... (db) done.
017 -> 018 ... (db) done.
018 -> 019 ... (db) done.
019 -> 020 ... (db) done.
020 -> 021 ... (db) done.
021 -> 022 ... (db) done.
022 -> 023 ... (db) done.
023 -> 024 ... (db) done.
024 -> 025 ... (db) done.
025 -> 026 ... (db) done.
026 -> 027 ... (db) done.
027 -> 028 ... (db) done.
028 -> 029 ... (db) done.
029 -> 030 ... (db) done.
030 -> 031 ... (db) done.
031 -> 032 ... (db) done.
032 -> 033 ... (db) done.
033 -> 034 ... (db) done.
034 -> 035 ... (db) done.
035 -> 036 ... (db) done.
036 -> 037 ... (db) done.
037 -> 038 ... (db) done.
038 -> 039 ... (db) done.
039 -> 040 ... (db) done.
040 -> 041 ... (db) done.
041 -> 042 ... (db) done.
042 -> 043 ... (db) done.
043 -> 044 ... (db) done.
044 -> 045 ... (db) done.
045 -> 046 ... (db) done.
046 -> 047 ... (db) done.
047 -> 048 ... (db) done.
048 -> 049 ... (db) done.
049 -> 050 ... (db) done.
050 -> 051 ... (db) done.
051 -> 052 ... (db) done.
052 -> 053 ... (db) done.
053 -> 054 ... (db) done.
054 -> 055 ... (db) done.
055 -> 056 ... (db) done.
056 -> 057 ... (db) done.
057 -> 058 ... (db) done.
058 -> 059 ... (db) done.
059 -> 060 ... (db) done.
060 -> 061 ... (db) done.
061 -> 062 ... (db) done.
062 -> 063 ... (db) done.
063 -> 064 ... (db) done.
064 -> 065 ... (db) done.
065 -> 066 ... (db) done.
066 -> 067 ... (db) done.
067 -> 068 ... (db) done.
068 -> 069 ... (db) done.
069 -> 070 ... (db) done.
070 -> 071 ... (db) done.
071 -> 072 ... (db) done.
072 -> 073 ... (db) done.
073 -> 074 ... (php) Updating netscaler service RRDs
074 -> 075 ... (db) done.
075 -> 076 ... (db) done.
076 -> 077 ... (db) done.
077 -> 078 ... (db) done.
078 -> 079 ... (db) done.
079 -> 080 ... (db) done.
080 -> 081 ... (db) done.
081 -> 082 ... (db) done.
082 -> 083 ... (db) done.
083 -> 084 ... (db) done.
084 -> 085 ... (db) done.
085 -> 086 ... (db) done.
086 -> 087 ... (db) done.
087 -> 088 ... (db) done.
088 -> 089 ... (db) done.
089 -> 090 ... (db) done.
090 -> 091 ... (db) done.
091 -> 092 ... (db) done.
092 -> 093 ... (db) done.
093 -> 094 ... (db) done.
094 -> 095 ... (php) Converting alert serialize() arrays to JSON:
095 -> 096 ... (db) done.
096 -> 097 ... (db) done.
097 -> 098 ... (db) done.
098 -> 099 ... (db) done.
099 -> 100 ... (db) done.
100 -> 101 ... (db) done.
101 -> 102 ... (db) done.
102 -> 103 ... (db) done.
103 -> 104 ... (db) done.
104 -> 105 ... (db) done.
105 -> 106 ... (db) done.
106 -> 107 ... (db) done.
107 -> 108 ... (db) done.
108 -> 109 ... (db) done.
109 -> 110 ... (db) done.
110 -> 111 ... (db) done.
111 -> 112 ... (db) done.
112 -> 113 ... (db) done.
113 -> 114 ... (db) done.
114 -> 115 ... (db) done.
115 -> 116 ... (db) done.
116 -> 117 ... (db) done.
117 -> 118 ... (db) done.
118 -> 119 ... (db) done.
119 -> 120 ... (db) done.
120 -> 121 ... (db) done.
121 -> 122 ... (db) done.
122 -> 123 ... (db) done.
123 -> 124 ... (db) done.
124 -> 125 ... (db) done.
125 -> 126 ... (db) done.
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.
131 -> 132 ... (db) done.
132 -> 133 ... (db) done.
133 -> 134 ... (db) done.
134 -> 135 ... (db) done.
135 -> 136 ... (db) done.
136 -> 137 ... (db) done.
137 -> 138 ... (db) done.
138 -> 139 ... (db) done.
139 -> 140 ... (db) done.
140 -> 141 ... (db) done.
141 -> 142 ... (db) done.
142 -> 143 ... (db) done.
143 -> 144 ... (db) done.
144 -> 145 ... (db) done.
145 -> 146 ... (db) done.
146 -> 147 ... (db) done.
147 -> 148 ... (db) done.
148 -> 149 ... (db) done.
149 -> 150 ... (db) done (2 errors).


# svn update && ./discovery.php -h none
Updating '.':
At revision 7229.

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

-- Updating database/file schema
149 -> 150 ... (db) done (10 errors).




# cat update-errors.log
[2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ==============
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE  `alert_assoc` CHANGE  `device_attributes`  `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc'
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE  `alert_assoc` CHANGE  `attributes`  `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc'
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE  `ports_perms` ADD  `entity_type` VARCHAR( 32 ) NOT NULL AFTER  `user_id` ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE  `ports_perms` CHANGE  `port_id`  `entity_id` INT( 11 ) NOT NULL ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE  `ports_perms` TO  `entity_permissions` ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms'
[2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'


# cat db.log
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE  `alert_assoc` CHANGE  `device_attributes`  `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE  `alert_assoc` CHANGE  `attributes`  `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE  `ports_perms` ADD  `entity_type` VARCHAR( 32 ) NOT NULL AFTER  `user_id` ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE  `ports_perms` CHANGE  `port_id`  `entity_id` INT( 11 ) NOT NULL ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE  `ports_perms` TO  `entity_permissions` ;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`;




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


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




--
Eduardo Schoedler

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




--
Mike Stupalov
http://observium.org/