UP?

Anything showing up in the brower debug console? 

@sims24 no access to console :(

@kermith72 Aurai tu une idée ?

I meant browser console, not tty. You can display it with F12 and hit refresh. 

oups sorry @sims24 

here:

What do you have in the Network tab? 

@sims24 

nothing

fuck

It seem to be a reinstall of Centreon :(

@art3mis you still have the issue ? Or you’ve decided to reinstall ?

Still have the issue @Kriko :(

I would reinstall only if I had no choice.
It annoys me because these are situations that could be avoided
Being an sysadmin, I don't want to start all over again.

Ok, in the network tab, if you click on upgrade.php ? What did you have in the detail response pannel ?

Here an example:

@Kriko 

It seem to be I have not the same information on Vivaldi :

On firefox:

Got it!

And on step4.php or process_step4.php ?
What did you get in the response ?

Did you something in the upgrade.log in /var/log/centreon/ ?

@Kriko

I see this on the last upgrade process :

Detail: 

{ "result" : "1", "current" : "21.10.6", "next" : "22.04.0-beta.1", "msg" : "UPGRADE - 22.04.0-beta.1: Impossible to add \\"login_attempts\\" and \\"blocking_time\\" columns to \\"contact\\" table" }

and this:

Detail:

Error: >object Event] msg.js:143:38
Uncaught SyntaxError: JSON.parse: expected ',' or '}' after property value in object at line 5 column 65 of the JSON data
    nextStep http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:37
    jQuery 6
    doProcess http://172.23.62.214/centreon/install/upgrade.php:40
    nextStep http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:32
    <anonymous> http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:13
    jQuery 11
    <anonymous> http://172.23.62.214/centreon/install/upgrade.php line 2 > injectedScript:8
    jQuery 14
    <anonymous> http://172.23.62.214/centreon/install/upgrade.php:17
    jQuery 13
upgrade.php line 2 > injectedScript:37:35

Ok so it’s sql request that failed.

Could you check in /var/log/centreon/sql-error.log or /var/log/centreon/upgrade.log if you successed to catch the request ? (should be a INSERT)

And you connect to your database and return me the output of:

use centreon;
desc contact;

@Kriko

On /var/log/centreon/upgrade.log

2022-05-25 09:02|0|0|UPGRADE - 22.04.0-beta.1: Impossible to add "login_attempts" and "blocking_time" columns to "contact" table - Code : 42000 - Error : SQLSTATET42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.1.php(77): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')
#3 {main}

On /var/log/centreon/sql-error.log

2022-05-25 09:02|0|0|SQLSTATEA42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE contact
            ADD login_attempts INT(11) UNSIGNED DEFAULT NULL,
            ADD blocking_time BIGINT(20) UNSIGNED DEFAULT NULL

And the result of contact table:

 

MariaDB acentreon]> use centreon;
Database changed
MariaDB acentreon]> desc contact;
+--------------------------------------+--------------------------+------+-----+---------+----------------+
| Field                                | Type                     | Null | Key | Default | Extra          |
+--------------------------------------+--------------------------+------+-----+---------+----------------+
| contact_id                           | int(11)                  | NO   | PRI | NULL    | auto_increment |
| timeperiod_tp_id                     | int(11)                  | YES  | MUL | NULL    |                |
| timeperiod_tp_id2                    | int(11)                  | YES  | MUL | NULL    |                |
| contact_name                         | varchar(200)             | YES  | MUL | NULL    |                |
| contact_alias                        | varchar(200)             | YES  | MUL | NULL    |                |
| contact_passwd                       | varchar(255)             | YES  |     | NULL    |                |
| contact_lang                         | varchar(255)             | YES  |     | browser |                |
| contact_host_notification_options    | varchar(200)             | YES  |     | NULL    |                |
| contact_service_notification_options | varchar(200)             | YES  |     | NULL    |                |
| contact_email                        | varchar(200)             | YES  |     | NULL    |                |
| contact_pager                        | varchar(200)             | YES  |     | NULL    |                |
| contact_address1                     | varchar(200)             | YES  |     | NULL    |                |
| contact_address2                     | varchar(200)             | YES  |     | NULL    |                |
| contact_address3                     | varchar(200)             | YES  |     | NULL    |                |
| contact_address4                     | varchar(200)             | YES  |     | NULL    |                |
| contact_address5                     | varchar(200)             | YES  |     | NULL    |                |
| contact_address6                     | varchar(200)             | YES  |     | NULL    |                |
| contact_comment                      | text                     | YES  |     | NULL    |                |
| contact_js_effects                   | enum('0','1')            | YES  |     | 0       |                |
| contact_location                     | int(11)                  | YES  |     | 0       |                |
| contact_oreon                        | enum('0','1')            | YES  |     | NULL    |                |
| reach_api                            | int(11)                  | YES  |     | 0       |                |
| reach_api_rt                         | int(1)                   | YES  |     | 0       |                |
| contact_enable_notifications         | enum('0','1','2')        | YES  |     | 2       |                |
| contact_template_id                  | int(11)                  | YES  | MUL | NULL    |                |
| contact_admin                        | enum('0','1')            | YES  |     | 0       |                |
| contact_type_msg                     | enum('txt','html','pdf') | YES  |     | txt     |                |
| contact_activate                     | enum('0','1')            | YES  |     | NULL    |                |
| contact_auth_type                    | varchar(255)             | YES  |     |         |                |
| contact_ldap_dn                      | text                     | YES  |     | NULL    |                |
| ar_id                                | int(11)                  | YES  | MUL | NULL    |                |
| contact_acl_group_list               | varchar(255)             | YES  |     | NULL    |                |
| contact_autologin_key                | varchar(255)             | YES  |     | NULL    |                |
| default_page                         | int(11)                  | YES  |     | NULL    |                |
| show_deprecated_pages                | enum('0','1')            | YES  |     | 0       |                |
| contact_charset                      | varchar(255)             | YES  |     | NULL    |                |
| contact_register                     | tinyint(6)               | NO   |     | 1       |                |
| contact_ldap_last_sync               | int(11)                  | NO   |     | 0       |                |
| contact_ldap_required_sync           | enum('0','1')            | NO   |     | 0       |                |
| enable_one_click_export              | enum('0','1')            | YES  |     | 0       |                |
+--------------------------------------+--------------------------+------+-----+---------+----------------+
40 rows in set (0.003 sec)

Could you execute the following request on your database:

ALTER TABLE centreon.contact ROW_FORMAT=DYNAMIC;

and try again the upgrade ?

@Kriko

I have this 

2022-05-25 09:48|0|0|UPGRADE - 22.04.0-beta.2: Unable to remove log_archive_path,log_rotation_method,daemon_dumps_core from cfg_nagios table - Code : 42000 - Error : SQLSTATET42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.2.php(39): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')

2022-05-25 09:48|0|0|SQLSTATET42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE cfg_nagios
            DROP COLUMN log_archive_path,
            DROP COLUMN log_rotation_method,
            DROP COLUMN daemon_dumps_core

This just keeps getting better :’)

In the log upgrade.log and sql-error.log what did we get now ?

yes it’s better @Kriko :)

2022-05-25 09:48|0|0|UPGRADE - 22.04.0-beta.2: Unable to remove log_archive_path,log_rotation_method,daemon_dumps_core from cfg_nagios table - Code : 42000 - Error : SQLSTATES42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - Trace : #0 /usr/share/centreon/www/class/centreonDB.class.php(309): PDO->query()
#1 /usr/share/centreon/www/install/php/Update-22.04.0-beta.2.php(39): CentreonDB->query()
#2 /usr/share/centreon/www/install/step_upgrade/process/process_step4.php(72): include_once('...')

2022-05-25 09:48|0|0|SQLSTATEL42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs QUERY : ALTER TABLE cfg_nagios
            DROP COLUMN log_archive_path,
            DROP COLUMN log_rotation_method,
            DROP COLUMN daemon_dumps_core

Ok we need to do the same request as previously :

ALTER TABLE centreon.cfg_nagios ROW_FORMAT=DYNAMIC;

Damn you save my life :)

Many Thanks 

Other questions if I can abuse your time? :

1- I have this odd status details, normal ?

 2- With the switch to Gorgone can I remove the cencore service?

3-  Can I contact you again if I have other problems?

4- Why this problem ??? Very odd...

And many thanks again !!!

You are my super heros today 😄

1. you can.
2. you can post an another question on thewatch, maybe I will answer, maybe someone else :)
3. I don’t know. By default the tables are in dynamic mode, here I don’t know why these 2 tables weren’t in dynamic mode

You’re welcome :)

@Kriko 

I edit my questions can you see the new first with screenshot ?

Not normal.
Could you create a new post about this one ?