Re: Which knobs do I use to control BDB use in MySQL-server port?
> I'll check the build's output with ldd when the build finishes. Looks like the simple workaround works :-) ldd /usr/local/libexec/mysqld libz.so.3 => /lib/libz.so.3 (0x284a8000) libwrap.so.4 => /usr/lib/libwrap.so.4 (0x284b9000) libssl.so.5 => /usr/local/lib/libssl.so.5 (0x284c) libcrypto.so.5 => /usr/local/lib/libcrypto.so.5 (0x284fc000) libcrypt.so.3 => /lib/libcrypt.so.3 (0x28642000) libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x2865a000) libm.so.4 => /lib/libm.so.4 (0x28725000) libpthread.so.2 => /lib/libpthread.so.2 (0x2873b000) libc.so.6 => /lib/libc.so.6 (0x2876) Port install's done -- with No BDB. Great! Bye, Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan, One last thing (It's way past my bedtime here ;-p) > See that "--with-berkeley-db" in there? :-( A little digging in the mysql ditribution's source files dredged up the "CONF_COMMAND" variable. Do-ing, CONF_COMMAND="--without-berkeley-db"; export $CONF_COMMAND perl -pi -e 's/^(CONFIGURE_ARGS.*)with-berkeley-db(.*)$/$1without-berkeley-db$2/g' Makefile Seems to do the trick as far as the build /process/ goes, grep berkeley-db ./work/mysql-5.0.45/config.log | grep "$ ./configure" $ ./configure --localstatedir=/var/db/mysql --without-debug --without-readline --without-libedit --without-bench --without-extra-tools --with-libwrap --with-mysqlfs --with-low-memory --with-comment=FreeBSD port: mysql-server-5.0.45 --enable-thread-safe-client --with-openssl=/usr/local --enable-assembler --without-berkeley-db --with-named-thread-libs=-pthread --prefix=/usr/local --mandir=/usr/local/man --infodir=/usr/local/info/ --build=i386-portbld-freebsd6.2 See the "--without-berkeley-db" is there, now. I'll check the build's output with ldd when the build finishes. For now, my pooch inists that it's "lights out" <:-} Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan! > I just tried it and it looks like that does disable bdb. I never > noticed that line in the Makefile before :) Well, you'd think it should. But even with, grep berkeley-db ./Makefile CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db the build seems to /ignore/ the flag, grep berkeley-db ./work/mysql-5.0.45/config.log | grep "$ ./configure" $ ./configure --localstatedir=/var/db/mysql --without-debug --without-readline --without-libedit --without-bench --without-extra-tools --with-libwrap --with-mysqlfs --with-low-memory --with-comment=FreeBSD port: mysql-server-5.0.45 --enable-thread-safe-client --with-openssl=/usr/local --enable-assembler --with-berkeley-db --with-named-thread-libs=-pthread --prefix=/usr/local --mandir=/usr/local/man --infodir=/usr/local/info/ --build=i386-portbld-freebsd6.2 See that "--with-berkeley-db" in there? :-( Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Which knobs do I use to control BDB use in MySQL-server port?
In the last episode (Sep 19), Aliya Harbouri said:
> > > (1) Turn OFF use of BDB completely. The build seems to default
> > > to the bundled BDB
> >
> > Mysql 5.0's configure script doesn't seem to have a --without-bdb
> > flag, so it always gets built.
>
> > > (2) Use the Port install of BDB v46 I mentioned above.
> >
> > It does have a --with-berkeley-db=DIR flag, so you could add that
> > to CONFIGURE_ARGS to force an external bdb to be used instead of
> > the one bundled with mysql. Note that the bdb engine has been
> > removed from mysql 5.1, so you should think about moving any bdb
> > tables you might already have to innodb. Development on the bdb
> > engine pretty much stopped once innodb was available.
>
> Gotcha!
>
> So, If I'm going to use the Port & make changes anyway, since,
>
> grep berkeley-db Makefile
>CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
>
> I suppose I might as well just do
>
> vi Makefile
>
> .if ${ARCH} == "i386"
> - CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
> + CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db
> .endif
I just tried it and it looks like that does disable bdb. I never
noticed that line in the Makefile before :)
> I know about the BDB-engine removal, too. Funny that this Port
> doesn't give you that option.
>
> Thanks a lot!
>
> Ali
--
Dan Nelson
[EMAIL PROTECTED]
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan!
> > (1) Turn OFF use of BDB completely. The build seems to default to the
> > bundled BDB
>
> Mysql 5.0's configure script doesn't seem to have a --without-bdb flag,
> so it always gets built.
> > (2) Use the Port install of BDB v46 I mentioned above.
>
> It does have a --with-berkeley-db=DIR flag, so you could add that to
> CONFIGURE_ARGS to force an external bdb to be used instead of the one
> bundled with mysql. Note that the bdb engine has been removed from
> mysql 5.1, so you should think about moving any bdb tables you might
> already have to innodb. Development on the bdb engine pretty much
> stopped once innodb was available.
Gotcha!
So, If I'm going to use the Port & make changes anyway, since,
grep berkeley-db Makefile
CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
I suppose I might as well just do
vi Makefile
.if ${ARCH} == "i386"
- CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
+ CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db
.endif
I know about the BDB-engine removal, too. Funny that this Port
doesn't give you that option.
Thanks a lot!
Ali
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Which knobs do I use to control BDB use in MySQL-server port?
In the last episode (Sep 18), Aliya Harbouri said: > Building the databases/mysql50-server Port, I see (they'er all in > Makefile, yes?) my choices for knob-settings in make.conf are: > > WITH_OPENSSL=true > WITH_PROC_SCOPE_PTH=yes > BUILD_OPTIMIZED=yes > WITH_INNODB=yes > WITHOUT_ARCHIVE=true > WITHOUT_CSV=true > WITHOUT_FEDERATED=true > WITHOUT_NDB=true > > Turning INNODB on/off is clear. > > But I haven't been able to grok how to > > (1) Turn OFF use of BDB completely. The build seems to default to the > bundled BDB Mysql 5.0's configure script doesn't seem to have a --without-bdb flag, so it always gets built. > (2) Use the Port install of BDB v46 I mentioned above. It does have a --with-berkeley-db=DIR flag, so you could add that to CONFIGURE_ARGS to force an external bdb to be used instead of the one bundled with mysql. Note that the bdb engine has been removed from mysql 5.1, so you should think about moving any bdb tables you might already have to innodb. Development on the bdb engine pretty much stopped once innodb was available. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Which knobs do I use to control BDB use in MySQL-server port?
Hi everybody, I'm building my 1st FreeBSD-based box. Yay, I guess ;-p I've already installed Berkeley DB v46 from the Ports system. Now, I'ts on to MySQL server. I can easily build manually from source, configuring whatever I need. But, I'm trying to get the Ports system's "knobs" figured out :-/ Building the databases/mysql50-server Port, I see (they'er all in Makefile, yes?) my choices for knob-settings in make.conf are: WITH_OPENSSL=true WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes WITH_INNODB=yes WITHOUT_ARCHIVE=true WITHOUT_CSV=true WITHOUT_FEDERATED=true WITHOUT_NDB=true Turning INNODB on/off is clear. But I haven't been able to grok how to (1) Turn OFF use of BDB completely. The build seems to default to the bundled BDB (2) Use the Port install of BDB v46 I mentioned above. Can somebody explaing the right knobs to turn to do both? Or, do I have to rely on manual configuration? THanks a lot! Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
