January 2012 - discuss - lists.mariadb.org

[Maria-discuss] getting all name-value pairs from a dynamic column
by MARK CALLAGHAN 13 Apr '12

13 Apr '12

These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns How do you fetch all name-value pairs from a dynamic column in a format that can be consumed by a client? The client can select the column as is but then must know how mariadb encoded it. The function column_list returns the column names. If there were a function that encoded all name-value pairs as JSON, then the client could do something like this and be able to decode the result: select column_json(dynamic_column_name) from t where ... -- Mark Callaghan mdcallag(a)gmail.com

4 9

[Maria-discuss] auth_pam does not compile on OSX
by Terin Stock 20 Jan '12

20 Jan '12

The 5.2.10 version of MariaDB is not compiling for me (using homebrew) on OSX. The error and other information, is as follows. I've resolved the issue for now by passing in --without-plugin-auth_pam to configure. libtool: compile: /usr/bin/llvm-gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/Cellar/readline/6.2.1/include -DMYSQL_DYNAMIC_PLUGIN -O3 -w -pipe -march=core2 -msse4 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -c auth_pam.c -fno-common -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: ‘pam_info’ redeclared as different kind of symbol /usr/include/security/openpam.h:104: error: previous declaration of ‘pam_info’ was here make[2]: *** [auth_pam_la-auth_pam.lo] Error 1 $ ./configure --without-docs --without-debug --disable-dependency-tracking --prefix=/usr/local/Cellar/mariadb/5.2.10 --localstatedir=/usr/local/var/mysql --sysconfdir=/usr/local/etc/ --with-extra-charsets=complex --without-readline --enable-assembler --enable-thread-safe-client --with-big-tables --without-plugin-innodb_plugin --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-plugins=max-no-ndb --with-embedded-server --with-libevent C: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CXX: /usr/bin/llvm-g++ => /usr/llvm-gcc-4.2/bin/llvm-g++-4.2 LD: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CFLAGS: -O3 -w -pipe -march=core2 -msse4 CXXFLAGS: -O3 -w -pipe -march=core2 -msse4 -O3 -fno-omit-frame-pointer -felide-constructors CPPFLAGS: -I/usr/local/Cellar/readline/6.2.1/include LDFLAGS: -L/usr/local/Cellar/readline/6.2.1/lib MAKEFLAGS: -j4 -- #Terin Stock

4 5

[Maria-discuss] pam plugin does't compile on FreeBSD
by geoffroy desvernay 09 Jan '12

09 Jan '12

Hi everyone, I'm mariadb's port maintainer for FreeBSD, and I'd like to get it compile before pushing the 5.2.10 update... Seems to be the same problem than under OSX: (with openpam) https://lists.launchpad.net/maria-discuss/msg00506.html Under FreeBSD 9.0RC3 (and 8.2) amd64: libtool: compile: cc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/include -DMYSQL_DYNAMIC_PLUGIN -O2 -pipe -fno-strict-aliasing -MT auth_pam_la-auth_pam.lo -MD -MP -MF .deps/auth_pam_la-auth_pam.Tpo -c auth_pam.c -fPIC -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: 'pam_info' redeclared as different kind of symbol /usr/include/security/openpam.h:102: error: previous declaration of 'pam_info' was here *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 Sergei Golubchik wrote 'Fixed' in the referenced mail, but I don't know if it's fixed by removing pam support for OSX or ? (did not find any difference in bzr branch 5.2) Should I disable pam support for FreeBSD or is there any patch I could include in the port for 5.2.10 ? Thanks, -- *Geoffroy Desvernay* C.R.I - Administration systèmes et réseaux Ecole Centrale de Marseille

2 2