search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.13k stars 1.28k forks source link

[0.90.4] GLPI notifications - Security die. trying to load an forbidden class name #838

Closed pszafer closed 8 years ago

pszafer commented 8 years ago

Hello, I upgraded GLPI from 0.90.3 to 0.90.4 today. Unfortunately one of the tables in db was marked as crashed before (I didn't noticed that) and during setup I've got error:

Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/glpi/inc/dbmysql.class.php on line 280

Then I checked mysql, repaired table and now I have problem with notifications tab. When I try to go to: http://myglpi/front/notification.php I see:

Security die. trying to load an forbidden class name

How can I repair it? Maybe it is some way to rerun update process?

Information about system installation and configuration
[code]

GLPI 0.90.4 ( => /var/www/glpi)

Server

Operating system: Linux glpi.poznan.tbhydro.net 4.4.8-1-pve #1 SMP Tue May 17 16:14:08 CEST 2016 x86_64
PHP 5.4.16 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, apache2handler, bz2, calendar, ctype, curl, date, dom,
    ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, json, ldap, libxml, mbstring, mhash, mysql, mysqli,
    openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, shmop, snmp, soap, sockets, sqlite3, standard, sysvmsg, sysvsem, sysvshm,
    tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="50M" safe_mode="" session.save_handler="files"
    upload_max_filesize="120M" 
Software: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_wsgi/3.4 Python/2.7.5 ()
    Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.82 Safari/537.36
Server Software: (Debian)
    Server Version: 5.5.50-0+deb8u1
    Server SQL Mode: 
    Parameters: glpi@mysql.poznan.tbhydro.net/glpi
    Host info: mysql.poznan.tbhydro.net via TCP/IP

OK/var/www/glpi/config : OK
OK/var/www/glpi/files : OK
OK/var/www/glpi/files/_dumps : OK
OK/var/www/glpi/files/_sessions : OK
OK/var/www/glpi/files/_cron : OK
OK/var/www/glpi/files/_graphs : OK
OK/var/www/glpi/files/_lock : OK
OK/var/www/glpi/files/_plugins : OK
OK/var/www/glpi/files/_tmp : OK
OK/var/www/glpi/files/_rss : OK
OK/var/www/glpi/files/_uploads : OK
OK/var/www/glpi/files/_pictures : OK
OK/var/www/glpi/files/_log : OK
Web access to files directory is protectedWeb access to files directory is protected : OK
OKSELinux mode is Disabled

Libraries

htmLawed version 1.1.21 in (/var/www/glpi/lib/htmlawed)
phpCas version 1.3.4 in (/var/www/glpi/lib/phpcas)
PHPMailer version 5.2.8 in (/var/www/glpi/lib/phpmailer)
ZetaComponent ezcGraph installed in (/var/www/glpi/lib/zeta/Base):  OK
Zend Framework version 2.4.9 in (/var/www/glpi/lib/Zend)
SimplePie version 1.3.1 in (/var/www/glpi/lib/simplepie)
TCPDF version 6.2.12 in (/var/www/glpi/lib/tcpdf)
ircmaxell/password-compat in (/var/www/glpi/lib/password_compat). Compatitility: Ok

LDAP directories

Server: 'server.poznan.tbhydro.net', Port: '389', BaseDN: 'DC=poznan,DC=tbhydro,DC=net', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'CN=addressbook,CN=Users,DC=poznan,DC=tbhydro,DC=net', Use TLS: none
Server: 'serverwa.wagrowiec.tbhydro.net', Port: '389', BaseDN: 'DC=wagrowiec,DC=tbhydro,DC=net', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'CN=addressbook,CN=Users,DC=wagrowiec,DC=tbhydro,DC=net', Use TLS: none

Mysql replicas

Not active

Notifications

Way of sending emails: SMTP+SSL (notifications@tbhydro.com.pl@smtp.gmail.com)

Mails receivers

Name: 'help@tbhydro.com.pl' Active: Yes
    Server: '{imap.gmail.com:993/imap/ssl/novalidate-cert}HELPDESK' Login: 'notifications@tbhydro.com.pl' Password: Yes

Plugins list

    webapplications      Name: Aplikacje internetowe          Version: 2.1.1      State: Enabled
    financialreports     Name: Asset situation                Version: 2.2.1      State: Enabled
    badges               Name: Badges                         Version: 2.1.1      State: Enabled
    databases            Name: Bazy danych                    Version: 1.8.1      State: Enabled
    certificates         Name: Certyfikaty                    Version: 2.1.1      State: Enabled
    dashboard            Name: Dashboard                      Version: 0.7.1      State: Enabled
    domains              Name: Domains                        Version: 1.7.0      State: Enabled
    environment          Name: Environment                    Version: 1.9.0      State: Enabled
    formcreator          Name: Formularze                     Version: 0.90-1.3.3 State: Enabled
    fusioninventory      Name: FusionInventory                Version: 0.90+1.3   State: Enabled
    accounts             Name: Konta                          Version: 2.1.1      State: Enabled
    monitoring           Name: Monitoring                     Version: 0.90+1.1   State: Enabled
    mreporting           Name: More Reporting                 Version: 0.90+1.1   State: Enabled
    archires             Name: Network Architectures          Version: 2.3        State: Enabled
    order                Name: Orders management              Version: 0.85+1.1   State: Enabled
    reports              Name: Raporty                        Version: 1.9.1      State: Enabled
    shellcommands        Name: Shell Commands                 Version: 1.9.1      State: Enabled
    tasklists            Name: Tasks list                     Version: 1.0.0      State: Enabled
    webservices          Name: Web Services                   Version: 1.6.0      State: Enabled
    racks                Name: Zarządzanie szafami Rack       Version: 1.6.1      State: Enabled

[/code]
satyan01 commented 8 years ago

Hello

disable plugins and enable them one after one to see which one generate this error

pszafer commented 8 years ago

Tried it before, but error still occurs.

Here is system info:

[code]

GLPI 0.90.4 ( => /var/www/glpi)

Server

Operating system: Linux glpi.poznan.tbhydro.net 4.4.8-1-pve #1 SMP Tue May 17 16:14:08 CEST 2016 x86_64
PHP 5.4.16 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, apache2handler, bz2, calendar, ctype, curl, date, dom,
    ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, json, ldap, libxml, mbstring, mhash, mysql, mysqli,
    openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, shmop, snmp, soap, sockets, sqlite3, standard, sysvmsg, sysvsem, sysvshm,
    tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="50M" safe_mode="" session.save_handler="files"
    upload_max_filesize="120M" 
Software: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_wsgi/3.4 Python/2.7.5 ()
    Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.82 Safari/537.36
Server Software: (Debian)
    Server Version: 5.5.50-0+deb8u1
    Server SQL Mode: 
    Parameters: glpi@mysql.poznan.tbhydro.net/glpi
    Host info: mysql.poznan.tbhydro.net via TCP/IP

OK/var/www/glpi/config : OK
OK/var/www/glpi/files : OK
OK/var/www/glpi/files/_dumps : OK
OK/var/www/glpi/files/_sessions : OK
OK/var/www/glpi/files/_cron : OK
OK/var/www/glpi/files/_graphs : OK
OK/var/www/glpi/files/_lock : OK
OK/var/www/glpi/files/_plugins : OK
OK/var/www/glpi/files/_tmp : OK
OK/var/www/glpi/files/_rss : OK
OK/var/www/glpi/files/_uploads : OK
OK/var/www/glpi/files/_pictures : OK
OK/var/www/glpi/files/_log : OK
Web access to files directory is protectedWeb access to files directory is protected : OK
OKSELinux mode is Disabled

Libraries

htmLawed version 1.1.21 in (/var/www/glpi/lib/htmlawed)
phpCas version 1.3.4 in (/var/www/glpi/lib/phpcas)
PHPMailer version 5.2.8 in (/var/www/glpi/lib/phpmailer)
ZetaComponent ezcGraph installed in (/var/www/glpi/lib/zeta/Base):  OK
Zend Framework version 2.4.9 in (/var/www/glpi/lib/Zend)
SimplePie version 1.3.1 in (/var/www/glpi/lib/simplepie)
TCPDF version 6.2.12 in (/var/www/glpi/lib/tcpdf)
ircmaxell/password-compat in (/var/www/glpi/lib/password_compat). Compatitility: Ok

LDAP directories

Server: 'server.poznan.tbhydro.net', Port: '389', BaseDN: 'DC=poznan,DC=tbhydro,DC=net', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'CN=addressbook,CN=Users,DC=poznan,DC=tbhydro,DC=net', Use TLS: none
Server: 'serverwa.wagrowiec.tbhydro.net', Port: '389', BaseDN: 'DC=wagrowiec,DC=tbhydro,DC=net', Connection filter:
        '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
        'CN=addressbook,CN=Users,DC=wagrowiec,DC=tbhydro,DC=net', Use TLS: none

Mysql replicas

Not active

Notifications

Way of sending emails: SMTP+SSL (notifications@tbhydro.com.pl@smtp.gmail.com)

Mails receivers

Name: 'help@tbhydro.com.pl' Active: Yes
    Server: '{imap.gmail.com:993/imap/ssl/novalidate-cert}HELPDESK' Login: 'notifications@tbhydro.com.pl' Password: Yes

Plugins list

    webapplications      Name: Aplikacje internetowe          Version: 2.1.1      State: Not activated
    financialreports     Name: Asset situation                Version: 2.2.1      State: Not activated
    badges               Name: Badges                         Version: 2.1.1      State: Not activated
    databases            Name: Bazy danych                    Version: 1.8.1      State: Not activated
    certificates         Name: Certyfikaty                    Version: 2.1.1      State: Not activated
    dashboard            Name: Dashboard                      Version: 0.7.1      State: Not activated
    domains              Name: Domains                        Version: 1.7.0      State: Not activated
    environment          Name: Environment                    Version: 1.9.0      State: Not activated
    formcreator          Name: Formularze                     Version: 0.90-1.3.3 State: Not activated
    fusioninventory      Name: FusionInventory                Version: 0.90+1.3   State: Not activated
    accounts             Name: Konta                          Version: 2.1.1      State: Not activated
    monitoring           Name: Monitoring                     Version: 0.90+1.1   State: Not activated
    mreporting           Name: More Reporting                 Version: 0.90+1.1   State: Not activated
    archires             Name: Network Architectures          Version: 2.3        State: Not activated
    order                Name: Orders management              Version: 0.85+1.1   State: Not activated
    reports              Name: Raporty                        Version: 1.9.1      State: Not activated
    shellcommands        Name: Shell Commands                 Version: 1.9.1      State: Not activated
    tasklists            Name: Tasks list                     Version: 1.0.0      State: Not activated
    webservices          Name: Web Services                   Version: 1.6.0      State: Not activated
    racks                Name: Zarządzanie szafami Rack       Version: 1.6.1      State: Not activated

[/code]

I tried to get Debug mode, but with this error, debug mode is not working :/ No errors in glpi/files/_log No errors in apache logs - /var/log/httpd/

Don't know what to do. I can add new 'notification', but can't display it after saving.

pszafer commented 8 years ago

Just for information. Updated to 0.90.5, all plugins disables, error still occurs...

flegastelois commented 8 years ago

Hi,

Can you give us the results of these SQL queries :

Regards,

tomolimo commented 8 years ago

Hello, Could you check again the mySQL DB? What was the crashed table name? What are the error messages in the php-errors.log and in sql-errors.log? Thank you, regards, Tomolimo

pszafer commented 8 years ago

@flegastelois glpi_sql_issue838.pdf

@tomolimo - there is no logged errors in sql-errors.log and php-errors.log during update process.

Here is result of mysqlcheck. Currently we use plugins (I reenabled them):

Other tables you see like OCSNG, Monitoring - we are not using it anymore.

Mysqlcheck.txt:

glpi.glpi_alerts                                   OK
glpi.glpi_apiclients                               OK
glpi.glpi_authldapreplicates                       OK
glpi.glpi_authldaps                                OK
glpi.glpi_authmails                                OK
glpi.glpi_autoupdatesystems                        OK
glpi.glpi_blacklistedmailcontents                  OK
glpi.glpi_blacklists                               OK
glpi.glpi_bookmarks                                OK
glpi.glpi_bookmarks_users                          OK
glpi.glpi_budgets                                  OK
glpi.glpi_budgettypes                              OK
glpi.glpi_calendars                                OK
glpi.glpi_calendars_holidays                       OK
glpi.glpi_calendarsegments                         OK
glpi.glpi_cartridgeitems                           OK
glpi.glpi_cartridgeitems_printermodels             OK
glpi.glpi_cartridgeitemtypes                       OK
glpi.glpi_cartridges                               OK
glpi.glpi_changecosts                              OK
glpi.glpi_changes                                  OK
glpi.glpi_changes_groups                           OK
glpi.glpi_changes_items                            OK
glpi.glpi_changes_problems                         OK
glpi.glpi_changes_projects                         OK
glpi.glpi_changes_suppliers                        OK
glpi.glpi_changes_tickets                          OK
glpi.glpi_changes_users                            OK
glpi.glpi_changetasks                              OK
glpi.glpi_changevalidations                        OK
glpi.glpi_computerantiviruses                      OK
glpi.glpi_computerdisks                            OK
glpi.glpi_computermodels                           OK
glpi.glpi_computers                                OK
glpi.glpi_computers_items                          OK
glpi.glpi_computers_softwarelicenses               OK
glpi.glpi_computers_softwareversions               OK
glpi.glpi_computertypes                            OK
glpi.glpi_computervirtualmachines                  OK
glpi.glpi_configs                                  OK
glpi.glpi_consumableitems                          OK
glpi.glpi_consumableitemtypes                      OK
glpi.glpi_consumables                              OK
glpi.glpi_contacts                                 OK
glpi.glpi_contacts_suppliers                       OK
glpi.glpi_contacttypes                             OK
glpi.glpi_contractcosts                            OK
glpi.glpi_contracts                                OK
glpi.glpi_contracts_items                          OK
glpi.glpi_contracts_suppliers                      OK
glpi.glpi_contracttypes                            OK
glpi.glpi_crontasklogs                             OK
glpi.glpi_crontasks                                OK
glpi.glpi_devicecases                              OK
glpi.glpi_devicecasetypes                          OK
glpi.glpi_devicecontrols                           OK
glpi.glpi_devicedrives                             OK
glpi.glpi_devicegraphiccards                       OK
glpi.glpi_deviceharddrives                         OK
glpi.glpi_devicememories                           OK
glpi.glpi_devicememorytypes                        OK
glpi.glpi_devicemotherboards                       OK
glpi.glpi_devicenetworkcards                       OK
glpi.glpi_devicepcis                               OK
glpi.glpi_devicepowersupplies                      OK
glpi.glpi_deviceprocessors                         OK
glpi.glpi_devicesoundcards                         OK
glpi.glpi_displaypreferences                       OK
glpi.glpi_documentcategories                       OK
glpi.glpi_documents                                OK
glpi.glpi_documents_items                          OK
glpi.glpi_documenttypes                            OK
glpi.glpi_domains                                  OK
glpi.glpi_dropdowntranslations                     OK
glpi.glpi_entities                                 OK
glpi.glpi_entities_knowbaseitems                   OK
glpi.glpi_entities_reminders                       OK
glpi.glpi_entities_rssfeeds                        OK
glpi.glpi_events                                   OK
glpi.glpi_fieldblacklists                          OK
glpi.glpi_fieldunicities                           OK
glpi.glpi_filesystems                              OK
glpi.glpi_fqdns                                    OK
glpi.glpi_groups                                   OK
glpi.glpi_groups_knowbaseitems                     OK
glpi.glpi_groups_problems                          OK
glpi.glpi_groups_reminders                         OK
glpi.glpi_groups_rssfeeds                          OK
glpi.glpi_groups_tickets                           OK
glpi.glpi_groups_users                             OK
glpi.glpi_holidays                                 OK
glpi.glpi_infocoms                                 OK
glpi.glpi_interfacetypes                           OK
glpi.glpi_ipaddresses                              OK
glpi.glpi_ipaddresses_ipnetworks                   OK
glpi.glpi_ipnetworks                               OK
glpi.glpi_ipnetworks_vlans                         OK
glpi.glpi_items_devicecases                        OK
glpi.glpi_items_devicecontrols                     OK
glpi.glpi_items_devicedrives                       OK
glpi.glpi_items_devicegraphiccards                 OK
glpi.glpi_items_deviceharddrives                   OK
glpi.glpi_items_devicememories                     OK
glpi.glpi_items_devicemotherboards                 OK
glpi.glpi_items_devicenetworkcards                 OK
glpi.glpi_items_devicepcis                         OK
glpi.glpi_items_devicepowersupplies                OK
glpi.glpi_items_deviceprocessors                   OK
glpi.glpi_items_devicesoundcards                   OK
glpi.glpi_items_problems                           OK
glpi.glpi_items_projects                           OK
glpi.glpi_items_tickets                            OK
glpi.glpi_itilcategories                           OK
glpi.glpi_knowbaseitemcategories                   OK
glpi.glpi_knowbaseitems                            OK
glpi.glpi_knowbaseitems_profiles                   OK
glpi.glpi_knowbaseitems_users                      OK
glpi.glpi_knowbaseitemtranslations                 OK
glpi.glpi_links                                    OK
glpi.glpi_links_itemtypes                          OK
glpi.glpi_locations                                OK
glpi.glpi_logs                                     OK
glpi.glpi_mailcollectors                           OK
glpi.glpi_manufacturers                            OK
glpi.glpi_monitormodels                            OK
glpi.glpi_monitors                                 OK
glpi.glpi_monitortypes                             OK
glpi.glpi_netpoints                                OK
glpi.glpi_networkaliases                           OK
glpi.glpi_networkequipmentfirmwares                OK
glpi.glpi_networkequipmentmodels                   OK
glpi.glpi_networkequipments                        OK
glpi.glpi_networkequipmenttypes                    OK
glpi.glpi_networkinterfaces                        OK
glpi.glpi_networknames                             OK
glpi.glpi_networkportaggregates                    OK
glpi.glpi_networkportaliases                       OK
glpi.glpi_networkportdialups                       OK
glpi.glpi_networkportethernets                     OK
glpi.glpi_networkportfiberchannels                 OK
glpi.glpi_networkportlocals                        OK
glpi.glpi_networkports                             OK
glpi.glpi_networkports_networkports                OK
glpi.glpi_networkports_vlans                       OK
glpi.glpi_networkportwifis                         OK
glpi.glpi_networks                                 OK
glpi.glpi_notepads                                 OK
glpi.glpi_notifications                            OK
glpi.glpi_notificationtargets                      OK
glpi.glpi_notificationtemplates                    OK
glpi.glpi_notificationtemplatetranslations         OK
glpi.glpi_notimportedemails                        OK
glpi.glpi_objectlocks                              OK
glpi.glpi_operatingsystemarchitectures             OK
glpi.glpi_operatingsystems                         OK
glpi.glpi_operatingsystemservicepacks              OK
glpi.glpi_operatingsystemversions                  OK
glpi.glpi_peripheralmodels                         OK
glpi.glpi_peripherals                              OK
glpi.glpi_peripheraltypes                          OK
glpi.glpi_phonemodels                              OK
glpi.glpi_phonepowersupplies                       OK
glpi.glpi_phones                                   OK
glpi.glpi_phonetypes                               OK
glpi.glpi_planningrecalls                          OK
glpi.glpi_plugin_accounts_accounts                 OK
glpi.glpi_plugin_accounts_accounts_items           OK
glpi.glpi_plugin_accounts_accountstates            OK
glpi.glpi_plugin_accounts_accounttypes             OK
glpi.glpi_plugin_accounts_aeskeys                  OK
glpi.glpi_plugin_accounts_configs                  OK
glpi.glpi_plugin_accounts_hashes                   OK
glpi.glpi_plugin_accounts_notificationstates       OK
glpi.glpi_plugin_addressing_addressings            OK
glpi.glpi_plugin_addressing_configs                OK
glpi.glpi_plugin_addressing_profiles               OK
glpi.glpi_plugin_archires_appliancequeries         OK
glpi.glpi_plugin_archires_imageitems               OK
glpi.glpi_plugin_archires_locationqueries          OK
glpi.glpi_plugin_archires_networkequipmentqueries  OK
glpi.glpi_plugin_archires_networkinterfacecolors   OK
glpi.glpi_plugin_archires_querytypes               OK
glpi.glpi_plugin_archires_statecolors              OK
glpi.glpi_plugin_archires_views                    OK
glpi.glpi_plugin_archires_vlancolors               OK
glpi.glpi_plugin_badges_badges                     OK
glpi.glpi_plugin_badges_badgetypes                 OK
glpi.glpi_plugin_badges_configs                    OK
glpi.glpi_plugin_badges_notificationstates         OK
glpi.glpi_plugin_badges_requests                   OK
glpi.glpi_plugin_barcode_configs                   OK
glpi.glpi_plugin_barcode_configs_types             OK
glpi.glpi_plugin_barcode_profiles                  OK
glpi.glpi_plugin_certificates_certificates         OK
glpi.glpi_plugin_certificates_certificates_items   OK
glpi.glpi_plugin_certificates_certificatestates    OK
glpi.glpi_plugin_certificates_certificatetypes     OK
glpi.glpi_plugin_certificates_configs              OK
glpi.glpi_plugin_certificates_notificationstates   OK
glpi.glpi_plugin_dashboard_config                  OK
glpi.glpi_plugin_dashboard_count                   OK
glpi.glpi_plugin_dashboard_map                     OK
glpi.glpi_plugin_databases_databasecategories      OK
glpi.glpi_plugin_databases_databases               OK
glpi.glpi_plugin_databases_databases_items         OK
glpi.glpi_plugin_databases_databasetypes           OK
glpi.glpi_plugin_databases_instances               OK
glpi.glpi_plugin_databases_scripts                 OK
glpi.glpi_plugin_databases_scripttypes             OK
glpi.glpi_plugin_databases_servertypes             OK
glpi.glpi_plugin_domains_configs                   OK
glpi.glpi_plugin_domains_domains                   OK
glpi.glpi_plugin_domains_domains_items             OK
glpi.glpi_plugin_domains_domaintypes               OK
glpi.glpi_plugin_financialreports_configs          OK
glpi.glpi_plugin_financialreports_disposalitems    OK
glpi.glpi_plugin_financialreports_parameters       OK
glpi.glpi_plugin_formcreator_answers               OK
glpi.glpi_plugin_formcreator_categories            OK
glpi.glpi_plugin_formcreator_formanswers           OK
glpi.glpi_plugin_formcreator_formprofiles          OK
glpi.glpi_plugin_formcreator_forms                 OK
glpi.glpi_plugin_formcreator_formvalidators        OK
glpi.glpi_plugin_formcreator_headers               OK
glpi.glpi_plugin_formcreator_questions             OK
glpi.glpi_plugin_formcreator_questions_conditions  OK
glpi.glpi_plugin_formcreator_sections              OK
glpi.glpi_plugin_formcreator_targets               OK
glpi.glpi_plugin_formcreator_targettickets         OK
glpi.glpi_plugin_formcreator_targettickets_actors  OK
glpi.glpi_plugin_fusioninventory_agentmodules      OK
glpi.glpi_plugin_fusioninventory_agents            OK
glpi.glpi_plugin_fusioninventory_collects          OK
glpi.glpi_plugin_fusioninventory_collects_files    OK
glpi.glpi_plugin_fusioninventory_collects_files_contents OK
glpi.glpi_plugin_fusioninventory_collects_registries OK
glpi.glpi_plugin_fusioninventory_collects_registries_contents OK
glpi.glpi_plugin_fusioninventory_collects_wmis     OK
glpi.glpi_plugin_fusioninventory_collects_wmis_contents OK
glpi.glpi_plugin_fusioninventory_computerarchs     OK
glpi.glpi_plugin_fusioninventory_computerlicenseinfos OK
glpi.glpi_plugin_fusioninventory_configlogfields   OK
glpi.glpi_plugin_fusioninventory_configs           OK
glpi.glpi_plugin_fusioninventory_configsecurities  OK
glpi.glpi_plugin_fusioninventory_credentialips     OK
glpi.glpi_plugin_fusioninventory_credentials       OK
glpi.glpi_plugin_fusioninventory_dblockinventories
note     : The storage engine for the table doesn't support check
glpi.glpi_plugin_fusioninventory_dblockinventorynames
note     : The storage engine for the table doesn't support check
glpi.glpi_plugin_fusioninventory_dblocksoftwares
note     : The storage engine for the table doesn't support check
glpi.glpi_plugin_fusioninventory_dblocksoftwareversions
note     : The storage engine for the table doesn't support check
glpi.glpi_plugin_fusioninventory_deployfiles       OK
glpi.glpi_plugin_fusioninventory_deploygroups      OK
glpi.glpi_plugin_fusioninventory_deploygroups_dynamicdatas OK
glpi.glpi_plugin_fusioninventory_deploygroups_staticdatas OK
glpi.glpi_plugin_fusioninventory_deploymirrors     OK
glpi.glpi_plugin_fusioninventory_deployorders      OK
glpi.glpi_plugin_fusioninventory_deploypackages    OK
glpi.glpi_plugin_fusioninventory_entities          OK
glpi.glpi_plugin_fusioninventory_ignoredimportdevices OK
glpi.glpi_plugin_fusioninventory_inventorycomputerantiviruses OK
glpi.glpi_plugin_fusioninventory_inventorycomputerbatteries OK
glpi.glpi_plugin_fusioninventory_inventorycomputerblacklists OK
glpi.glpi_plugin_fusioninventory_inventorycomputerchemistries OK
glpi.glpi_plugin_fusioninventory_inventorycomputercomputers OK
glpi.glpi_plugin_fusioninventory_inventorycomputercriterias OK
glpi.glpi_plugin_fusioninventory_inventorycomputerstats OK
glpi.glpi_plugin_fusioninventory_inventorycomputerstorages OK
glpi.glpi_plugin_fusioninventory_inventorycomputerstorages_storages OK
glpi.glpi_plugin_fusioninventory_inventorycomputerstoragetypes OK
glpi.glpi_plugin_fusioninventory_ipranges          OK
glpi.glpi_plugin_fusioninventory_ipranges_configsecurities OK
glpi.glpi_plugin_fusioninventory_locks             OK
glpi.glpi_plugin_fusioninventory_mappings          OK
glpi.glpi_plugin_fusioninventory_networkequipments OK
glpi.glpi_plugin_fusioninventory_networkportconnectionlogs OK
glpi.glpi_plugin_fusioninventory_networkportlogs   OK
glpi.glpi_plugin_fusioninventory_networkports      OK
glpi.glpi_plugin_fusioninventory_networkporttypes  OK
glpi.glpi_plugin_fusioninventory_ouis              OK
glpi.glpi_plugin_fusioninventory_pcidevices        OK
glpi.glpi_plugin_fusioninventory_pcivendors        OK
glpi.glpi_plugin_fusioninventory_printercartridges OK
glpi.glpi_plugin_fusioninventory_printerlogs       OK
glpi.glpi_plugin_fusioninventory_printers          OK
glpi.glpi_plugin_fusioninventory_rulematchedlogs   OK
glpi.glpi_plugin_fusioninventory_statediscoveries  OK
glpi.glpi_plugin_fusioninventory_taskjoblogs       OK
glpi.glpi_plugin_fusioninventory_taskjobs          OK
glpi.glpi_plugin_fusioninventory_taskjobstates     OK
glpi.glpi_plugin_fusioninventory_tasks             OK
glpi.glpi_plugin_fusioninventory_timeslotentries   OK
glpi.glpi_plugin_fusioninventory_timeslots         OK
glpi.glpi_plugin_fusioninventory_unmanageds        OK
glpi.glpi_plugin_fusioninventory_usbdevices        OK
glpi.glpi_plugin_fusioninventory_usbvendors        OK
glpi.glpi_plugin_monitoring_acknowledges           OK
glpi.glpi_plugin_monitoring_businessrulegroups     OK
glpi.glpi_plugin_monitoring_businessrules          OK
glpi.glpi_plugin_monitoring_businessrules_components OK
glpi.glpi_plugin_monitoring_checks                 OK
glpi.glpi_plugin_monitoring_commands               OK
glpi.glpi_plugin_monitoring_commandtemplates       OK
glpi.glpi_plugin_monitoring_components             OK
glpi.glpi_plugin_monitoring_componentscatalogs     OK
glpi.glpi_plugin_monitoring_componentscatalogs_components OK
glpi.glpi_plugin_monitoring_componentscatalogs_hosts OK
glpi.glpi_plugin_monitoring_componentscatalogs_rules OK
glpi.glpi_plugin_monitoring_configs                OK
glpi.glpi_plugin_monitoring_contactgroups          OK
glpi.glpi_plugin_monitoring_contactgroups_contactgroups OK
glpi.glpi_plugin_monitoring_contacts               OK
glpi.glpi_plugin_monitoring_contacts_contactgroups OK
glpi.glpi_plugin_monitoring_contacts_items         OK
glpi.glpi_plugin_monitoring_contacttemplates       OK
glpi.glpi_plugin_monitoring_customitems_counters   OK
glpi.glpi_plugin_monitoring_customitems_gauges     OK
glpi.glpi_plugin_monitoring_displayviews           OK
glpi.glpi_plugin_monitoring_displayviews_groups    OK
glpi.glpi_plugin_monitoring_displayviews_items     OK
glpi.glpi_plugin_monitoring_displayviews_rules     OK
glpi.glpi_plugin_monitoring_displayviews_users     OK
glpi.glpi_plugin_monitoring_downtimes              OK
glpi.glpi_plugin_monitoring_entities               OK
glpi.glpi_plugin_monitoring_eventhandlers          OK
glpi.glpi_plugin_monitoring_hostaddresses          OK
glpi.glpi_plugin_monitoring_hostconfigs            OK
glpi.glpi_plugin_monitoring_hostcounters           OK
glpi.glpi_plugin_monitoring_hostdailycounters      OK
glpi.glpi_plugin_monitoring_hostnotificationtemplates OK
glpi.glpi_plugin_monitoring_hosts                  OK
glpi.glpi_plugin_monitoring_logs                   OK
glpi.glpi_plugin_monitoring_networkports           OK
glpi.glpi_plugin_monitoring_notificationcommands   OK
glpi.glpi_plugin_monitoring_perfdatadetails        OK
glpi.glpi_plugin_monitoring_perfdatas              OK
glpi.glpi_plugin_monitoring_profiles               OK
glpi.glpi_plugin_monitoring_realms                 OK
glpi.glpi_plugin_monitoring_redirecthomes          OK
glpi.glpi_plugin_monitoring_rrdtooltemplates       OK
glpi.glpi_plugin_monitoring_servicedefs            OK
glpi.glpi_plugin_monitoring_serviceevents          OK
glpi.glpi_plugin_monitoring_servicenotificationtemplates OK
glpi.glpi_plugin_monitoring_services               OK
glpi.glpi_plugin_monitoring_servicescatalogs       OK
glpi.glpi_plugin_monitoring_shinkenstates          OK
glpi.glpi_plugin_monitoring_shinkenwebservices     OK
glpi.glpi_plugin_monitoring_sliders                OK
glpi.glpi_plugin_monitoring_sliders_groups         OK
glpi.glpi_plugin_monitoring_sliders_items          OK
glpi.glpi_plugin_monitoring_sliders_users          OK
glpi.glpi_plugin_monitoring_tags                   OK
glpi.glpi_plugin_monitoring_unavaibilities         OK
glpi.glpi_plugin_monitoring_unavailabilities       OK
glpi.glpi_plugin_monitoring_unavailabilitystates   OK
glpi.glpi_plugin_monitoring_weathermaplinks        OK
glpi.glpi_plugin_monitoring_weathermapnodes        OK
glpi.glpi_plugin_monitoring_weathermaps            OK
glpi.glpi_plugin_mreporting_configs                OK
glpi.glpi_plugin_mreporting_dashboards             OK
glpi.glpi_plugin_mreporting_notifications          OK
glpi.glpi_plugin_mreporting_preferences            OK
glpi.glpi_plugin_mreporting_profiles               OK
glpi.glpi_plugin_ocsinventoryng_configs            OK
glpi.glpi_plugin_ocsinventoryng_details            OK
glpi.glpi_plugin_ocsinventoryng_networkports       OK
glpi.glpi_plugin_ocsinventoryng_networkporttypes   OK
glpi.glpi_plugin_ocsinventoryng_notimportedcomputers OK
glpi.glpi_plugin_ocsinventoryng_ocsadmininfoslinks OK
glpi.glpi_plugin_ocsinventoryng_ocslinks           OK
glpi.glpi_plugin_ocsinventoryng_ocsservers         OK
glpi.glpi_plugin_ocsinventoryng_profiles           OK
glpi.glpi_plugin_ocsinventoryng_registrykeys       OK
glpi.glpi_plugin_ocsinventoryng_servers            OK
glpi.glpi_plugin_ocsinventoryng_threads            OK
glpi.glpi_plugin_order_bills                       OK
glpi.glpi_plugin_order_billstates                  OK
glpi.glpi_plugin_order_billtypes                   OK
glpi.glpi_plugin_order_configs                     OK
glpi.glpi_plugin_order_deliverystates              OK
glpi.glpi_plugin_order_documentcategories          OK
glpi.glpi_plugin_order_orderpayments               OK
glpi.glpi_plugin_order_orders                      OK
glpi.glpi_plugin_order_orders_items                OK
glpi.glpi_plugin_order_orders_suppliers            OK
glpi.glpi_plugin_order_orderstates                 OK
glpi.glpi_plugin_order_ordertaxes                  OK
glpi.glpi_plugin_order_ordertypes                  OK
glpi.glpi_plugin_order_others                      OK
glpi.glpi_plugin_order_othertypes                  OK
glpi.glpi_plugin_order_preferences                 OK
glpi.glpi_plugin_order_references                  OK
glpi.glpi_plugin_order_references_suppliers        OK
glpi.glpi_plugin_order_surveysuppliers             OK
glpi.glpi_plugin_pdf_preferences                   OK
glpi.glpi_plugin_pdf_profiles                      OK
glpi.glpi_plugin_racks_configs                     OK
glpi.glpi_plugin_racks_connections                 OK
glpi.glpi_plugin_racks_itemspecifications          OK
glpi.glpi_plugin_racks_othermodels                 OK
glpi.glpi_plugin_racks_others                      OK
glpi.glpi_plugin_racks_rackmodels                  OK
glpi.glpi_plugin_racks_racks                       OK
glpi.glpi_plugin_racks_racks_items                 OK
glpi.glpi_plugin_racks_rackstates                  OK
glpi.glpi_plugin_racks_racktypes                   OK
glpi.glpi_plugin_racks_roomlocations               OK
glpi.glpi_plugin_shellcommands_commandgroups       OK
glpi.glpi_plugin_shellcommands_commandgroups_items OK
glpi.glpi_plugin_shellcommands_profiles            OK
glpi.glpi_plugin_shellcommands_shellcommandpaths   OK
glpi.glpi_plugin_shellcommands_shellcommands       OK
glpi.glpi_plugin_shellcommands_shellcommands_items OK
glpi.glpi_plugin_tasklists_tasks                   OK
glpi.glpi_plugin_tasklists_tasktypes               OK
glpi.glpi_plugin_treeview_configs                  OK
glpi.glpi_plugin_treeview_preferences              OK
glpi.glpi_plugin_treeview_profiles                 OK
glpi.glpi_plugin_utilitaires_profiles              OK
glpi.glpi_plugin_webapplications_webapplications   OK
glpi.glpi_plugin_webapplications_webapplications_items OK
glpi.glpi_plugin_webapplications_webapplicationservertypes OK
glpi.glpi_plugin_webapplications_webapplicationtechnics OK
glpi.glpi_plugin_webapplications_webapplicationtypes OK
glpi.glpi_plugin_webservices_clients               OK
glpi.glpi_plugins                                  OK
glpi.glpi_printermodels                            OK
glpi.glpi_printers                                 OK
glpi.glpi_printertypes                             OK
glpi.glpi_problemcosts                             OK
glpi.glpi_problems                                 OK
glpi.glpi_problems_suppliers                       OK
glpi.glpi_problems_tickets                         OK
glpi.glpi_problems_users                           OK
glpi.glpi_problemtasks                             OK
glpi.glpi_profilerights                            OK
glpi.glpi_profiles                                 OK
glpi.glpi_profiles_reminders                       OK
glpi.glpi_profiles_rssfeeds                        OK
glpi.glpi_profiles_users                           OK
glpi.glpi_projectcosts                             OK
glpi.glpi_projects                                 OK
glpi.glpi_projectstates                            OK
glpi.glpi_projecttasks                             OK
glpi.glpi_projecttasks_tickets                     OK
glpi.glpi_projecttaskteams                         OK
glpi.glpi_projecttasktypes                         OK
glpi.glpi_projectteams                             OK
glpi.glpi_projecttypes                             OK
glpi.glpi_queuedmails                              OK
glpi.glpi_registeredids                            OK
glpi.glpi_reminders                                OK
glpi.glpi_reminders_users                          OK
glpi.glpi_requesttypes                             OK
glpi.glpi_reservationitems                         OK
glpi.glpi_reservations                             OK
glpi.glpi_rssfeeds                                 OK
glpi.glpi_rssfeeds_users                           OK
glpi.glpi_ruleactions                              OK
glpi.glpi_rulecriterias                            OK
glpi.glpi_rulerightparameters                      OK
glpi.glpi_rules                                    OK
glpi.glpi_slalevelactions                          OK
glpi.glpi_slalevelcriterias                        OK
glpi.glpi_slalevels                                OK
glpi.glpi_slalevels_tickets                        OK
glpi.glpi_slas                                     OK
glpi.glpi_slts                                     OK
glpi.glpi_softwarecategories                       OK
glpi.glpi_softwarelicenses                         OK
glpi.glpi_softwarelicensetypes                     OK
glpi.glpi_softwares                                OK
glpi.glpi_softwareversions                         OK
glpi.glpi_solutiontemplates                        OK
glpi.glpi_solutiontypes                            OK
glpi.glpi_ssovariables                             OK
glpi.glpi_states                                   OK
glpi.glpi_suppliers                                OK
glpi.glpi_suppliers_tickets                        OK
glpi.glpi_suppliertypes                            OK
glpi.glpi_taskcategories                           OK
glpi.glpi_tasktemplates                            OK
glpi.glpi_ticketcosts                              OK
glpi.glpi_ticketfollowups                          OK
glpi.glpi_ticketrecurrents                         OK
glpi.glpi_tickets                                  OK
glpi.glpi_tickets_tickets                          OK
glpi.glpi_tickets_users                            OK
glpi.glpi_ticketsatisfactions                      OK
glpi.glpi_tickettasks                              OK
glpi.glpi_tickettemplatehiddenfields               OK
glpi.glpi_tickettemplatemandatoryfields            OK
glpi.glpi_tickettemplatepredefinedfields           OK
glpi.glpi_tickettemplates                          OK
glpi.glpi_ticketvalidations                        OK
glpi.glpi_transfers                                OK
glpi.glpi_usercategories                           OK
glpi.glpi_useremails                               OK
glpi.glpi_users                                    OK
glpi.glpi_usertitles                               OK
glpi.glpi_virtualmachinestates                     OK
glpi.glpi_virtualmachinesystems                    OK
glpi.glpi_virtualmachinetypes                      OK
glpi.glpi_vlans                                    OK
glpi.glpi_wifinetworks                             OK
tomolimo commented 8 years ago

You should also have a migration_to_0.90.5.log

tomolimo commented 8 years ago

and may be a migration_to_0.90.4.log

tomolimo commented 8 years ago

You may try to replay the migration from 0.90.3 to 0.90.4, doing the following:

  1. go to table glpi_configs
  2. select record with context = 'core' and name = 'version' (should be id=1)
  3. change value from 0.90.5 to 0.90.3
  4. reload glpi home page, you should be asked to migrate

regards, Tomolimo

pszafer commented 8 years ago

@tomolimo - migration log shows only 0 seconds for all records, it is cutted at line:

0 seconds for "optimize - glpi_vlans" @ 2016-08-09 10:26:42 [32@glpi.poznan.tbhydro.net]
0 seconds for "optimize - glpi_wifinetworks" @
~

do you want full log?

and screencast of updating glpi 'emulated 0.90.3' to 0.90.5. as you see no errors, but notifications still have security die. https://youtu.be/cj1UaZTG-0o

flegastelois commented 8 years ago

You have an entry with "itemtype=0" in glpi_notifications table : that causes your error.

You can remove this line with this query :

Regards,

pszafer commented 8 years ago

thank you very much for help! Working again :)