search

OCSInventory-NG / OCSInventory-ocsreports

Webconsole for OCS Inventory NG
https://www.ocsinventory-ng.org
GNU General Public License v2.0
232 stars 151 forks source link

Search with various Criteria doesn't show results #74

Closed ids-itsupport closed 8 years ago

ids-itsupport commented 8 years ago

We've set up a new OCS Server 2.2 Unix Installation ob Debian. It seems that everything works fine, but the "Search with various Criteria" doesn't show any results, no matter which search condition we insert. ocsinventory_search_error

We tried to gather debug information by the activation of LogLevel in the Webinterface (Config->Server) and setting " PerlSetEnv OCS_OPT_DBI_PRINT_ERROR 1". I've attached the access and error log of apache.

access_ocsinventory.txt error_ocsinventory.txt

gillesdubois commented 8 years ago

Hi,

Your access and error log show nothing.

Can you provide these informations : Did you try with an other browser ? Debian version ? What php version is installed on your server ? Can you take a screenshot of your bug with the debug mode enable ?

Regards, Gilles Dubois.

ids-itsupport commented 8 years ago

Hi Gilles, thanks for the quick reply.

We've tried it with IE, Chrome and Firefox. All Browsers showed the same empty result. We're using Debian 8.4 with PHP 5.6.19

I've tried to setup debug mode as written in the doc: To use this functionality, you have to activate log function from administration console (LOGLEVEL), and modify server configuration file z-ocsinventory-server.conf to set OCS_OPT_DBI_PRINT_ERROR option to 1. But the output at log and screen is that what I've attached to the first post. So what can i do to provide better debug informations?

Thank you! Simon

gillesdubois commented 8 years ago

You can toggle the debug mode on the ocs reports to know what sql query and data are used on the page.

To activate it you just need to click on the settings icon on top right of the webconsole and then select your running mode (debug)

debug_mode

When it's done just make a multi search and paste the output of the debug mode here

Regards, Gilles Dubois.

ids-itsupport commented 8 years ago

Thank you. Sorry I've not noticed this switch in webconsole before... Hope this information are helpful.

[DEBUG]RAW DATAS[DEBUG] 0 => SOFTWARES [DEBUG]table field=[DEBUG] 0 => NAME [DEBUG]Comparison field=[DEBUG] 0 => ressemble [DEBUG]value to search=[DEBUG] 0 => %Quicktime% [DEBUG]Complementary field=[DEBUG] [DEBUG]AND OR Field=[DEBUG] [DEBUG]table =>[DEBUG]SOFTWARES [DEBUG]filed =>[DEBUG]NAME [DEBUG]comparison =>[DEBUG] IN [DEBUG]value to search =>[DEBUG]('3Dconnexion Plug-in for QuickTime VR','QuickTime','QuickTime 7') [DEBUG]complementary field =>[DEBUG] [DEBUG]AND_OR =>[DEBUG] [DEBUG]NORMAL CONDITION REQUEST[DEBUG]

[DEBUG]REQUEST MADE => [DEBUG] select distinct HARDWARE_ID,softwares.PUBLISHER as 'Software: Company',softwares.NAME as 'Software: Name',softwares.VERSION as 'Software: Version',softwares.FOLDER as 'Software: Install directory',softwares.COMMENTS as 'Software: Comments' from softwares where ( ( NAME IN ('3Dconnexion Plug-in for QuickTime VR','QuickTime','QuickTime 7'))) [DEBUG] => weight: [DEBUG]10

[DEBUG]REQUEST MADE => [DEBUG] select NAME,IVALUE,TVALUE,COMMENTS from config where NAME in ( 'LOG_GUI', 'LOG_DIR', 'LOG_SCRIPT' ) SELECT id,user_group FROM operators WHERE id='admin' and passwd ='21232f297a57a5a743894a0e4a801fc3' select ID,TYPE,NAME,COMMENT from accountinfo_config where account_type = 'COMPUTERS' select id from hardware where deviceid <> 'SYSTEMGROUP' AND deviceid <> 'DOWNLOADGROUP' AND id in ( '309', '838', '901', '2409', '267', '820', '1766', '2763', '2880', '2900' ) select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config order by show_order DESC select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=4 order by show_order DESC select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=1 order by show_order DESC select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=2 order by show_order DESC select id from hardware where deviceid <> 'SYSTEMGROUP' AND deviceid <> 'DOWNLOADGROUP' AND id in ( '309', '838', '901', '2409', '267', '820', '1766', '2763', '2880', '2900' )

VAR POST CSRF_86 4a0c14290ad8e48d0aaa7144d588e248a409df1f multiSearch Choose SelComp-SOFTWARES-NAME-0 ressemble InputValue-SOFTWARES-NAME-0 %Quicktime% Valid-search Search Valid VALID delfield
reset

AR SESSION LOG_DIR /var/lib/ocsinventory-reports/logs/ LOG_GUI OLD_CONF_DIR /var/www/html//scripts/ CONF_PROFILS_DIR /usr/share/ocsinventory-reports/ocsreports//usr/share/ocsinventory-reports/ocsreports/plugins/main_sections/conf/ SQL_BASE_VERS 7009 SQL_TABLE
accesslog
ID ID HARDWARE_ID HARDWARE_ID USERID USERID LOGDATE LOGDATE PROCESSES PROCESSES accountinfo HARDWARE_ID HARDWARE_ID TAG TAG fields_4 fields_4 accountinfo_config
ID ID NAME_ACCOUNTINFO NAME_ACCOUNTINFO TYPE TYPE NAME NAME ID_TAB ID_TAB COMMENT COMMENT SHOW_ORDER SHOW_ORDER ACCOUNT_TYPE ACCOUNT_TYPE DEFAULT_VALUE DEFAULT_VALUE batteries
ID ID HARDWARE_ID HARDWARE_ID LOCATION LOCATION MANUFACTURER MANUFACTURER MANUFACTUREDATE MANUFACTUREDATE SERIALNUMBER SERIALNUMBER NAME NAME CHEMISTRY CHEMISTRY DESIGNCAPACITY DESIGNCAPACITY DESIGNVOLTAGE DESIGNVOLTAGE SBDSVERSION SBDSVERSION MAXERROR MAXERROR OEMSPECIFIC OEMSPECIFIC bios
HARDWARE_ID HARDWARE_ID SMANUFACTURER SMANUFACTURER SMODEL SMODEL SSN SSN TYPE TYPE BMANUFACTURER BMANUFACTURER BVERSION BVERSION BDATE BDATE ASSETTAG ASSETTAG MMANUFACTURER MMANUFACTURER MMODEL MMODEL MSN MSN blacklist_macaddresses
ID ID MACADDRESS MACADDRESS blacklist_serials
ID ID SERIAL SERIAL blacklist_subnet
ID ID SUBNET SUBNET MASK MASK config
NAME NAME IVALUE IVALUE TVALUE TVALUE COMMENTS COMMENTS conntrack
IP IP TIMESTAMP TIMESTAMP controllers ID ID HARDWARE_ID HARDWARE_ID MANUFACTURER MANUFACTURER NAME NAME CAPTION CAPTION DESCRIPTION DESCRIPTION VERSION VERSION TYPE TYPE cpus
ID ID HARDWARE_ID HARDWARE_ID MANUFACTURER MANUFACTURER TYPE TYPE SERIALNUMBER SERIALNUMBER SPEED SPEED CORES CORES L2CACHESIZE L2CACHESIZE CPUARCH CPUARCH DATA_WIDTH DATA_WIDTH CURRENT_ADDRESS_WIDTH CURRENT_ADDRESS_WIDTH LOGICAL_CPUS LOGICAL_CPUS VOLTAGE VOLTAGE CURRENT_SPEED CURRENT_SPEED SOCKET SOCKET deleted_equiv
DATE DATE DELETED DELETED EQUIVALENT EQUIVALENT deploy
NAME NAME CONTENT CONTENT devices HARDWARE_ID HARDWARE_ID NAME NAME IVALUE IVALUE TVALUE TVALUE COMMENTS COMMENTS devicetype
ID ID NAME NAME dico_ignored
EXTRACTED EXTRACTED dico_soft
EXTRACTED EXTRACTED FORMATTED FORMATTED download_affect_rules
ID ID RULE RULE PRIORITY PRIORITY CFIELD CFIELD OP OP COMPTO COMPTO SERV_VALUE SERV_VALUE RULE_NAME RULE_NAME download_available
FILEID FILEID NAME NAME PRIORITY PRIORITY FRAGMENTS FRAGMENTS SIZE SIZE OSNAME OSNAME COMMENT COMMENT ID_WK ID_WK download_enable ID ID FILEID FILEID INFO_LOC INFO_LOC PACK_LOC PACK_LOC CERT_PATH CERT_PATH CERT_FILE CERT_FILE SERVER_ID SERVER_ID GROUP_ID GROUP_ID download_history
HARDWARE_ID HARDWARE_ID PKG_ID PKG_ID PKG_NAME PKG_NAME download_servers
HARDWARE_ID HARDWARE_ID URL URL ADD_PORT ADD_PORT ADD_REP ADD_REP GROUP_ID GROUP_ID downloadwk_conf_values
FIELD FIELD VALUE VALUE ID ID DEFAULT_FIELD DEFAULT_FIELD downloadwk_fields
TAB TAB FIELD FIELD TYPE TYPE LBL LBL MUST_COMPLETED MUST_COMPLETED ID ID VALUE VALUE DEFAULT_FIELD DEFAULT_FIELD RESTRICTED RESTRICTED LINK_STATUS LINK_STATUS downloadwk_history
ID ID ID_DDE ID_DDE AUTHOR AUTHOR DATE DATE ACTION ACTION downloadwk_pack ID ID LOGIN_USER LOGIN_USER GROUP_USER GROUP_USER Q_DATE Q_DATE fields_1 fields_1 fields_2 fields_2 fields_3 fields_3 fields_4 fields_4 fields_5 fields_5 fields_6 fields_6 fields_7 fields_7 fields_8 fields_8 fields_9 fields_9 fields_10 fields_10 downloadwk_statut_request
ID ID NAME NAME LBL LBL ACTIF ACTIF downloadwk_tab_values
FIELD FIELD VALUE VALUE LBL LBL ID ID DEFAULT_FIELD DEFAULT_FIELD drives
ID ID HARDWARE_ID HARDWARE_ID LETTER LETTER TYPE TYPE FILESYSTEM FILESYSTEM TOTAL TOTAL FREE FREE NUMFILES NUMFILES VOLUMN VOLUMN CREATEDATE CREATEDATE engine_mutex
NAME NAME PID PID TAG TAG engine_persistent
ID ID NAME NAME IVALUE IVALUE TVALUE TVALUE files
NAME NAME VERSION VERSION OS OS CONTENT CONTENT groups
HARDWARE_ID HARDWARE_ID REQUEST REQUEST CREATE_TIME CREATE_TIME REVALIDATE_FROM REVALIDATE_FROM XMLDEF XMLDEF groups_cache
HARDWARE_ID HARDWARE_ID GROUP_ID GROUP_ID STATIC STATIC hardware
ID ID DEVICEID DEVICEID NAME NAME WORKGROUP WORKGROUP USERDOMAIN USERDOMAIN OSNAME OSNAME OSVERSION OSVERSION OSCOMMENTS OSCOMMENTS PROCESSORT PROCESSORT PROCESSORS PROCESSORS PROCESSORN PROCESSORN MEMORY MEMORY SWAP SWAP IPADDR IPADDR DNS DNS DEFAULTGATEWAY DEFAULTGATEWAY ETIME ETIME LASTDATE LASTDATE LASTCOME LASTCOME QUALITY QUALITY FIDELITY FIDELITY USERID USERID TYPE TYPE DESCRIPTION DESCRIPTION WINCOMPANY WINCOMPANY WINOWNER WINOWNER WINPRODID WINPRODID WINPRODKEY WINPRODKEY USERAGENT USERAGENT CHECKSUM CHECKSUM SSTATE SSTATE IPSRC IPSRC UUID UUID ARCH ARCH hardware_osname_cache
ID ID OSNAME OSNAME inputs
ID ID HARDWARE_ID HARDWARE_ID TYPE TYPE MANUFACTURER MANUFACTURER CAPTION CAPTION DESCRIPTION DESCRIPTION INTERFACE INTERFACE POINTTYPE POINTTYPE itmgmt_comments ID ID HARDWARE_ID HARDWARE_ID COMMENTS COMMENTS USER_INSERT USER_INSERT DATE_INSERT DATE_INSERT ACTION ACTION VISIBLE VISIBLE javainfo
HARDWARE_ID HARDWARE_ID JAVANAME JAVANAME JAVAPATHLEVEL JAVAPATHLEVEL JAVACOUNTRY JAVACOUNTRY JAVACLASSPATH JAVACLASSPATH JAVAHOME JAVAHOME journallog
HARDWARE_ID HARDWARE_ID ID ID JOURNALLOG JOURNALLOG LISTENERNAME LISTENERNAME DATE DATE STATUS STATUS ERRORCODE ERRORCODE languages
NAME NAME IMG IMG JSON_VALUE JSON_VALUE locks
HARDWARE_ID HARDWARE_ID ID ID SINCE SINCE memories
ID ID HARDWARE_ID HARDWARE_ID CAPTION CAPTION DESCRIPTION DESCRIPTION CAPACITY CAPACITY PURPOSE PURPOSE TYPE TYPE SPEED SPEED NUMSLOTS NUMSLOTS SERIALNUMBER SERIALNUMBER modems
ID ID HARDWARE_ID HARDWARE_ID NAME NAME MODEL MODEL DESCRIPTION DESCRIPTION TYPE TYPE monitors
ID ID HARDWARE_ID HARDWARE_ID MANUFACTURER MANUFACTURER CAPTION CAPTION DESCRIPTION DESCRIPTION TYPE TYPE SERIAL SERIAL netmap
IP IP MAC MAC MASK MASK NETID NETID DATE DATE NAME NAME network_devices ID ID DESCRIPTION DESCRIPTION TYPE TYPE MACADDR MACADDR USER USER networks
ID ID HARDWARE_ID HARDWARE_ID DESCRIPTION DESCRIPTION TYPE TYPE TYPEMIB TYPEMIB SPEED SPEED MACADDR MACADDR STATUS STATUS IPADDRESS IPADDRESS IPMASK IPMASK IPGATEWAY IPGATEWAY IPSUBNET IPSUBNET IPDHCP IPDHCP VIRTUALDEV VIRTUALDEV officepack
ID ID HARDWARE_ID HARDWARE_ID OFFICEVERSION OFFICEVERSION PRODUCT PRODUCT PRODUCTID PRODUCTID TYPE TYPE OFFICEKEY OFFICEKEY GUID GUID INSTALL INSTALL NOTE NOTE officepack_lang LCID LCID LANG LANG officepack_sku
VERSION VERSION REF_ID REF_ID PRODUCT PRODUCT officepack_type REF_ID REF_ID TYPE_VERSION TYPE_VERSION officepack_version
REF_ID REF_ID VERSION VERSION operators
ID ID FIRSTNAME FIRSTNAME LASTNAME LASTNAME PASSWD PASSWD ACCESSLVL ACCESSLVL COMMENTS COMMENTS NEW_ACCESSLVL NEW_ACCESSLVL EMAIL EMAIL USER_GROUP USER_GROUP PASSWORD_VERSION PASSWORD_VERSION plugins id id name name version version licence licence author author verminocs verminocs activated activated reg_date reg_date ports
ID ID HARDWARE_ID HARDWARE_ID TYPE TYPE NAME NAME CAPTION CAPTION DESCRIPTION DESCRIPTION printers
ID ID HARDWARE_ID HARDWARE_ID NAME NAME DRIVER DRIVER PORT PORT DESCRIPTION DESCRIPTION SERVERNAME SERVERNAME SHARENAME SHARENAME RESOLUTION RESOLUTION COMMENT COMMENT SHARED SHARED NETWORK NETWORK prolog_conntrack
ID ID DEVICEID DEVICEID TIMESTAMP TIMESTAMP PID PID regconfig
ID ID NAME NAME REGTREE REGTREE REGKEY REGKEY REGVALUE REGVALUE registry
ID ID HARDWARE_ID HARDWARE_ID NAME NAME REGVALUE REGVALUE registry_name_cache ID ID NAME NAME registry_regvalue_cache ID ID REGVALUE REGVALUE sim ID ID HARDWARE_ID HARDWARE_ID OPERATOR OPERATOR OPNAME OPNAME COUNTRY COUNTRY SERIALNUMBER SERIALNUMBER DEVICEID DEVICEID slots
ID ID HARDWARE_ID HARDWARE_ID NAME NAME DESCRIPTION DESCRIPTION DESIGNATION DESIGNATION PURPOSE PURPOSE STATUS STATUS PSHARE PSHARE snmp
ID ID IPADDR IPADDR MACADDR MACADDR SNMPDEVICEID SNMPDEVICEID NAME NAME DESCRIPTION DESCRIPTION CONTACT CONTACT LOCATION LOCATION UPTIME UPTIME DOMAIN DOMAIN TYPE TYPE LASTDATE LASTDATE CHECKSUM CHECKSUM snmp_accountinfo
SNMP_ID SNMP_ID TAG TAG snmp_blades SNMP_ID SNMP_ID SERIALNUMBER SERIALNUMBER SYSTEM SYSTEM snmp_cards
ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION REFERENCE REFERENCE FIRMWARE FIRMWARE SOFTWARE SOFTWARE REVISION REVISION SERIALNUMBER SERIALNUMBER MANUFACTURER MANUFACTURER TYPE TYPE snmp_cartridges ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION TYPE TYPE LEVEL LEVEL MAXCAPACITY MAXCAPACITY COLOR COLOR snmp_communities
ID ID VERSION VERSION NAME NAME USERNAME USERNAME AUTHKEY AUTHKEY AUTHPASSWD AUTHPASSWD snmp_computers
SNMP_ID SNMP_ID SYSTEM SYSTEM snmp_cpus
ID ID SNMP_ID SNMP_ID SPEED SPEED TYPE TYPE MANUFACTURER MANUFACTURER snmp_drives ID ID SNMP_ID SNMP_ID LETTER LETTER TYPE TYPE FILESYSTEM FILESYSTEM TOTAL TOTAL FREE FREE NUMFILES NUMFILES VOLUMN VOLUMN LABEL LABEL SERIAL SERIAL snmp_fans
ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION REFERENCE REFERENCE REVISION REVISION SERIALNUMBER SERIALNUMBER MANUFACTURER MANUFACTURER TYPE TYPE snmp_firewalls
SNMP_ID SNMP_ID SERIALNUMBER SERIALNUMBER SYSTEM SYSTEM snmp_inputs ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION TYPE TYPE snmp_laststate
SNMP_ID SNMP_ID COMMON COMMON PRINTERS PRINTERS TRAYS TRAYS CARTRIDGES CARTRIDGES NETWORKS NETWORKS SWITCHS SWITCHS BLADES BLADES STORAGES STORAGES DRIVES DRIVES POWERSUPPLIES POWERSUPPLIES FANS FANS SWITCHINFOS SWITCHINFOS LOADBALANCERS LOADBALANCERS CARDS CARDS COMPUTERS COMPUTERS SOFTWARES SOFTWARES MEMORIES MEMORIES CPUS CPUS INPUTS INPUTS PORTS PORTS SOUNDS SOUNDS VIDEOS VIDEOS MODEMS MODEMS LOCALPRINTERS LOCALPRINTERS snmp_loadbalancers
SNMP_ID SNMP_ID SERIALNUMBER SERIALNUMBER SYSTEM SYSTEM MANUFACTURER MANUFACTURER TYPE TYPE snmp_localprinters
ID ID SNMP_ID SNMP_ID NAME NAME snmp_memories
ID ID SNMP_ID SNMP_ID CAPACITY CAPACITY snmp_modems ID ID SNMP_ID SNMP_ID NAME NAME snmp_networks
ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION MACADDR MACADDR DEVICEMACADDR DEVICEMACADDR SLOT SLOT STATUS STATUS SPEED SPEED TYPE TYPE DEVICEADDRESS DEVICEADDRESS DEVICENAME DEVICENAME DEVICEPORT DEVICEPORT DEVICETYPE DEVICETYPE TYPEMIB TYPEMIB IPADDR IPADDR IPMASK IPMASK IPGATEWAY IPGATEWAY IPSUBNET IPSUBNET IPDHCP IPDHCP DRIVER DRIVER VIRTUALDEV VIRTUALDEV snmp_ports
ID ID SNMP_ID SNMP_ID NAME NAME TYPE TYPE snmp_powersupplies
ID ID SNMP_ID SNMP_ID MANUFACTURER MANUFACTURER REFERENCE REFERENCE TYPE TYPE SERIALNUMBER SERIALNUMBER DESCRIPTION DESCRIPTION REVISION REVISION snmp_printers
SNMP_ID SNMP_ID NAME NAME SERIALNUMBER SERIALNUMBER COUNTER COUNTER STATUS STATUS ERRORSTATE ERRORSTATE snmp_softwares
ID ID SNMP_ID SNMP_ID NAME NAME INSTALLDATE INSTALLDATE COMMENTS COMMENTS VERSION VERSION snmp_sounds ID ID SNMP_ID SNMP_ID NAME NAME snmp_storages
ID ID SNMP_ID SNMP_ID DESCRIPTION DESCRIPTION MANUFACTURER MANUFACTURER NAME NAME MODEL MODEL DISKSIZE DISKSIZE TYPE TYPE SERIALNUMBER SERIALNUMBER FIRMWARE FIRMWARE snmp_switchinfos
SNMP_ID SNMP_ID TYPE TYPE snmp_switchs
ID ID SNMP_ID SNMP_ID MANUFACTURER MANUFACTURER REFERENCE REFERENCE TYPE TYPE SOFTVERSION SOFTVERSION FIRMVERSION FIRMVERSION SERIALNUMBER SERIALNUMBER REVISION REVISION DESCRIPTION DESCRIPTION snmp_trays
ID ID SNMP_ID SNMP_ID NAME NAME DESCRIPTION DESCRIPTION LEVEL LEVEL MAXCAPACITY MAXCAPACITY snmp_videos ID ID SNMP_ID SNMP_ID NAME NAME snmp_virtualmachines
ID ID SNMP_ID SNMP_ID CONFIG_FILE CONFIG_FILE CPU CPU MEMORY MEMORY NAME NAME OS OS POWER POWER UUID UUID softwares
ID ID HARDWARE_ID HARDWARE_ID PUBLISHER PUBLISHER NAME NAME VERSION VERSION FOLDER FOLDER COMMENTS COMMENTS FILENAME FILENAME FILESIZE FILESIZE SOURCE SOURCE GUID GUID LANGUAGE LANGUAGE INSTALLDATE INSTALLDATE BITSWIDTH BITSWIDTH softwares_name_cache
ID ID NAME NAME sounds
ID ID HARDWARE_ID HARDWARE_ID MANUFACTURER MANUFACTURER NAME NAME DESCRIPTION DESCRIPTION ssl_store
ID ID FILE FILE AUTHOR AUTHOR FILE_NAME FILE_NAME FILE_TYPE FILE_TYPE DESCRIPTION DESCRIPTION storages
ID ID HARDWARE_ID HARDWARE_ID MANUFACTURER MANUFACTURER NAME NAME MODEL MODEL DESCRIPTION DESCRIPTION TYPE TYPE DISKSIZE DISKSIZE SERIALNUMBER SERIALNUMBER FIRMWARE FIRMWARE subnet
NETID NETID NAME NAME ID ID MASK MASK tags
Tag Tag Login Login tblwetest_toollist
test_id test_id toollist toollist test_type test_type test_subtype test_subtype test_order test_order test_user test_user test_timestamp test_timestamp toollist_id toollist_id test_stationstyp test_stationstyp test_aktiv test_aktiv temp_files
ID ID TABLE_NAME TABLE_NAME FIELDS_NAME FIELDS_NAME file file COMMENT COMMENT AUTHOR AUTHOR FILE_NAME FILE_NAME FILE_TYPE FILE_TYPE FILE_SIZE FILE_SIZE ID_DDE ID_DDE videos
ID ID HARDWARE_ID HARDWARE_ID NAME NAME CHIPSET CHIPSET MEMORY MEMORY RESOLUTION RESOLUTION virtualmachines ID ID HARDWARE_ID HARDWARE_ID NAME NAME STATUS STATUS SUBSYSTEM SUBSYSTEM VMTYPE VMTYPE UUID UUID VCPU VCPU MEMORY MEMORY SQL_TABLE_HARDWARE_ID
accesslog accesslog accountinfo accountinfo batteries batteries bios bios controllers controllers cpus cpus devices devices download_history download_history download_servers download_servers drives drives groups groups groups_cache groups_cache inputs inputs itmgmt_comments itmgmt_comments javainfo javainfo journallog journallog locks locks memories memories modems modems monitors monitors networks networks officepack officepack ports ports printers printers registry registry sim sim slots slots softwares softwares sounds sounds storages storages videos videos virtualmachines virtualmachines url_service Objet de la classe Urls URL ms_all_computers visu_computers ms_config admin_conf ms_repart_tag visu_repart_tag ms_groups visu_groups ms_all_soft visu_all_soft ms_multi_search visu_search ms_custom_groups groups_search ms_custom_lock lock_search ms_custom_pack pack_search ms_custom_sup sup_search ms_custom_tag tag_seach ms_dict admin_dico ms_upload_file admin_upload ms_upload_file_popup upload_file ms_regconfig admin_reg ms_logs admin_logs ms_admininfo admin_info ms_ipdiscover show_ipdiscover ms_admin_ipdiscover admin_ipdiscover ms_doubles admin_double ms_label admin_lbl ms_users admin_user ms_add_user admin_add_user ms_user_details admin_user_details ms_config_account account_config ms_profiles admin_profiles ms_add_profile admin_add_profile ms_profile_details admin_profile_details ms_custom_perim admin_perim ms_local admin_local_import ms_help help ms_stats stats ms_codes admin_codes ms_blacklist admin_black ms_console console ms_components components ms_tele_package tele_package ms_tele_modify tele_modify ms_tele_activate tele_activate ms_tele_popup_active tele_popup_active ms_tele_actives tele_actives ms_tele_pack tele_pack ms_rules_redistrib rules_redistrib ms_custom_param opt_param ms_opt_ipdiscover opt_ipdiscover ms_group_show group_show ms_show_detail show_detail ms_custom_info ipdiscover_info ms_debug debug ms_computer computer ms_soft_csv export_soft ms_csv export_csv ms_tele_stats tele_stat ms_tele_compress compress ms_speed_stat stat_speed ms_admin_management admin_type_manage ms_adminvalues admin_values ms_view_file view_file ms_search_soft search_soft ms_options search_soft_option ms_snmp snmp ms_snmp_detail snmp_detail ms_update_new_tag script_new_tag ms_server_redistrib server_redistrib jp_teledeploy_stats teledeploy_stats jp_teledeploy_speed_stats teledeploy_speed_stats jp_activity_stats activity_stats ms_ipdiscover_analyse ipdiscover_analyse ms_stats_connexion stats_connexion ms_add_key add_key ms_export_ocs export_ocs ms_qrcode qrcode ms_plugins plugins ms_pluginsmanager pluginsmanager ms_stats_top stats_top ms_server_infos server_infos ms_wiki wiki ms_irc irc ms_forums forums ms_offers offers ms_ask ask ms_about about JAVASCRIPT
0 ms_search_soft/js/autocomplete-3-2.js 1 ms_search_soft/js/print.js 2 ms_users/js/profile-create-form.js 3 ms_users/js/profile-edit-form.js LANGUAGE english PASSWORD_VERSION 1 PASSWORD_ENCRYPTION PASSWORD_BCRYPT CSRFNUMBER 90 CSRF
0 a5984e3d8f0ea43eda6759abed58d57c86336018 1 3b3dc5d0cede14a835904cd5358463abafeb4e32 2 c3033657ff9728465c622f9ab86e41419cbba00b 3 4229307480102128a64ea5f7e738832e364d358b 4 136f0628998c80a45e6707be29c6f0c815c08a79 5 c05eabf73d166df94251d4d9fbe5e523bf3009e9 6 7507500095f4e26d49a022cc9257410d5bef8d0b 7 a9bde9609100805b1b460b70bb1040e6b6312752 8 a30b895f5ca57c54b69600df99a88ce976099b1f 9 ceba753bde05c50d1435d9e0180df0797bf72c99 10 f55173be4e55d6253ceee0305af476d9013b44f2 11 d148c5cd8daa65e7c39993e47ba2e0c4b372b6b3 12 f4926d7f65a6f1d9015f9ca4ce6ed28cec1d6efa 13 724c6aafd963f14342a767dd65b467619efd7a89 14 696e6b916b024f4f5f43e9143c9dcb6846fdaef7 15 d2b5b90bf7922fbf2e5e94107de70f365a27655a 16 85a64e0c0a40ae2f00d8d1bbf101ff73c8597a7e 17 6858f552e5bb69faa92b678bbd0173fe67653c18 18 a09ae344c021baf84dbce76b8588cd1d7c0e8f8a 19 faf6ee3c19ad15485e9e26af31f4a74a5a030817 20 216ff240bcd38e0e9e62ea24cf994842d2aeddae 21 291e6d45c978c6149046299e21ac3d697ae5e373 22 dd7c40f6812909639c47f074284e4cd49224a7f5 23 5bdd7d68b4278d830980fe6d10b25353c18bf78a 24 81c988312f8382676d0fe76bc844c0ec9179a930 25 62c0676d82a807387fa335c2f1357ec03a6aa80c 26 8a2bfd85ac18323b882cc61fd4df633766b90298 27 596609a8365fc33491862dd9a1d9490fe27cbe02 28 55f44d3abcbd509adc725c1dfe770ceb90477a7f 29 ab3ba58969b7fd1daf626f039b042fab55a3468b 30 58b68d8dd14a58a827b9463b374c73886389afc0 31 2508f9368db257f28acf2479d2dc25feba0855b3 32 3897db104d997a606398cedea8f9af452272f76a 33 d30c10666bd5f7abce917e4dc574b19490f6faa2 34 2505264837f7a9b4d6c0e4492541c99055e892b5 35 203b74da633deb59aa1c8215b234bdc99f2ba641 36 acb2f3d7788059fbbe489ff2a8fc7fb76afcb65e 37 fccb46da3466c0657ef84d348dd327824b40227b 38 8c1b97887465ed85ed03d1c501eb5abef62a6f4c 39 6df01211e0d202f7eca6eeda150963fa8e855e17 40 4db8ee1f21166a4ab33e534736eb079fb9326a2f 41 e33f91c40baf1ba5767d8cd68e401c45de926044 42 1546bf110a59bf7a1427165cd52a9a9b1cf1356a 43 a20dfd7fdda1285fde22e4e45d484bd4485ff6df 44 d1d26f2bfdf3bdffe333e0df8fd8e8c30c6aeb87 45 262ab246b930916fe652682043bf4959add84129 46 331e716cdf56263f6fbbf339c20b76771c6f26cd 47 e9bf3a39d6f668faa4135fdc42cd6da2ab6b114d 48 09e6ce5fa76f52755bcee3abf848954d15b4f385 49 be8511c4b09bc20a1cf0c94c15d276ff693f4dfa 50 4de1a298f7a5ac861ed7210e8e1043def7bcb770 51 621076065053257d48d8180e26e7d7608fd25c52 52 548ed02fe0d1bb43a642ad27ef40eabe34afa88c 53 d73e429c49863f300707f85dc7e010168f0b8721 54 a61d0b926b9614898cd4f41378d782af5ec651e6 55 98c1e0ff64ef8c96a3cd6eaecb1ec130b3487259 56 55c09a7f21431bb2a33f002d6f799583974e3f2f 57 936787e8c5047ca311b5667a6ebf1159262af069 58 60b958f6fe3d3508f34af1dcec988ede96ed87f6 59 c1a390557005360bc729bacefc531fab5181cc2c 60 6e78821d4b5ae280cf28519a1b665dd6fe1893f5 61 7dee303f9d2eb192d9f0ce91567bd8fc76de69b0 62 e60d0596fe17c52d75332e4f3477fbf94f1df8a5 63 c6b7626ffb4ded390b97f5344139cc46397d2883 64 39cc3b226aa0876a89a28bc195c8808e0c6a9bb2 65 1ea37220ce530fa0530e503db9e25b9bb370f99b 66 ca2cda8e9b3e3e49f911867ba2e68a9399ffc799 67 0e68a66399e76f4c4e51536805fef8fa915d6232 68 2527540d75db7c1fb63ddcdfdb025286de65e540 69 c8862238909c8ec682b9f9680cff4891ef138c28 70 de01541bf34d993f3726bfb309b8c0491972a1b7 71 1485822c59103c109e70c34990cc3e781fbe57ba 72 672dd5216c4b95ea9c4196a20d5a9cf1f472d9cf 73 40d671643bee60381a43619b4eb542270fdc6317 74 2a83c3a0a5ac44f923a596e9e1da8a7a76a77c4f 75 11007e483b9d91004ee3a59f85cbd5398ee09450 76 ee459b2f0f9569d81abf5e319de25e6cb6822298 77 7bd551446c6d6f60a196a9fecde1278674e71b86 78 5093d1a1ccca61782d39ec1c6885830040d2e059 79 ca3cfa7ed95c28cfe6c4a36e35913ebf59bf3070 80 05932933dd509724c4c9382f26c2598b73a87a33 81 ca75aac39fe56334c0ffa0bb5be74c4eb765f647 82 d044baaa895ceb44778dbeb4d863895b66cbf3db 83 2ea185c026d8b5d8df604c2c5e2d83789b890658 84 ebc1e2a8a2b5fb9bcd2ae03887ae93b3817d1276 85 0fd6214ad1766b2e609e2dff650340ce2d64642b 86 4a0c14290ad8e48d0aaa7144d588e248a409df1f 87 f004e399795118471f2bc8e37f130c82fa23ab45 88 24181d4724642fac9e0a6fd5369726b18e62a1bc 89 250e2beb1926fe0e606a0369b9784831e98d2054 loggeduser admin cnx_origine LOCAL user_group
lvluser sadmin tabcache 0 USE_NEW_SOFT_TABLES 0 use_redistribution 1 TAG_LBL TAG TAG BEMERKUNG Bemerkung TAG_ID
1 TAG 4 BEMERKUNG profile Objet de la classe Profile COUNT_CONSOLE
OCS_REPORT_NB_ALL_COMPUTOR 407 OCS_REPORT_NB_COMPUTOR 407 OCS_REPORT_NB_CONTACT 104 OCS_REPORT_NB_INV 101 OCS_REPORT_NB_4_MOMENT 130 OCS_REPORT_NB_SNMP 0 OCS_REPORT_NB_IPDISCOVER 5456 csv SQLNOLIMIT
list_show_all SELECT %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s from hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id LEFT JOIN networks n ON n.hardware_id=h.id AND h.IPADDR=n.IPADDRESS LEFT JOIN bios e ON e.hardware_id=h.id where deviceid'SYSTEMGROUP' AND deviceid'DOWNLOADGROUP' group by h.id order by a.fields_4 asc TAB_MULTICRITERE SELECT a.TAG, a.fields_4, h.ID, h.LASTDATE, h.LASTCOME, h.NAME as name_of_machine, h.USERID, h.OSNAME, h.USERAGENT, h.WORKGROUP, h.MEMORY, h.PROCESSORS, h.PROCESSORT, h.PROCESSORN, h.quality, h.ipaddr, h.DESCRIPTION, h.FIDELITY, h.SWAP, h.WINPRODKEY, h.WINPRODID, h.wincompany, h.winowner, h.userdomain, h.OSCOMMENTS, h.OSVERSION, h.ARCH, softwares.PUBLISHER, softwares.NAME, softwares.VERSION, softwares.FOLDER, softwares.COMMENTS from hardware h left join accountinfo a on h.id=a.hardware_id left join softwares on h.id=softwares.hardware_id where h.id in ( %s, %s, %s, %s, %s, %s, %s, %s, %s, %s ) group by h.ID order by a.TAG asc SQL list_show_all SELECT %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s from hardware h LEFT JOIN accountinfo a ON a.hardware_id=h.id LEFT JOIN networks n ON n.hardware_id=h.id AND h.IPADDR=n.IPADDRESS LEFT JOIN bios e ON e.hardware_id=h.id where deviceid'SYSTEMGROUP' AND deviceid'DOWNLOADGROUP' group by h.id order by a.fields_4 asc limit 0 , 99999999999 TAB_MULTICRITERE SELECT a.TAG, a.fields_4, h.ID, h.LASTDATE, h.LASTCOME, h.NAME as name_of_machine, h.USERID, h.OSNAME, h.USERAGENT, h.WORKGROUP, h.MEMORY, h.PROCESSORS, h.PROCESSORT, h.PROCESSORN, h.quality, h.ipaddr, h.DESCRIPTION, h.FIDELITY, h.SWAP, h.WINPRODKEY, h.WINPRODID, h.wincompany, h.winowner, h.userdomain, h.OSCOMMENTS, h.OSVERSION, h.ARCH, softwares.PUBLISHER, softwares.NAME, softwares.VERSION, softwares.FOLDER, softwares.COMMENTS from hardware h left join accountinfo a on h.id=a.hardware_id left join softwares on h.id=softwares.hardware_id where h.id in ( %s, %s, %s, %s, %s, %s, %s, %s, %s, %s ) group by h.ID order by a.TAG asc limit 0 , 99999999999 REPLACE_VALUE
list_show_all
TAB_MULTICRITERE
ARG list_show_all
0 a.fields_4 1 a.TAG 2 h.lastdate 3 h.name 4 h.ID 5 h.userid 6 h.osname 7 h.memory 8 h.processors 9 h.workgroup 10 h.osversion 11 h.oscomments 12 h.processort 13 h.processorn 14 h.swap 15 h.lastcome 16 h.quality 17 h.fidelity 18 h.description 19 h.wincompany 20 h.winowner 21 h.useragent 22 e.smanufacturer 23 e.bmanufacturer 24 e.ssn 25 e.smodel 26 e.bversion 27 h.ipaddr 28 h.userdomain 29 h.ARCH 30 e.bdate 31 n.macaddr 32 n.ipmask 33 n.ipgateway 34 n.ipsubnet TAB_MULTICRITERE
0 309 1 838 2 901 3 2409 4 267 5 820 6 1766 7 2763 8 2880 9 2900 list_fields list_show_all
Account info: Bemerkung a.fields_4 Account info: TAG a.TAG Last inventory h.lastdate NAME h.name Computer Id h.ID User h.userid Operating system h.osname RAM (MB) h.memory CPU (MHz) h.processors Domain h.workgroup OS Version h.osversion Service pack h.oscomments CPU type h.processort CPU number h.processorn Swap h.swap Last come h.lastcome Quality h.quality Fidelity h.fidelity Description h.description Company h.wincompany Owner h.winowner User agent h.useragent Manufacturer e.smanufacturer BIOS Manufacturer e.bmanufacturer Serial number e.ssn Model e.smodel BIOS Version e.bversion IP address h.ipaddr Userdomain h.userdomain Architecture h.ARCH BIOS Date e.bdate MAC address n.macaddr Netmask n.ipmask Gateway n.ipgateway Network number n.ipsubnet CHECK h.ID SUP h.ID ACTIONS h.ID TAB_MULTICRITERE
Account info: TAG a.TAG Account info: Bemerkung a.fields_4 Machine(s): id h.ID Machine(s): Last inventory h.LASTDATE Machine(s): Last contact h.LASTCOME NAME h.NAME Machine(s): User h.USERID Machine(s): Operating system h.OSNAME Machine(s): User agent h.USERAGENT Network(s): Domain h.WORKGROUP Machine(s): Memory h.MEMORY Machine(s): CPU (MHz) h.PROCESSORS Machine(s): CPU type h.PROCESSORT Machine(s): CPU number h.PROCESSORN Machine(s): Quality h.quality Machine(s): IP address h.ipaddr Machine(s): Description h.DESCRIPTION Machine(s): Fidelity h.FIDELITY Machine(s): Swap h.SWAP Machine(s): Windows licence h.WINPRODKEY Machine(s): Windows key h.WINPRODID Machine(s): Company h.wincompany Machine(s): Owner h.winowner Machine(s): Userdomain h.userdomain Operating system: Service pack h.OSCOMMENTS Operating system: Version h.OSVERSION Machine(s): Architecture h.ARCH Software: Company softwares.PUBLISHER Software: Name softwares.NAME Software: Version softwares.VERSION Software: Install directory softwares.FOLDER Software: Comments softwares.COMMENTS SUP h.ID CHECK h.ID ACTIONS h.ID col_tab list_show_all
a.fields_4 Account info: Bemerkung a.TAG Account info: TAG h.lastdate Last inventory h.name NAME h.ID ACTIONS h.userid User h.osname Operating system h.memory RAM (MB) h.processors CPU (MHz) h.workgroup Domain h.osversion OS Version h.oscomments Service pack h.processort CPU type h.processorn CPU number h.swap Swap h.lastcome Last come h.quality Quality h.fidelity Fidelity h.description Description h.wincompany Company h.winowner Owner h.useragent User agent e.smanufacturer Manufacturer e.bmanufacturer BIOS Manufacturer e.ssn Serial number e.smodel Model e.bversion BIOS Version h.ipaddr IP address h.userdomain Userdomain h.ARCH Architecture e.bdate BIOS Date n.macaddr MAC address n.ipmask Netmask n.ipgateway Gateway n.ipsubnet Network number TAB_MULTICRITERE
a.TAG Account info: TAG a.fields_4 Account info: Bemerkung h.ID ACTIONS h.LASTDATE Machine(s): Last inventory h.LASTCOME Machine(s): Last contact h.NAME NAME h.USERID Machine(s): User h.OSNAME Machine(s): Operating system h.USERAGENT Machine(s): User agent h.WORKGROUP Network(s): Domain h.MEMORY Machine(s): Memory h.PROCESSORS Machine(s): CPU (MHz) h.PROCESSORT Machine(s): CPU type h.PROCESSORN Machine(s): CPU number h.quality Machine(s): Quality h.ipaddr Machine(s): IP address h.DESCRIPTION Machine(s): Description h.FIDELITY Machine(s): Fidelity h.SWAP Machine(s): Swap h.WINPRODKEY Machine(s): Windows licence h.WINPRODID Machine(s): Windows key h.wincompany Machine(s): Company h.winowner Machine(s): Owner h.userdomain Machine(s): Userdomain h.OSCOMMENTS Operating system: Service pack h.OSVERSION Operating system: Version h.ARCH Machine(s): Architecture softwares.PUBLISHER Software: Company softwares.NAME Software: Name softwares.VERSION Software: Version softwares.FOLDER Software: Install directory softwares.COMMENTS Software: Comments list_show_all
nb_resultat 407 multiSearch 0 SOFTWARES-NAME SelComp-HARDWARE-USERID-0 diff InputValue-HARDWARE-USERID-0 123 list_tables_request TAB_MULTICRITERE
SOFTWARES SOFTWARES TAB_MULTICRITERE
nb_resultat 10 SelComp-HARDWARE-NAME-0 diff InputValue-HARDWARE-NAME-0 123 usecache 1 SelComp-SOFTWARES-NAME-0 ressemble InputValue-SOFTWARES-NAME-0 %Quicktime% DEBUG ON SQL_DEBUG
0 select NAME,IVALUE,TVALUE,COMMENTS from config where NAME in ( 'LOG_GUI', 'LOG_DIR', 'LOG_SCRIPT' ) 1 SELECT id,user_group FROM operators WHERE id='admin' and passwd ='21232f297a57a5a743894a0e4a801fc3' 2 select ID,TYPE,NAME,COMMENT from accountinfo_config where account_type = 'COMPUTERS' 3 select id from hardware where deviceid 'SYSTEMGROUP' AND deviceid 'DOWNLOADGROUP' AND id in ( '309', '838', '901', '2409', '267', '820', '1766', '2763', '2880', '2900' ) 4 select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config order by show_order DESC 5 select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=4 order by show_order DESC 6 select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=1 order by show_order DESC 7 select id,type,name,id_tab,comment,show_order,account_type,default_value from accountinfo_config where id=2 order by show_order DESC 8 select id from hardware where deviceid 'SYSTEMGROUP' AND deviceid 'DOWNLOADGROUP' AND id in ( '309', '838', '901', '2409', '267', '820', '1766', '2763', '2880', '2900' ) SQL_DATA_FIXE
TAB_MULTICRITERE
0 select distinct HARDWARE_ID,softwares.PUBLISHER as 'Software: Company',softwares.NAME as 'Software: Name',softwares.VERSION as 'Software: Version',softwares.FOLDER as 'Software: Install directory',softwares.COMMENTS as 'Software: Comments' from softwares where ( ( NAME IN ('3Dconnexion Plug-in for QuickTime VR','QuickTime','QuickTime 7'))) ID_REQ
267 267 309 309 820 820 838 838 901 901 1766 1766 2409 2409 2763 2763 2880 2880 2900 2900 SEARCH_SQL_GROUP
0 select distinct HARDWARE_ID from softwares where ( ( NAME IN (select NAME as name from softwares_name_cache where NAME like '%%Quicktime%%') ))

gillesdubois commented 8 years ago

Your bug is really weird i can't reproduce it. There is no error and all request are executed without error on a debian 8.4 with the same php version as yours.

This can come from Datatable which generate the table but you don't have any error log ...

The only thing that can be a problem is mysql server Did you import the data from an older sql sever ?

EDIT : Did you try to re-download and re-install the ocs sever ?

Regards, Gilles Dubois.

ids-itsupport commented 8 years ago

Hi Gilles, Sorry for the delay. Thank you so much for your help. Yes we've imported the Database from an older mysql Server to our new one via MYSQL Dump. We used OCS 2.0.5 before and migrated to a new server with the new OCS version 2.2 . After the installation and importing the dump, the setup asks me to upgrade the database. The Upgrade process was going well without problems. So i thought everything should work fine.

Is it possible to reinstall the server only by starting the setup again? If yes I'll try this.

gillesdubois commented 8 years ago

Hi,

yes you can reinstall by only starting the setup again :)

Waiting for your feedback, Regards, Gilles Dubois.

ids-itsupport commented 8 years ago

HI Gilles, After reinstall it seems to work :+1:

gillesdubois commented 8 years ago

Hi,

I'm glad your installation now work properly :-) Hope you will love this new version.

Have a nice day. Regards, Gilles Dubois.