Comments - Installing OQGRAPH

 
1 year ago Kevin Coonan, MD

There isn't much on installing OQGRAPH on openSUSE (Leap 15.5 and/or Tumbleweed).

I would like to know how other openSUSE users have stood up OQGRAPH and am somewhat surprised that it isn't even in someone's home repo.

Several options suggest themselves: 1. Build everything from source so I have full control and maintenance headaches. If # ./configure, # make , and either $ make install --or-- install into my local /bin/ works, then super! Lots of fun. 2. Use the Fedora or RedHat RPMs and cross my fingers 3. Use the Fedora/RedHat RPMs in a container (this seems like the route I am least likely to screw everything up with) 4. Use Distrobox and the Fedora or RedHat (e.g. install Scientific Linux into Distrobox). 5. Other ideas?

Thank you!

 
7 years, 6 months ago maziar Sedghisaray

Hi everyone I have problem with installing oqgraph engine, can anyone suggest something??

" ERROR 1126 (HY000): Can't open shared library 'ha_oqgraph.so' (errno: 8, API version for STORAGE ENGINE plugin OQGRAPH not supported by this version of the server) "

my installation steps on centos 6 minimal are following: 1- Setting up MariaDB Repositories 2- install epel-release and socat 3- install Development Tools 4- install wget 5- install boost boost-devel boost-doc 6- wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm 7- rpm -Uvh epel-release-6-8.noarch.rpm 8- yum install Judy 9-yum install MariaDB-Galera-server MariaDB*engine MariaDB-client rsync galera

it shows me that oqgraph and other engines installed but when I check MariaDB engines with "SHOW ENGINES" oqgraph is not installed and when I try to install it with "INSTALL SONAME 'ha_oqgraph'" it gives me the error which I mentioned above

Thanks for any advice Regards Maziar

 
8 years, 1 month ago Luke

Is this package currently supported on Fedora 24? I have found a package for F23, but am having difficulty finding a version for the latest Fedora. Thanks!

 
8 years, 7 months ago Jan Steinman

I'm getting an error 2 on MariaDB 10.1.1 on Mac OS 10.10.5, installed via Homebrew:

Can't open shared library '/usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_oqgraph.so' (errno: 2, dlopen(/usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_oqgraph.so, 2): no suitable image found.  Did find:
	/usr/local/Cellar/ma)

/usr/include/sys/errno.h implies that the file doesn't exist, but I can see it seems to have the same perms as other plugins that can be INSTALLed (such as CONNECT):

# ls -l /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_*.so
-r--r--r--  1 _mysql  admin    53336 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_archive.so
-r--r--r--  1 _mysql  admin    30664 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_blackhole.so
-r--r--r--  1 _mysql  admin   895120 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_connect.so
-r--r--r--  1 _mysql  admin    31504 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_example.so
-r--r--r--  1 _mysql  admin    49084 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_federated.so
-r--r--r--  1 _mysql  admin    72920 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_federatedx.so
-r--r--r--  1 _mysql  admin  2292516 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_innodb.so
-r--r--r--  1 _mysql  admin  2798648 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_mroonga.so
-r--r--r--  1 _mysql  admin    62140  3 Feb 17:06 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_oqgraph.so
-r--r--r--  1 _mysql  admin    70860 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_sphinx.so
-r--r--r--  1 _mysql  admin   711416 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_spider.so
-r--r--r--  1 _mysql  admin    24844 23 Dec 07:33 /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_test_sql_discovery.so

Any clues what's going on here?

 
8 years, 7 months ago Sergei Golubchik

If you google for "Can't open shared library no suitable image found" you'll find quite a few hints of might be the reason. Start from

$ file /usr/local/Cellar/mariadb/10.1.10/lib/plugin/ha_*.so

What did you get?

 
8 years, 7 months ago Jan Steinman

Thanks for the pointer, which I will investigate further.

file(1) shows that all the ha_*.so libs are "Mach-O 64-bit bundle x86_64", EXCEPT ha_oqgraph.so, which is "Mach-O 64-bit object x86_64".

 
8 years, 7 months ago Sergei Golubchik

Did you build MariaDB as in here or installed as in here?

 
8 years, 7 months ago Jan Steinman

I had done a "brew install maraidb", on top of a previous install. But I a sum(1) on that file and the oqgraph from 10.1.6, and they are the same. So I may have some crufty old stuff hanging around somehow.

I just did a clean "brew install mariadb" on another machine. No ha_oqgraph.so gets installed:

0 Create:jan-/Volumes/1.5TB/Applications/Google Chrome.app/Contents: ls -la /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_*.so
-r--r-----  1 jan  admin    53336 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_archive.so
-r--r-----  1 jan  admin    30664 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_blackhole.so
-r--r-----  1 jan  admin   895008 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_connect.so
-r--r-----  1 jan  admin    31504 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_example.so
-r--r-----  1 jan  admin    49084 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_federated.so
-r--r-----  1 jan  admin    72920 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_federatedx.so
-r--r-----  1 jan  admin  2292516 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_innodb.so
-r--r-----  1 jan  admin  2798648 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_mroonga.so
-r--r-----  1 jan  admin    70860 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_sphinx.so
-r--r-----  1 jan  admin   711416 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_spider.so
-r--r-----  1 jan  admin    24844 28 Jan 04:13 /usr/local/Cellar/mariadb/10.1.11/lib/plugin/ha_test_sql_discovery.so

What has to be done to get ha_oqgraph.so built? I'm willing to hack around on the Homebrew formula if I have a good starting point.

From looking at "brew edit mariadb", is it as simple as setting the compile flag: "-DPLUGIN_OQGRAPH=YES"?

Thanks for any advice offered!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.