49 Commits
Author SHA1 Message Date
TheWitness ea05cd5198 Issue #5450 - Bulk convert to latin1
* Unable to bulk convert to latin1 if desired
* Minor paranoa on audit_database.php
2023-08-12 18:24:12 -04:00
TheWitness 79cb027d92 Fixing #5208 audit errors and audit_schema.sql
* Audit Database throws error during runtime on PHP8
* Prepare audit_schema.sql for upgrade
2023-01-28 15:12:17 -05:00
TheWitness 29d521b9d4 QA: #5180 - database default 2023-01-21 12:41:13 -05:00
TheWitness cf60b852b1 Fixing #5180 Audit database storage compare
Audit Database has issues with storage engine compare
2023-01-21 12:32:12 -05:00
Mark Brugnoli-Vinten d2a94dc3b3 Update copyright year for 2023 2023-01-03 22:46:09 +00:00
Jing Chen 5efe3f2ac0 Update three fiels for PHP error under PHP 8.x (#4738) 2022-11-24 13:11:39 -05:00
TheWitness 0479c42982 Fixing #4927 - Issues with audit_database.php
When running audit_database.php script will fail if cacti password had a ) in it
2022-09-24 11:32:01 -04:00
TheWitness abbcbaeb85 Fixing Issue #4888 - MySQL 8 Audit
Cacti audit_database.php script fails on MySQL 8.0.29 and likely will on newer versions
2022-08-21 13:31:47 -04:00
TheWitness 32fa795439 QA: Issue with upgrade_database.php 2022-07-31 13:34:06 -04:00
TheWitness 1743fa47ab Spelling issue associated with #4792 2022-06-17 12:45:07 -04:00
TheWitness d9f8e2af0d Spelling issue associated with #4792 2022-06-17 12:44:15 -04:00
TheWitness 65df9489ce Spelling issue associated with #4792 2022-06-17 11:54:24 -04:00
Jing Chen 7ec983e59c Misc fixes about table schema and audit utility (#4737) 2022-04-23 16:50:20 +01:00
Jing ChenandTheWitness c4602ac816 audit_database.php miss to report text/mediumtext column due to typo (#4732)
* Miss to report text/mediumtext column due to typo

* Update CHANGELOG for PR#4732

* Make '--alters' output is normal SQL text

Co-authored-by: TheWitness <thewitness@cacti.net>
2022-04-20 08:11:25 -04:00
TheWitness 786c0693b5 Fixing Issue #4620 - Remote CLI Issues
- Remote Data Collector CLI scripts connect to the local database instead of the main database even when online
- Add PHP Doc style documentation to lib/database.php
- Add missing $log and $db_conn to one function
2022-03-15 17:36:32 -04:00
TheWitness 82b229db9e Updating Copyright to 2022. 2022-02-06 17:16:20 -05:00
Jing Chen c8474f40b6 Refixed: #4079 Audit Database: (#4301)
audit_database.php compatibility enhance for current_timestamp() and CURRENT_TIMESTAMP
2021-06-12 15:59:48 +01:00
TheWitness 302ccc9014 Fixing Issue #4079 - Audit Database
- audit_database.php compatibility enhance for current_timestamp() and CURRENT_TIMESTAMP
2021-01-23 10:59:55 -05:00
TheWitness df54a4a3f3 Updating copright years 2021-01-01 20:28:58 -05:00
YongBoLiuandyboliu a3319e80ce Fix3999 (#4000)
* feature 3965, Add a value check if the input field is textbox in settings

* feature 3965, revert

* Fix #3999

* Refix issue #3999, wrap mysqldump into db_dump_data()

* Fix issue #3999, update the db_dump_data() to minimize password be caught.

Co-authored-by: yboliu <yboliu@oc8636837557.ibm.com>
2020-12-30 18:03:11 -05:00
ddb4github fd97a5da3c Fixed: audit_database.php set macro IN_PLUGIN_INSTALL for plugin upgrade (#3997)
* Fixed: audit_database.php Invalid parameter number: no parameters were bound

* Fixed: audit_database.php set macro IN_PLUGIN_INSTALL to skip cache of db_column_exists function
2020-12-09 08:59:30 -05:00
ddb4github 2bbd3f857f Fixed: audit_database.php Invalid parameter number: no parameters were bound (#3996) 2020-12-09 08:08:23 -05:00
TheWitness 909bcbf7c5 Two minor typos 2020-11-26 14:03:49 -05:00
TheWitness f888a845e6 Correct last remaining issues and more messaging 2020-11-26 10:13:04 -05:00
TheWitness 83b52e1138 Fixing Issue #3942
* The audit_database.php script will only modify columns, and add indexes, it does not add column
* There will likely be one more update to this before it's done.  There are a few cases not working 100% yet.
2020-11-26 08:32:16 -05:00
TheWitness a4e5976b8e Update file permissions 2020-11-22 16:58:46 -05:00
TheWitness a392ce8e96 Use LSB shebang notation for cli scripts 2020-11-06 07:02:37 -05:00
netniV 4fa9a68fb3 Update copyright to 2020 2020-01-12 12:19:49 +00:00
netniV c3972f212d Make audit_database report one line per column for better differencing 2019-12-17 14:05:30 +00:00
cigamit 112c7494da Update audit information for 1.2.2 2019-02-23 16:23:30 -06:00
netniV b8c579b129 Update copyright notices for 2019 2019-01-25 08:06:11 +00:00
cigamit daee354bad Resolving Issue #2281
Database audit cli giving incorrect results
2019-01-12 16:12:19 -06:00
netniV 801523b9a4 Resolving issue #2075 2018-10-16 19:23:11 +00:00
cigamit bb4bb77894 Update audit database for release 2018-10-10 17:34:29 -05:00
Mark Brugnoli-Vinten 1ca32862a9 Resolving issue #1920 (#1922)
* Resolving issue #1920

* Minor QA issue
2018-09-14 20:59:52 -05:00
Mark Brugnoli-Vinten 0fb4f53809 Resolving issue #1897 (#1898)
* Resolving issue #1897

* Resolving issue #1899

* Further Resolving Issue #1899
2018-09-06 21:24:51 -05:00
cigamit 5f31ca3137 Modify audit database to handle uft8mb4 2018-08-18 16:22:07 -05:00
cigamit e70e1ca956 Update audit database for 1.2
This does not include the utf8mb4 corrections
2018-08-18 16:12:08 -05:00
cigamit f3de95b5f8 Exit with 1 if there are parameter errors and PSR standards
Replace "echo" with "print" for PSR
2018-08-11 11:54:23 -05:00
Mark Brugnoli-Vinten 29bed92dc3 Resolving Issue #1824 (#1825)
* Resolving issue #1824

* Fix more fixes for REMOTE_ADDR
2018-08-11 11:08:27 -05:00
cigamit 4e05e305aa Update audit_dataabse.php for latest schema 2018-05-08 20:52:27 -05:00
cigamit a35411aa7b Resolving Issue #1468
Increase max length of host.snmp_sysObjectID column
2018-03-24 09:20:42 -05:00
netniV efa0495d7b Issue #1447: Cli audit_database.php not detecting database name (#1448)
Issue #1447: Cli audit_database.php not detecting database name, and failed to create audit tables when run from fresh due to invalid indxees.

MySQL was complaining about the key not all being NOT NULL for a PRIMARY key as opposed to being UNIQUE
2018-03-05 18:13:33 -06:00
cigamit 5ba3fd4f7f Minor updates from Regression and QA 2018-02-04 14:27:12 -06:00
cigamit 1d7118a941 More audit changes around snmp and column names and types
This change also removes the auto_increment defaults for certain tables
which should not be included in the default schema.
2018-02-03 13:31:21 -06:00
cigamit ffb9ad0e35 Update audi_database.php is default shema details
Final updates after multiple upgrades from 0.8.7h to 1.1.34 and strait
installs of 1.1.34.
2018-01-28 11:08:43 -06:00
cigamit cc1891fdef Resolving Issue #1263
The utility includes the options:
--report, --alters, --report, --repair, and --load (for developers)

The load will create the default tables from the current schema.  The
developer who runs with the --load option is still responsible for
loading the 'revised' table contents into the two string variables
though.  The --repair option will repair all tables and would be
suitable for the installers purposes.
2018-01-26 19:02:36 -06:00
cigamit e9bb85e611 Update to Issue #1263
Removing some attributes that have little impact.  There are still
issues in the index parsing, and indexes that are missing are not caught
presently.
2018-01-24 21:07:36 -06:00
cigamit 6c563b72bb First half of a resolution to Issue #1263
Allow Auditiong of the Database
2018-01-24 19:53:30 -06:00