8.2 --> 8.3 Mysql *** Error code 74

[koklushkin]

Обновился с 8.2 i386 до 8.3 и решил накатить Mysql

Код: Выделить всё

-felide-constructors -fno-rtti -fno-exceptions'!"  -e 's!@''MYSQLD_USER''@!mysql!'  -e 's!@''sysconfdir''@!/usr/local/etc!'  -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!'  -e 's!@''SHARED_LIB_VERSION''@!16:0:0!'  -e 's!@''MYSQL_BASE_VERSION''@!5.1!'  -e 's!@''MYSQL_NO_DASH_VERSION''@!5.1.66!'  -e 's!@''MYSQL_U_SCORE_VERSION''@!5.1.66!'  -e 's!@''MYSQL_COPYRIGHT_YEAR''@!2012!'  -e 's!@''MYSQL_TCP_PORT''@!3306!'  -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!'  -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!'  -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!'  ndb-config-2-node.ini.sh > ndb-config-2-node.ini-t
/bin/mv ndb-config-2-node.ini-t ndb-config-2-node.ini
/bin/rm -f mysql.spec mysql.spec-t
/usr/bin/sed  -e 's!@''bindir''@!/usr/local/bin!g'  -e 's!@''sbindir''@!/usr/local/sbin!g'  -e 's!@''scriptdir''@!/usr/local/bin!g'  -e 's!@''prefix''@!/usr/local!g'  -e 's!@''datadir''@!/usr/local/share!g'  -e 's!@''localstatedir''@!/var/db/mysql!g'  -e 's!@''libexecdir''@!/usr/local/libexec!g'  -e 's!@''CC''@!cc!' -e 's!@''CXX''@!c++!' -e 's!@''GXX''@!yes!' -e 's!@''PERL''@!/usr/bin/perl!'  -e 's!@''CFLAGS''@!-O2 -pipe  -fPIC -fno-strict-aliasing!' -e 's!@''CXXFLAGS''@!-O2 -pipe -fPIC -fno-strict-aliasing -O2 -pipe  -fPIC -fno-strict-aliasing -felide-constructors -fno-rtti -fno-exceptions!' -e 's!@''LDFLAGS''@!!' -e 's!@''VERSION''@!5.1.66!'  -e 's!@''MYSQL_SERVER_SUFFIX''@!!'  -e 's!@''COMPILATION_COMMENT''@!FreeBSD port: mysql-server-5.1.66!'  -e 's!@''MACHINE_TYPE''@!i386!'  -e 's!@''HOSTNAME''@!/bin/hostname!'  -e 's!@''SYSTEM_TYPE''@!portbld-freebsd8.3!'  -e 's!@''CHECK_PID''@!/bin/kill -0 $PID > /dev/null 2> /dev/null!'  -e 's!@''FIND_PROC''@!/bin/ps p $PID | grep -v " grep" | grep -v mysqld_safe | grep -- "$MYSQLD" > /dev/null!'  -e 's!@''MYSQLD_DEFAULT_SWITCHES''@!!'  -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/mysql.sock!'  -e 's!@''TARGET_LINUX''@!false!'  -e "s!@""CONF_COMMAND""@!./configure  '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--with-libwrap' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-5.1.66' '--enable-thread-safe-client' '--with-plugins=max-no-ndb' '--enable-assembler' '--with-named-thread-libs=-pthread' '--with-embedded-server' '--prefix=/usr/local' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=i386-portbld-freebsd8.3' 'build_alias=i386-portbld-freebsd8.3' 'CC=cc' 'CFLAGS=-O2 -pipe  -fPIC -fno-strict-aliasing' 'LDFLAGS=' 'CPPFLAGS=' 'CPP=cpp' 'CXX=c++' 'CXXFLAGS=-O2 -pipe -fPIC -fno-strict-aliasing -O2 -pipe  -fPIC -fno-strict-aliasing -felide-constructors -fno-rtti -fno-exceptions'!"  -e 's!@''MYSQLD_USER''@!mysql!'  -e 's!@''sysconfdir''@!/usr/local/etc!'  -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!'  -e 's!@''SHARED_LIB_VERSION''@!16:0:0!'  -e 's!@''MYSQL_BASE_VERSION''@!5.1!'  -e 's!@''MYSQL_NO_DASH_VERSION''@!5.1.66!'  -e 's!@''MYSQL_U_SCORE_VERSION''@!5.1.66!'  -e 's!@''MYSQL_COPYRIGHT_YEAR''@!2012!'  -e 's!@''MYSQL_TCP_PORT''@!3306!'  -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!'  -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!'  -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!'  mysql.spec.sh > mysql.spec-t
/bin/mv mysql.spec-t mysql.spec
rm -f mysql-5.1.66.spec
cp mysql.spec mysql-5.1.66.spec
make abi_headers="" do_abi_check
x;  for file in ; do  cc -E -nostdinc -dI -DMYSQL_ABI_CHECK  -I./include  -I./include/mysql  -I./sql  -I./include  -I./include/mysql  -I./sql  $file 2>/dev/null |  /usr/bin/sed -e '/^# /d'  -e '/^[        ]*$/d'  -e '/^#pragma GCC set_debug_pwd/d'  -e '/^#ident/d' >  ./abi_check.out;  /usr/bin/diff -w $file.pp ./abi_check.out;  /bin/rm ./abi_check.out;  done
===>  Installing for mysql-server-5.1.66
===>   Generating temporary packing list
===>  Checking if databases/mysql51-server already installed
===> Creating users and/or groups.
Using existing group `mysql'.
Creating user `mysql' with uid `88'.
pw: user 'mysql' already exists
*** Error code 74

Stop in /usr/ports/databases/mysql51-server.
hp# Creating user `mysql' with uid `88'.
Unmatched '.
hp# pw: user 'mysql' already exists
pw:: Too many arguments.
hp# *** Error code 74
Makefile: Command not found.

C Mysql 5.5 тоже самое, не знаю связано ли это с обновлением. Кто сталкивался ?

[Хостинг HostFood.ru]

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

[skeletor]

сделайте uninstall старого mysql'я и потом install нового.

[ChihPih]

Мож в этом дело

Using existing group `mysql'.
Creating user `mysql' with uid `88'.
pw: user 'mysql' already exists
*** Error code 74

Удалите пользователя и группу mysql, и попробуйте уставноить мускул.

[koklushkin]

Код: Выделить всё

hp# pkg_info
autoconf-2.68       Automatically configure source code on many Un*x platforms
autoconf-wrapper-20101119 Wrapper script for GNU autoconf
cmake-2.8.9         A cross-platform Makefile generator
cmake-modules-2.8.9 Modules and Templates for CMake
curl-7.21.3_2       Non-interactive tool to get files from FTP, GOPHER, HTTP(S)
dnsmasq-2.57_3,1    Lightweight DNS forwarder, DHCP and TFTP server
expat-2.0.1_1       XML 1.0 parser written in C
gamin-0.1.10_4      A file and directory monitoring system
gettext-0.18.1.1    GNU gettext package
gio-fam-backend-2.26.1 FAM backend for GLib's GIO library
glib-2.26.1_1       Some useful routines of C programming (current stable versi
gmake-3.82          GNU version of 'make' utility
help2man-1.40.4     Automatically generating simple manual pages from program o
ldns-1.6.10         A library for programs conforming to DNS RFCs and drafts
libevent-1.4.14b_2  Provides an API to execute callback functions on certain ev
libevent2-2.0.12    API for executing callback functions on events or timeouts
libiconv-1.13.1_1   A character set conversion library
libidn-1.22         Internationalized Domain Names command line tool
libslang2-2.2.3     Routines for rapid alpha-numeric terminal applications deve
libtool-2.4         Generic shared library support script
libxml2-2.7.8_1     XML parser library for GNOME
lzo2-2.05           Portable speedy, lossless data compression library
m4-1.4.16,1         GNU m4
mc-4.7.5            Midnight Commander, a free Norton Commander Clone
nginx-1.0.5         Robust and small WWW server
openvpn-2.2.1       Secure IP/Ethernet tunnel daemon
p5-Locale-gettext-1.05_3 Message handling functions
p5-Text-Iconv-1.7   Perl interface to iconv() codeset conversion function
p5-XML-Parser-2.40  Perl extension interface to James Clark's XML parser, expat
pcre-8.12           Perl Compatible Regular Expressions library
perl-5.10.1_3       Practical Extraction and Report Language
pkg-config-0.25_1   A utility to retrieve information about installed libraries
pkg_tree-1.1_2      Get a 'graphical' tree-overview of installed packages
png-1.4.5           Library for manipulating PNG images
python26-2.6.6      An interpreted object-oriented programming language
rejik-3.2.6         A squid redirector used for blocking unwanted content
ru-freebsd-doc-20110110 Russian translation of the FreeBSD Documentation Project
sqlite3-3.7.7.1     An SQL database engine in a C library
squid-2.7.9_1       HTTP Caching Proxy
tcl-8.5.10          Tool Command Language
tcl-modules-8.5.10  Tcl common modules
transmission-daemon-2.32 A fast and lightweight daemon BitTorrent client
transmission-web-2.32 A fast and lightweight WebUI for Transmission BitTorrent c                                                                             l
unzip-6.0_1         List, test and extract compressed files in a ZIP archive
wget-1.12_4         Retrieve files from the Net via HTTP(S) and FTP

далее make && make install

Код: Выделить всё

-- Installing: /usr/local/man/man1/mysqlbinlog.1
-- Installing: /usr/local/man/man1/mysqlcheck.1
-- Installing: /usr/local/man/man1/mysqldump.1
-- Installing: /usr/local/man/man1/mysqlimport.1
-- Installing: /usr/local/man/man1/mysqlshow.1
-- Installing: /usr/local/man/man1/mysqlslap.1
===>   Compressing manual pages for mysql-client-5.5.28
===>   Running ldconfig
/sbin/ldconfig -m /usr/local/lib/mysql
===>   Installing ldconfig configuration file
===>   Registering installation for mysql-client-5.5.28
===>   Returning to build of mysql-server-5.5.28
===>   Generating temporary packing list
===>  Checking if databases/mysql55-server already installed
===> Creating users and/or groups.
Using existing group `mysql'.
Creating user `mysql' with uid `88'.
pw: user 'mysql' already exists
*** Error code 74

Stop in /usr/ports/databases/mysql55-server.
*** Error code 1

Stop in /usr/ports/databases/mysql55-server.

[ChihPih]

вы пользователя mysql удалили? и на всякий случай порты обновите.

[rayder]

то что у вас не стоит mysql, не означает что в системе нет пользователя/группы mysql.

[koklushkin]

решение http://forums.freebsd.org/showthread.php?t=29765
последние сообщения

[RexaleX]

Код: Выделить всё

pwd_mkdb /etc/master.passwd

чтоб не искали, там уже много чего подописывали