Your message dated Fri, 06 Oct 2023 08:42:26 +0000
with message-id <e1qogpi-006g2f...@fasolo.debian.org>
and subject line Bug#1053507: fixed in openstack-cluster-installer 42.3.0
has caused the Debian Bug report #1053507,
regarding openstack-cluster-installer: 500 error on oci agent first report
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
1053507: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1053507
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: openstack-cluster-installer
Version: 42.3.0~bpo12+1
When PXE booting a new node, on its first report there is an error in
the apache logs:
[Tue Oct 03 08:48:00.052212 2023] [php:error] [pid 83221] [client
10.10.48.12:54344] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown
column 'hwid' in 'field list' in
/usr/share/openstack-cluster-installer/report.php:292\nStack trace:\n#0
/usr/share/openstack-cluster-installer/report.php(292): mysqli_query()\n#1
{main}\n thrown in /usr/share/openstack-cluster-installer/report.php on line
292
This appears to be due to an incorrect table name in an SQL statement.
Patch attached.
--
Regards
Jim
diff --git a/src/report.php b/src/report.php
index 6240fc36..1ade880a 100644
--- a/src/report.php
+++ b/src/report.php
@@ -289,7 +289,7 @@ if($n == 0){
if(!preg_match($reg_alpha, $blkdev_ctrl_product)) die("Block device controller product suspicious line ".__LINE__." file ".__FILE__);
if(!preg_match($reg_alpha, $blkdev_ctrl_ctrl_type)) die("Block device controller ctrl type suspicious line ".__LINE__." file ".__FILE__);
if(!preg_match($reg_int, $blkdev_ctrl_firmware_version)) die("Block device controller fw version suspicious line ".__LINE__." file ".__FILE__);
- $r = mysqli_query($con, "INSERT INTO physblockdevices (machine_id, hwid, vendor, product, ctrl_type, firmware_version) VALUES ('".$machine_id."', '".$blkdev_ctrl_hwid."', '".$blkdev_ctrl_vendor."', '".$blkdev_ctrl_product."', '".$blkdev_ctrl_ctrl_type."', '".$blkdev_ctrl_firmware_version."')");
+ $r = mysqli_query($con, "INSERT INTO blkdev_ctrl (machine_id, hwid, vendor, product, ctrl_type, firmware_version) VALUES ('".$machine_id."', '".$blkdev_ctrl_hwid."', '".$blkdev_ctrl_vendor."', '".$blkdev_ctrl_product."', '".$blkdev_ctrl_ctrl_type."', '".$blkdev_ctrl_firmware_version."')");
}
}
}
--- End Message ---
--- Begin Message ---
Source: openstack-cluster-installer
Source-Version: 42.3.0
Done: Thomas Goirand <z...@debian.org>
We believe that the bug you reported is fixed in the latest version of
openstack-cluster-installer, which is due to be installed in the Debian FTP
archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 1053...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Thomas Goirand <z...@debian.org> (supplier of updated
openstack-cluster-installer package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 06 Oct 2023 10:00:43 +0200
Source: openstack-cluster-installer
Architecture: source
Version: 42.3.0
Distribution: unstable
Urgency: medium
Maintainer: Debian OpenStack <team+openst...@tracker.debian.org>
Changed-By: Thomas Goirand <z...@debian.org>
Closes: 1028457 1039302 1053506 1053507 1053510 1053513 1053514
Changes:
openstack-cluster-installer (42.3.0) unstable; urgency=medium
.
[ Thomas Goirand ]
* Use a new field for the Designate ptr_zone_email.
* Disable amphora logging in Octavia.
* Depends on default-mysql-server | mariadb-server, not just
default-mysql-server.
* openstack-cluster-installer-build-live-image: do not attempt to install
megactl, megamgr and dellmgr when installing megacli in the live image.
* openstack-cluster-installer-agent: use first RAID controller (head -n 1).
* oci-block-device-udev-sorting: Add ProLiant DL365 Gen10 Plus support.
* Add support for using storcli instead of megacli.
* Set keystone_authtoken/service_type in cinder.conf.
* Add support for puppet-openstack Antelope.
* network.pp: rotate /var/log/conntrackd-stats.log daily.
* Fix: new compute not being discovered automatically (because of a not
defined $clusterid in a MySQL query).
* New ocicli feature to re-assign the IPMI address of a server.
* Add support for HPE ProLiant DL345 Gen11.
* Swiftstores: do not attempt to XFS format nvme0n1 if nvme0 is the system
disk.
* lldpd: list existing NICs instead of just eth*, which doesn't work with
BIOS names.
* Agent: report version of MegaRAID 12GSAS/PCIe Secure SAS39xx controller.
* Fix handling of CPU model extra flags params.
* Add oci-poc-virtual-network.service (Closes: #1039302).
* Increased the size of the BIOS version field to 64 chars
(Closes: #1028457).
* Correctly transmit "$self_signed_api_cert" to messaging nodes.
* Applied patches sent by Jim Scadden to the Debian BTS. Thanks a lot to him
for his bugfix contributions:
- fix ocicli machine-guess-racking returns error when no match found
(Closes: #1053506).
- fix 500 error on oci agent first report (Closes: #1053507).
- fix puppetserver sign command needs updating for puppet 7
(Closes: #1053510).
- Use "dmidecode -s system-uuid" on QEMU VMs in some cases
(Closes: #1053513).
- Bugfix for handling NICs which do not report a speed (Closes: #1053514).
* Cleans better.
.
[ Axel Jacquet ]
* Use a new field for managed_resource_tenant_id.
* Add deployment of MySQL server + rally in the Tempest role.
Checksums-Sha1:
0ea04a03f03aadeb65aa06f7d3b19b1818f29e02 2514
openstack-cluster-installer_42.3.0.dsc
7823f07c4e1bc2358a19c89901186f55062868d3 377412
openstack-cluster-installer_42.3.0.tar.xz
4f5b8603806b1a2abe0d0969070eb97cfcd45a0e 9383
openstack-cluster-installer_42.3.0_amd64.buildinfo
Checksums-Sha256:
92e2f6bf19115d87910d7b01cf136f8378b4bb02d3fc954f4eba68953c83d146 2514
openstack-cluster-installer_42.3.0.dsc
d55132f2e46c8754cd9063b317d89f23fec53133f340fd4ec97769f5ac7f4a01 377412
openstack-cluster-installer_42.3.0.tar.xz
88995551fd6e937173cb4ffea5fdadee558c71f4ec72cae03bded824cb9b3488 9383
openstack-cluster-installer_42.3.0_amd64.buildinfo
Files:
52e8ed7dbcc8824b868ced6509814f05 2514 net optional
openstack-cluster-installer_42.3.0.dsc
f58db1d3de73aa8bccd3178a3d110cc2 377412 net optional
openstack-cluster-installer_42.3.0.tar.xz
89222d6b702957af3af9134bcd9dddb8 9383 net optional
openstack-cluster-installer_42.3.0_amd64.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCAAdFiEEoLGp81CJVhMOekJc1BatFaxrQ/4FAmUfwe4ACgkQ1BatFaxr
Q/4IUA//bixlt4Tqsu4OK7J7hlyr5G+yKBIh7ZHs8FQj3pAk8NzgTGO6H/zel8s5
Xl7TLbSy9TDix0lxhl0RvJVLZI5p+DC2FzQGQ+P4VMr+OFawL4LnrMRTy6LHYWO3
zWJ7Bm04U501nx6RLgsc+ZSqT5vQRYPpmkBTdmzAbSIoLpSdj2NwidXhXhmbH9ye
hVrnTHdbB0TQQdR2dSM+iRE2TW4UamFLyrDOOitc+EZoO5FyfIFEzZLIb7jc7S8r
nOWVKW3ATKTs0GS1J/+ImufaIpEc5qJDdbkcpziQ0CIf66fSxQ5YycuD/mcuF2ED
y40/gu1Unt/bdmCZQwyFHCRTkzryiBYxuh2WwJ/7RwEBqgpVcwJVGOqnhc+ZQoNG
W8gsOQKNSjlWK0i29cyWPPCNyPDkESG+ejj4H4hRdvtjb1PdCOc+PjB3K0nFzshZ
pbPsGMdvkS/aiofrplFaVgBrUG9o3msZb9mxtNvHWByx0YzkgGOaNwo+QnUHboRW
gDdg++kqIpGEZDW/i8vx0qv1Z8SNEDeOVxUuXSaUVilCY1Xbf6oSmGpadZldKybN
qBlwjtRxKeChAH7XbmYjwxLtaZw47yfG84cC5dGZnIxAY60RVMXYfJxTw2py+1fN
GSa+onC+LIvKj6l5FSXKXKZs1NQYvoeSOCPyul8xHVEkd6rgsiw=
=xA7Y
-----END PGP SIGNATURE-----
--- End Message ---
