[MDEV-25159] OQGraph Support on 10.5 Created: 2021-03-16 Updated: 2021-05-11 Resolved: 2021-05-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Platform RedHat |
| Affects Version/s: | 10.5.9 |
| Fix Version/s: | 10.5.10 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Nicholas Denning | Assignee: | Daniel Bartholomew |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Compatibility | ||
| Environment: |
Redhat Linux and Centos |
||
| Description |
|
On centos we have access to the OQGRAPH plugin which is listed in the REPO. However on RHEL OQGRAPH is not in the repo and therefore cannot be installed using yum install. Is there a reason whey OQGRAPH is not available with the rhel release? At the moment this is minor because we can still run on 10.4 but I was hoping to upgrade our solution to 10.5. For the record I have also noted a problem where we are getting an error on 10.5 centos where OQGRAPH is installed saying that SAVEPOINT is not allowed. All tables are InoDB with the exception of one oqgraph backing table, and I haven't yet experimented to see if that is the culprit but have my suspicions. Is this the reason why OQGRAPH is not on RHEL? |
| Comments |
| Comment by Daniel Black [ 2021-03-16 ] | ||||||
|
Its most likely a boost dependency isn't available on RHEL but is on Centos. | ||||||
| Comment by Nicholas Denning [ 2021-03-16 ] | ||||||
|
I left out of my first note that we were previously running on RHEL 7 and CENTOS 7 and were now also upgrading to RHEL 8 and CENTOS 8. We are seeing some other funny situations such as we cannot see MariaDB-server in the package list. I will get my colleagues to do some detailed analysis of precisely what we can see and will update. | ||||||
| Comment by Elena Stepanova [ 2021-03-28 ] | ||||||
|
Indeed, there are no oqgraph packages for CentOS 8. | ||||||
| Comment by Daniel Bartholomew [ 2021-03-30 ] | ||||||
|
When RHEL 8 was released it didn't have a Judy-devel package available. This is required to be able to compile oqgraph. At the time, I opened a support case about it with RedHat and went back and forth a few times with them on it. At one point they said it was fixed, but when I checked it wasn't and when I checked just now it also is still not fixed. I will ping them again about it. | ||||||
| Comment by Nicholas Denning [ 2021-04-02 ] | ||||||
|
Many thanks. We use OQGRAPH for defining ACLs and an overall security framework. As with all of these things, if we had to re-write our engine to remove OQGRAPH it would be possible. However if we can get chase RHEL/CENTOS to get the underlying technologies available and hence OQGRAPH included that would be helpful. | ||||||
| Comment by Daniel Bartholomew [ 2021-04-08 ] | ||||||
|
After some back and forth with RedHat I was able to locate the missing Judy-devel package. For future reference, the steps to get it installed on RHEL 8 are:
I have done the above on our RHEL 8 builder on buildbot.askmonty.org. So we'll see with the next builds if that gets I also installed Judy-devel on the CentOS 8 builder, but ran into some issues with dnf not finding the correct Judy package to install along-side Judy-devel. Finally sorted it with the following, after enabling the mariadb-devel module:
| ||||||
| Comment by Daniel Bartholomew [ 2021-04-08 ] | ||||||
|
So far so good. I triggered a rebuild of the most recent 10.5 push on the rhel8-amd64 builder and it successfully built the MariaDB-oqgraph-engine and MariaDB-oqgraph-engine-debuginfo packages: | ||||||
| Comment by Daniel Bartholomew [ 2021-04-08 ] | ||||||
|
Packages from the above test build are available here if anyone wants to try them out: Keep in mind that these are pre-release packages and may have unresolved issues. But they should be suitable for testing the new 10.5 OQGraph rpm packages. | ||||||
| Comment by Nicholas Denning [ 2021-04-09 ] | ||||||
|
Daniel, many thanks. I will test this over the weekend. | ||||||
| Comment by Daniel Bartholomew [ 2021-05-11 ] | ||||||
|
The 10.5.10 release includes the MariaDB-oqgraph-engine plugin for RHEL 8. So closing. | ||||||
| Comment by Nicholas Denning [ 2021-05-11 ] | ||||||
|
Fantastic. So sorry for slowness in commenting. many thanks. |