Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
can't get mysql/mariadb to work (solved)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Tue Mar 22, 2011 7:37 am    Post subject: can't get mysql/mariadb to work (solved) Reply with quote

Hello Community,
as I already wrote there: https://forums.gentoo.org/viewtopic-p-6621787.html#6621787 I have a brand new AMD Fusion E350 system. I got it somehow installed and running but now mysql and mariadb won't start.
Emerge works fine but when I run
Code:
 /usr/bin/mysql_install_db
I got a segfault of mysqld with Error:0 in libgcc_s.so.1.
I will post any more information as soon as I am back home in front of my system.
Maybe somebody has any idea where to start...

thx
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...


Last edited by drizzt on Mon May 30, 2011 7:11 pm; edited 2 times in total
Back to top
View user's profile Send private message
msalerno
Veteran
Veteran


Joined: 17 Dec 2002
Posts: 1338
Location: Sweating in South Florida

PostPosted: Tue Mar 22, 2011 3:04 pm    Post subject: Reply with quote

Did you try a revdep-rebuild ?
Back to top
View user's profile Send private message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Tue Mar 22, 2011 4:33 pm    Post subject: Reply with quote

Yes, multiple times.

This is my emerge --info:
Code:

emerge --info
Portage 2.1.9.43 (default/linux/amd64/10.0/server, gcc-4.5.2, glibc-2.13-r2, 2.6.38-gentoo x86_64)
=================================================================
System uname: Linux-2.6.38-gentoo-x86_64-AMD_E-350_Processor-with-gentoo-2.0.1
Timestamp of tree: Sun, 20 Mar 2011 20:30:01 +0000
app-shells/bash:     4.2_p8
dev-lang/python:     2.6.6-r2, 2.7.1-r1, 3.1.3-r1
dev-util/cmake:      2.8.4
sys-apps/baselayout: 2.0.1-r1
sys-apps/openrc:     0.7.0
sys-apps/sandbox:    2.4
sys-devel/autoconf:  2.68
sys-devel/automake:  1.10.3, 1.11.1
sys-devel/binutils:  2.21
sys-devel/gcc:       4.4.4-r2, 4.5.2
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.4-r1
sys-devel/make:      3.82
virtual/os-headers:  2.6.36.1 (sys-kernel/linux-headers)
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-mtune=generic -O2 -pipe -mssse3 -msse4a -mmmx -msse -msse2"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"                                                                                                                                                                                               
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-mtune=generic -O2 -pipe -mssse3 -msse4a -mmmx -msse -msse2"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests binpkg-logs distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
FFLAGS=""
GENTOO_MIRRORS="rsync://gentoo.tiscali.nl/gentoo/ http://gentoo.mirrors.easynews.com/linux/gentoo/ ftp://distro.ibiblio.org/pub/linux/distributions/gentoo/ rsync://gentoo.mirrors.tds.net/gentoo rsync://212.219.56.139/www.ibiblio.org/gentoo/ rsync://mirror.leaseweb.com/gentoo/ rsync://mirror.cambrium.nl/gentoo/ http://mirror.cambrium.nl/pub/os/linux/gentoo/ http://ftp.snt.utwente.nl/pub/os/linux/gentoo ftp://91.121.125.139/gentoo-distfiles/"
LANG="de_DE.utf8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
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=""
SYNC="rsync://rsync8.de.gentoo.org/gentoo-portage"
USE="X acl acpi alsa amd64 apm bash-completion berkdb bzip2 cli consolekit cracklib crypt cups cxx dbus device-mapper dri extras fam fortran gdbm gdu gpm graphite iconv jpeg libnotify lzo mmx mmxext modules mudflap multilib ncurses nls nptl nptlonly openmp pam pcre policykit pppd python readline sdl sensord session snmp sse sse2 sse4 sse4a ssl ssse3 startup-notification sysfs tcpd truetype udev unicode xml xorg zlib" ALSA_CARDS="hda-intel" 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 cgi cgid 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" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" PHP_TARGETS="php5-3" QEMU_SOFTMMU_TARGETS="x86_64" QEMU_USER_TARGETS="x86_64" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="radeon r600 r300" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS


UPDATE:

After changing the CFLAGS (see my other thread mentioned above) the situation slightly changed. The script still fails but with no errormessage. It just says script failed, no segfault logged, no errorcode...
And I still can't access the mysql server.
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Back to top
View user's profile Send private message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Thu Mar 24, 2011 7:16 am    Post subject: Reply with quote

Since I can't find any solution I've thrown away the installation and started over again. Let's see how far I can get this time.
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Back to top
View user's profile Send private message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Thu Mar 24, 2011 6:34 pm    Post subject: Reply with quote

Here we go, fresh install, mysql still fails:
Quote:
110324 20:06:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
ERROR: 1004 Can't create file '/tmp/' (errno: 21)
110324 20:06:40 [ERROR] Aborting

110324 20:06:40 [Note] /usr/sbin/mysqld: Shutdown complete

Of course /tmp is there and has proper rights:
Quote:
drwxr-xr-x 12 root root 0 Mar 24 19:03 sys
drwxrwxrwt 4 root root 4096 Mar 24 20:04 tmp
drwxr-xr-x 13 root root 4096 Mar 23 23:45 usr
drwxr-xr-x 12 root root 4096 Mar 24 17:31 var


Anybody any ideas ?
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Back to top
View user's profile Send private message
BVer
n00b
n00b


Joined: 11 Aug 2005
Posts: 7

PostPosted: Thu May 12, 2011 9:10 am    Post subject: Reply with quote

drizzt,

Code:
CFLAGS="-O1 -pipe -march=amdfam10 -mcx16 -mpopcnt -mmmx -msse -msse2 -mssse3 -msse4a"

works for me.

It seems that mysql-5.1.56 does not like the -O2 optimisation level when using gcc 4.4.5 on AMD E-350.
Another packages were compiled with -O2 -- no issues. I have no idea why - and have no time for a deeper investigation.
Hope it helps.
Back to top
View user's profile Send private message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Thu May 19, 2011 6:33 pm    Post subject: Reply with quote

Thanks for the hint, I will try as soon as I can.
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Back to top
View user's profile Send private message
drizzt
Guru
Guru


Joined: 21 Jul 2002
Posts: 428

PostPosted: Mon May 30, 2011 7:11 pm    Post subject: Reply with quote

Thank you very much for this tip. It worked right away.
I added "-mno-3dnow" to your line:

Code:
CFLAGS="-O1 -pipe -march=amdfam10 -mcx16 -mpopcnt -mmmx -msse -msse2 -mssse3 -msse4a -mno-3dnow"


Since Fusion definitely don't support this anymore.

Hopefully one of the devs read this and puts this information into a proper place / or apply proper filter to packages.
_________________
People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Back to top
View user's profile Send private message
hujuice
Guru
Guru


Joined: 16 Oct 2007
Posts: 336
Location: Rome, Italy

PostPosted: Sat Nov 12, 2011 9:24 pm    Post subject: Reply with quote

Setting CFLAGS to -O1 was a solution for me too, compiling and running dev-db/mariadb-5.1.50 on Zacate. :D
CPU:
# cat /proc/cpuinfo|grep "model name"
model name      : AMD E-350 Processor
model name      : AMD E-350 Processor


Also, for people don't knowing/remebering this feature, you can set per-package CFLAGS (or other variables).
Per-package settings:
# echo "CFLAGS=\"-march=amdfam10 -mno-3dnow -O2 -pipe\"" >> /etc/portage/env/O1-CFLAGS.conf
# echo "dev-db/mariadb O1-CFLAGS.conf" >> /etc/portage/package.env


I did so, because I'm running a well working ("headless") machine with
General CFLAGS (make.conf):
CFLAGS="-march=amdfam10 -mno-3dnow -O2 -pipe"

and I don't want to change the setting for the whole system.

I really love the Zacate/MiniITX solution, but it is somewhat pioneer (until the new gcc, I suppose).

Regards,
HUjuice
_________________
Who hasn't a spine, should have a method.
Chi non ha carattere, deve pur avere un metodo.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum