Re: MariaDB and OpenBSD

[Bogdan Andu]

on that machine I have imported mariadb in  /usr/ports/databases/mariadb, via
cvs, which compiled ok.

The problem was with p5-DBD-mysql needed by
mariadb-server-5.5.31p0, which refuses to install without it, and for that
reason I had to generate a p5-DBD-mysql for mariadb, using the Makefile rev.
1.36 for that package.

I took the following steps:
1. checkout mariadb from
cvs repository into
 /usr/ports/databases/mariadb
2. compiled and generated
the packages  mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0;
3. removed
mysql* packages (client and server) because of conflicts
4. when tried to
install newlly generated  mariadb-server-5.5.31p0 it required
 p5-DBD-mysql,
but p5-DBD-mysql depends on mysql-* stuff;
5. I removed p5-DBD-mysql;
6. I
update the Makefile with rev. 1.36 in
/usr/ports/databases/p5-DBD-mysql/Makefile to make it mariadb compatible
7. I
did sudo make install for p5-DBD-mysql
8. sudo pkg_add mariadb-server-5.5.31p0
9. sudo pkg_add mariadb-client-5.5.31p0


both client and server are working,
but programmaticaly I encountered that error which seems to be solved, as
Stefan Sperling suggested, via LD_PRELOAD env, var.

what I am doing wrong?

 From: Stuart Henderson s...@spacehopper.org
To: misc@openbsd.org 
Sent: Saturday, June 29, 2013 1:19 AM
Subject: Re:
MariaDB and OpenBSD
 

On 2013-06-28, Bogdan Andu bo...@yahoo.com wrote:

Hello,

 I have installed mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.
http://www.openbsd.org/faq/faq15.html#NoFun

Re: MariaDB and OpenBSD

[Stuart Henderson]

You are trying to use a -current ports tree on 5.3 which is not supported and 
you can have various problems as a result of this.

Also mariadb is not currently enabled in the ports tree. It is setup to use 
mysql not mariadb so you're going to have to modify the port for anything 
you're installing which uses mysql.


Bogdan Andu bo...@yahoo.com wrote:

on that machine I have imported mariadb in 
/usr/ports/databases/mariadb, via cvs, which compiled ok.

The problem was with p5-DBD-mysql needed by mariadb-server-5.5.31p0,
which refuses to install without it, and for that reason I had to
generate a p5-DBD-mysql for mariadb, using the Makefile rev. 1.36 for
that package.

I took the following steps:
1. checkout mariadb from cvs repository into
 /usr/ports/databases/mariadb
2. compiled and generated the packages  mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0;
3. removed mysql* packages (client and server) because of conflicts
4. when tried to install newlly generated  mariadb-server-5.5.31p0 it
required
 p5-DBD-mysql, but p5-DBD-mysql depends on mysql-* stuff;
5. I removed p5-DBD-mysql;
6. I update the Makefile with rev. 1.36 in
/usr/ports/databases/p5-DBD-mysql/Makefile to make it mariadb
compatible
7. I did sudo make install for p5-DBD-mysql
8. sudo pkg_add mariadb-server-5.5.31p0
9. sudo pkg_add mariadb-client-5.5.31p0


both client and server are working, but programmaticaly I encountered
that error which seems to be solved, as Stefan Sperling suggested, via
LD_PRELOAD env, var.

what I am doing wrong?




 From: Stuart Henderson s...@spacehopper.org
To: misc@openbsd.org 
Sent: Saturday, June 29, 2013 1:19 AM
Subject: Re: MariaDB and OpenBSD
 

On 2013-06-28, Bogdan Andu bo...@yahoo.com wrote:
 Hello,

 I have installed mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.

http://www.openbsd.org/faq/faq15.html#NoFun

Re: MariaDB and OpenBSD

[Bogdan Andu]

maybe the fact that mariadb packages built correctly made me blind enough 
to forget about any other package  that might depend on mysql and not mariadb
libraries, and curiously enough p5-DBD-mysql was one of them, which I modified
it to suport mariadb


i was excited to use mariadb on my OpenBSD machines.
i'll clean'em up and i'll  switch back to mysql-5.1 packages.

i have a some
remaining bits, though left in the dark namely, concerning that cryptic
message from cvs :

Revert back to using MySQL 5.1 for the time being.
MariaDB 5.5 introduces
a new libmysqlclient non-blocking API which utilizes
co-routines. The X86
specific GCC ASM co-routine support hid the fact that
there was an issue.
The only fallback code so far is POSIX user contexts which
OpenBSD does not
support.

Please if someone can shed more light upon this
comment, because it seems that it has impact on linux also
and based on this
comment, which seems to me very important, I want to know if it is safe to run
mariadb server
on linux also, as I do currently on an Ubuntu 13.04 linux
x86_64 .

Thank you all , for your comments,

Bogdan

 From: Stuart Henderson s...@spacehopper.org
To: Bogdan Andu bo...@yahoo.com; Bogdan Andu bo...@yahoo.com;
misc@openbsd.org misc@openbsd.org 
Sent: Monday, July 1, 2013 10:01 AM
Subject: Re: MariaDB and OpenBSD
 

You are trying to use a -current ports
tree on 5.3 which is not supported and you can have various problems as a
result of this.

Also mariadb is not currently enabled in the ports tree. It
is setup to use mysql not mariadb so you're going to have to modify the port
for anything you're installing which uses mysql.


Bogdan Andu
bo...@yahoo.com wrote:

on that machine I have imported mariadb in 
/usr/ports/databases/mariadb, via cvs, which compiled ok.

The problem was
with p5-DBD-mysql needed by mariadb-server-5.5.31p0,
which refuses to install
without it, and for that reason I had to
generate a p5-DBD-mysql for mariadb,
using the Makefile rev. 1.36 for
that package.

I took the following steps:
1. checkout mariadb from cvs repository into
 /usr/ports/databases/mariadb
2. compiled and generated the packages  mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0;
3. removed mysql* packages (client and server)
because of conflicts
4. when tried to install newlly generated 
mariadb-server-5.5.31p0 it
required
 p5-DBD-mysql, but p5-DBD-mysql depends
on mysql-* stuff;
5. I removed p5-DBD-mysql;
6. I update the Makefile with
rev. 1.36 in
/usr/ports/databases/p5-DBD-mysql/Makefile to make it mariadb
compatible
7. I did sudo make install for p5-DBD-mysql
8. sudo pkg_add
mariadb-server-5.5.31p0
9. sudo pkg_add mariadb-client-5.5.31p0


both
client and server are working, but programmaticaly I encountered
that error
which seems to be solved, as Stefan Sperling suggested, via
LD_PRELOAD env,
var.

what I am doing wrong?




 From:
Stuart Henderson s...@spacehopper.org
To: misc@openbsd.org 
Sent: Saturday,
June 29, 2013 1:19 AM
Subject: Re: MariaDB and OpenBSD
 

On 2013-06-28,
Bogdan Andu bo...@yahoo.com wrote:
 Hello,

 I have installed
mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64
machine.

http://www.openbsd.org/faq/faq15.html#NoFun

Re: MariaDB and OpenBSD

[Stuart Henderson]

The relevant code is in the client library and if I remember correctly is just 
used for asynchronous access functions. It won't affect your use of the server 
on Linux x86/x86_64.

The relevant code is written in assembler for amd64/i386 and for other arches 
it falls back to using ucontext.h functions specified by an old version of 
posix which were never implemented on OpenBSD. They were marked 'obsokescent' 
in newer posix due to a dependency on an obsolescent C language feature (see 
'rationale' in 
http://pubs.opengroup.org/onlinepubs/009695399/functions/makecontext.html) so 
can't be used in strictly posix-conforming software.

They aren't widely used (I've only seen it in mariadb and powerdns-recursor) 
and unlikely to be added to OpenBSD. (For some uses, boost's context library 
might be an alternative, though I'm unsure about arch support).

Bogdan Andu bo...@yahoo.com wrote:



maybe the fact that mariadb packages built correctly made me blind
enough  to forget about any other package  that might depend on mysql
and not mariadb libraries, and curiously enough p5-DBD-mysql was one of
them, which I modified it to suport mariadb


i was excited to use mariadb on my OpenBSD machines.

i'll clean'em up and i'll  switch back to mysql-5.1 packages.

i have a some remaining bits, though left in the dark namely,
concerning that cryptic message from cvs :

Revert back to using MySQL 5.1 for the time being. MariaDB 5.5
introduces
a new libmysqlclient non-blocking API which utilizes co-routines. The
X86
specific GCC ASM co-routine support hid the fact that there was an
issue.
The only fallback code so far is POSIX user contexts which OpenBSD does
not
support.

Please if someone can shed more light upon this comment, because it
seems that it has impact on linux also
and based on this comment, which seems to me very important, I want to
know if it is safe to run mariadb server
on linux also, as I do currently on an Ubuntu 13.04 linux x86_64 .

Thank you all , for your comments,

Bogdan



 From: Stuart Henderson s...@spacehopper.org
To: Bogdan Andu bo...@yahoo.com; Bogdan Andu bo...@yahoo.com;
misc@openbsd.org misc@openbsd.org 
Sent: Monday, July 1, 2013 10:01 AM
Subject: Re: MariaDB and OpenBSD
 

You are trying to use a -current ports tree on 5.3 which is not
supported and you can have various problems as a result of this.

Also mariadb is not currently enabled in the ports tree. It is setup to
use mysql not mariadb so you're going to have to modify the port for
anything you're installing which uses mysql.


Bogdan Andu bo...@yahoo.com wrote:

on that machine I have imported mariadb in 
/usr/ports/databases/mariadb, via cvs, which compiled ok.

The problem was with p5-DBD-mysql needed by mariadb-server-5.5.31p0,
which refuses to install without it, and for that reason I had to
generate a p5-DBD-mysql for mariadb, using the Makefile rev. 1.36 for
that package.

I took the following steps:
1. checkout mariadb from cvs repository into
 /usr/ports/databases/mariadb
2. compiled and generated the packages  mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0;
3. removed mysql* packages (client and server) because of conflicts
4. when tried to install newlly generated  mariadb-server-5.5.31p0 it
required
 p5-DBD-mysql, but p5-DBD-mysql depends on mysql-* stuff;
5. I removed p5-DBD-mysql;
6. I update the Makefile with rev. 1.36 in
/usr/ports/databases/p5-DBD-mysql/Makefile to make it mariadb
compatible
7. I did sudo make install for p5-DBD-mysql
8. sudo pkg_add mariadb-server-5.5.31p0
9. sudo pkg_add mariadb-client-5.5.31p0


both client and server are working, but programmaticaly I encountered
that error which seems to be solved, as Stefan Sperling suggested, via
LD_PRELOAD env, var.

what I am doing wrong?




 From: Stuart Henderson s...@spacehopper.org
To: misc@openbsd.org 
Sent: Saturday, June 29, 2013 1:19 AM
Subject: Re: MariaDB and OpenBSD
 

On 2013-06-28, Bogdan Andu bo...@yahoo.com wrote:
 Hello,

 I have installed mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.

http://www.openbsd.org/faq/faq15.html#NoFun

Re: MariaDB and OpenBSD

[Bogdan Andu]

If I understand correctly, mariadb packages on OpenBSD machine (5.3, amd64)
should work fine, only the client has these posix issues on platforms other
than i386 or amd64.

and as far as I can see the integration of mariadb in
OpenBSD on archs other than i386 or amd64 depends on the implementation of
that
assembler code.


Having these in mind what is the roadmap of integrating
mariadb in OpenBSD?

Bogdan




 From: Stuart
Henderson s...@spacehopper.org
To: Bogdan Andu bo...@yahoo.com; Bogdan Andu
bo...@yahoo.com; misc@openbsd.org misc@openbsd.org 
Sent: Monday, July
1, 2013 11:04 AM
Subject: Re: MariaDB and OpenBSD
 

The relevant code is in
the client library and if I remember correctly is just used for asynchronous
access functions. It won't affect your use of the server on Linux x86/x86_64.
The relevant code is written in assembler for amd64/i386 and for other arches
it falls back to using ucontext.h functions specified by an old version of
posix which were never implemented on OpenBSD. They were marked 'obsokescent'
in newer posix due to a dependency on an obsolescent C language feature (see
'rationale' in
http://pubs.opengroup.org/onlinepubs/009695399/functions/makecontext.html) so
can't be used in strictly posix-conforming software.

They aren't widely used
(I've only seen it in mariadb and powerdns-recursor) and unlikely to be added
to OpenBSD. (For some uses, boost's context library might be an alternative,
though I'm unsure about arch support).

Bogdan Andu bo...@yahoo.com wrote:


maybe the fact that mariadb packages built correctly made me blind
enough  to forget about any other package  that might depend on mysql
and
not mariadb libraries, and curiously enough p5-DBD-mysql was one of
them,
which I modified it to suport mariadb


i was excited to use mariadb on my
OpenBSD machines.

i'll clean'em up and i'll  switch back to mysql-5.1
packages.

i have a some remaining bits, though left in the dark namely,
concerning that cryptic message from cvs :

Revert back to using MySQL 5.1
for the time being. MariaDB 5.5
introduces
a new libmysqlclient non-blocking
API which utilizes co-routines. The
X86
specific GCC ASM co-routine support
hid the fact that there was an
issue.
The only fallback code so far is POSIX
user contexts which OpenBSD does
not
support.

Please if someone can shed
more light upon this comment, because it
seems that it has impact on linux
also
and based on this comment, which seems to me very important, I want to
know if it is safe to run mariadb server
on linux also, as I do currently on
an Ubuntu 13.04 linux x86_64 .

Thank you all , for your comments,

Bogdan



 From: Stuart Henderson
s...@spacehopper.org
To: Bogdan Andu bo...@yahoo.com; Bogdan Andu
bo...@yahoo.com;
misc@openbsd.org misc@openbsd.org 
Sent: Monday, July
1, 2013 10:01 AM
Subject: Re: MariaDB and OpenBSD
 

You are trying to use
a -current ports tree on 5.3 which is not
supported and you can have various
problems as a result of this.

Also mariadb is not currently enabled in the
ports tree. It is setup to
use mysql not mariadb so you're going to have to
modify the port for
anything you're installing which uses mysql.


Bogdan
Andu bo...@yahoo.com wrote:

on that machine I have imported mariadb in 
/usr/ports/databases/mariadb, via cvs, which compiled ok.

The problem
was with p5-DBD-mysql needed by mariadb-server-5.5.31p0,
which refuses to
install without it, and for that reason I had to
generate a p5-DBD-mysql for
mariadb, using the Makefile rev. 1.36 for
that package.

I took the
following steps:
1. checkout mariadb from cvs repository into

/usr/ports/databases/mariadb
2. compiled and generated the packages 
mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0;
3. removed mysql*
packages (client and server) because of conflicts
4. when tried to install
newlly generated  mariadb-server-5.5.31p0 it
required
 p5-DBD-mysql, but
p5-DBD-mysql depends on mysql-* stuff;
5. I removed p5-DBD-mysql;
6. I
update the Makefile with rev. 1.36 in
/usr/ports/databases/p5-DBD-mysql/Makefile to make it mariadb
compatible
7. I did sudo make install for p5-DBD-mysql
8. sudo pkg_add
mariadb-server-5.5.31p0
9. sudo pkg_add mariadb-client-5.5.31p0


both
client and server are working, but programmaticaly I encountered
that error
which seems to be solved, as Stefan Sperling suggested, via
LD_PRELOAD env,
var.

what I am doing wrong?




 From: Stuart Henderson s...@spacehopper.org
To: misc@openbsd.org
Sent: Saturday, June 29, 2013 1:19 AM
Subject: Re: MariaDB and OpenBSD


On 2013-06-28, Bogdan Andu bo...@yahoo.com wrote:
 Hello,

 I
have installed mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an
OpenBSD 5.3 amd64 machine.

http://www.openbsd.org/faq/faq15.html#NoFun

Re: MariaDB and OpenBSD

[Stefan Sperling]

On Fri, Jun 28, 2013 at 01:49:09AM -0700, Bogdan Andu wrote:
 Hello,
 
 I have installed mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.
 
 I have also re-installed from ports
 p5-DBD-mysql with version 1.36 of Makefile, which supports mariadb.
 p5-DBD-mysql via pkg_add gives me this error:
 sudo pkg_add
 /usr/ports/packages/amd64/all/mariadb-server-5.5.31p0.tgz 
 Can't install
 mysql-client-5.1.68 because of conflicts
 (mariadb-client-5.5.31p0,mariadb-tests-5.5.31p0)
 Can't install
 p5-DBD-mysql-4.022: can't resolve mysql-client-5.1.68
 Can't install
 mariadb-server-5.5.31p0: can't resolve p5-DBD-mysql-4.022
 ---
 mysql-client-5.1.68 ---
 Can't install mysql-client-5.1.68:
 conflicts
 
 because it depends on the mysql-client-5.1.68.

I'd suggest to just use mysql until mariadb has been properly
integrated into OpenBSD and has replaced mysql.

 mariadb-server is
 running, I am able to connect to the server via mysql command line client.
 However I am not able to do the same thing from a Perl script when trying to
 connect to the a mariadb database.
 
 install_driver(mysql) failed: Can't load
 '/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/mysql/mysql.so'
 for module DBD::mysql: Cannot load specified object at
 /usr/libdata/perl5/amd64-openbsd/5.12.2/DynaLoader.pm line 200.
 ?at (eval 5)
 line 3
 Compilation failed in require at (eval 5) line 3.
 Perhaps a required
 shared library or dll isn't installed where expected

Perhaps you need to pre-load libpthread?
Try running your script like this:
  env LD_PRELOAD=libpthread.so perl your-script.pl
 
 May this has something
 to do with the comment from cvs repository for
 ports/databases/p5-DBD-mysql/Makefile:
 
 Revert back to using MySQL 5.1 for
 the time being. MariaDB 5.5 introduces
 a new libmysqlclient non-blocking API
 which utilizes co-routines. The X86
 specific GCC ASM co-routine support hid
 the fact that there was an issue.
 The only fallback code so far is POSIX user
 contexts which OpenBSD does not
 support.

No, that's a different problem. MariaDB doesn't work on any architecture
other than i386 and amd64 because of this, since OpenBSD doesn't support
the fallback mode MariaDB developers have chosen for other architectures.

Re: MariaDB and OpenBSD

[Bogdan Andu]

ok, that did the trick

but how can I specify in one place this variable
env LD_PRELOAD=libpthread.so?

is this related to mariadb-client?

i think
i'll switch back to mysql until mariadb is fully supported by OpenBSD.
Bogdan



 From: Stefan Sperling
s...@openbsd.org
To: Bogdan Andu bo...@yahoo.com 
Cc: misc@openbsd.org
misc@openbsd.org 
Sent: Friday, June 28, 2013 12:06 PM
Subject: Re: MariaDB
and OpenBSD
 

On Fri, Jun 28, 2013 at 01:49:09AM -0700, Bogdan Andu wrote:

Hello,
 
 I have installed mariadb-server-5.5.31p0 and
mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.
 
 I have also
re-installed from ports
 p5-DBD-mysql with version 1.36 of Makefile, which
supports mariadb.
 p5-DBD-mysql via pkg_add gives me this error:
 sudo
pkg_add
 /usr/ports/packages/amd64/all/mariadb-server-5.5.31p0.tgz 
 Can't
install
 mysql-client-5.1.68 because of conflicts

(mariadb-client-5.5.31p0,mariadb-tests-5.5.31p0)
 Can't install

p5-DBD-mysql-4.022: can't resolve mysql-client-5.1.68
 Can't install

mariadb-server-5.5.31p0: can't resolve p5-DBD-mysql-4.022
 ---

mysql-client-5.1.68 ---
 Can't install mysql-client-5.1.68:

conflicts
 
 because it depends on the mysql-client-5.1.68.

I'd suggest to
just use mysql until mariadb has been properly
integrated into OpenBSD and has
replaced mysql.

 mariadb-server is
 running, I am able to connect to the
server via mysql command line client.
 However I am not able to do the same
thing from a Perl script when trying to
 connect to the a mariadb database.

 install_driver(mysql) failed: Can't load

'/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/mysql/mysql.so'

for module DBD::mysql: Cannot load specified object at

/usr/libdata/perl5/amd64-openbsd/5.12.2/DynaLoader.pm line 200.
 ?at (eval 5)
 line 3
 Compilation failed in require at (eval 5) line 3.
 Perhaps a
required
 shared library or dll isn't installed where expected

Perhaps you
need to pre-load libpthread?
Try running your script like this:
  env
LD_PRELOAD=libpthread.so perl your-script.pl


 May this has something
 to
do with the comment from cvs repository for

ports/databases/p5-DBD-mysql/Makefile:
 
 Revert back to using MySQL 5.1
for
 the time being. MariaDB 5.5 introduces
 a new libmysqlclient
non-blocking API
 which utilizes co-routines. The X86
 specific GCC ASM
co-routine support hid
 the fact that there was an issue.
 The only fallback
code so far is POSIX user
 contexts which OpenBSD does not
 support.

No,
that's a different problem. MariaDB doesn't work on any architecture
other
than i386 and amd64 because of this, since OpenBSD doesn't support
the
fallback mode MariaDB developers have chosen for other architectures.

Re: MariaDB and OpenBSD

[Marc Espie]

On Fri, Jun 28, 2013 at 02:36:10AM -0700, Bogdan Andu wrote:
 ok, that did the trick
 
 but how can I specify in one place this variable
 env LD_PRELOAD=libpthread.so?
 
 is this related to mariadb-client?
 
 i think
 i'll switch back to mysql until mariadb is fully supported by OpenBSD.
 Bogdan

It's more a question of mariadb fully supporting OpenBSD, actually, as there
are limitations in some mariadb new api that only work on a few selected
platforms using assemblers, and on some others using dubious obsolete
system calls that OpenBSD never implemented.

Re: MariaDB and OpenBSD

[Stefan Sperling]

On Fri, Jun 28, 2013 at 02:36:10AM -0700, Bogdan Andu wrote:
 
 
 ok, that did the trick
 
 but how can I specify in one place this variable  env 
 LD_PRELOAD=libpthread.so?

You can write a small wrapper shell script that sets the variable and
then runs your perl script. See here for an example:
http://www.openbsd.org/cgi-bin/cvsweb/ports/games/frozen-bubble/files/Attic/wrapper.sh?rev=1.1;content-type=text%2Fplain;hideattic=0

It might already work in -current without LD_PRELOAD. So by the time
OpenBSD 5.4 comes out you can probably stop using a wrapper script.
I don't think upgrading to -current just for this is worth the effort.

 is this related to mariadb-client?

No. It's related to perl not being linked to the pthread library.

Re: MariaDB and OpenBSD

[Stuart Henderson]

On 2013-06-28, Bogdan Andu bo...@yahoo.com wrote:
 Hello,

 I have installed mariadb-server-5.5.31p0 and mariadb-client-5.5.31p0
 on an OpenBSD 5.3 amd64 machine.

http://www.openbsd.org/faq/faq15.html#NoFun