Re: [gentoo-user] mysql-8.0.32-r2 compile failure

[Dale]

Ionen Wolkens wrote:
> On Wed, Feb 14, 2024 at 08:00:08AM -0600, Dale wrote:
>> Howdy,
>>
>> This has been failing for a while now, month or two.  I did a few
>> searches but what I did find shows a similar problem was fixed ages
>> ago.  The link is about protobuf but seems related.  Link further down. 
>> I'm wondering if it may be a USE flag or something triggering this since
>> it can't find anything more recent.  It also fails on a previous version
>> as well.  The error bit is about midways.  I tried to get either side of
>> it. 
>  
>> ld.lld: error: undefined symbol: AbslInternalSpinLockWake_lts_20230802
> referenced by spinlock_wait.h:85
>> (/usr/include/absl/base/internal/spinlock_wait.h:85)
>   
>> CMakeFiles/xprotocol_plugin.dir/message_field_chain.cc.o:(void
>> absl::lts_20230802::base_internal::CallOnceImpl> (*)(google::protobuf::FieldDescriptor const*),
>> google::protobuf::FieldDescriptor const*>(std::atomic*,
>> absl::lts_20230802::base_internal::SchedulingMode, void
>> (*&&)(google::protobuf::FieldDescriptor const*),
>> google::protobuf::FieldDescriptor const*&&))
>> collect2: error: ld returned 1 exit status
>> Link mentioned above, dated a while back and claims upstream fixed. 
>>
>> https://github.com/protocolbuffers/protobuf/issues/12292
> Sounds like https://bugs.gentoo.org/912797 which is fixed but only in
> ~testing dev-db/mysql-8.0.34. Albeit as far as I'm aware this shouldn't
> affect stable 8.0.32-r2 unless you're using ~testing protobuf-23 (aka
> mixing stable and ~testing). Not that I tried building it.


That was it.  I keyworded the .34 version and it compiled just fine.  I
thought I had tried that already but maybe I did before it was fixed.  I
do run some things unstable, KDE for example, but try to keep things
mostly stable, especially those things that are needed to boot and such. 

Anyway, now I have a clean updated system again.  :-D 

Thanks much.

Dale

:-)  :-) 

Re: [gentoo-user] mysql-8.0.32-r2 compile failure

[Ionen Wolkens]

On Wed, Feb 14, 2024 at 08:00:08AM -0600, Dale wrote:
> Howdy,
> 
> This has been failing for a while now, month or two.  I did a few
> searches but what I did find shows a similar problem was fixed ages
> ago.  The link is about protobuf but seems related.  Link further down. 
> I'm wondering if it may be a USE flag or something triggering this since
> it can't find anything more recent.  It also fails on a previous version
> as well.  The error bit is about midways.  I tried to get either side of
> it. 
 
> ld.lld: error: undefined symbol: AbslInternalSpinLockWake_lts_20230802
> >>> referenced by spinlock_wait.h:85
> (/usr/include/absl/base/internal/spinlock_wait.h:85)
> >>>  
> CMakeFiles/xprotocol_plugin.dir/message_field_chain.cc.o:(void
> absl::lts_20230802::base_internal::CallOnceImpl (*)(google::protobuf::FieldDescriptor const*),
> google::protobuf::FieldDescriptor const*>(std::atomic*,
> absl::lts_20230802::base_internal::SchedulingMode, void
> (*&&)(google::protobuf::FieldDescriptor const*),
> google::protobuf::FieldDescriptor const*&&))
> collect2: error: ld returned 1 exit status

> Link mentioned above, dated a while back and claims upstream fixed. 
> 
> https://github.com/protocolbuffers/protobuf/issues/12292

Sounds like https://bugs.gentoo.org/912797 which is fixed but only in
~testing dev-db/mysql-8.0.34. Albeit as far as I'm aware this shouldn't
affect stable 8.0.32-r2 unless you're using ~testing protobuf-23 (aka
mixing stable and ~testing). Not that I tried building it.
-- 
ionen


signature.asc
Description: PGP signature

[gentoo-user] mysql-8.0.32-r2 compile failure

[Dale]

Howdy,

This has been failing for a while now, month or two.  I did a few
searches but what I did find shows a similar problem was fixed ages
ago.  The link is about protobuf but seems related.  Link further down. 
I'm wondering if it may be a USE flag or something triggering this since
it can't find anything more recent.  It also fails on a previous version
as well.  The error bit is about midways.  I tried to get either side of
it. 




[ 13%] Building CXX object
plugin/x/protocol/protobuf/CMakeFiles/mysqlxmessages_lite.dir/__/__/generated/protobuf_lite/mysqlx_expr.pb.cc.o
cd
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/plugin/x/protocol/protobuf
&& /usr/bin/x86_64-pc-linux-gnu-g++ -DBOOST_NO_CXX98_FUNCTION_BASE
-DHAVE_CONFIG_H -DHAVE_TLSv13 -DLOG_COMPONENT_TAG=\"mysqlx\"
-DLZ4_DISABLE_DEPRECATE_WARNINGS -DRAPIDJSON_NO_SIZETYPEDEFINE
-DRAPIDJSON_SCHEMA_USE_INTERNALREGEX=0 -DRAPIDJSON_SCHEMA_USE_STDREGEX=1
-D_FILE_OFFSET_BITS=64 -D_GNU_SOURCE -D_USE_MATH_DEFINES
-D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/include
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/include -isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/extra/rapidjson/include
-isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/extra/libedit/libedit-20210910-3.1/src/editline
-isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/plugin/x/client
-isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/plugin/x/generated/protobuf_lite
-isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/plugin/x/generated
-U_FORTIFY_SOURCE -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -march=native
-O2 -pipe -std=c++17 -Wall -Wextra -Wformat-security -Wvla -Wundef
-Wmissing-format-attribute -Woverloaded-virtual -Wcast-qual
-Wimplicit-fallthrough=5 -Wstringop-truncation -Wsuggest-override
-Wmissing-include-dirs -Wextra-semi -Wlogical-op -DNDEBUG -g1 -fPIC  
-U_FORTIFY_SOURCE -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 
-Wno-unused-variable -Wno-undef -Wno-ignored-qualifiers
-Wno-sign-compare -Wno-suggest-override  -Wno-unused-parameter
-Wno-undef -Wno-unused-but-set-parameter -Wno-extra-semi
-Wno-suggest-override -MD -MT
plugin/x/protocol/protobuf/CMakeFiles/mysqlxmessages_lite.dir/__/__/generated/protobuf_lite/mysqlx_expr.pb.cc.o
-MF
CMakeFiles/mysqlxmessages_lite.dir/__/__/generated/protobuf_lite/mysqlx_expr.pb.cc.o.d
-o
CMakeFiles/mysqlxmessages_lite.dir/__/__/generated/protobuf_lite/mysqlx_expr.pb.cc.o
-c
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/plugin/x/generated/protobuf_lite/mysqlx_expr.pb.cc
[ 13%] Building CXX object mysys/CMakeFiles/mysys_objlib.dir/my_mmap.cc.o
cd /var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/mysys &&
/usr/bin/x86_64-pc-linux-gnu-g++ -DBOOST_NO_CXX98_FUNCTION_BASE
-DHAVE_CONFIG_H -DHAVE_TLSv13 -DLZ4_DISABLE_DEPRECATE_WARNINGS
-DRAPIDJSON_NO_SIZETYPEDEFINE -DRAPIDJSON_SCHEMA_USE_INTERNALREGEX=0
-DRAPIDJSON_SCHEMA_USE_STDREGEX=1 -D_FILE_OFFSET_BITS=64 -D_GNU_SOURCE
-D_USE_MATH_DEFINES -D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/include
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/include -isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/extra/rapidjson/include
-isystem
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/extra/libedit/libedit-20210910-3.1/src/editline
-U_FORTIFY_SOURCE -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -march=native
-O2 -pipe -std=c++17 -Wall -Wextra -Wformat-security -Wvla -Wundef
-Wmissing-format-attribute -Woverloaded-virtual -Wcast-qual
-Wimplicit-fallthrough=5 -Wstringop-truncation -Wsuggest-override
-Wmissing-include-dirs -Wextra-semi -Wlogical-op -DNDEBUG -g1 -fPIC  
-U_FORTIFY_SOURCE -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -Wshadow=local
-MD -MT mysys/CMakeFiles/mysys_objlib.dir/my_mmap.cc.o -MF
CMakeFiles/mysys_objlib.dir/my_mmap.cc.o.d -o
CMakeFiles/mysys_objlib.dir/my_mmap.cc.o -c
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql/mysys/my_mmap.cc
[ 13%] Building CXX object
plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/src/bindings/xcom/xcom/get_synode_app_data.cc.o
cd
/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/plugin/group_replication/libmysqlgcs
&& /usr/bin/x86_64-pc-linux-gnu-g++ -DBOOST_NO_CXX98_FUNCTION_BASE
-DHAVE_CONFIG_H -DHAVE_TIRPC -DHAVE_TLSv13
-DLZ4_DISABLE_DEPRECATE_WARNINGS -DRAPIDJSON_NO_SIZETYPEDEFINE
-DRAPIDJSON_SCHEMA_USE_INTERNALREGEX=0 -DRAPIDJSON_SCHEMA_USE_STDREGEX=1
-D_FILE_OFFSET_BITS=64 -D_GNU_SOURCE -D_USE_MATH_DEFINES
-D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS -DMYSQL_DYNAMIC_PLUGIN
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build
-I/var/tmp/portage/dev-db/mysql-8.0.32-r2/work/mysql_build/include

[gentoo-user] MySQL update could break things

[Michael]

Colleen posted a message a couple of weeks ago about mysql hanging at boot.  I 
came across the same problem on an old PC a few days ago.

Symptom:
===
Boot hangs as mysql service is started.

Cause:
=
MySQL upgrade from an old 5.7 version to 8.0 has a lot of material changes, 
which require a careful migration plan and pre-emptive steps:

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

Workaround:
==

If you have not made a migration plan or taken the steps advised by MySQL 
devs, then rebooted a headless server following your thoughtless mysql 
installation upgrade and started scratching your head wondering why your 
remote system has not come up, I can advise as follows.

1. Go make, then enjoy a leisurely cuppa.
2. About 15 minutes later try to login again.  The mysql attempt to restart 
the service should have timed out and the boot process will eventually 
continue and complete.
3. Remove mysql from the default run service to make the next reboot less 
stressful.
4. Move your /usr/lib/mysql directory somewhere else and run emerge --config 
on your mysql-8.0 package.
5. Import your backed up databases and follow the mysql link above.

If you do not have db dumps, then it may be easier to install an earlier mysql 
version, dump your databases, then upgrade mysql following the devs 
instructions.

Note, the above will restore your databases, but the applications using them 
may not be compatible (yet) with mysql-8.0.  Apparently, in their wisdom MySQL 
devs have introduce an even longer list of reserved words, including every day 
terms like "system", which are included in PHP SQL calls by various code bases 
up and the down the country.  

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

So you start the database, address issues like user passwd using SHA2 instead 
of the old insecure MySQL native passwd salting and then you discover your 
website will not load at all.

At that point, you can:

· pester the application devs to rewrite their code to make its SQL calls 
compatible with mysql 8.0, or you can;
· start fishing through the code to find and enclose in `backticks` any 
reserved terms, or you can; 
· downgrade mysql for now and get on with your life.

It would be good if the ebuild posted a warning requiring the user to 
acknowledge requisite steps *prior* to upgrading mysql.  I expect it'll be a 
while before things smooth out with this issue.

HTH.

signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] mysql-workbench

[lee]

Alan McKinnon  writes:

> On 17/04/2017 19:12, lee wrote:
>> Hi,
>> 
>> mysql-workbench requires a USE flag of '>=x11-libs/cairo- -X' while
>> lots of other packages apparently require cairo with X:
>
> no it doesn't. With a fresh tree:
>
> khamul mysql-workbench # grep cairo *ebuild
> mysql-workbench-6.3.3.ebuild:   >=x11-libs/cairo-1.5.12[glib,svg]
> mysql-workbench-6.3.4-r1.ebuild:
>>=x11-libs/cairo-1.5.12[glib,svg]
> mysql-workbench-6.3.4-r2.ebuild:
>>=x11-libs/cairo-1.5.12[glib,svg]
> mysql-workbench-6.3.4.ebuild:   >=x11-libs/cairo-1.5.12[glib,svg]
> # grep  *ebuild
> #
>

Emerge said I need to make above use change.

There are some entries about cairo in package.use, yet commenting them
out didn't help.


, [ grep cairo /etc/portage/package.use ]
| =x11-libs/cairo-1.12.16 xcb
| =x11-libs/cairo-1.12.16 X
| =x11-libs/cairo-1.12.16 opengl
| =x11-libs/cairo-1.12.16-r4 X xcb
| =x11-libs/cairo-1.12.18-r1 xcb X
| >=x11-libs/cairo-1.14.2 xcb X
| >=app-text/poppler-0.42.0 cairo
| # required by dev-cpp/cairomm-1.12.0-r1::gentoo
| >=x11-libs/cairo- X
| # required by dev-cpp/cairomm-1.12.0-r1::gentoo
| =x11-libs/cairo-1.14.8 -X
`


> Are you using an overlay that provides someone's latest greatest
> mysql-workbench?
>
> This is what the tree has right now, what does your machine say?
>
> # eix mysql-workbench
> * dev-db/mysql-workbench
>  Available versions:  6.3.3 (~)6.3.4 6.3.4-r1 (~)6.3.4-r2 {debug doc
> gnome-keyring PYTHON_TARGETS="python2_7"}
>  Homepage:http://dev.mysql.com/workbench/
>  Description: MySQL Workbench
>

same here:

, [ eix mysql-workbench ]
| * dev-db/mysql-workbench
|  Verfügbare Versionen:   6.3.3 ~6.3.4 6.3.4-r1 ~6.3.4-r2 {debug doc 
gnome-keyring PYTHON_TARGETS="python2_7"}
|  Startseite: http://dev.mysql.com/workbench/
|  Beschreibung:   MySQL Workbench
`


, [ emerge -a mysql-workbench ]
| 
|  * IMPORTANT: 1 news items need reading for repository 'gentoo'.
|  * Use eselect news read to view new items.
| 
| 
|  * IMPORTANT: 3 config files in '/etc/portage' need updating.
|  * See the CONFIGURATION FILES and CONFIGURATION FILES UPDATE TOOLS
|  * sections of the emerge man page to learn how to update config files.
| 
| These are the packages that would be merged, in order:
| 
| Calculating dependencies... done!
| [ebuild  N ] sci-libs/proj-4.8.0  USE="-java -static-libs" 
| [ebuild  N ] sys-apps/baselayout-java-0.1.0 
| [ebuild  N ] dev-python/pexpect-3.3  USE="-doc -examples {-test}" 
PYTHON_TARGETS="python2_7 python3_4 (-pypy) (-pypy3) (-python3_5) (-python3_6)" 
| [ebuild  N ] dev-java/java-config-2.2.0-r3  USE="{-test}" 
PYTHON_TARGETS="python2_7 python3_4 (-python3_5)" 
| [ebuild  N ] dev-python/paramiko-2.1.2  USE="-doc -examples" 
PYTHON_TARGETS="python2_7 python3_4 (-python3_5) (-python3_6)" 
| [ebuild  N ] app-eselect/eselect-java-0.3.0 
| [ebuild  N ] dev-lang/lua-5.1.5-r4  USE="deprecated readline -emacs 
-static" 
| [ebuild  N ] dev-cpp/ctemplate-2.3-r1  USE="-doc -emacs -static-libs 
{-test} -vim-syntax" 
| [ebuild  N ] dev-db/vsqlite++-0.3.13-r1  USE="-static-libs" 
| [ebuild  N ] dev-libs/libzip-1.0.1  USE="-static-libs" 
| [ebuild  N ] sci-libs/libgeotiff-1.4.0  USE="-debug -doc -static-libs" 
| [ebuild  N ] dev-libs/json-c-0.12  USE="-doc -static-libs" 
| [ebuild  N ] sci-libs/gdal-2.0.2-r3  USE="aux_xml threads -armadillo 
-curl -debug -doc -fits -geos -gif -gml -hdf5 -java -jpeg -jpeg2k -mdb -mysql 
-netcdf -odbc -ogdi -opencl -pdf -perl -png -postgres -python -spatialite 
-sqlite -xls" PYTHON_TARGETS="python2_7 python3_4" 
| [ebuild  N ] app-admin/sudo-1.8.18_p1  USE="nls pam sendmail -ldap 
-offensive (-selinux) -skey" 
| [ebuild  N ] dev-db/mysql-connector-c++-1.1.6  USE="-debug -examples 
-gcov -static-libs" 
| [ebuild U *] x11-libs/cairo- [1.14.8] USE="-X* -utils%" 
| [ebuild  N ] dev-cpp/atkmm-2.24.2  USE="-doc" 
| [ebuild  N ] dev-cpp/cairomm-1.12.0-r1  USE="svg -X (-aqua) -doc" 
| [ebuild  N ] dev-cpp/pangomm-2.40.1  USE="-doc" 
| [ebuild  N ] dev-cpp/gtkmm-2.24.5  USE="-doc -examples {-test}" 
| [ebuild  N ] dev-java/icedtea-bin-3.3.0  USE="alsa cups gtk webstart -doc 
-examples -headless-awt (-multilib) -nsplugin -pulseaudio (-selinux) -source" 
| [ebuild  N ] virtual/jdk-1.8.0-r3 
| [ebuild  N ] virtual/jre-1.8.0-r1 
| [ebuild  N ] dev-java/icedtea-web-1.6.1-r1  USE="-doc -javascript 
-nsplugin -tagsoup {-test}" 
| [ebuild  N ] dev-db/mysql-workbench-6.3.4-r1  USE="-debug -doc 
-gnome-keyring" PYTHON_TARGETS="python2_7" 
| 
| The following USE changes are necessary to proceed:
|  (see "package.use" in the portage(5) man page for more details)
| # required by dev-cpp/cairomm-1.12.0-r1::gentoo
| # required by dev-cpp/pangomm-2.40.1::gentoo
| # required by dev-db/mysql-workbench-6.3.4-r1::gentoo
| # required by 

Re: [gentoo-user] mysql-workbench

[Alan McKinnon]

On 17/04/2017 19:12, lee wrote:
> Hi,
> 
> mysql-workbench requires a USE flag of '>=x11-libs/cairo- -X' while
> lots of other packages apparently require cairo with X:

no it doesn't. With a fresh tree:

khamul mysql-workbench # grep cairo *ebuild
mysql-workbench-6.3.3.ebuild:   >=x11-libs/cairo-1.5.12[glib,svg]
mysql-workbench-6.3.4-r1.ebuild:
>=x11-libs/cairo-1.5.12[glib,svg]
mysql-workbench-6.3.4-r2.ebuild:
>=x11-libs/cairo-1.5.12[glib,svg]
mysql-workbench-6.3.4.ebuild:   >=x11-libs/cairo-1.5.12[glib,svg]
# grep  *ebuild
#


Are you using an overlay that provides someone's latest greatest
mysql-workbench?

This is what the tree has right now, what does your machine say?

# eix mysql-workbench
* dev-db/mysql-workbench
 Available versions:  6.3.3 (~)6.3.4 6.3.4-r1 (~)6.3.4-r2 {debug doc
gnome-keyring PYTHON_TARGETS="python2_7"}
 Homepage:http://dev.mysql.com/workbench/
 Description: MySQL Workbench




> 
> 
> x11-libs/cairo:0
> 
>   (x11-libs/cairo-:0/0::gentoo, ebuild scheduled for merge) conflicts with
> >=x11-libs/cairo-1.8.4[X] required by 
> (dev-dotnet/libgdiplus-4.2-r3:0/0::gentoo, installed)
>^ 
> >=x11-libs/cairo-1.12.14-r4:0/0=[svg,X,abi_x86_64(-)] required by 
> (x11-libs/gtk+-2.24.31-r1:2/2::gentoo, installed)
>  ^   
> >=x11-libs/cairo-1.12.14-r4:0/0=[X,abi_x86_64(-)] required by 
> (x11-libs/pango-1.40.4:0/0::gentoo, installed)
>  ^   
> x11-libs/cairo[X,-xlib-xcb(-)] required by 
> (app-office/libreoffice-5.2.3.3-r1:0/0::gentoo, installed)
>^  
> >=x11-libs/cairo-1.12.14-r4:=[X,abi_x86_64(-)] required by 
> (x11-libs/pango-1.40.4:0/0::gentoo, installed)
>   ^   
> >=x11-libs/cairo-1.10:0/0=[X] required by 
> (net-libs/webkit-gtk-2.4.11-r200:2/2::gentoo, installed)
>^ 
> >=x11-libs/cairo-1.14[glib,svg,X,abi_x86_64(-)] required by 
> (x11-libs/gtk+-3.22.11:3/3::gentoo, installed)
>^   
> >=x11-libs/cairo-1.12.14-r4:=[svg,X,abi_x86_64(-)] required by 
> (x11-libs/gtk+-2.24.31-r1:2/2::gentoo, installed)
>   ^   
> >=x11-libs/cairo-1.10[X] required by 
> (www-client/seamonkey-2.46-r1:0/0::gentoo, installed)
>   ^ 
> >=x11-libs/cairo-1.10:=[X] required by 
> (net-libs/webkit-gtk-2.4.11-r200:2/2::gentoo, installed)
> 
> 
> Is there a good way to get mysql-workbench installed without removing
> the other packages?

Find what you are installing exactly then take it from there



-- 
Alan McKinnon
alan.mckin...@gmail.com

[gentoo-user] mysql-workbench

[lee]

Hi,

mysql-workbench requires a USE flag of '>=x11-libs/cairo- -X' while
lots of other packages apparently require cairo with X:


x11-libs/cairo:0

  (x11-libs/cairo-:0/0::gentoo, ebuild scheduled for merge) conflicts with
>=x11-libs/cairo-1.8.4[X] required by 
(dev-dotnet/libgdiplus-4.2-r3:0/0::gentoo, installed)
   ^ 
>=x11-libs/cairo-1.12.14-r4:0/0=[svg,X,abi_x86_64(-)] required by 
(x11-libs/gtk+-2.24.31-r1:2/2::gentoo, installed)
 ^   
>=x11-libs/cairo-1.12.14-r4:0/0=[X,abi_x86_64(-)] required by 
(x11-libs/pango-1.40.4:0/0::gentoo, installed)
 ^   
x11-libs/cairo[X,-xlib-xcb(-)] required by 
(app-office/libreoffice-5.2.3.3-r1:0/0::gentoo, installed)
   ^  
>=x11-libs/cairo-1.12.14-r4:=[X,abi_x86_64(-)] required by 
(x11-libs/pango-1.40.4:0/0::gentoo, installed)
  ^   
>=x11-libs/cairo-1.10:0/0=[X] required by 
(net-libs/webkit-gtk-2.4.11-r200:2/2::gentoo, installed)
   ^ 
>=x11-libs/cairo-1.14[glib,svg,X,abi_x86_64(-)] required by 
(x11-libs/gtk+-3.22.11:3/3::gentoo, installed)
   ^   
>=x11-libs/cairo-1.12.14-r4:=[svg,X,abi_x86_64(-)] required by 
(x11-libs/gtk+-2.24.31-r1:2/2::gentoo, installed)
  ^   
>=x11-libs/cairo-1.10[X] required by 
(www-client/seamonkey-2.46-r1:0/0::gentoo, installed)
  ^ 
>=x11-libs/cairo-1.10:=[X] required by 
(net-libs/webkit-gtk-2.4.11-r200:2/2::gentoo, installed)


Is there a good way to get mysql-workbench installed without removing
the other packages?

[gentoo-user] MySQL utf8 support (was Re: utf8_general_ci)

[Harm Geerts]

On Tuesday 05 May 2015 09:32:15 Joseph wrote:
 I have my mysql database Collation set as: utf8_general_ci
 
 but when a customer from for example Japan places an order all I see is:
 
 amp;#31481;amp;#40763;amp;#31435;amp;#21407;amp;#30010;amp;#65301;amp
 ;#65293;amp;#65301;
 
 Do I need to change Collation setting to something else or something else?

I'm not sure which character codes are used for Japanese but it's worth noting 
that mysql's utf8 encoding is a partial implementation which only supports 3 
bytes per character.

For full utf8 support you'll need to use the utf8mb4 encoding.

https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
https://mathiasbynens.be/notes/mysql-utf8mb4

Note that this is not relevant to your problem which is covered by 
Fernando Rodriguez' reply.

Re: [gentoo-user] mysql upgrade 5.5 5.6 mysql_upgrade needed?

[hydra]

On Tue, Mar 31, 2015 at 10:27 PM, Marko Weber | 8000 we...@zbfmail.de
wrote:


 hello list,
 again i have to ask.
 Do i need to run mysql_upgrade after upgrading mysql 5.5  5.6 ?
 I ask because the post install text recommend this after an major upgrade.
 On the Mysql Website is a major upgrade 5.5  6.0, not 5.5  5.6
 So i ask you guys.
 Any can help me?

 thank you

 marko



Yes, you need to - it IS a major upgrade.

Check out http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html and
http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html

It states:
To upgrade to 5.6 from any previous version, MySQL recommends that you
dump your tables with *mysqldump*
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html before upgrading
and reload the dump file after upgrading. Use the --all-databases
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_all-databases
option to include all databases in the dump. If your databases include
stored programs, use the --routines
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_routines
and --events
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_events
options as well.

So either you dump/restore (safest but harder with downtime - except when
you run replication and switch masters) or you do upgrade on the fly and
run mysql_upgrade.

Re: [gentoo-user] mysql upgrade 5.5 5.6 mysql_upgrade needed?

[Neil Bothwick]

On Tue, 31 Mar 2015 22:27:38 +0200, Marko Weber | 8000 wrote:

 Do i need to run mysql_upgrade after upgrading mysql 5.5  5.6 ?
 I ask because the post install text recommend this after an major 
 upgrade.

Do you *need* to? Possibly not. Should you do it? Yes.

If you run it unnecessarily, it simply tells you so, so there is no harm
in running it after every upgrade.


-- 
Neil Bothwick

Please rotate your phone 90 degrees and try again.


pgpFk0dZgh3n_.pgp
Description: OpenPGP digital signature

[gentoo-user] mysql upgrade 5.5 5.6 mysql_upgrade needed?

[Marko Weber | 8000]

hello list,
again i have to ask.
Do i need to run mysql_upgrade after upgrading mysql 5.5  5.6 ?
I ask because the post install text recommend this after an major 
upgrade.

On the Mysql Website is a major upgrade 5.5  6.0, not 5.5  5.6
So i ask you guys.
Any can help me?

thank you

marko

[gentoo-user] MySql Upgrade Question (Major Release)

[Marko Weber | 8000]

Hi list,
the dev-db/mysql will update from 5.5 to 5.6
At the end a post install text tells me i have to fire up mysql_upgrade
when this is a major update.

On the mysql site i found this

5.5.40

5.x.x   is the major nr
x.5.x   is the release nr
x.x.40  is the level of the release

so, do i have to fire up mysql_upgrade on change from 5.5.40  5.6.40 at 
example.



thank you

marko



--
zbfmail - Mittendrin statt nur Datei!

OpenDKIM, SPF, DSPAM, Greylisting, POSTSCREEN, AMAVIS, Mailgateways
Mailfiltering, SMTP Service, Spam Abwehr, MX-Backup, Mailserver Backup
Redundante Mailgateways, HA Mailserver, Secure Mailserver

[gentoo-user] Mysql upgrade from 5.5 to 5.6 not trigger rebuild fot php-5.3

[marco]

Hi,
i have a server with dev-db/mysql-5.5.40 and dev-lang/php-5.3.29 .
After the upgrade from dev-db/mysql-5.5.40 to dev-db/mysql-5.6.22 the
mysql_connect give some warnings:

PHP Warning:  mysql_connect(): Headers and client library minor version
mismatch. Headers:50540 Library:50622 in 

The warning disappear if i rebuild dev-lang/php-5.3.29 .

The question is:
why the mysql update dind't triggered the rebuild for
dev-lang/php-5.3.29 ?

Thanks Marco

[gentoo-user] mysql-5.6.22 update borked akonadi

[Mick]

Hi All,

I just updated a laptop after a week's abstinence and with mysql-5.6.22 
akonadi won't start.  This error renders this laptop useless for email (it 
uses kmail) and therefore I am hesitant to update other boxen to avoid a luser 
riot.  Have you experienced such a problem?  How can I fix it?


This is the error log:
==

2015-01-25 09:18:08 3192 [Warning] Buffered warning: Changed limits: 
max_open_files: 1024 (requested 5000)

2015-01-25 09:18:08 3192 [Warning] Buffered warning: Changed limits: 
max_connections: 214 (requested 256)

2015-01-25 09:18:08 7f3605d7c740 InnoDB: Warning: Using 
innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in 
future releases, together with the option innodb_use_sys_malloc and with the 
InnoDB's internal memory allocator.
2015-01-25 09:18:08 3192 [Note] InnoDB: Using atomics to ref count buffer pool 
pages
2015-01-25 09:18:08 3192 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-25 09:18:08 3192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic 
builtins
2015-01-25 09:18:08 3192 [Note] InnoDB: Memory barrier is not used
2015-01-25 09:18:08 3192 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-01-25 09:18:08 3192 [Note] InnoDB: Using Linux native AIO
2015-01-25 09:18:08 3192 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-25 09:18:08 3192 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2015-01-25 09:18:08 3192 [Note] InnoDB: Completed initialization of buffer 
pool
2015-01-25 09:18:08 3192 [Note] InnoDB: Highest supported file format is 
Barracuda.
2015-01-25 09:18:08 3192 [Note] InnoDB: The log sequence numbers 20549320007 
and 20549320007 in ibdata files do not match the log sequence number 
20692769575 in the ib_logfiles!
2015-01-25 09:18:08 3192 [Note] InnoDB: Database was not shutdown normally!
2015-01-25 09:18:08 3192 [Note] InnoDB: Starting crash recovery.
2015-01-25 09:18:08 3192 [Note] InnoDB: Reading tablespace information from 
the .ibd files...
2015-01-25 09:18:08 3192 [Note] InnoDB: Restoring possible half-written data 
pages
2015-01-25 09:18:08 3192 [Note] InnoDB: from the doublewrite buffer...
09:18:08 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16384
read_buffer_size=131072
max_used_connections=0
max_threads=214
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 85119 K  
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x4
/usr/sbin/mysqld(my_print_stacktrace+0x20)[0x83f5c0]
/usr/sbin/mysqld(handle_fatal_signal+0x34d)[0x61fcbd]
/lib64/libpthread.so.0(+0x11250)[0x7f3604aed250]
/usr/sbin/mysqld[0x9e3d28]
/usr/sbin/mysqld[0x9e4df1]
/usr/sbin/mysqld[0x96d245]
/usr/sbin/mysqld[0x8cc8e4]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x57d401]
/usr/sbin/mysqld[0x6975d0]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x91c)[0x69b5dc]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x83f)[0x57722f]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f360414edb5]
/usr/sbin/mysqld[0x56c9e5]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
==

-- 
Regards,
Mick


signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] MySQL date look funny: 2014-0

[J. Roeleveld]

On 21 September 2014 07:33:43 CEST, Joseph syscon...@gmail.com wrote:
After recent upgrade my Orders in OsCommerce program date look funny:
2014-0

I downgraded mysql to 5.1.70 but this is caused by it.

I've two PHP installed: 5.3 and 5.5 
I tried switching to 5.3 it still the same date display  2014-0

What do you see when querying using native tools?
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [gentoo-user] MySQL date look funny: 2014-0

[Mick]

On Sunday 21 Sep 2014 07:11:15 J. Roeleveld wrote:
 On 21 September 2014 07:33:43 CEST, Joseph syscon...@gmail.com wrote:
 After recent upgrade my Orders in OsCommerce program date look funny:
 2014-0
 
 I downgraded mysql to 5.1.70 but this is caused by it.
 
 I've two PHP installed: 5.3 and 5.5
 I tried switching to 5.3 it still the same date display  2014-0
 
 What do you see when querying using native tools?

Have you made any changes in your locale?  I would think that this is not an 
application specific setting, but picked up from your env.
-- 
Regards,
Mick


signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] MySQL date look funny: 2014-0

[Joseph]

On 09/21/14 09:40, Mick wrote:

On Sunday 21 Sep 2014 07:11:15 J. Roeleveld wrote:

On 21 September 2014 07:33:43 CEST, Joseph syscon...@gmail.com wrote:
After recent upgrade my Orders in OsCommerce program date look funny:
2014-0

I downgraded mysql to 5.1.70 but this is caused by it.

I've two PHP installed: 5.3 and 5.5
I tried switching to 5.3 it still the same date display  2014-0

What do you see when querying using native tools?


Have you made any changes in your locale?  I would think that this is not an
application specific setting, but picked up from your env.
--
Regards,
Mick


I think you are correct, some setting had changed but I don't know which. 
My locale as root:

# locale -a
C
en_US
en_US.iso88591
en_US.utf8
POSIX

user:
$ locale
LANG=en_US.UTF-8
LC_CTYPE=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_TIME=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
LC_MONETARY=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_PAPER=en_US.UTF-8
LC_NAME=en_US.UTF-8
LC_ADDRESS=en_US.UTF-8
LC_TELEPHONE=en_US.UTF-8
LC_MEASUREMENT=en_US.UTF-8
LC_IDENTIFICATION=en_US.UTF-8
LC_ALL=en_US.UTF-8

In Mysql database the date look normal:
date_purchased: 2014-09-20 18:46:25



--
Joseph

[gentoo-user] MySQL date look funny: 2014-0

[Joseph]

After recent upgrade my Orders in OsCommerce program date look funny: 2014-0

I downgraded mysql to 5.1.70 but this is caused by it.

I've two PHP installed: 5.3 and 5.5 
I tried switching to 5.3 it still the same date display  2014-0


--
Joseph

[gentoo-user] mysql to postgresql migration

[James]

Hello,

I recently ran across this script: py-mysql2pgsql [1]
and this discussion on it's origin [2]. I'm keenly interested
in the recommendations of others for migrating mysql databases
to postgresql and any comments on this aforementioned script
or other methodologies


TIA,
James


[1] https://github.com/philipsoutham/py-mysql2pgsql

[2] http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/

Re: [gentoo-user] mysql to postgresql migration

[J. Roeleveld]

On 15 July 2014 14:55:14 CEST, James wirel...@tampabay.rr.com wrote:
Hello,

I recently ran across this script: py-mysql2pgsql [1]
and this discussion on it's origin [2]. I'm keenly interested
in the recommendations of others for migrating mysql databases
to postgresql and any comments on this aforementioned script
or other methodologies


TIA,
James


[1] https://github.com/philipsoutham/py-mysql2pgsql

[2]
http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/

James,

I haven't looked into this recently. But I believe that the DDLs and data can 
be migrated relatively easy.

Just be aware that software specifically written using MySQLs version of SQL is 
unlikely to work on a different RDBMS without extensive rewrites.

This is the biggest problem people are facing when porting websites to use a 
different database.

What is the reason for migrating and what kind of data and applications are you 
using?

--
Joost
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Stroller]

On 23 January 2013, at 18:58, Manuel McLure wrote:
 … eth0 is not configured any more (it used to be used for IPTV
 connectivity to my cable provider for MythTV before they changes their
 system.) eth1 is configured via DHCP to an RFC 1918 10.x.x.x address -
 the DHCP server is always configured to provide the same IP address
 for this system. net.eth1 is symlinked to /etc/runlevels/default.
 
 The boot process starts, configures eth1, starts LCDd, and then
 attempts to start MySQL - and hangs for about 15 minutes before
 continuing with the boot.
 
 I added several debugging statements to /etc/init.d/mysql and found
 that even though the log shows that eth1 got its IP address, when
 MySQL attempts to start the interface does not have an IP address
 assigned. It's like the net.eth1 script exits before the interface is
 completely up.

I think, to be rigorous, I would want to test this system (I'm not saying you 
should keep it this way) by setting the IP address statically for eth1. 

From what I'm understanding, this doesn't sound like a MySQL problem, but a 
DHCP problem.

You're checking the IP address with ifconfig - I believe that is deprecated. I 
guess at some point you might replace that in your `echo  test.log` scripts 
with the newer tools, just to make sure they say the same thing. Maybe this is 
paranoia, but you know what they say about that.

http://blog.timheckman.net/2011/12/22/why-you-should-replace-ifconfig/

 ...
 eth1: flags=4163UP,BROADCAST,RUNNING,MULTICAST  mtu 1500
inet6 :::::::  prefixlen 64
 scopeid 0x0global
inet6 :::::  prefixlen 64  scopeid 0x20link

I don't think these are valid IPv6 addresses. If you're not using IPv6 then I 
would recommend removing the IPv6 USE flag globally and remerging everything 
--newuse. This will ensure nothing is depending upon IPv6 or expecting it or 
waiting for it.

 The entries for eth1 in /etc/conf.d/net are:
 
 config_eth1=dhcp
 routes_eth1=239.0.0.0/8

Is this right?

 I could add a delay to the mysql script to ensure startup, but I'd
 rather figure out why the IP address is not yet available even though
 the net.eth1 script has completed. Does anyone have any hints on what
 could be going wrong?

There are several DHCP clients available in Portage. 

You need to tell us which one you're using.

It wouldn't do any harm to experiment with one or two others.

I think that a busybox version may be installed on some systems, and that this 
may interfere or misbehave. I don't know if a bug report has been filed for 
this.6

Stroller.

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Paul Hartman]

On Wed, Jan 23, 2013 at 12:58 PM, Manuel McLure man...@mclure.org wrote:
 I'm having a problem with booting my Gentoo system due to MySQL
 hanging at startup. My system is up-to-date stable (including
 udev-197, although I believe the problem started while I was still on
 171) except for the kernel, which is at 3.1.10 because I can't seem to
 get lirc to work correctly on newer kernels. The problem started after
 a large system update just before the udev 171 to 197 migration. Among
 other upgrades dhcpcd was upgraded from 5.2.12 to 5.6.4, net-tools was
 upgraded from 1.60_p20110409135728 to 1.60_p20120127084908, and openrc
 was upgraded from 0.9.8.4 to 0.11.8.

try adding the line after net to the depend section of the init.d
script for mysql to cause it not to start until the network is up

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Kerin Millar]

On 23/01/2013 18:58, Manuel McLure wrote:

I'm having a problem with booting my Gentoo system due to MySQL
hanging at startup. My system is up-to-date stable (including
udev-197, although I believe the problem started while I was still on
171) except for the kernel, which is at 3.1.10 because I can't seem to
get lirc to work correctly on newer kernels. The problem started after
a large system update just before the udev 171 to 197 migration. Among
other upgrades dhcpcd was upgraded from 5.2.12 to 5.6.4, net-tools was
upgraded from 1.60_p20110409135728 to 1.60_p20120127084908, and openrc
was upgraded from 0.9.8.4 to 0.11.8.


snip additional info


I could add a delay to the mysql script to ensure startup, but I'd
rather figure out why the IP address is not yet available even though
the net.eth1 script has completed. Does anyone have any hints on what
could be going wrong?


I can't determine what the problem is exactly but I can offer some hints ...

You should detail your my.cnf file. By default, the mysql runscript 
depends only on net.lo. There's nothing wrong with that unless you are 
binding to a specific address. Using skip-name-resolve is also 
helpful, provided that you don't require host names to be resolved for 
your grant tables to work correctly.


If the nature of your configuration is such that a specific interface 
must be up then you can insert the following lines in /etc/conf.d/mysql:


rc_use=net.eth1
rc_after=net.eth1

NOTE: You need not - and should not - edit the mysql runscript directly 
in order to customize its dependencies.


This particular caveat is described by the comments in that file, along 
with several others. I'd suggest taking a look at these comments if you 
haven't already done so.


Cheers,

--Kerin

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Paul Hartman]

On Thu, Jan 24, 2013 at 11:50 AM, Kerin Millar kerfra...@fastmail.co.uk wrote:
 If the nature of your configuration is such that a specific interface must
 be up then you can insert the following lines in /etc/conf.d/mysql:

 rc_use=net.eth1
 rc_after=net.eth1


This is a better solution than what I suggested. Pay no attention to
my previous message. :)

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Manuel McLure]

On Thu, Jan 24, 2013 at 7:03 AM, Stroller
strol...@stellar.eclipse.co.uk wrote:
 I think, to be rigorous, I would want to test this system (I'm not saying you 
 should keep it this way) by setting the IP address statically for eth1.

 From what I'm understanding, this doesn't sound like a MySQL problem, but a 
 DHCP problem.

You're correct. When I set the interface statically, MySQL starts up
like a champ.

 You're checking the IP address with ifconfig - I believe that is deprecated. 
 I guess at some point you might replace that in your `echo  test.log` 
 scripts with the newer tools, just to make sure they say the same thing. 
 Maybe this is paranoia, but you know what they say about that.

 http://blog.timheckman.net/2011/12/22/why-you-should-replace-ifconfig/

Thanks for the link. I'll definitely check that out.

 ...
 eth1: flags=4163UP,BROADCAST,RUNNING,MULTICAST  mtu 1500
inet6 :::::::  prefixlen 64
 scopeid 0x0global
inet6 :::::  prefixlen 64  scopeid 0x20link

 I don't think these are valid IPv6 addresses. If you're not using IPv6 then I 
 would recommend removing the IPv6 USE flag globally and remerging everything 
 --newuse. This will ensure nothing is depending upon IPv6 or expecting it or 
 waiting for it.

The real addresses are valid, I just didn't want to put them in a
public mailing list message so I edited them. IPv6 on my network
(through a Hurricane Electric tunnel) is working fine.

 The entries for eth1 in /etc/conf.d/net are:

 config_eth1=dhcp
 routes_eth1=239.0.0.0/8

 Is this right?

Yes. The extra route is so that DLNA/uPnP works correctly on my network.

 I could add a delay to the mysql script to ensure startup, but I'd
 rather figure out why the IP address is not yet available even though
 the net.eth1 script has completed. Does anyone have any hints on what
 could be going wrong?

 There are several DHCP clients available in Portage.

 You need to tell us which one you're using.

I did, although it was sort of hidden in the list of upgraded
packages: dhcpcd was upgraded from 5.2.12 to 5.6.4.

 It wouldn't do any harm to experiment with one or two others.

 I think that a busybox version may be installed on some systems, and that 
 this may interfere or misbehave. I don't know if a bug report has been filed 
 for this.6

In any case, I did some more debugging and found that the problem
seems to be an interaction between dhcpcd and IPv6 configuration.  The
latest version of dhcpcd now attempts by default to take over IPv6
stateless configuration instead of letting the kernel take care of it
as happened before. dhcpcd appears to be getting an IPv6 address set
up before the IPv4 configuration is complete, and considers this good
enough to background itself instead of waiting for the IPv4
configuration to be complete. The workaround was to add noipv6rs
(Disable solicition of IPv6 Router Advertisements) to the
/etc/dhcpcd.conf file so that dhcpcd ignores IPv6 configuration. The
kernel still configures IPv6 correctly, and dhcpcd now waits for the
IPv4 configuration to be complete before backgrounding itself.

-- 
Manuel A. McLure WW1FA man...@mclure.org http://www.mclure.org
...for in Ulthar, according to an ancient and significant law,
no man may kill a cat.   -- H.P. Lovecraft

Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Stroller]

On 24 January 2013, at 18:35, Manuel McLure wrote:

 In any case, I did some more debugging and found that the problem
 seems to be an interaction between dhcpcd and IPv6 configuration.  The
 latest version of dhcpcd now attempts by default to take over IPv6
 stateless configuration instead of letting the kernel take care of it
 as happened before. dhcpcd appears to be getting an IPv6 address set
 up before the IPv4 configuration is complete, and considers this good
 enough to background itself instead of waiting for the IPv4
 configuration to be complete. The workaround was to add noipv6rs
 (Disable solicition of IPv6 Router Advertisements) to the
 /etc/dhcpcd.conf file so that dhcpcd ignores IPv6 configuration. The
 kernel still configures IPv6 correctly, and dhcpcd now waits for the
 IPv4 configuration to be complete before backgrounding itself.

That sounds queer. You should file a bug.

Stroller. 

[gentoo-user] MySQL startup problem - interface does not have an address yet.

[Manuel McLure]

I'm having a problem with booting my Gentoo system due to MySQL
hanging at startup. My system is up-to-date stable (including
udev-197, although I believe the problem started while I was still on
171) except for the kernel, which is at 3.1.10 because I can't seem to
get lirc to work correctly on newer kernels. The problem started after
a large system update just before the udev 171 to 197 migration. Among
other upgrades dhcpcd was upgraded from 5.2.12 to 5.6.4, net-tools was
upgraded from 1.60_p20110409135728 to 1.60_p20120127084908, and openrc
was upgraded from 0.9.8.4 to 0.11.8.

For historical reasons, this system has two ethernet adapters, eth0
and eth1. eth0 is not configured any more (it used to be used for IPTV
connectivity to my cable provider for MythTV before they changes their
system.) eth1 is configured via DHCP to an RFC 1918 10.x.x.x address -
the DHCP server is always configured to provide the same IP address
for this system. net.eth1 is symlinked to /etc/runlevels/default.

The boot process starts, configures eth1, starts LCDd, and then
attempts to start MySQL - and hangs for about 15 minutes before
continuing with the boot.

I added several debugging statements to /etc/init.d/mysql and found
that even though the log shows that eth1 got its IP address, when
MySQL attempts to start the interface does not have an IP address
assigned. It's like the net.eth1 script exits before the interface is
completely up.

After the 15 minute hang, the system boots up as usual, except for
MySQL not running. If I then start mysql manually it comes up
immediately.

Here's the rc.log output:

 * Starting D-BUS system messagebus ...
 [ ok ]
 * Bringing up interface eth1
 *   dhcp ...
 * Running dhcpcd ...
dhcpcd[8400]: version 5.6.4 starting
dhcpcd[8400]: eth1: waiting for carrier
dhcpcd[8400]: eth1: carrier acquired
dhcpcd[8400]: eth1: sending IPv6 Router Solicitation
dhcpcd[8400]: eth1: sendmsg: Cannot assign requested address
dhcpcd[8400]: eth1: rebinding lease of 10.x.y.14
dhcpcd[8400]: eth1: acknowledged 10.x.y.14 from 10.x.y.1
dhcpcd[8400]: eth1: checking for 10.x.y.14
dhcpcd[8400]: eth1: Router Advertisement from :::::
dhcpcd[8400]: forked to background, child pid 8454
 [ ok ]
 * received address
 [ ok ]
 *   Adding routes
 * 239.0.0.0/8 ...
 [ ok ]
 * Starting LCDd ...
 [ ok ]
 * Starting mysql ...
 [ !! ]
 * ERROR: mysql failed to start
 * Starting syslog-ng ...
 [ ok ]
 * Mounting network filesystems ...
 [ ok ]

I added the following commands before the start-stop-daemon line in
/etc/init.d/mysql:

date /var/log/mysqlstart.log
netstat -anp | grep 3306 /var/log/mysqlstart.log
ps -efl | grep mysql /var/log/mysqlstart.log
lsof -i @10.x.y.14:3306 /var/log/mysqlstart.log
ifconfig -a /var/log/mysqlstart.log

The output of this was:

Wed Jan 23 09:56:03 PST 2013
0 S root  8497  8290  0  80   0 -  4301 poll_s 09:56 ?
00:00:00 /sbin/runscript /etc/init.d/mysql --lockfd 10 start
4 S root  8498  8497  1  80   0 -  3425 wait   09:56 ?
00:00:00 /bin/sh /lib64/rc/sh/runscript.sh /etc/init.d/mysql start
0 S root  8537  8498  0  80   0 -  2142 pipe_w 09:56 ?
00:00:00 grep mysql
eth0: flags=4098BROADCAST,MULTICAST  mtu 1500
ether 00:22:15:b7:ff:bc  txqueuelen 1000  (Ethernet)
RX packets 0  bytes 0 (0.0 B)
RX errors 0  dropped 0  overruns 0  frame 0
TX packets 0  bytes 0 (0.0 B)
TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
device interrupt 22  base 0xa000

eth1: flags=4163UP,BROADCAST,RUNNING,MULTICAST  mtu 1500
inet6 :::::::  prefixlen 64
scopeid 0x0global
inet6 :::::  prefixlen 64  scopeid 0x20link
ether 00:1b:21:b1:cb:bb  txqueuelen 1000  (Ethernet)
RX packets 9  bytes 1149 (1.1 KiB)
RX errors 0  dropped 0  overruns 0  frame 0
TX packets 8  bytes 936 (936.0 B)
TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0
device interrupt 18  memory 0xfebe-fec0

lo: flags=73UP,LOOPBACK,RUNNING  mtu 16436
inet 127.0.0.1  netmask 255.0.0.0
inet6 ::1  prefixlen 128  scopeid 0x10host
loop  txqueuelen 0  (Local Loopback)
RX packets 0  bytes 0 (0.0 B)
RX errors 0  dropped 0  overruns 0  frame 0
TX packets 0  bytes 0 (0.0 B)
TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

As you can see, eth1 has no IPV4 address assigned. Once the server
boots (after the 15 minute mysql timeout ends) ifconfig shows the
following:


eth1: flags=4163UP,BROADCAST,RUNNING,MULTICAST  mtu 1500
inet 10.x.y.14  netmask 255.255.255.0  broadcast 10.x.y.255
inet6 :::::::  prefixlen 64
scopeid 0x0global
inet6 :::::  prefixlen 64  scopeid 0x20link
ether 00:1b:21:b1:cb:bb  txqueuelen 1000  (Ethernet)
RX packets 2732  bytes 496650 

Re: [gentoo-user] MySQL MariaDB - is it time?

[Jorge Martínez López]

2012/3/2 Matthew Finkel matthew.fin...@gmail.com:

 It's definitely an interesting dilemma, but one that was expected to happen
 eventually. Lucky Gentoo doesn't have to worry about release cycles. MariaDB
 is in portage so, in theory, it shouldn't be too difficult for any of us to
 make the switch.

Seeing how successful is Oracle managing a free software community
(OpenSolaris, OpenOffice.org, Harmony) I made the switch yesterday
with zero issues:

keyworded =dev-db/mariadb-5.2 (make sure you install the same minor
version as you have with MySQL).
emerge -aC mysql
emerge mariabd

And that's it.

Greetings,
-- 
Jorge Martínez López jorg...@gmail.com http://www.jorgeml.net
      Google Talk / XMPP: jorg...@gmail.com

Re: [gentoo-user] MySQL MariaDB - is it time?

[Alex Schuster]

Tanstaafl writes:

 Anyone here ever done the switch want to share their experience?

I use MySQL for an ld phpBB board and for Amarok, and do not now much
about it. I never explicitely installed MySQL, I only have the mysql USE
flag set for things like python or PHP. Somehow, dev-db/mysql was never
installed, but I have dev-db/mariadb installed instead. Seems I already
made the switch, without knowing about it.

Wonko

[gentoo-user] MySQL MariaDB - is it time?

[Tanstaafl]

Hi all,

I just came across this thread today on the MariaDB discuss list about 
the poor stewardship of Oracle with respect to MySQL (and it references 
Oracle's track record of poor handling of the FLOSS projects it 
inherited when it bought Sun):


https://lists.launchpad.net/maria-discuss/msg00514.html

In it is discussed - among many other things including lots of good 
reason *why* - the possibility of replacing MySQL with MariaDB in 
anticipation of Oracle's current poor stewardship of MySQL...


My question is - shouldn't gentoo be considering this move as well?


I've been seriously considering this for my own servers for some time, 
and after reading this, I think it is time to stop thinking about it and 
just do it, but I'm a bit nervous - ianap, and don't want to shoot 
myself in the foot in the process.


Anyone here ever done the switch want to share their experience?

Re: [gentoo-user] MySQL MariaDB - is it time?

[Matthew Finkel]

On Thu, Mar 1, 2012 at 3:47 PM, Tanstaafl tansta...@libertytrek.org wrote:

 Hi all,

 I just came across this thread today on the MariaDB discuss list about the
 poor stewardship of Oracle with respect to MySQL (and it references
 Oracle's track record of poor handling of the FLOSS projects it inherited
 when it bought Sun):

 https://lists.launchpad.net/**maria-discuss/msg00514.htmlhttps://lists.launchpad.net/maria-discuss/msg00514.html

 In it is discussed - among many other things including lots of good reason
 *why* - the possibility of replacing MySQL with MariaDB in anticipation of
 Oracle's current poor stewardship of MySQL...

 My question is - shouldn't gentoo be considering this move as well?


 I've been seriously considering this for my own servers for some time, and
 after reading this, I think it is time to stop thinking about it and just
 do it, but I'm a bit nervous - ianap, and don't want to shoot myself in the
 foot in the process.

 Anyone here ever done the switch want to share their experience?



It's definitely an interesting dilemma, but one that was expected to happen
eventually. Lucky Gentoo doesn't have to worry about release cycles.
MariaDB is in portage so, in theory, it shouldn't be too difficult for any
of us to make the switch.

- Matt

Re: [gentoo-user] MySQL MariaDB - is it time?

[Pandu Poluan]

On Mar 2, 2012 3:50 AM, Tanstaafl tansta...@libertytrek.org wrote:

 Hi all,

 I just came across this thread today on the MariaDB discuss list about
the poor stewardship of Oracle with respect to MySQL (and it references
Oracle's track record of poor handling of the FLOSS projects it inherited
when it bought Sun):

 https://lists.launchpad.net/maria-discuss/msg00514.html

 In it is discussed - among many other things including lots of good
reason *why* - the possibility of replacing MySQL with MariaDB in
anticipation of Oracle's current poor stewardship of MySQL...

 My question is - shouldn't gentoo be considering this move as well?


 I've been seriously considering this for my own servers for some time,
and after reading this, I think it is time to stop thinking about it and
just do it, but I'm a bit nervous - ianap, and don't want to shoot myself
in the foot in the process.

 Anyone here ever done the switch want to share their experience?


Back in the ubuntu-server mailing list, this has been the topic of a lively
discussion last week.

The consensus seemed to be that MariaDB and Percona would be drop-in
replacements for MySQL.

Myself, I'm a PostgreSQL guy so I have no opinion ;-)

Rgds,

Re: [gentoo-user] mysql... drives me crazy

[András Csányi]

On 19 September 2010 21:12, Albert Hopkins mar...@letterboxes.org wrote:
 On Sun, 2010-09-19 at 16:02 +0200, András Csányi wrote:
 Hi all,

 I'm not a mysql guru but what that bastard is doing it's drive me crazy.

 version:5.1.50-r1 installed from portage

 So...
 I have installed and working fine.
 I have installed phpmyadmin too and it's working fine. I can log in... :)
 I wanted to create a database but after I gave the database's name and
 click Create button the phpmyadmin kicked me out. Now, I can't log
 in and there is no error message or something.
 I'have tried to fix it with mysql_permission but there is no result. I
 can't log in through phpmyadmin. But, I can log in through terminal.

 So your problem seems to be with phpmyadmin, not with MySQL per sé.

Basicly, I don't know what is the root cause, Mysql or Phpmyadmin?

 I don't like mysql console because this is an uncomfortable, non
 usable little piece of something.

 Yet it works...

 Seems to me more like the phpmyadmin is the non usable such and such.

Yes, it works. :) But annoying that fact there is no comfortable way
to handle my databases and more annoying that I can't solve this
problem.
What is your opinion, what should I have to do? It's not problem to
learn use mysql from console.

-- 
- -
--  Csanyi Andras (Sayusi Ando)  -- http://sayusi.hu --
http://facebook.com/andras.csanyi
--  Trust in God and keep your gunpowder dry! - Cromwell

[gentoo-user] mysql... drives me crazy

[András Csányi]

Hi all,

I'm not a mysql guru but what that bastard is doing it's drive me crazy.

version:5.1.50-r1 installed from portage

So...
I have installed and working fine.
I have installed phpmyadmin too and it's working fine. I can log in... :)
I wanted to create a database but after I gave the database's name and
click Create button the phpmyadmin kicked me out. Now, I can't log
in and there is no error message or something.
I'have tried to fix it with mysql_permission but there is no result. I
can't log in through phpmyadmin. But, I can log in through terminal.

I don't like mysql console because this is an uncomfortable, non
usable little piece of something.

Thanks for any suggestions in advance!

András

-- 
- -
--  Csanyi Andras (Sayusi Ando)  -- http://sayusi.hu --
http://facebook.com/andras.csanyi
--  Trust in God and keep your gunpowder dry! - Cromwell

Re: [gentoo-user] mysql... drives me crazy

[Albert Hopkins]

On Sun, 2010-09-19 at 16:02 +0200, András Csányi wrote:
 Hi all,
 
 I'm not a mysql guru but what that bastard is doing it's drive me crazy.
 
 version:5.1.50-r1 installed from portage
 
 So...
 I have installed and working fine.
 I have installed phpmyadmin too and it's working fine. I can log in... :)
 I wanted to create a database but after I gave the database's name and
 click Create button the phpmyadmin kicked me out. Now, I can't log
 in and there is no error message or something.
 I'have tried to fix it with mysql_permission but there is no result. I
 can't log in through phpmyadmin. But, I can log in through terminal.

So your problem seems to be with phpmyadmin, not with MySQL per sé.

 I don't like mysql console because this is an uncomfortable, non
 usable little piece of something.

Yet it works...

Seems to me more like the phpmyadmin is the non usable such and such.

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Stroller]

On 29 Jul 2010, at 21:37, Tomas Krasnican wrote:
... But, when is the mysql in the depend part of rc script (for  
example, when you emerge syslog-ng with mysql enabled flag, that  
will be puted here automaticly), the running localy database is  
required for start this service. It is not required to have it rc- 
enabled the mysql database, because you have already enabled another  
service, which it requires..


Surely the rc-scripts should use before and after instead of  
needs or depends. I haven't looked at this recently, but I'm  
pretty sure there used to be such a distinction.


Stroller.

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[kashani]

On 7/31/2010 1:58 AM, Stroller wrote:


On 29 Jul 2010, at 21:37, Tomas Krasnican wrote:

... But, when is the mysql in the depend part of rc script (for
example, when you emerge syslog-ng with mysql enabled flag, that will
be puted here automaticly), the running localy database is required
for start this service. It is not required to have it rc-enabled the
mysql database, because you have already enabled another service,
which it requires..


Surely the rc-scripts should use before and after instead of needs
or depends. I haven't looked at this recently, but I'm pretty sure
there used to be such a distinction.

Stroller.


For grins I compiled sql support into syslog-ng. Here's the new rc 
script.

depend() {
need net
use mysql dns logger netmount postgresql
after sshd
}

	It'll load after Mysql only if it exists in the current runlevel. As 
other people have said, there isn't any problem to solve here.


kashani

[gentoo-user] mysql use flag witout server, using only client libaries

[Tomas Krasnican]

Hi list,

I'm sorry for my bad english..

I would like to emerge some packages using mysql use flag (and mysql flag 
features, for example. php, dovecot, postfix, ...), but without mysql database 
server (applications will connecting to the mysql database on the another 
(remote) server). Problem is, when I set the mysql use flag at some package, 
and I try to emerge that, mysql database is in the dependencies list.

I want to emerge that without mysql database server, using mysql client 
libraries only. How can I define that?

Thanks,
Regards,
Tomas Krasnican

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Alan McKinnon]

On Thursday 29 July 2010 16:54:45 Tomas Krasnican wrote:
 Hi list,
 
 I'm sorry for my bad english..
 
 I would like to emerge some packages using mysql use flag (and mysql flag
 features, for example. php, dovecot, postfix, ...), but without mysql
 database server (applications will connecting to the mysql database on the
 another (remote) server). Problem is, when I set the mysql use flag at
 some package, and I try to emerge that, mysql database is in the
 dependencies list.
 
 I want to emerge that without mysql database server, using mysql client
 libraries only. How can I define that?
 
 Thanks,
 Regards,
 Tomas Krasnican


Short answer: you can't.

Long answer: you might but the devs are not going to help you

Huge answer: a mysql client has support for connecting to a server on 
localhost. Apps like dovecot etc therefore assume the same. So the ebuilds 
install mysql if you ask for mysql support and you get everything.

There is no exact meaning for the mysql USE flag, it is interpreted (mostly) 
in whatever way the dev thinks it makes sense. Maybe this should not be like 
this. Doesn't matter - right now that's how it is. So you could inspect each 
ebuild you use for stuff that has mysql support and rip it apaprt to make it 
do what you want. Repeat for every version bump.



Or, you could just do the sane thing:

# equery size mysql
 * dev-db/mysql-5.1.46
 Total files : 403
 Total size  : 45.03 MiB
 
It's 45M, not a train smash. Most of that is docs, support configs, other 
weird shit that Sun thought was a good idea, client libs, common libs. And the 
server binary.


You are running php, dovecot and postfix on the box. Therefore apache too.

Trust me, the extra 2M the mysql server takes up is not disk space you are 
short off. Not worth the effort.

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Tomas Krasnican]

Alan McKinnon wrote:
 On Thursday 29 July 2010 16:54:45 Tomas Krasnican wrote:
 Hi list,

 I'm sorry for my bad english..

 I would like to emerge some packages using mysql use flag (and mysql flag
 features, for example. php, dovecot, postfix, ...), but without mysql
 database server (applications will connecting to the mysql database on the
 another (remote) server). Problem is, when I set the mysql use flag at
 some package, and I try to emerge that, mysql database is in the
 dependencies list.

 I want to emerge that without mysql database server, using mysql client
 libraries only. How can I define that?

 Thanks,
 Regards,
 Tomas Krasnican
 
 
 Short answer: you can't.
 
 Long answer: you might but the devs are not going to help you
 
 Huge answer: a mysql client has support for connecting to a server on 
 localhost. Apps like dovecot etc therefore assume the same. So the ebuilds 
 install mysql if you ask for mysql support and you get everything.
 
 There is no exact meaning for the mysql USE flag, it is interpreted (mostly) 
 in whatever way the dev thinks it makes sense. Maybe this should not be like 
 this. Doesn't matter - right now that's how it is. So you could inspect each 
 ebuild you use for stuff that has mysql support and rip it apaprt to make it 
 do what you want. Repeat for every version bump.
 
 
 
 Or, you could just do the sane thing:
 
 # equery size mysql
  * dev-db/mysql-5.1.46
  Total files : 403
  Total size  : 45.03 MiB
  
 It's 45M, not a train smash. Most of that is docs, support configs, other 
 weird shit that Sun thought was a good idea, client libs, common libs. And 
 the 
 server binary.
 
 
 You are running php, dovecot and postfix on the box. Therefore apache too.
 
 Trust me, the extra 2M the mysql server takes up is not disk space you are 
 short off. Not worth the effort.
 

Thanks for your reply.

When I'll install the mysql database server on the box, the lot of 
gentoo-like things will require it localy.

For example, when I emerge php with mysql support, the apache rc script will 
contains something like use mysql , or need mysql in that depend part. 
When I emerge something else with mysql support too, it will containts this 
thing too. And when I try to restart some of that, or when I wanna to restart 
the box, the mysql server will be started and it will take more time, as is 
realy needed. I wouldn't like that...

I can edit this scripts and remove the mysql dependency manually...but Why I 
must do it using this way? I wouldn't like to edit lot of rc scripts after 
every update. I am too lazy (and many admins too, I think) for doing this...

For daily modifying are designed the configuration files, but not rc (and not 
only rc) scripts. I think that developers are able to edit this scripts, when 
is it needed, but not end-user.

And I haven't see any reason to run mysql server localy, when all of 
applications are using external box as the database server. So, I looking for 
the another solution of this problem.

Any ideas about this problem?

Thanks
Tomas Krasnican

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Neil Bothwick]

On Thu, 29 Jul 2010 16:54:45 +0200, Tomas Krasnican wrote:

 I want to emerge that without mysql database server, using mysql client
 libraries only. How can I define that?

Set the minimal USE flag for mysql, do not set it globally.

dev-db/mysql:minimal - Install client programs only, no server


-- 
Neil Bothwick

WYTYSYDG - What you thought you saw, you didn't get.


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Peter Humphrey]

On Thursday 29 July 2010 17:19:09 Tomas Krasnican wrote:

 I haven't see any reason to run mysql server localy, when all of
 applications are using external box as the database server. So, I
 looking for the another solution of this problem.

As Alan said, installing the server doesn't cost a lot, especially 
compared with the personal cost of finding a way to exclude it while 
still keeping the client. And as long as you don't add mysqld to any run 
level, it doesn't consume any CPU cycles: it just sits there on your 
disk being ignored.

You were right to put problem in quotation marks.

-- 
Rgds
Peter.  Linux Counter 5290, 1994-04-23.

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Peter Humphrey]

On Thursday 29 July 2010 18:54:54 Neil Bothwick wrote:

 Set the minimal USE flag for mysql, do not set it globally.
 
 dev-db/mysql:minimal - Install client programs only, no server

Eek! I wish I'd seen this before my other post.

-- 
Rgds
Peter.  Linux Counter 5290, 1994-04-23.

Re: [gentoo-user] mysql use flag witout server, using only client libaries

[Tomas Krasnican]

Neil Bothwick wrote:
 Set the minimal USE flag for mysql, do not set it globally.
 dev-db/mysql:minimal - Install client programs only, no server

Thanks you! This is what I looking for..

Peter Humphrey wrote:
 As Alan said, installing the server doesn't cost a lot, especially 
 compared with the personal cost of finding a way to exclude it while 
 still keeping the client. And as long as you don't add mysqld to any run 
 level, it doesn't consume any CPU cycles: it just sits there on your 
 disk being ignored.

I'd like to doing things minimally, if is it possible. Simply is clever.. But, 
when is the mysql in the depend part of rc script (for example, when you emerge 
syslog-ng with mysql enabled flag, that will be puted here automaticly), the 
running localy database is required for start this service. It is not required 
to have it rc-enabled the mysql database, because you have already enabled 
another service, which it requires.. And at this point it could consume some 
CPU cycles... Yes minimally, thats true.

So, I don't want to see the running mysql in my proccess list..

-- 
Regards
Tomas Krasnican

[gentoo-user] mysql

[Stéphane Guedon]

Hello

Could someone help me concerning mysql.

My servers (both laptop hosted mysql and server hosted) are buggy. Every time I 
restart them through the 
init script, it crash ! :

18:15:06 r...@einstein:~ # rc-service mysql restart
pdns  | * Stopping PowerDNS (default) ...
mediatomb | * Stopping MediaTomb ...  [ 
ok ]
mysql | * Stopping  ...
mysql | * Stopping mysqld (0)   
  [ ok ]
mysql | * Starting  ...
mysql | * Starting  (/etc/mysql/my.cnf)
mysql | * MySQL NOT started (0) 
[ !! ]
mysql | * ERROR: mysql failed to start
18:15:44 r...@einstein:~ # ps -A|grep mys
 2333 ?00:00:00 mysqld
18:15:56 r...@einstein:~ # killall mysqld
18:17:37 r...@einstein:~ # rc-service mysql zap
mysql | * Manually resetting mysql to stopped state
18:17:44 r...@einstein:~ # rc-service mysql start
mysql | * Starting  ...
mysql | * Starting  (/etc/mysql/my.cnf)
mysql | * MySQL NOT started (0) 
[ !! ]
mysql | * ERROR: mysql failed to start
18:17:53 r...@einstein:~ # ps -A|grep mys   

 
 2628 ?00:00:00 mysqld

Of course, it crashs also on boot process, whereas at least two services (pdns 
and mediatomb) need it !

==

Here is the end of emerge --info mysql for the server hosted, which is the most 
problematic :

dev-db/mysql-5.1.46 was built with the following:
USE=community debug latin1 (multilib) perl -big-tables -cluster -embedded 
-extraengine -max-idx-128 -
minimal -pbxt -profiling (-selinux) -ssl -static -test -xtradb 
CFLAGS=-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 
-fno-strict-aliasing
CXXFLAGS=-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 
-fno-exceptions -
fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates 
-fno-strict-aliasing

==

I think I have read carefully the doc concerning mysql : 
http://www.gentoo.org/doc/fr/mysql-howto.xml.

What can I do ?

Thanks

-- 
Stéphane Guedon
page web : http://www.22decembre.eu/
carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf
clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc


signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] mysql

[roundyz]

St??phane Guedon wrote:

 Hello
 
 Could someone help me concerning mysql.
 
 My servers (both laptop hosted mysql and server hosted) are buggy. Every 
 time I restart them through the 
 init script, it crash ! :
 
 18:15:06 r...@einstein:~ # rc-service mysql restart
 pdns  | * Stopping PowerDNS (default) ...
 mediatomb | * Stopping MediaTomb ... 
  [ ok ]
 mysql | * Stopping  ...
 mysql | * Stopping mysqld (0)
  [ ok ]
 mysql | * Starting  ...
 mysql | * Starting  (/etc/mysql/my.cnf)
 mysql | * MySQL NOT started (0)  
[ !! ]
 mysql | * ERROR: mysql failed to start
 18:15:44 r...@einstein:~ # ps -A|grep mys
  2333 ?00:00:00 mysqld
 18:15:56 r...@einstein:~ # killall mysqld
 18:17:37 r...@einstein:~ # rc-service mysql zap
 mysql | * Manually resetting mysql to stopped state
 18:17:44 r...@einstein:~ # rc-service mysql start
 mysql | * Starting  ...
 mysql | * Starting  (/etc/mysql/my.cnf)
 mysql | * MySQL NOT started (0)  
[ !! ]
 mysql | * ERROR: mysql failed to start
 18:17:53 r...@einstein:~ # ps -A|grep mys
  

  2628 ?00:00:00 mysqld
 
 Of course, it crashs also on boot process, whereas at least two services 
 (pdns and mediatomb) need it !
 
 ==
 
 Here is the end of emerge --info mysql for the server hosted, which is the 
 most problematic :
 
 dev-db/mysql-5.1.46 was built with the following:
 USE=community debug latin1 (multilib) perl -big-tables -cluster -embedded 
 -extraengine -max-idx-128 -
 minimal -pbxt -profiling (-selinux) -ssl -static -test -xtradb 
 CFLAGS=-march=native -O3 -pipe -fomit-frame-pointer 
 -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing
 CXXFLAGS=-march=native -O3 -pipe -fomit-frame-pointer 
 -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -
 fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates 
 -fno-strict-aliasing
 
 ==
 
 I think I have read carefully the doc concerning mysql : 
 http://www.gentoo.org/doc/fr/mysql-howto.xml.
 
 What can I do ?
 
 Thanks

Hello,

What do the logs in /var/log/mysql/ read? Thats where I'd look for the
clue. Also check your config file.

Ragards,

Matt

Re: [gentoo-user] mysql

[Stéphane Guedon]

Le dimanche 11 juillet 2010 20:07:11, roun...@hotmail.ru a écrit :
 St??phane Guedon wrote:
  Hello
  
  Could someone help me concerning mysql.
  
  My servers (both laptop hosted mysql and server hosted) are buggy. Every
  time I restart them through the init script, it crash ! :
  
  18:15:06 r...@einstein:~ # rc-service mysql restart
  pdns  | * Stopping PowerDNS (default) ...
  mediatomb | * Stopping MediaTomb ...
   [ ok ] mysql | * Stopping  ...
  mysql | * Stopping mysqld (0)   
   [ ok ] mysql | * Starting  ...
  mysql | * Starting  (/etc/mysql/my.cnf)
  mysql | * MySQL NOT started (0) 
 [ !! ] mysql | * ERROR: mysql failed to start
  18:15:44 r...@einstein:~ # ps -A|grep mys
  
   2333 ?00:00:00 mysqld
  
  18:15:56 r...@einstein:~ # killall mysqld
  18:17:37 r...@einstein:~ # rc-service mysql zap
  mysql | * Manually resetting mysql to stopped state
  18:17:44 r...@einstein:~ # rc-service mysql start
  mysql | * Starting  ...
  mysql | * Starting  (/etc/mysql/my.cnf)
  mysql | * MySQL NOT started (0) 
 [ !! ] mysql | * ERROR: mysql failed to start
  18:17:53 r...@einstein:~ # ps -A|grep mys
  
   2628 ?00:00:00 mysqld
  
  Of course, it crashs also on boot process, whereas at least two services
  (pdns and mediatomb) need it !
  
  ==
  
  Here is the end of emerge --info mysql for the server hosted, which is
  the most problematic :
  
  dev-db/mysql-5.1.46 was built with the following:
  USE=community debug latin1 (multilib) perl -big-tables -cluster
  -embedded -extraengine -max-idx-128 - minimal -pbxt -profiling
  (-selinux) -ssl -static -test -xtradb CFLAGS=-march=native -O3 -pipe
  -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing
  CXXFLAGS=-march=native -O3 -pipe -fomit-frame-pointer
  -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions - fno-strict-aliasing
  -felide-constructors -fno-rtti -fno-implicit-templates
  -fno-strict-aliasing
  
  ==
  
  I think I have read carefully the doc concerning mysql :
  http://www.gentoo.org/doc/fr/mysql-howto.xml.
  
  What can I do ?
  
  Thanks
 
 Hello,
 
 What do the logs in /var/log/mysql/ read? Thats where I'd look for the
 clue. Also check your config file.

19:12:09 r...@einstein:/var/log/mysql # ls -l 
total 36
-rw-rw 1 mysql mysql 0 Jul 11 15:05 mysql.err
-rw-rw 1 mysql mysql 0 Jul 11 15:05 mysql.log
-rw-rw 1 mysql mysql 36816 Apr 21 10:52 mysqld.err

19:14:11 r...@einstein:/var/log/mysql # tail mysqld.err 
100323  8:30:20 [Note] Event Scheduler: Loaded 0 events
100323  8:30:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.44-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  
Gentoo Linux mysql-5.1.44-r1
100421 10:52:15 [Note] /usr/sbin/mysqld: Normal shutdown

100421 10:52:17 [Note] Event Scheduler: Purging the queue. 0 events
100421 10:52:20  InnoDB: Starting shutdown...
100421 10:52:39  InnoDB: Shutdown completed; log sequence number 0 8395213
100421 10:52:40 [Note] /usr/sbin/mysqld: Shutdown complete

This file is like this since DAYS ! I don't know why !

I use the usual config file given by the emerge process...

 
 Ragards,
 
 Matt

-- 
Stéphane Guedon
page web : http://www.22decembre.eu/
carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf
clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc


signature.asc
Description: This is a digitally signed message part.

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

On Fri, 5 Mar 2010 06:53:15 +, Mick wrote:

 I was trying to understand why a virtual package like virtual/mysql is
 pulling in dev-db/mysql and I used the syslog virtual/real
 relationship as an analogy.

The clue is in the name of the virtual, it is satisfied by one of the
MySQL packages in portage. You canot simply replace one SQL database with
another, otherwise there's be a virtual/sqldb that would be satisfied by
any of them.


-- 
Neil Bothwick

Last yur I kudnt spel modjerater now I are won.


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 5 March 2010 09:42, Neil Bothwick n...@digimed.co.uk wrote:
 On Fri, 5 Mar 2010 06:53:15 +, Mick wrote:

 I was trying to understand why a virtual package like virtual/mysql is
 pulling in dev-db/mysql and I used the syslog virtual/real
 relationship as an analogy.

 The clue is in the name of the virtual, it is satisfied by one of the
 MySQL packages in portage. You canot simply replace one SQL database with
 another, otherwise there's be a virtual/sqldb that would be satisfied by
 any of them.

Of course!  It was all in the pkg_name.  Thank you Neil.
-- 
Regards,
Mick

[gentoo-user] mysql is being pulled in again!

[Mick]

I am trying to understand what is pulling in mysql again.  This
morning a load of qt packages were being updated and I noticed a bunch
of perl and virtual packages in there too.  Rest assured dev-db/mysql
was in there, again.  This is despite the fact that the mysql use flag
seem to be not active as far as portage is concerned:

# euse -i mysql
global use flags (searching: mysql)

[-] mysql - Adds mySQL Database support

local use flags (searching: mysql)

[-] mysql (app-admin/ulogd):
Build MYSQL output plugin to save packets in a mysql database.

[-] mysql (net-misc/mediatomb):
Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
disabled, dev-db/sqlite is used in its stead.

Looking into it further I see that the virtual package is pulling the
database in:

# equery depends dev-db/mysql
[ Searching for packages depending on dev-db/mysql... ]
virtual/mysql-5.0 (=dev-db/mysql-5.0*)

# equery depends virtual/mysql
[ Searching for packages depending on virtual/mysql... ]
dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)

So, is this telling me the virtual mysql package depends of the real
mysql and vice versa?  Should I give up and accept that just like a
LAMP build, from now on a Linux desktop *must* run mysql and nothing
else will do?  I've read that sqlite is borked and won't do what
semantic-desktop wants, but what about people who for arguments sake
want to run postgress or some other database?
-- 
Regards,
Mick

Re: [gentoo-user] mysql is being pulled in again!

[Alan McKinnon]

On Thursday 04 March 2010 17:37:23 Mick wrote:
 I am trying to understand what is pulling in mysql again.  This
 morning a load of qt packages were being updated and I noticed a bunch
 of perl and virtual packages in there too.  Rest assured dev-db/mysql
 was in there, again.  This is despite the fact that the mysql use flag
 seem to be not active as far as portage is concerned:
 
 # euse -i mysql
 global use flags (searching: mysql)
 
 [-] mysql - Adds mySQL Database support
 
 local use flags (searching: mysql)
 
 [-] mysql (app-admin/ulogd):
 Build MYSQL output plugin to save packets in a mysql database.
 
 [-] mysql (net-misc/mediatomb):
 Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
 disabled, dev-db/sqlite is used in its stead.
 
 Looking into it further I see that the virtual package is pulling the
 database in:
 
 # equery depends dev-db/mysql
 [ Searching for packages depending on dev-db/mysql... ]
 virtual/mysql-5.0 (=dev-db/mysql-5.0*)
 
 # equery depends virtual/mysql
 [ Searching for packages depending on virtual/mysql... ]
 dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
 dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
 dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
 dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
 x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)
 
 So, is this telling me the virtual mysql package depends of the real
 mysql and vice versa?  Should I give up and accept that just like a
 LAMP build, from now on a Linux desktop *must* run mysql and nothing
 else will do?  I've read that sqlite is borked and won't do what
 semantic-desktop wants, but what about people who for arguments sake
 want to run postgress or some other database?

The tool you want to answer this question is

emerge -t

There will be a reason why mysql is being pulled in, most likely a package 
that must have it. 

If a user wants postgres, he should install and run postgres. How would this 
affect the presence or absence of mysql?
 
-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

On Thu, 4 Mar 2010 17:57:15 +0200, Alan McKinnon wrote:

 The tool you want to answer this question is
 
 emerge -t
 
 There will be a reason why mysql is being pulled in, most likely a
 package that must have it. 

I notice qt-sql is in the list, does that have the mysql flag forced on?


-- 
Neil Bothwick

In the begining, there was nothing.


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 4 March 2010 15:57, Alan McKinnon alan.mckin...@gmail.com wrote:
 On Thursday 04 March 2010 17:37:23 Mick wrote:
 I am trying to understand what is pulling in mysql again.  This
 morning a load of qt packages were being updated and I noticed a bunch
 of perl and virtual packages in there too.  Rest assured dev-db/mysql
 was in there, again.  This is despite the fact that the mysql use flag
 seem to be not active as far as portage is concerned:

 # euse -i mysql
 global use flags (searching: mysql)
 
 [-    ] mysql - Adds mySQL Database support

 local use flags (searching: mysql)
 
 [-    ] mysql (app-admin/ulogd):
 Build MYSQL output plugin to save packets in a mysql database.

 [-    ] mysql (net-misc/mediatomb):
 Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
 disabled, dev-db/sqlite is used in its stead.

 Looking into it further I see that the virtual package is pulling the
 database in:

 # equery depends dev-db/mysql
 [ Searching for packages depending on dev-db/mysql... ]
 virtual/mysql-5.0 (=dev-db/mysql-5.0*)

 # equery depends virtual/mysql
 [ Searching for packages depending on virtual/mysql... ]
 dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
 dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
 dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
 dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
 x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)

 So, is this telling me the virtual mysql package depends of the real
 mysql and vice versa?  Should I give up and accept that just like a
 LAMP build, from now on a Linux desktop *must* run mysql and nothing
 else will do?  I've read that sqlite is borked and won't do what
 semantic-desktop wants, but what about people who for arguments sake
 want to run postgress or some other database?

 The tool you want to answer this question is

 emerge -t

Right, but I started this mammoth emerge before I spent enough time
looking at its contents I'm afraid.  :-(  I could of course uninstall
them and try again, but there's steam coming out the back of this old
box and I would rather not have to rinse and repeat.

This is what was pulled in today and most of the perl stuff seemed
like new installs:

 Thu Mar  4 09:20:24 2010  dev-libs/libffi-3.0.9
 Thu Mar  4 09:20:49 2010  dev-db/mysql-init-scripts-1.2
 Thu Mar  4 09:26:49 2010  net-dns/bind-tools-9.4.3_p5
 Thu Mar  4 09:33:38 2010  dev-perl/Net-Daemon-0.43
 Thu Mar  4 09:34:57 2010  perl-core/Storable-2.20
 Thu Mar  4 09:35:22 2010  dev-perl/yaml-0.68
 Thu Mar  4 09:35:56 2010  perl-core/Test-Harness-3.17
 Thu Mar  4 09:36:32 2010  perl-core/Package-Constants-0.02
 Thu Mar  4 09:37:07 2010  perl-core/Sys-Syslog-0.27
 Thu Mar  4 09:37:26 2010  virtual/perl-Storable-2.20
 Thu Mar  4 09:37:41 2010  virtual/perl-Test-Harness-3.17
 Thu Mar  4 09:37:57 2010  virtual/perl-Package-Constants-0.02
 Thu Mar  4 09:38:15 2010  virtual/perl-Sys-Syslog-0.27
 Thu Mar  4 09:38:46 2010  dev-perl/PlRPC-0.2020-r1
 Thu Mar  4 09:39:19 2010  perl-core/IO-Zlib-1.09
 Thu Mar  4 09:39:35 2010  virtual/perl-IO-Zlib-1.09
 Thu Mar  4 09:40:09 2010  perl-core/Archive-Tar-1.54
 Thu Mar  4 09:40:27 2010  virtual/perl-Archive-Tar-1.54
 Thu Mar  4 09:41:03 2010  perl-core/Module-Build-0.34.0201
 Thu Mar  4 09:41:19 2010  virtual/perl-Module-Build-0.34.0201
 Thu Mar  4 09:41:52 2010  perl-core/ExtUtils-CBuilder-0.26.03
 Thu Mar  4 09:42:08 2010  virtual/perl-ExtUtils-CBuilder-0.26.03
 Thu Mar  4 09:42:48 2010  perl-core/File-Spec-3.30
 Thu Mar  4 09:43:21 2010  perl-core/ExtUtils-ParseXS-2.20.0401
 Thu Mar  4 09:43:37 2010  virtual/perl-ExtUtils-ParseXS-2.20.0401
 Thu Mar  4 09:43:53 2010  virtual/perl-File-Spec-3.30
 Thu Mar  4 09:44:48 2010  dev-perl/DBI-1.609
 Thu Mar  4 09:47:31 2010  dev-util/boost-build-1.41.0
 Thu Mar  4 09:55:19 2010  media-gfx/exiv2-0.19
 Thu Mar  4 11:49:55 2010  dev-libs/boost-1.41.0-r3
 Thu Mar  4 12:29:27 2010  dev-db/mysql-5.0.84-r1
 Thu Mar  4 12:29:44 2010  virtual/mysql-5.0
 Thu Mar  4 12:30:32 2010  dev-perl/DBD-mysql-4.00.5
 Thu Mar  4 13:08:28 2010  x11-libs/qt-core-4.6.2-r1
 Thu Mar  4 13:12:49 2010  x11-libs/qt-dbus-4.6.2
 Thu Mar  4 13:28:44 2010  x11-libs/qt-script-4.6.2
 Thu Mar  4 13:32:06 2010  x11-libs/qt-sql-4.6.2
 Thu Mar  4 13:33:58 2010  x11-libs/qt-test-4.6.2
 Thu Mar  4 14:01:18 2010  x11-libs/qt-xmlpatterns-4.6.2
 Thu Mar  4 15:45:26 2010  x11-libs/qt-gui-4.6.2
 Thu Mar  4 16:11:12 2010  x11-libs/qt-qt3support-4.6.2
 Thu Mar  4 16:17:31 2010  x11-libs/qt-opengl-4.6.2
 Thu Mar  4 16:21:11 2010  x11-libs/qt-svg-4.6.2


 There will be a reason why mysql is being pulled in, most likely a package
 that must have it.

If a package must have it, wouldn't the USE flag mysql switch to + ?

 If a user 

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

On Thu, 4 Mar 2010 17:07:22 +, Mick wrote:

  The tool you want to answer this question is
 
  emerge -t
 
 Right, but I started this mammoth emerge before I spent enough time
 looking at its contents I'm afraid.

The use emerge --depclean -pv dev-db/mysql

  There will be a reason why mysql is being pulled in, most likely a
  package that must have it.
 
 If a package must have it, wouldn't the USE flag mysql switch to + ?

USE flags control optional dependencies. If a package must have it, there
won't be a USE flag.

  If a user wants postgres, he should install and run postgres. How
  would this affect the presence or absence of mysql?
 
 Well, I am assuming that if postgres can do what mysql does, then it
 could work in its place.  Like if syslog-ng will do what metalog does,
 then the virtual/log-thingie will not insist in pulling in metalog.

The difference is that the virtual/logger is satisfied by a number of
loggers, while virtual/mysql is satisfied by different mysql variants.
The other difference is that the various loggers present the same face to
other programs, whereas postgresql has a different API to mysql.

 Anyway, the postgres is just an example of asking why are we locking
 down the choice of a database to a particular package/provider.

WE are not doing anything of the sort. The upstream developers have
decided mysql is the storage system they want to use. Supporting multiple
databases would require time or experience they do not have, unless
someone else is prepared to contribute some of their own.


-- 
Neil Bothwick

God: What one human uses to persecute another.


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql is being pulled in again!

[Roy Wright]

Since you already merged it in:

# equery depends mysql

then unmerge or correct USE flags for dependent apps.

To have portage error out instead of merging mysql in the future:

# echo dev-db/mysql /etc/portage/package.mask/I_said_no_mysql

HTH,
Roy

Re: [gentoo-user] mysql is being pulled in again!

[Alan McKinnon]

On Thursday 04 March 2010 19:07:22 Mick wrote:
  There will be a reason why mysql is being pulled in, most likely a
  package that must have it.
 
 If a package must have it, wouldn't the USE flag mysql switch to + ?

Your post seems to indicate a lack of understanding of how these things work.

Often-times things are not optional, that's what must means. USE is 
diametrically opposed to that as it has to imply a meaning of may. If a 
package if hard-coded to use mysql, then it must have it, and putting it in 
USE in pointless.

There's no rule about this. If mysql is a hard dep, then that's the way it is. 

  If a user wants postgres, he should install and run postgres. How would
  this affect the presence or absence of mysql?
 
 Well, I am assuming that if postgres can do what mysql does, then it
 could work in its place.  Like if syslog-ng will do what metalog does,
 then the virtual/log-thingie will not insist in pulling in metalog.
 Anyway, the postgres is just an example of asking why are we locking
 down the choice of a database to a particular package/provider.

Again, you appear to fail to understand. metalog supports a variety of 
database backends. Not all apps are like this, some are hard-coded. If you 
want to use an app like this, you have no choice but to install mysql.

If you don't like this, then your choices number two:

1. Tough, get over it;
2. Use a different app

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

On Thu, 4 Mar 2010 22:07:14 +0200, Alan McKinnon wrote:

 Again, you appear to fail to understand. metalog supports a variety of 
 database backends. Not all apps are like this, some are hard-coded. If
 you want to use an app like this, you have no choice but to install
 mysql.
 
 If you don't like this, then your choices number two:
 
 1. Tough, get over it;
 2. Use a different app

3. Patch the code to support a different database.


-- 
Neil Bothwick

Better to understand a little than to misunderstand a lot.


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 4 March 2010 20:07, Alan McKinnon alan.mckin...@gmail.com wrote:
 On Thursday 04 March 2010 19:07:22 Mick wrote:
  There will be a reason why mysql is being pulled in, most likely a
  package that must have it.

 If a package must have it, wouldn't the USE flag mysql switch to + ?

 Your post seems to indicate a lack of understanding of how these things work.

Yep.  :-(

 Often-times things are not optional, that's what must means. USE is
 diametrically opposed to that as it has to imply a meaning of may. If a
 package if hard-coded to use mysql, then it must have it, and putting it in
 USE in pointless.

I see.  I thought that (some relevant) USE flags reflected
dependencies at some level and that if a dependency changed then this
would reflect those USE flags which would now show up as active.  So I
thought that the mysql USE flag would change from - to +.

 There's no rule about this. If mysql is a hard dep, then that's the way it is.

  If a user wants postgres, he should install and run postgres. How would
  this affect the presence or absence of mysql?

 Well, I am assuming that if postgres can do what mysql does, then it
 could work in its place.  Like if syslog-ng will do what metalog does,
 then the virtual/log-thingie will not insist in pulling in metalog.
 Anyway, the postgres is just an example of asking why are we locking
 down the choice of a database to a particular package/provider.

 Again, you appear to fail to understand. metalog supports a variety of
 database backends. Not all apps are like this, some are hard-coded. If you
 want to use an app like this, you have no choice but to install mysql.

 If you don't like this, then your choices number two:

 1. Tough, get over it;
 2. Use a different app

No I think you fail to understand what I fail to understand!  Ha, ha!  :-))

I was not talking about what db a syslog app will use as a back end.
I was trying to understand why a virtual package like virtual/mysql is
pulling in dev-db/mysql and I used the syslog virtual/real
relationship as an analogy.  Anyway, I now know two things:

a) qt-sql pulled in mysql

b) when the wife shouts at me to get going with chores, I do not start
an emerge without first checking the contents of it!  :-))

Thanks again for your replies.
-- 
Regards,
Mick

[gentoo-user] MySQL 5.1 and Amarok

[Nikos Chantziaras]

It's not possible to use Amarok with the embedded USE flag with the 
newly released MySQL 5.1.  Why is that?  Can we expect it to work at 
some point?

Re: [gentoo-user] MySQL 5.1 and Amarok

[Alan McKinnon]

On Sunday 21 February 2010 11:44:18 Nikos Chantziaras wrote:
 It's not possible to use Amarok with the embedded USE flag with the
 newly released MySQL 5.1.  Why is that?  Can we expect it to work at
 some point?


Do you mean it doesn't work, or the upgrade is dogdy with blocker messages 
that seem to have no source, make no sense, and no reason given?

My update this morning would not proceed with amarok-2.2.2 installed, and 
portage could not work it's automagic. Unmerging amarok, emergeing world, then 
merging amarok-2.2.2.90 seems to be proceeding fine, it's building as I type.

No guarantees it will succeed though...
Or that it will work in any sane fashion.

I'm starting to get really ticked off with amarok. The trials the devs have 
put me through defy belief, and for some stupid reason, I persist with the 
thing. I've removed it 3 times over the last 2 years and each time given it a 
chance again and put it back. I really do like it's feature set, and I really 
want it to succeed. My these infernal eternal cockups with mysql will be the 
end of me.

But I dunno, I think I'm flogging a dead horse with this music player


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] MySQL 5.1 and Amarok

[Volker Armin Hemmann]

On Sonntag 21 Februar 2010, Alan McKinnon wrote:
 On Sunday 21 February 2010 11:44:18 Nikos Chantziaras wrote:
  It's not possible to use Amarok with the embedded USE flag with the
  newly released MySQL 5.1.  Why is that?  Can we expect it to work at
  some point?
 
 Do you mean it doesn't work, or the upgrade is dogdy with blocker messages
 that seem to have no source, make no sense, and no reason given?
 
 My update this morning would not proceed with amarok-2.2.2 installed, and
 portage could not work it's automagic. Unmerging amarok, emergeing world,
 then merging amarok-2.2.2.90 seems to be proceeding fine, it's building as
 I type.
 
 No guarantees it will succeed though...
 Or that it will work in any sane fashion.
 
 I'm starting to get really ticked off with amarok. The trials the devs have
 put me through defy belief, 

what is so bad about typing emerge amarok?

openoffice - now that is a real bitch...

Re: [gentoo-user] MySQL 5.1 and Amarok

[Volker Armin Hemmann]

On Sonntag 21 Februar 2010, Nikos Chantziaras wrote:
 It's not possible to use Amarok with the embedded USE flag with the
 newly released MySQL 5.1.  Why is that?  Can we expect it to work at
 some point?

you can use amarok with embedded useflag. just unmerge it and emerge it again - 
I just tried it.
It is not much of a difference if you have to do it or revdep-rebuilt is doing 
it

It works.

Re: [gentoo-user] MySQL 5.1 and Amarok

[Alan McKinnon]

On Sunday 21 February 2010 18:18:18 Volker Armin Hemmann wrote:
 On Sonntag 21 Februar 2010, Alan McKinnon wrote:
  On Sunday 21 February 2010 11:44:18 Nikos Chantziaras wrote:
   It's not possible to use Amarok with the embedded USE flag with the
   newly released MySQL 5.1.  Why is that?  Can we expect it to work at
   some point?
  
  Do you mean it doesn't work, or the upgrade is dogdy with blocker
  messages that seem to have no source, make no sense, and no reason
  given?
  
  My update this morning would not proceed with amarok-2.2.2 installed, and
  portage could not work it's automagic. Unmerging amarok, emergeing world,
  then merging amarok-2.2.2.90 seems to be proceeding fine, it's building
  as I type.
  
  No guarantees it will succeed though...
  Or that it will work in any sane fashion.
  
  I'm starting to get really ticked off with amarok. The trials the devs
  have put me through defy belief,
 
 what is so bad about typing emerge amarok?

Initiating the build is not the problem. When the build fails like today, and 
it is eerily familiar to errors of the past (see later), then that is a 
problem. Today's error:

Linking CXX shared module ../../../../lib/amarok_collection-
mysqlecollection.so 
/usr/lib/gcc/x86_64-pc-linux-gnu/4.4.3/../../../../x86_64-pc-linux-gnu/bin/ld: 
/usr/lib64/mysql/libmysqld.a(client.o): relocation R_X86_64_32 against 
`mysql_server_last_error' can not be used when making a shared object; 
recompile with -fPIC   
/usr/lib64/mysql/libmysqld.a: could not read symbols: Bad value 

collect2: ld returned 1 exit status 


Until recently, the entire amarok-2.0 range was beset with build trouble, most 
often related to mysql. It all comes down to the really odd things the amarok 
devs are doing with mysql, which causes problems for us gentoo users. Binary 
distros don't have this problem, the maintainers there simply adjust their 
build farms to cope and then ship the result. Which the user will not 
recompile and all is good.

We can look at amarok's history of randomly crashing for no good reason when 
loading playlists, or loading internet streaming services under some 
conditions. Our how about the long period when it just steadfastly refused to 
even try to read and build a collection, despite the devs declaring it to be a 
useable stable release

I'm not making this up, it's all there is in the bugzillas, every ugly 
embarrassing bit of it.

Like I said, I'd like this app to succeed. But the evidence shows that the 
devs are probably not capable of making it so, given the numbers of 
showstoppers it's had in it's basic functionality and backend. 

It just ain't there yet.
Ye gods, I'm starting to sound like Dale :-)

 openoffice - now that is a real bitch...

Can't argue with that. But at least 3.2.0 built here today first time (after 
I'd given it 6G free in /var/tmp/portage/)

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Neil Bothwick]

On Wed, 18 Nov 2009 09:09:35 +0200, Alan McKinnon wrote:

 eix comes with some useful utilities like eix-test-obsolete which scans
 all your portage files and tells you which settings are redundant,
 duplicated and so on.

And flagedit warns if you have set any obsolete flags in make.conf.


-- 
Neil Bothwick

To most people solutions mean finding the answers. But to chemists
solutions are things that are still all mixed up.


signature.asc
Description: PGP signature

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Neil Bothwick wrote:

On Wed, 18 Nov 2009 09:09:35 +0200, Alan McKinnon wrote:

  

eix comes with some useful utilities like eix-test-obsolete which scans
all your portage files and tells you which settings are redundant,
duplicated and so on.



And flagedit warns if you have set any obsolete flags in make.conf.


  


I have used that eix one before.  It was a while back tho.  It does seem 
to output a LOT and takes a while to sort through it all.  Don't worry, 
I won't post all that on here.  I bet it is a lot of stuff. 


About to emerge flagedit now.  See what it does.

Thanks.

Dale

:-)  :-)

[gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Hi,

KDE 4 was having issues with sqlite not working correctly.  After 
reading about and people telling me that mySql works better, I installed 
mySql.  Its big and all but at least it works.  Anyway, I changed the 
USE flags and have -sqlite in my USE flag line.  I want to get rid of 
sqlite on here.  I see no need for me to have two of these installed at 
the same time.  Here is what depends on sqlite:


r...@smoker / # equery depends sqlite
[ Searching for packages depending on sqlite... ]
app-pda/libopensync-0.22 (=dev-db/sqlite-3)
app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)
dev-lang/python-2.6.2-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-lang/python-3.1.1-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
   (sqlite3? dev-db/sqlite:3)
dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
dev-libs/nspr-4.8 (=dev-db/sqlite-3.5)
dev-libs/nss-3.12.3-r1 (=dev-db/sqlite-3.5)
dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
dev-util/subversion-1.6.5 (=dev-db/sqlite-3.4[threadsafe])
kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
media-libs/libsndfile-1.0.20 (sqlite? =dev-db/sqlite-3.2)
net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
net-libs/webkit-gtk-1.1.10 (=dev-db/sqlite-3)
net-libs/xulrunner-1.9.1.4 (sqlite? =dev-db/sqlite-3.6.16)
www-client/mozilla-firefox-3.5.4 (sqlite? =dev-db/sqlite-3.6.10)
x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
r...@smoker / #

Those appear to be in the ebuild and MySql is not a option for 
replacement.  Is there a way?  I have already emerged these with the 
-sqlite and +mysql USE flag.  I notice something about sqlite3 in one of 
the ebuilds.  What is that?


Ideas?

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Tuesday 17 November 2009 23:53:01 Dale wrote:
 Hi,
 
 KDE 4 was having issues with sqlite not working correctly.  After
 reading about and people telling me that mySql works better, I installed
 mySql.  Its big and all but at least it works.  Anyway, I changed the
 USE flags and have -sqlite in my USE flag line.  I want to get rid of
 sqlite on here.  I see no need for me to have two of these installed at
 the same time.  Here is what depends on sqlite:
 
 r...@smoker / # equery depends sqlite
 [ Searching for packages depending on sqlite... ]
 app-pda/libopensync-0.22 (=dev-db/sqlite-3)
 app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)
 dev-lang/python-2.6.2-r1 (!build  sqlite? =dev-db/sqlite-3)
 dev-lang/python-3.1.1-r1 (!build  sqlite? =dev-db/sqlite-3)
 dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
 (sqlite3? dev-db/sqlite:3)
 dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
 dev-libs/nspr-4.8 (=dev-db/sqlite-3.5)
 dev-libs/nss-3.12.3-r1 (=dev-db/sqlite-3.5)
 dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
 dev-util/subversion-1.6.5 (=dev-db/sqlite-3.4[threadsafe])
 kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
 kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
 media-libs/libsndfile-1.0.20 (sqlite? =dev-db/sqlite-3.2)
 net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
 net-libs/webkit-gtk-1.1.10 (=dev-db/sqlite-3)
 net-libs/xulrunner-1.9.1.4 (sqlite? =dev-db/sqlite-3.6.16)
 www-client/mozilla-firefox-3.5.4 (sqlite? =dev-db/sqlite-3.6.10)
 x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
 r...@smoker / #
 
 Those appear to be in the ebuild and MySql is not a option for
 replacement.  Is there a way?  I have already emerged these with the
 -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
 the ebuilds.  What is that?

Look at it:

# equery size sqlite
 * dev-db/sqlite-2.8.16-r4
 Total files : 48
 Total size  : 2.50 MiB
 * dev-db/sqlite-3.6.20-r1
 Total files : 518
 Total size  : 7.49 MiB

10M. Why are you worried? Pretend it's not there.

sqlite is SLOTted 0 and 3 (usual reasons for SLOTs)

There is no package called sqlite3, there are bindings in other languages with 
that string in the name. sqlite-3 in ebuilds is not a package, it's a version 
atom, like

=dev-db/sqlite-3

Some stuff uses sqlite for storage. If it works, leave it alone. Just because 
some parts of KDE koffkoff amarok koffkoff have issues with it doesn;t 
mean all of KDE has issues with it


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[James Ausmus]

On Tue, Nov 17, 2009 at 1:53 PM, Dale rdalek1...@gmail.com wrote:

 Hi,

 KDE 4 was having issues with sqlite not working correctly.  After reading
 about and people telling me that mySql works better, I installed mySql.  Its
 big and all but at least it works.  Anyway, I changed the USE flags and have
 -sqlite in my USE flag line.  I want to get rid of sqlite on here.  I see no
 need for me to have two of these installed at the same time.  Here is what
 depends on sqlite:

 r...@smoker / # equery depends sqlite
 [ Searching for packages depending on sqlite... ]
 app-pda/libopensync-0.22 (=dev-db/sqlite-3)
 app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)
 dev-lang/python-2.6.2-r1 (!build  sqlite? =dev-db/sqlite-3)
 dev-lang/python-3.1.1-r1 (!build  sqlite? =dev-db/sqlite-3)
 dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
   (sqlite3? dev-db/sqlite:3)
 dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
 dev-libs/nspr-4.8 (=dev-db/sqlite-3.5)
 dev-libs/nss-3.12.3-r1 (=dev-db/sqlite-3.5)
 dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
 dev-util/subversion-1.6.5 (=dev-db/sqlite-3.4[threadsafe])
 kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
 kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
 media-libs/libsndfile-1.0.20 (sqlite? =dev-db/sqlite-3.2)
 net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
 net-libs/webkit-gtk-1.1.10 (=dev-db/sqlite-3)
 net-libs/xulrunner-1.9.1.4 (sqlite? =dev-db/sqlite-3.6.16)
 www-client/mozilla-firefox-3.5.4 (sqlite? =dev-db/sqlite-3.6.10)
 x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
 r...@smoker / #

 Those appear to be in the ebuild and MySql is not a option for replacement.
  Is there a way?  I have already emerged these with the -sqlite and +mysql
 USE flag.  I notice something about sqlite3 in one of the ebuilds.  What is
 that?

 Ideas?


Unfortunately, MySQL is not a drop-in replacement for sqlite - the
programming APIs and DB capabilities are sufficiently different to not be
able to just replace one with the other - the developer has to add in
extra code/abstraction in order to be able to support one or the other or
both.

As far as sqlite vs. sqlite3, the more recent major version of sqlite
(sqlite-3.*) broke backwards compatibility with =sqlite-2.*, and has, once
again, a different programming API and different DB capabilities - some
packages might still only be able to use sqlite-3, some might be able to
use either (hence the sqlite vs. sqlite3 USE flags), and some might only be
able to use =sqlite-3.*. If you look at the package list above, you'll see
that pretty much all of them require some version of sqlite-3, and the only
one that can optionally do either has the USE flag split out into sqlite
(for the sqlite-3 version) and sqlite-3 - I would guess w/o looking at the
ebuild that sqlite-3 takes precedence if both are set, as it's a better and
more robust DB system than the older sqlite.

HTH-

-James



 Dale

 :-)  :-)

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Alan McKinnon wrote:

On Tuesday 17 November 2009 23:53:01 Dale wrote:
  

Hi,

KDE 4 was having issues with sqlite not working correctly.  After
reading about and people telling me that mySql works better, I installed
mySql.  Its big and all but at least it works.  Anyway, I changed the
USE flags and have -sqlite in my USE flag line.  I want to get rid of
sqlite on here.  I see no need for me to have two of these installed at
the same time.  Here is what depends on sqlite:

r...@smoker / # equery depends sqlite
[ Searching for packages depending on sqlite... ]
app-pda/libopensync-0.22 (=dev-db/sqlite-3)
app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)
dev-lang/python-2.6.2-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-lang/python-3.1.1-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
(sqlite3? dev-db/sqlite:3)
dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
dev-libs/nspr-4.8 (=dev-db/sqlite-3.5)
dev-libs/nss-3.12.3-r1 (=dev-db/sqlite-3.5)
dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
dev-util/subversion-1.6.5 (=dev-db/sqlite-3.4[threadsafe])
kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
media-libs/libsndfile-1.0.20 (sqlite? =dev-db/sqlite-3.2)
net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
net-libs/webkit-gtk-1.1.10 (=dev-db/sqlite-3)
net-libs/xulrunner-1.9.1.4 (sqlite? =dev-db/sqlite-3.6.16)
www-client/mozilla-firefox-3.5.4 (sqlite? =dev-db/sqlite-3.6.10)
x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
r...@smoker / #

Those appear to be in the ebuild and MySql is not a option for
replacement.  Is there a way?  I have already emerged these with the
-sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
the ebuilds.  What is that?



Look at it:

# equery size sqlite
 * dev-db/sqlite-2.8.16-r4
 Total files : 48
 Total size  : 2.50 MiB
 * dev-db/sqlite-3.6.20-r1
 Total files : 518
 Total size  : 7.49 MiB

10M. Why are you worried? Pretend it's not there.

sqlite is SLOTted 0 and 3 (usual reasons for SLOTs)

There is no package called sqlite3, there are bindings in other languages with 
that string in the name. sqlite-3 in ebuilds is not a package, it's a version 
atom, like


  

=dev-db/sqlite-3



Some stuff uses sqlite for storage. If it works, leave it alone. Just because 
some parts of KDE koffkoff amarok koffkoff have issues with it doesn;t 
mean all of KDE has issues with it



  


So basically I have to have it anyway?  It's just one more thing to 
update is why I want to gt rid of it.


I also noticed the sqlite3 USE flag.  Changing that next.

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Wednesday 18 November 2009 00:22:08 Dale wrote:
  Some stuff uses sqlite for storage. If it works, leave it alone. Just
  because  some parts of KDE koffkoff amarok koffkoff have issues
  with it doesn;t mean all of KDE has issues with it
 
 

 
 So basically I have to have it anyway?  It's just one more thing to 
 update is why I want to gt rid of it.
 
You have better things to worry about, trust me :-)

Like, why do you have to have redland and lucene around when a) redland sucks 
b) lucene sucks much less despite being java?

Or XML parsers... why do you invariably have libxml and expat at the same 
time?

For that matter, I'll bet you have 3 SLOTTED versions of db in addition to 
gdbm (all in addition to sqlite of course)

Lets not even start with the scripting languages ... I often hear newbies 
complain about having bash, python, perl and ruby all at the same time. Can't 
the devs just stick to one language?

See where I'm going with this? At 10M for two versions of sqlite, it's not 
worth worrying about and you don't have to pay any attention to updating it - 
portage and --depclean will sort you out just fine

-- 
alan dot mckinnon at gmail dot com

equery depends vs. emerge -pv --depclean atom (was: Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.)

[Daniel Pielmeier]

Dale schrieb am 17.11.2009 22:53:

 r...@smoker / # equery depends sqlite
 [ Searching for packages depending on sqlite... ]
 app-pda/libopensync-0.22 (=dev-db/sqlite-3)

If you have this package installed and want to keep it you are forced to
keep sqlite as it is a hard dependency. Meaning this package needs
sqlite and there is no alternative.

 app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)

Here sqlite is optional via use flag. So you can get rid of the
dependency it by disabling the use flag.

 Those appear to be in the ebuild and MySql is not a option for
 replacement.  Is there a way?  I have already emerged these with the
 -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
 the ebuilds.  What is that?

The main reason why I respond to this post is that there are still a lot
of people which are using equery depends, although it is known to
print false positive by not taking use flags into account. You have to
scan through the output and check if the use flag is activated which
pulls in the package you want to check. Like for eix in the above
example. Eix only depends on sqlite if the sqlite use flag is activated.
Equery depends lists it in any case (activated or not) as it doesn't
take the use flags into account.

A more convenient way to find out the correct reverse dependencies with
portage is emerge -pv --depclean atom[1]. Running only emerge -pv
--depclean checks the complete world and system set, but if you pass a
package to it only the reverse dependencies of the package in question
are examined.

[1] http://www.gentoo.org/proj/en/portage/doc/faq.xml

-- 
Daniel Pielmeier



signature.asc
Description: OpenPGP digital signature

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Alan McKinnon wrote:

On Wednesday 18 November 2009 00:22:08 Dale wrote:
  

Some stuff uses sqlite for storage. If it works, leave it alone. Just
because  some parts of KDE koffkoff amarok koffkoff have issues
with it doesn;t mean all of KDE has issues with it


  
  
So basically I have to have it anyway?  It's just one more thing to 
update is why I want to gt rid of it.

 
You have better things to worry about, trust me :-)


Like, why do you have to have redland and lucene around when a) redland sucks 
b) lucene sucks much less despite being java?


Or XML parsers... why do you invariably have libxml and expat at the same 
time?


For that matter, I'll bet you have 3 SLOTTED versions of db in addition to 
gdbm (all in addition to sqlite of course)


Lets not even start with the scripting languages ... I often hear newbies 
complain about having bash, python, perl and ruby all at the same time. Can't 
the devs just stick to one language?


See where I'm going with this? At 10M for two versions of sqlite, it's not 
worth worrying about and you don't have to pay any attention to updating it - 
portage and --depclean will sort you out just fine


  


Well that stirred up my curiosity.  Here is my USE line:

r...@smoker / # emerge --info | grep USE
USE=3dnow X aac acl acpi alsa amd automount berkdb bzip2 cairo cddb cdr 
chroot cli consolekit cracklib cups curl dbus dri dvd dvdr dvdread 
emboss encode esd evo exif fam fdftk flac fortran gdbm gif gimp gkrellm 
gphoto2 gpm gstreamer gtk hal hbci htmlhandbook iconv ipv6 java 
javascript jbig jpeg jpeg2k justify kde ldap libnotify libwww logrotate 
loop-aes mad mikmod mmx mng modules mp3 mp4 mpeg mplayer mudflap mysql 
ncurses nptl nptlonly nsplugin offensive ofx ogg opengl openmp pam 
parport pcre pdf perl png ppds pppd python qt3 qt3support qt4 quicktime 
readline realmedia reflection sdl seamonkey session spell spl sse ssl 
startup-notification svg sysfs syslog tcl tcpd thunar tiff tk truetype 
unicode usb vorbis webkit win32codecs wma wmf wmp x264 x86 xml xorg xv 
xvid yahoo zeroconf zlib ALSA_CARDS=emu10k1 ALSA_PCM_PLUGINS=adpcm 
alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug 
ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route 
share shm softvol CAMERAS=canon ptp2 ELIBC=glibc 
INPUT_DEVICES=keyboard mouse evdev KERNEL=linux LINGUAS=en_US en 
SANE_BACKENDS=hp USERLAND=GNU VIDEO_CARDS=nvidia nv

r...@smoker / #

Should I be turning some of those off as they are not needed?  This is 
my oldest install so I bet some are not even needed or can be done away 
with.  I most likely had a good reason for turning them on way back when 
but may not have a good reason now. 


Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

James Ausmus wrote:



On Tue, Nov 17, 2009 at 1:53 PM, Dale rdalek1...@gmail.com 
mailto:rdalek1...@gmail.com wrote:


Hi,

KDE 4 was having issues with sqlite not working correctly.
 After reading about and people telling me that mySql works
better, I installed mySql.  Its big and all but at least it works.
 Anyway, I changed the USE flags and have -sqlite in my USE flag
line.  I want to get rid of sqlite on here.  I see no need for me
to have two of these installed at the same time.  Here is what
depends on sqlite:

r...@smoker / # equery depends sqlite
[ Searching for packages depending on sqlite... ]
app-pda/libopensync-0.22 (=dev-db/sqlite-3)
app-portage/eix-0.17.0 (sqlite? =dev-db/sqlite-3)
dev-lang/python-2.6.2-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-lang/python-3.1.1-r1 (!build  sqlite? =dev-db/sqlite-3)
dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
  (sqlite3? dev-db/sqlite:3)
dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
dev-libs/nspr-4.8 (=dev-db/sqlite-3.5)
dev-libs/nss-3.12.3-r1 (=dev-db/sqlite-3.5)
dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
dev-util/subversion-1.6.5 (=dev-db/sqlite-3.4[threadsafe])
kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
media-libs/libsndfile-1.0.20 (sqlite? =dev-db/sqlite-3.2)
net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
net-libs/webkit-gtk-1.1.10 (=dev-db/sqlite-3)
net-libs/xulrunner-1.9.1.4 (sqlite? =dev-db/sqlite-3.6.16)
www-client/mozilla-firefox-3.5.4 (sqlite? =dev-db/sqlite-3.6.10)
x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
r...@smoker / #

Those appear to be in the ebuild and MySql is not a option for
replacement.  Is there a way?  I have already emerged these with
the -sqlite and +mysql USE flag.  I notice something about sqlite3
in one of the ebuilds.  What is that?

Ideas?


Unfortunately, MySQL is not a drop-in replacement for sqlite - the 
programming APIs and DB capabilities are sufficiently different to not 
be able to just replace one with the other - the developer has to 
add in extra code/abstraction in order to be able to support one or 
the other or both.


As far as sqlite vs. sqlite3, the more recent major version of sqlite 
(sqlite-3.*) broke backwards compatibility with =sqlite-2.*, and has, 
once again, a different programming API and different DB capabilities 
- some packages might still only be able to use sqlite-3, some might 
be able to use either (hence the sqlite vs. sqlite3 USE flags), and 
some might only be able to use =sqlite-3.*. If you look at the 
package list above, you'll see that pretty much all of them require 
some version of sqlite-3, and the only one that can optionally do 
either has the USE flag split out into sqlite (for the sqlite-3 
version) and sqlite-3 - I would guess w/o looking at the ebuild that 
sqlite-3 takes precedence if both are set, as it's a better and more 
robust DB system than the older sqlite.


HTH-

-James


So they do the same thing but in different ways.  Hmmm.  Oh well.

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Albert Hopkins]

On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
 Should I be turning some of those off as they are not needed?  This
 is 
 my oldest install so I bet some are not even needed or can be done
 away 
 with.  I most likely had a good reason for turning them on way back
 when 
 but may not have a good reason now. 
 
 Dale 

I think you go down the wrong path when you ask someone else what USE
flags *you* need.  We don't know you and your requirements/preferences
enough to know what is needed for you.  It's like going up to a random
person and asking them if you should have your kitchen repainted and if
so what color.  That rarely happens but for kitchens but confusingly
enough it's frequent for USE flags.

Also, emerge --info |grep USE isn't very USEful (IMO) because it only
shows what USE flags you have turned on, not the ones you have turned
off.

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Albert Hopkins wrote:

On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
  

Should I be turning some of those off as they are not needed?  This
is 
my oldest install so I bet some are not even needed or can be done
away 
with.  I most likely had a good reason for turning them on way back
when 
but may not have a good reason now. 

Dale 



I think you go down the wrong path when you ask someone else what USE
flags *you* need.  We don't know you and your requirements/preferences
enough to know what is needed for you.  It's like going up to a random
person and asking them if you should have your kitchen repainted and if
so what color.  That rarely happens but for kitchens but confusingly
enough it's frequent for USE flags.

Also, emerge --info |grep USE isn't very USEful (IMO) because it only
shows what USE flags you have turned on, not the ones you have turned
off.

  


I was thinking that someone may see some USE flags that are no longer 
needed in most cases.  Some may not even be still in use as far as 
portage is concerned.  In other words, portage doesn't even recognize 
them as a option.  Basically, I do some picture stuff, surf with 
Seamonkey, Firefox and sometimes Konqueror, sometimes get on chat with 
Kopete, play Solitaire, watch a video on youtube sometimes.  Oh, I print 
stuff with my HP printer and download pics from my Canon camera. 

I never noticed that emerge --info doesn't show the USE flags I 
removed.  That is sort of weird.  I was thinking that it showed the USE 
flags with not only the profile but what I have set in make.conf which 
would include the ones turned on and turned off.   Neat info.


Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Wednesday 18 November 2009 07:49:40 Dale wrote:
 Albert Hopkins wrote:
  On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
  Should I be turning some of those off as they are not needed?  This
  is
  my oldest install so I bet some are not even needed or can be done
  away
  with.  I most likely had a good reason for turning them on way back
  when
  but may not have a good reason now.
 
  Dale
 
  I think you go down the wrong path when you ask someone else what USE
  flags *you* need.  We don't know you and your requirements/preferences
  enough to know what is needed for you.  It's like going up to a random
  person and asking them if you should have your kitchen repainted and if
  so what color.  That rarely happens but for kitchens but confusingly
  enough it's frequent for USE flags.
 
  Also, emerge --info |grep USE isn't very USEful (IMO) because it only
  shows what USE flags you have turned on, not the ones you have turned
  off.
 
 I was thinking that someone may see some USE flags that are no longer
 needed in most cases.  Some may not even be still in use as far as
 portage is concerned.  In other words, portage doesn't even recognize
 them as a option.  Basically, I do some picture stuff, surf with
 Seamonkey, Firefox and sometimes Konqueror, sometimes get on chat with
 Kopete, play Solitaire, watch a video on youtube sometimes.  Oh, I print
 stuff with my HP printer and download pics from my Canon camera.
 
 I never noticed that emerge --info doesn't show the USE flags I
 removed.  That is sort of weird.  I was thinking that it showed the USE
 flags with not only the profile but what I have set in make.conf which
 would include the ones turned on and turned off.   Neat info.

eix comes with some useful utilities like eix-test-obsolete which scans all 
your portage files and tells you which settings are redundant, duplicated and 
so on.

It takes a while to parse all of it, but a useful exercise nonetheless


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql USE flag error

[Renat Golubchyk]

On Mon, 19 Oct 2009 06:56:57 +0100
Mick michaelkintz...@gmail.com wrote:
 I am not sure I understand this message about the mysql USE flag:
 =
 # emerge -upDv world
 
 These are the packages that would be merged, in order:
 
 Calculating dependencies... done!
 
 emerge: there are no ebuilds built with USE flags to 
 satisfy =x11-libs/qt-sql-4.5.0:4[mysql].
 !!! One of the following packages is required to complete your
 request:
 - x11-libs/qt-sql-4.5.2 (Change USE: +mysql)
 (dependency required by app-office/akonadi-server-1.2.1 [ebuild])
 (dependency required by kde-base/kdepimlibs-4.3.1 [ebuild])
 (dependency required by kde-base/krfb-4.3.1 [ebuild])
 (dependency required by world [argument])

kde-base/krfb-4.3.1 requires kde-base/kdepimlibs-4.3.1 which requires
app-office/akonadi-server-1.2.1 which requires
=x11-libs/qt-sql-4.5.0:4[mysql]

Actually app-office/akonadi-server-1.2.1 requires
=x11-libs/qt-sql-4.5.0:4[mysql?,sqlite?] which means mysql or sqlite,
default to mysql.


Cheers,
Renat

-- 
Probleme kann man niemals mit derselben Denkweise loesen,
durch die sie entstanden sind.
  (Einstein)


signature.asc
Description: PGP signature

Re: [gentoo-user] mysql USE flag error

[Mick]

2009/10/19 Renat Golubchyk ragerm...@gmx.net:
 On Mon, 19 Oct 2009 06:56:57 +0100
 Mick michaelkintz...@gmail.com wrote:
 I am not sure I understand this message about the mysql USE flag:
 =
 # emerge -upDv world

 These are the packages that would be merged, in order:

 Calculating dependencies... done!

 emerge: there are no ebuilds built with USE flags to
 satisfy =x11-libs/qt-sql-4.5.0:4[mysql].
 !!! One of the following packages is required to complete your
 request:
 - x11-libs/qt-sql-4.5.2 (Change USE: +mysql)
 (dependency required by app-office/akonadi-server-1.2.1 [ebuild])
 (dependency required by kde-base/kdepimlibs-4.3.1 [ebuild])
 (dependency required by kde-base/krfb-4.3.1 [ebuild])
 (dependency required by world [argument])

 kde-base/krfb-4.3.1 requires kde-base/kdepimlibs-4.3.1 which requires
 app-office/akonadi-server-1.2.1 which requires
=x11-libs/qt-sql-4.5.0:4[mysql]

 Actually app-office/akonadi-server-1.2.1 requires
=x11-libs/qt-sql-4.5.0:4[mysql?,sqlite?] which means mysql or sqlite,
 default to mysql.

Thanks Renat, I am still struggling to understand why mysql is being
dragged in.  It seems that x11-libs/qt-sql-4.5.2 is already installed
with the sqlite flag:
=
 Installed versions:  4.5.2(4)(12:30:57 10/10/09)(iconv qt3support
sqlite -debug -firebird -mysql -odbc -pch -postgres)
=

I've added -mysql in /etc/portage/package.use for x11-libs/qt-sql but
it makes no difference.  Then I added mysql and all this mess comes
up:
=
# emerge -upDv world

These are the packages that would be merged, in order:

Calculating dependencies... done!

!!! Multiple package instances within a single package slot have been pulled
!!! into the dependency graph, resulting in a slot conflict:

x11-libs/qt-sql:4

  ('ebuild', '/', 'x11-libs/qt-sql-4.5.2', 'merge') pulled in by
=x11-libs/qt-sql-4.5.0:4[mysql] required by ('ebuild', '/',
'app-office/akonadi-server-1.2.1', 'merge')

  ('installed', '/', 'x11-libs/qt-sql-4.5.2', 'nomerge') pulled in by
=x11-libs/qt-sql-4.5.1:4[qt3support] required by ('ebuild', '/',
'kde-base/kmix-4.3.1', 'merge')
=x11-libs/qt-sql-4.5.1:4[qt3support] required by ('ebuild', '/',
'kde-base/kontactinterfaces-4.3.1', 'merge')
=x11-libs/qt-sql-4.5.1:4[qt3support] required by ('ebuild', '/', 'kde-base/
kimagemapeditor-4.3.1', 'merge')
(and 117 more)

sys-auth/pambase:0

  ('ebuild', '/', 'sys-auth/pambase-20090620.1-r1', 'merge') pulled in by
sys-auth/pambase required by world
sys-auth/pambase[consolekit] required by ('ebuild', '/',
'net-wireless/bluez-4.39-r2', 'merge')

  ('installed', '/', 'sys-auth/pambase-20090620.1-r1', 'nomerge') pulled in by
sys-auth/pambase required by world
=sys-auth/pambase-20081028 required by ('installed', '/',
'net-misc/openssh-5.2_p1-r3', 'nomerge')
=sys-auth/pambase-20080219.1 required by ('installed', '/',
'sys-apps/shadow-4.1.2.2', 'nomerge')
(and 1 more)


It may be possible to solve this problem by using package.mask to
prevent one of those packages from being selected. However, it is also
possible that conflicting dependencies exist such that they are
impossible to satisfy simultaneously. If such a conflict exists in the
dependencies of two different packages, then those packages can not be
installed simultaneously.

For more information, see MASKED PACKAGES section in the emerge man page
or refer to the Gentoo Handbook.


emerge: there are no ebuilds built with USE flags to satisfy
=dev-python/PyQt4-4.5[dbus,sql,svg,webkit,X].
!!! One of the following packages is required to complete your request:
- dev-python/PyQt4-4.5.4-r4 (Change USE: +sql +webkit)
(dependency required by kde-base/pykde4-4.3.1 [ebuild])
(dependency required by kde-base/plasma-workspace-4.3.1 [ebuild])
(dependency required by kde-base/kdebase-meta-4.3.1 [ebuild])
(dependency required by world [argument])
=

It seems to me that it may be easier to just unmerge krfb and forget
about it, but there must be a more elegant solution to this?
-- 
Regards,
Mick

[gentoo-user] mysql USE flag error

[Mick]

I am not sure I understand this message about the mysql USE flag:
=
# emerge -upDv world

These are the packages that would be merged, in order:

Calculating dependencies... done!

emerge: there are no ebuilds built with USE flags to 
satisfy =x11-libs/qt-sql-4.5.0:4[mysql].
!!! One of the following packages is required to complete your request:
- x11-libs/qt-sql-4.5.2 (Change USE: +mysql)
(dependency required by app-office/akonadi-server-1.2.1 [ebuild])
(dependency required by kde-base/kdepimlibs-4.3.1 [ebuild])
(dependency required by kde-base/krfb-4.3.1 [ebuild])
(dependency required by world [argument])

# euse -i mysql
global use flags (searching: mysql)

[-] mysql - Adds mySQL Database support

local use flags (searching: mysql)

[-] mysql (app-admin/ulogd):
Build MYSQL output plugin to save packets in a mysql database.

[-] mysql (net-misc/mediatomb):
Use dev-db/mysql as backend rather than SQLite3. If this USE flag is disabled, 
dev-db/sqlite is used in its stead.

$ eix -l x11-libs/qt-sql
[snip...]
 Installed versions:  4.5.2(4)(12:30:57 10/10/09)(iconv qt3support 
sqlite -debug -firebird -mysql -odbc -pch -postgres)
=

Of the packages mentioned as dependencies requiring mysql I only have 
installed kde-base/krfb, but not the version shown above 
kde-base/krfb-4.3.1 - see below:
=
# emerge -Cpv kde-base/krfb

 These are the packages that would be unmerged:

 kde-base/krfb
selected: 3.5.10 
   protected: none 
 omitted: none 

 'Selected' packages are slated for removal.
 'Protected' and 'omitted' packages will not be removed.
=

Can you please explain why this mysql USE flag message shows up?
-- 
Regards,
Mick


signature.asc
Description: This is a digitally signed message part.

[gentoo-user] Mysql and utf8: Can't initialize character set utf-8

[Galevsky]

Hi, I have a problem with mysql 5.0.71-r1 and utf8 charset. I have a
lighttpd v1.4.20 web server using php v5.2.9-r2 that provides several
websites.

I set up the DB server default charset to utf-8 into file /etc/my.cnf

[mysqld]
character-set-server= utf8
default-character-set   = utf8


since I want a utf8 box:

~$ locale
LANG=fr_FR.UTF-8
LC_CTYPE=fr_FR.UTF-8
LC_NUMERIC=fr_FR.UTF-8
LC_TIME=fr_FR.UTF-8
LC_COLLATE=fr_FR.UTF-8
LC_MONETARY=fr_FR.UTF-8
LC_MESSAGES=fr_FR.UTF-8
LC_PAPER=fr_FR.UTF-8
LC_NAME=fr_FR.UTF-8
LC_ADDRESS=fr_FR.UTF-8
LC_TELEPHONE=fr_FR.UTF-8
LC_MEASUREMENT=fr_FR.UTF-8
LC_IDENTIFICATION=fr_FR.UTF-8
LC_ALL=


but I changed the previous en_GB language to fr_FR.UTF-8 a few days
ago, and now my web sites can't connect to the DBs and I face the
following error:

Can't initialize character set utf-8 (path: /usr/share/mysql/charsets/)

I have 'unicode' in my USE flags, try to emerge -uDN my whole world
but I cannot get any /usr/share/mysql/charsets/utf-8.xml file !

What can I do ? Any support is welcome..

Hereafter my box settings:

~ # emerge --info
Portage 2.1.6.11 (default/linux/x86/2008.0, gcc-4.1.2,
glibc-2.8_p20080602-r1, 2.6.24.5-grsec--grs-ipv4-32 i686)
=
System uname: 
linux-2.6.24.5-grsec--grs-ipv4-32-i686-intel-r-_pentium-r-_dual_cpu_e21...@_2.00ghz-with-glibc2.0
Timestamp of tree: Wed, 29 Apr 2009 05:00:01 +
distcc 3.0 i686-pc-linux-gnu [disabled]
app-shells/bash: 3.2_p39
dev-lang/python: 2.4.4-r6, 2.5.4-r2
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:1.6-r2
sys-devel/autoconf:  2.63
sys-devel/automake:  1.10.2
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.27-r2
ACCEPT_KEYWORDS=x86
CBUILD=i686-pc-linux-gnu
CFLAGS=-O2 -march=i686 -pipe
CHOST=i686-pc-linux-gnu
CONFIG_PROTECT=/etc /var/bind
CONFIG_PROTECT_MASK=/etc/ca-certificates.conf /etc/env.d /etc/gconf
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d
/etc/terminfo /etc/udev/rules.d
CXXFLAGS=-O2 -march=i686 -pipe
DISTDIR=/usr/portage/distfiles
FEATURES=distlocks fixpackages parallel-fetch protect-owned sfperms
strict unmerge-orphans userfetch
GENTOO_MIRRORS=http://mirror.ovh.net/gentoo-distfiles/
ftp://mirror.ovh.net/gentoo-distfiles/;
LANG=fr_fr.u...@euro
LDFLAGS=-Wl,-O1
LINGUAS=fr en
MAKEOPTS=-j3
PKGDIR=/usr/portage/packages
PORTAGE_CONFIGROOT=/
PORTAGE_RSYNC_OPTS=--recursive --links --safe-links --perms --times
--compress --force --whole-file --delete --stats --timeout=180
--exclude=/distfiles --exclude=/local --exclude=/packages
PORTAGE_TMPDIR=/var/tmp
PORTDIR=/usr/portage
PORTDIR_OVERLAY=/usr/portage/local/layman/ovh-overlay
SYNC=rsync://rsync.gentoo.org/gentoo-portage
USE=acl berkdb bzip2 cgi cli cracklib crypt cups dri fastcgi fortran
gd gdbm gif gpm iconv ipv6 isdnlog jpeg midi mmx mudflap mysql ncurses
nls nptlonly openmp pam pcre perl png pppd python readline reflection
session spl sse sse2 ssl sysfs tcpd unicode x86 xml xorg zlib
ALSA_CARDS=ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci
emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel
intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem
ymfpci ALSA_PCM_PLUGINS=adpcm alaw asym copy dmix dshare dsnoop
empty extplug file hooks iec958 ioplug ladspa lfloat linear meter
mmap_emul mulaw multi null plug rate route share shm softvol
APACHE2_MODULES=actions alias auth_basic authn_alias authn_anon
authn_dbm authn_default authn_file authz_dbm authz_default
authz_groupfile authz_host authz_owner authz_user autoindex cache dav
dav_fs dav_lock deflate dir disk_cache env expires ext_filter
file_cache filter headers include info log_config logio mem_cache mime
mime_magic negotiation rewrite setenvif speling status unique_id
userdir usertrack vhost_alias ELIBC=glibc INPUT_DEVICES=keyboard
mouse evdev KERNEL=linux LCD_DEVICES=bayrad cfontz cfontz633 glk
hd44780 lb216 lcdm001 mtxorb ncurses text LINGUAS=fr en
USERLAND=GNU VIDEO_CARDS=fbdev glint i810 intel mach64 mga neomagic
nv r128 radeon savage sis tdfx trident vesa vga via vmware voodoo
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK,
LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS,
PORTAGE_RSYNC_EXTRA_OPTS

Galevsky

Re: [gentoo-user] mysql 5.1

[Arttu V.]

On 1/14/09, Marcin Niśkiewicz mniskiew...@gmail.com wrote:
 Hello
 Is it known when mysql version 5.1 will be available in portage for amd64
 (stable)?

I don't know if we on the *user* list really can know about the devs'
decisions. Maybe gentoo-dev list or irc channel could give better
answers? AFAIK the devs rarely reply on this list.

I found one comment which appears to be quite insightful of the
situation (I don't use mysql that much, so I have to take this at face
value), although it doesn't give exact time frames:

http://bugs.gentoo.org/show_bug.cgi?id=194561#c25

Eating your data is bad for a database and if that was the situation a
bit over a month ago, I wouldn't hold my breath for a stable marked
ebuild in portage for a while.

-- 
Arttu V.

[gentoo-user] mysql 5.1

[Marcin Niśkiewicz]

Hello
Is it known when mysql version 5.1 will be available in portage for amd64
(stable)?

Thanks for answer
best regards
nichu

[gentoo-user] mysql++ on amd64

[Jeffrey Wong]

Is anyone aware of known issues with mysql++ 2.2.2-r1 on amd64?  I have a
program I've been testing in gdb and I get occasional SIGILL crashes.

Is mysql++ 2.3.x stable enough for production use?

Re: [gentoo-user] mysql on a chrooted env

[Arnau Bria]

On Tue, 29 Jan 2008 18:17:00 +
Luu Danh Hieu wrote:

 2008/1/29, Arnau Bria [EMAIL PROTECTED]:
  Hi,
 
  my pc has died, so I'm trying to take all data from the disk...
  I have it connected via usb, and I'm in a chrooted env on the old
  system.
 [snip]
 
 Hello,
 
 It might be better if you copy over the files in /var/lib/mysql rather
 than starting the SQL server and dumping it, since you already have an
 offline SQL server, and offline servers are the easiest to backup.
Well, I did it, but got some problems (which I've already solved)...

but I was wondering how to solve my originakl problem..

 Have a look at [1].
 
 [1] : http://www.linux.com/feature/62177
Thanks for the link!!!


 Good luck.
 
 Hieu Luu Danh
Thank you very much!

-- 
Arnau Bria
http://blog.emergetux.net
Bombing for peace is like fucking for virginity
-- 
gentoo-user@lists.gentoo.org mailing list

[gentoo-user] mysql on a chrooted env

[Arnau Bria]

Hi,

my pc has died, so I'm trying to take all data from the disk...
I have it connected via usb, and I'm in a chrooted env on the old
system.
(I followe handbook instructions)


I'm trying to do a mysql dump, but I'm not able to start mysql:

(chroot) lx-arnau / # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (1) 

 logs show this:

(chroot) lx-arnau / # tail /var/log/mysql/mysqld.err 
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb68a808d, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0xb68a808d, stack_bottom=0xbf9f, 
thread_stack=196608, aborting backtrace.
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.


I've read the link, but I do not understand many things :-)

anyone could help me, please?


TIA,
-- 
Arnau Bria
http://blog.emergetux.net
Bombing for peace is like fucking for virginity
-- 
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] mysql on a chrooted env

[Hieu, Luu Danh]

2008/1/29, Arnau Bria [EMAIL PROTECTED]:
 Hi,

 my pc has died, so I'm trying to take all data from the disk...
 I have it connected via usb, and I'm in a chrooted env on the old
 system.
[snip]

Hello,

It might be better if you copy over the files in /var/lib/mysql rather
than starting the SQL server and dumping it, since you already have an
offline SQL server, and offline servers are the easiest to backup.
Have a look at [1].

[1] : http://www.linux.com/feature/62177

Good luck.

Hieu Luu Danh
-- 
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] MySQL isn't slotted. What to do?

[kashani]

Andrew Gaydenko wrote:

The issue is, I need to keep mysql 4.1.x version for my job. OTOH, say, last
dev-libs/apr-util needs mysql 5.x version. The mysql package isn't slotted,
and this fact is rather strange (4.0.x, 4.1.x and 5.x versions are _very_ 
different, and all are widely used in real servers). 


What to do?


apr-util doesn't need Mysql unless you're doing your own db connection 
pool within Apache (I bet you aren't), it just has that USE flag set.


echo dev-libs/apr-util -mysql  /etc/portage/package.use

kashani
--
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] MySQL isn't slotted. What to do?

[kashani]

kashani wrote:

Andrew Gaydenko wrote:

The issue is, I need to keep mysql 4.1.x version for my job. OTOH,
 say, last dev-libs/apr-util needs mysql 5.x version. The mysql
package isn't slotted, and this fact is rather strange (4.0.x,
4.1.x and 5.x versions are _very_ different, and all are widely
used in real servers). What to do?


apr-util doesn't need Mysql unless you're doing your own db
connection pool within Apache (I bet you aren't), it just has that
USE flag set.

echo dev-libs/apr-util -mysql  /etc/portage/package.use


A bit more info after poking around on this. The DBD layer in apr-util 
1.2.x can be used for Mysql auth and replaces mod_auth_mysql. That might 
be an issue if you're dependent on that sort of authentication.


It does seem odd that vrtual-mysql5 is required for Mysql support in 
apr-util, but that is what is specified in the ebuild.


kashani
--
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] MySQL isn't slotted. What to do?

[Andrew Gaydenko]

=== On Monday 20 August 2007, kashani wrote: ===
 kashani wrote:
...
  apr-util doesn't need Mysql unless you're doing your own db
  connection pool within Apache (I bet you aren't), it just has that
  USE flag set.
  
  echo dev-libs/apr-util -mysql  /etc/portage/package.use
 
 A bit more info after poking around on this. The DBD layer in apr-util 
 1.2.x can be used for Mysql auth and replaces mod_auth_mysql. That might 
 be an issue if you're dependent on that sort of authentication.
 
 It does seem odd that vrtual-mysql5 is required for Mysql support in 
 apr-util, but that is what is specified in the ebuild.
 
 kashani


Thanks! - Done. I haven't apache installed at all, and apr-util package was
installed as subversion's dependence-from (last one is installed without 
'apache2' useflag also).
-- 
[EMAIL PROTECTED] mailing list

[gentoo-user] MySQL isn't slotted. What to do?

[Andrew Gaydenko]

The issue is, I need to keep mysql 4.1.x version for my job. OTOH, say, last
dev-libs/apr-util needs mysql 5.x version. The mysql package isn't slotted,
and this fact is rather strange (4.0.x, 4.1.x and 5.x versions are _very_ 
different, and all are widely used in real servers). 

What to do?
-- 
[EMAIL PROTECTED] mailing list

[gentoo-user] mysql emerge error

[Eray Aslan]

Hello,

New server.  While emerging mysql, I got the following:

 [...]
 make[4]: Entering directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
 Makefile:251: .deps/trx0purge.Po: No such file or directory
 make[4]: *** No rule to make target `.deps/trx0purge.Po'.  Stop.
 make[4]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
 make[3]: *** [all-recursive] Error 1
 make[3]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
 make[2]: *** [all] Error 2
 make[2]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql'
 make: *** [all] Error 2
 
 !!! ERROR: dev-db/mysql-5.0.38 failed.
 Call stack:
   ebuild.sh, line 1614:   Called dyn_compile
   ebuild.sh, line 971:   Called qa_call 'src_compile'
   environment, line 4489:   Called src_compile
   ebuild.sh, line 1304:   Called mysql_src_compile
   mysql.eclass, line 605:   Called die
 
 !!! emake failed
 !!! If you need support, post the topmost build error, and the call stack if 
 relevant.
 !!! A complete build log is located at 
 '/var/log/portage/dev-db:mysql-5.0.38:20070420-074312.log'.

Couldn't find a related bug.  Any ideas what might be causing this?
emerge --info below.

Thanks.

 sunny ~ # emerge --info
 Portage 2.1.2.2 (default-linux/amd64/2006.1/no-multilib, gcc-4.1.1, 
 glibc-2.5-r0, 2.6.18-hardened-r6 x86_64)
 =
 System uname: 2.6.18-hardened-r6 x86_64 AMD Athlon(tm) 64 X2 Dual Core 
 Processor 4000+
 Gentoo Base System release 1.12.9
 Timestamp of tree: Thu, 19 Apr 2007 15:50:01 +
 dev-lang/python: 2.4.3-r4
 dev-python/pycrypto: 2.0.1-r5
 sys-apps/sandbox:1.2.17
 sys-devel/autoconf:  2.13, 2.61
 sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
 sys-devel/binutils:  2.16.1-r3
 sys-devel/gcc-config: 1.3.15-r1
 sys-devel/libtool:   1.5.22
 virtual/os-headers:  2.6.17-r2
 ACCEPT_KEYWORDS=amd64
 AUTOCLEAN=yes
 CBUILD=x86_64-pc-linux-gnu
 CFLAGS=-march=k8 -O2 -pipe
 CHOST=x86_64-pc-linux-gnu
 CONFIG_PROTECT=/etc
 CONFIG_PROTECT_MASK=/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo
 CXXFLAGS=-march=k8 -O2 -pipe
 DISTDIR=/usr/portage/distfiles
 FEATURES=buildpkg distlocks metadata-transfer sandbox sfperms strict
 GENTOO_MIRRORS=ftp://ftp.ankara.edu.tr/gentoo/  http://gentoo.osuosl.org/ 
 ftp://distro.ibiblio.org/pub/linux/distributions/gentoo/ 
 ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ 
 ftp://ftp.ntua.gr/pub/linux/gentoo/ 
 ftp://ftp.linux.org.tr/pub/mirrors/gentoo/;
 MAKEOPTS=-j2
 PKGDIR=/usr/portage/packages
 PORTAGE_RSYNC_OPTS=--recursive --links --safe-links --perms --times 
 --compress --force --whole-file --delete --delete-after --stats --timeout=180 
 --exclude=/distfiles --exclude=/local --exclude=/packages 
 --filter=H_**/files/digest-*
 PORTAGE_TMPDIR=/var/tmp
 PORTDIR=/usr/portage
 SYNC=rsync://rsync.europe.gentoo.org/gentoo-portage
 USE=amd64 berkdb cjk crypt hardened mysql ncurses nls nptl pam perl pic 
 python readline snmp ssl tcpd unicode xml ALSA_CARDS=ali5451 als4000 atiixp 
 atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 
 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem 
 ymfpci ALSA_PCM_PLUGINS=adpcm alaw asym copy dmix dshare dsnoop empty 
 extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null 
 plug rate route share shm softvol ELIBC=glibc INPUT_DEVICES=keyboard 
 mouse evdev KERNEL=linux LCD_DEVICES=bayrad cfontz cfontz633 glk hd44780 
 lb216 lcdm001 mtxorb ncurses text USERLAND=GNU VIDEO_CARDS=apm ark ati 
 chips cirrus cyrix dummy fbdev glint i128 i810 mga neomagic nv rendition s3 
 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga 
 via vmware voodoo
 Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, 
 LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, 
 PORTDIR_OVERLAY

-- 
Eray
-- 
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] mysql emerge error

[Eray Aslan]

On 20.04.2007 11:06, Eray Aslan wrote:
 [...]
 make[4]: Entering directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
 Makefile:251: .deps/trx0purge.Po: No such file or directory
 make[4]: *** No rule to make target `.deps/trx0purge.Po'.  Stop.
 make[4]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
 make[3]: *** [all-recursive] Error 1
 make[3]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
 make[2]: *** [all] Error 2
 make[2]: Leaving directory 
 `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql'
 make: *** [all] Error 2

Sorry for replying to my own email.  mysql-5.0.34 builds fine.  Bugged
5.0.38: http://bugs.gentoo.org/show_bug.cgi?id=175331

-- 
Eray
-- 
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] mysql emerge error

[Daniel Iliev]

On Fri, 20 Apr 2007 13:22:17 +0300
Eray Aslan [EMAIL PROTECTED] wrote:

 On 20.04.2007 11:06, Eray Aslan wrote:
  [...]
  make[4]: Entering directory
  `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
  Makefile:251: .deps/trx0purge.Po: No such file or directory
  make[4]: *** No rule to make target `.deps/trx0purge.Po'.  Stop.
  make[4]: Leaving directory
  `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase/trx'
  make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory
  `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
  make[2]: *** [all] Error 2 make[2]: Leaving directory
  `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql/innobase'
  make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory
  `/var/tmp/portage/dev-db/mysql-5.0.38/work/mysql' make: *** [all]
  Error 2
 
 Sorry for replying to my own email.  mysql-5.0.34 builds fine.  Bugged
 5.0.38: http://bugs.gentoo.org/show_bug.cgi?id=175331
 


If you don't use innodb, you could try
echo 'EXTRA_ECONF=$EXTRA_ECONF --without-innodb'  /etc/make.conf

I have mysqld  Ver 5.0.38 for pc-linux-gnu on x86_64 (Gentoo Linux
mysql-5.0.38) here compiled w/o problems.

-- 
Best regards,
Daniel

-- 
[EMAIL PROTECTED] mailing list

Re: [gentoo-user] mysql start issues

[Francisco Rivas]

Hi...

last month i had the same problem I was see a lot of posts in forums, this
solution works for me: create a sym link yo mysqd.sock, it's something like
this

ln -vs /tmp/mysql.sock /var/run/mysql/mysql.sock


for mysql 5.0.26-r2, that's work for me.

It's important see the my.cnf at the line where mysql put the mysql.sock
in my case :

[client]
password  = **
port= 3306
socket= /var/run/mysqld/mysqld.sock

$ls -l /tmp/mysql.sock
   /tmp/mysql.sock - /var/run/mysqld/mysqld.sock

I hope that's work for you too.

NOTE : Please excuse me for my english it's no so good, but I need to help
everyone that i can...that make a better world.. Peace..:D

On 3/19/07, Richard Torres [EMAIL PROTECTED] wrote:


OK.  I Unmerged and re-emerged mysql.

# /etc/init.d/mysql stop
# emerge -C mysql
# tar cjpvf ~/mysql.$(date +%FT%H-%M).tar.bz2 /etc/mysql/my.cnf
/var/lib/mysql/
# ls -l ~/mysql.*
# rm -rf /var/lib/mysql/ /var/log/mysql

# emerge -av dev-db/mysql

It completed installing/compiling then..

# emerge --config =dev-db/mysql-5.0.32

Configuring pkg...

* MySQL DATADIR is /var/lib/mysql
* Previous datadir found, it's YOUR job to change
* ownership and take care of it
* Creating the mysql database and setting proper
* permissions on it ...
* Insert a password for the mysql 'root' user
* Avoid ['\_%] characters in the password

* Retype the password


!!! ERROR: dev-db/mysql-5.0.32 failed.
Call stack:
  ebuild.sh, line 1527:   Called pkg_config
  ebuild.sh, line 1255:   Called mysql_pkg_config
  mysql.eclass, line 805:   Called die

!!! MySQL databases not installed
!!! If you need support, post the topmost build error, and the call stack
if
relevant.

# /etc/init.d/mysql start
* Starting mysql...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)

Any ideas?

-Original Message-
From: Dan Farrell [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 9:08 AM
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] mysql start issues

On Sat, 17 Mar 2007 13:11:54 -0500
Richard Torres [EMAIL PROTECTED] wrote:

 Hello,

 I'm having a trouble starting mysql since I emerged the newer version.
 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is
 greatly appreciated.



 -Richard



 # mysql

 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
 '/var/run/mysqld/mysqld.sock' (2)



 # /etc/init.d/mysql start

  * Starting mysql...

  * Starting mysql (/etc/mysql/my.cnf)

  * MySQL NOT started (0)

I had the same problem and my solution was found at :
http://www.gentoo.org/doc/en/mysql-upgrading.xml
.but I never did get my password-encoded columns back.

good luck!
--
gentoo-user@gentoo.org mailing list

--
gentoo-user@gentoo.org mailing list





--
['Cause without love I won't survive, I love you]. I

Francisco Rivas
2.6.19-gentoo-r5 x86
udev v087 gnome 2.16.2
xorg-x11-7.1 hotplug v20040923-r2
e-mail : [EMAIL PROTECTED]
msn : [EMAIL PROTECTED]

-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCS/E/IT/MU d-(+)@ s++: a-- C ULSC*()+++ P+(++)+++ L++(+++)
!E--- W+++ !N* !o-(--)-- K--? !w--- !O !M !V PS@ !PE@ Y PGP t 5 X R++
tv- b DI D G e+ h- r+ y-
--END GEEK CODE BLOCK--

Re: [gentoo-user] mysql start issues

[Dan Farrell]

On Mon, 19 Mar 2007 01:22:07 -0500
Richard Torres [EMAIL PROTECTED] wrote:

 Configuring pkg...
 
  * MySQL DATADIR is /var/lib/mysql
  * Previous datadir found, it's YOUR job to change
  * ownership and take care of it
  * Creating the mysql database and setting proper
  * permissions on it ...
  * Insert a password for the mysql 'root' user
  * Avoid ['\_%] characters in the password
 
  * Retype the password
 
 
 !!! ERROR: dev-db/mysql-5.0.32 failed.
 Call stack:
   ebuild.sh, line 1527:   Called pkg_config
   ebuild.sh, line 1255:   Called mysql_pkg_config
   mysql.eclass, line 805:   Called die

 Any ideas?

I am by no means a mysql expert, but the passwords got deleted, didn't
they?

 # rm -rf /var/lib/mysql/ /var/log/mysql
-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] mysql start issues

[Richard Torres]

Yes. And I re-entered one at the prompts ().

-Original Message-
From: Dan Farrell [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 19, 2007 9:05 AM
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] mysql start issues

On Mon, 19 Mar 2007 01:22:07 -0500
Richard Torres [EMAIL PROTECTED] wrote:

 Configuring pkg...
 
  * MySQL DATADIR is /var/lib/mysql
  * Previous datadir found, it's YOUR job to change
  * ownership and take care of it
  * Creating the mysql database and setting proper
  * permissions on it ...
  * Insert a password for the mysql 'root' user
  * Avoid ['\_%] characters in the password
 
  * Retype the password
 
 
 !!! ERROR: dev-db/mysql-5.0.32 failed.
 Call stack:
   ebuild.sh, line 1527:   Called pkg_config
   ebuild.sh, line 1255:   Called mysql_pkg_config
   mysql.eclass, line 805:   Called die

 Any ideas?

I am by no means a mysql expert, but the passwords got deleted, didn't
they?

 # rm -rf /var/lib/mysql/ /var/log/mysql
-- 
gentoo-user@gentoo.org mailing list

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql start issues

[Neil Walker]

Richard Torres wrote:

Yes. And I re-entered one at the prompts ().
  


It's telling you what the problem is - the database already exists (from 
your last install). Either just ignore the error or delete 
/var/lib/mysql/mysql and run emerge --config. again.


Be lucky,

Neil

--
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql start issues

[Dan Farrell]

On Sat, 17 Mar 2007 13:11:54 -0500
Richard Torres [EMAIL PROTECTED] wrote:

 Hello, 
 
 I'm having a trouble starting mysql since I emerged the newer version.
 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is
 greatly appreciated.
 
  
 
 -Richard
 
  
 
 # mysql
 
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
 '/var/run/mysqld/mysqld.sock' (2)
 
  
 
 # /etc/init.d/mysql start
 
  * Starting mysql...
 
  * Starting mysql (/etc/mysql/my.cnf)
 
  * MySQL NOT started (0)
 
I had the same problem and my solution was found at :
http://www.gentoo.org/doc/en/mysql-upgrading.xml
...but I never did get my password-encoded columns back.  

good luck!
-- 
gentoo-user@gentoo.org mailing list

RE: [gentoo-user] mysql start issues

[Richard Torres]

OK.  I Unmerged and re-emerged mysql. 

# /etc/init.d/mysql stop
# emerge -C mysql
# tar cjpvf ~/mysql.$(date +%FT%H-%M).tar.bz2 /etc/mysql/my.cnf
/var/lib/mysql/
# ls -l ~/mysql.*
# rm -rf /var/lib/mysql/ /var/log/mysql

# emerge -av dev-db/mysql

It completed installing/compiling then..

# emerge --config =dev-db/mysql-5.0.32

Configuring pkg...

 * MySQL DATADIR is /var/lib/mysql
 * Previous datadir found, it's YOUR job to change
 * ownership and take care of it
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Insert a password for the mysql 'root' user
 * Avoid ['\_%] characters in the password

 * Retype the password


!!! ERROR: dev-db/mysql-5.0.32 failed.
Call stack:
  ebuild.sh, line 1527:   Called pkg_config
  ebuild.sh, line 1255:   Called mysql_pkg_config
  mysql.eclass, line 805:   Called die

!!! MySQL databases not installed
!!! If you need support, post the topmost build error, and the call stack if
relevant.

# /etc/init.d/mysql start
 * Starting mysql...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)

Any ideas?

-Original Message-
From: Dan Farrell [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 18, 2007 9:08 AM
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] mysql start issues

On Sat, 17 Mar 2007 13:11:54 -0500
Richard Torres [EMAIL PROTECTED] wrote:

 Hello, 
 
 I'm having a trouble starting mysql since I emerged the newer version.
 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is
 greatly appreciated.
 
  
 
 -Richard
 
  
 
 # mysql
 
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
 '/var/run/mysqld/mysqld.sock' (2)
 
  
 
 # /etc/init.d/mysql start
 
  * Starting mysql...
 
  * Starting mysql (/etc/mysql/my.cnf)
 
  * MySQL NOT started (0)
 
I had the same problem and my solution was found at :
http://www.gentoo.org/doc/en/mysql-upgrading.xml
.but I never did get my password-encoded columns back.  

good luck!
-- 
gentoo-user@gentoo.org mailing list

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] mysql start issues

[Richard Torres]

Hello, 

I'm having a trouble starting mysql since I emerged the newer version.
'mysqld.sock' doesn't exist and the logs aren't much help. Any help is
greatly appreciated.

 

-Richard

 

# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

 

# /etc/init.d/mysql start

 * Starting mysql...

 * Starting mysql (/etc/mysql/my.cnf)

 * MySQL NOT started (0)