[gnu-sol-discuss] mysql errors and trying to install
Chris Lemire
good_bye300 at yahoo.com
Sun Oct 8 15:02:43 PDT 2006
Hello - I think I really messed up my Solaris 10 x86
system. Is there any chance in fixing it? The first
command with the first package was downloaded from
Sun. I do not have the output of the first group of
commands, but I showed what commands I entered. "su -
mysql" did not work because I did not have a mysql
user, so I started to follow the directions from
another website to get a mysql user, but later
realized the other website was for using the mysql
already installed in Solaris 10. I messed it up, but
what can I do to fix it? I am trying to learn.
# bzip2 -d CSQamp.pkg.bz2
# pkgadd -d ./CSQamp.pkg
# mkdir /usr/local/mysql32_bit/var
# chown -R mysql:mysql /usr/local/mysql32_bit
# su - mysql
# /usr/local/mysql32_bit/bin/mysql_install_db
SOME OUTPUT FROM THE LAST COMMAND
/usr/local/share/man/man3/iconv.3
/usr/local/share/man/man3/iconv_close.3
/usr/local/share/man/man3/iconv_open.3
[ verifying class <none> ]
## Executing postinstall script.
Installation of <CSQamp> was successful.
-bash-3.00# ls /usr/local/
Copyright.libxml2 include mysql_32bit
apache2 lib php5
bin man share
-bash-3.00# mkdir /usr/local/mysql_32bit/var
-bash-3.00# chown -R mysql:mysql
/usr/local/mysql_32bit
chown: unknown group id mysql
-bash-3.00# su - mysql
su: Unknown id: mysql
-bash-3.00# groupadd mysql
-bash-3.00# useradd -g mysql mysql
-bash-3.00# /usr/local/mysql_32bit/bin/my
my_print_defaults mysql_waitpid
myisam_ftdump mysql_zap
myisamchk mysqlaccess
myisamlog mysqladmin
myisampack mysqlbinlog
mysql mysqlbug
mysql_client_test mysqlcheck
mysql_config mysqld
mysql_convert_table_format mysqld_multi
mysql_create_system_tables mysqld_safe
mysql_explain_log mysqldump
mysql_find_rows mysqldumpslow
mysql_fix_extensions mysqlhotcopy
mysql_fix_privilege_tables mysqlimport
mysql_install_db mysqlshow
mysql_secure_installation mysqltest
mysql_setpermission mysqltestmanager
mysql_tableinfo mysqltestmanager-pwgen
mysql_tzinfo_to_sql mysqltestmanagerc
mysql_upgrade
-bash-3.00#
/usr/local/mysql_32bit/bin/mysql_install_db
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy
support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root
USER !
To do so, start the server, then issue the following
commands:
/usr/local/mysql_32bit/bin/mysqladmin -u root password
'new-password'
/usr/local/mysql_32bit/bin/mysqladmin -u root -h
solaris password 'new-password'See the manual for more
instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql_32bit ;
/usr/local/mysql_32bit/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in
the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the
/usr/local/mysql_32bit/bin/mysqlbug script!
The latest information about MySQL is available on the
web at
http://www.mysql.com
Support MySQL by buying support/licenses at
http://shop.mysql.com
-bash-3.00# chgrp -R mysql /var/mysql
-bash-3.00# chmod -R 770 /var/mysql
-bash-3.00# su - mysql
su: No directory!
-bash-3.00# logout
-bash-3.00$ su - mysql
Password:
su: Sorry
-bash-3.00$ su - mysql
Password:
su: Sorry
-bash-3.00$ su -
Password:
Sun Microsystems Inc. SunOS 5.10 Generic
January 2005
You have mail.
-bash-3.00# passwd mysql
New Password:
Re-enter new Password:
passwd: password successfully changed for mysql
-bash-3.00# logout
-bash-3.00$ su - mysql
Password:
su: No directory!
-bash-3.00$ su -
Password:
Sun Microsystems Inc. SunOS 5.10 Generic
January 2005
You have mail.
-bash-3.00# installf SUNWmysqlr /var/mysql d 770 root
mysql
-bash-3.00# cp /usr/sfw/share/mysql/my-medium.cnf
/var/mysql/my.cnf
-bash-3.00# /usr/sfw/sbin/mysqld_safe --user=mysql &
[1] 10469
-bash-3.00# Starting mysqld daemon with databases from
/var/mysql
STOPPING server from pid file /var/mysql/solaris.pid
061008 16:13:38 mysqld ended
[1]+ Done
/usr/sfw/sbin/mysqld_safe --user=mysql
-bash-3.00# /usr/sfw/sbin/mysqld_safe --user=mysql &
[1] 10496
-bash-3.00# Starting mysqld daemon with databases from
/var/mysql
STOPPING server from pid file /var/mysql/solaris.pid
061008 16:14:06 mysqld ended
[1]+ Done
/usr/sfw/sbin/mysqld_safe --user=mysql
-bash-3.00# cd /usr/sfw/bin
-bash-3.00# ./mysqladmin -u root password 'mypassword
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/tmp/mysql.sock' exists!
-bash-3.00# svcadm disable mysql
svcadm: Pattern 'mysql' doesn't match any instances
-bash-3.00# ps -ef | grep my
-bash-3.00# ps -ef | grep -i sql
root 10534 10463 0 16:15:59 pts/3 0:00
grep -i sql
-bash-3.00# cd /usr/sfw/bin
-bash-3.00#
/usr/local/mysql_32bit/share/mysql/mysql.server stop
ERROR! MySQL manager or server PID file could not be
found!
-bash-3.00# ./mysqladmin -u root password 'mypassword
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/tmp/mysql.sock' exists!
-bash-3.00# ps -ef | grep my
-bash-3.00# jobs
-bash-3.00# ps -ef
UID PID PPID C STIME TTY TIME CMD
root 0 0 0 Sep 16 ? 0:49
sched
root 1 0 0 Sep 16 ? 0:44
/sbin/init
root 2 0 0 Sep 16 ? 0:00
pageout
root 3 0 1 Sep 16 ? 106:19
fsflush
root 275 7 0 Sep 16 console 0:00
/usr/lib/saf/ttymon -g -d /dev/console -l console -T
sun-color -m ldterm,ttcomp
root 7 1 0 Sep 16 ? 0:55
/lib/svc/bin/svc.startd
root 9 1 0 Sep 16 ? 1:20
/lib/svc/bin/svc.configd
daemon 240 1 0 Sep 16 ? 0:00
/usr/lib/nfs/lockd
root 267 264 0 Sep 16 ? 0:01
/usr/lib/saf/ttymon
root 261 1 0 Sep 16 ? 0:51
/usr/lib/inet/inetd start
root 348 1 0 Sep 16 ? 0:18
/usr/lib/autofs/automountd
root 85 1 0 Sep 16 ? 2:36
/usr/sbin/nscd
root 263 1 0 Sep 16 ? 0:00
/usr/sbin/cron
root 51 1 0 Sep 16 ? 0:00
/sbin/dhcpagent
daemon 237 1 0 Sep 16 ? 0:00
/usr/lib/nfs/statd
daemon 98 1 0 Sep 16 ? 0:13
/usr/lib/crypto/kcfd
root 264 7 0 Sep 16 ? 0:01
/usr/lib/saf/sac -t 300
root 274 1 0 Sep 16 ? 0:07
/usr/lib/utmpd
lp 408 407 0 Sep 16 ? 0:00
/usr/apache/bin/httpd -f
/etc/apache/httpd-standalone-ipp.conf
root 9127 1 0 Oct 05 ? 0:00
/usr/lib/ssh/sshd
root 407 1 0 Sep 16 ? 2:33
/usr/apache/bin/httpd -f
/etc/apache/httpd-standalone-ipp.conf
daemon 233 1 0 Sep 16 ? 0:00
/usr/sbin/rpcbind
root 97 1 0 Sep 16 ? 0:00
/usr/lib/picl/picld
root 389 1 0 Sep 16 ? 0:00
/usr/lib/lp/local/lpsched
root 104 1 0 Sep 16 ? 0:00
/usr/lib/power/powerd
root 565 484 0 Sep 16 ? 0:00
/usr/dt/bin/dtlogin -daemon
root 106 1 0 Sep 16 ? 0:00
/usr/lib/sysevent/syseventd
root 359 1 0 Sep 16 ? 0:04
/usr/sbin/syslogd
smmsp 7958 1 0 Oct 01 ? 0:02
/usr/lib/sendmail -Ac -q15m
root 429 1 0 Sep 16 ? 0:00
/usr/sbin/vold -f /etc/vold.conf
root 442 1 0 Sep 16 ? 0:00
devfsadmd
nobody 620 261 0 Sep 16 ? 0:02
/usr/openwin/bin/xfs
root 386 1 0 Sep 16 ? 0:50
/usr/lib/fm/fmd/fmd
webservd 19899 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 533 1 0 Sep 16 ? 0:00
/usr/lib/dmi/snmpXdmid -s solaris
root 597 596 0 - ? 0:00
<defunct>
root 596 565 0 Sep 16 ? 15:38
dtgreet -display :0
root 17767 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metamedd
root 529 1 0 Sep 16 ? 0:00
/usr/lib/dmi/dmispd
root 17763 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.mdcommd
root 484 1 0 Sep 16 ? 0:00
/usr/dt/bin/dtlogin -daemon
root 497 484 0 Sep 16 ? 22:22
/usr/X11/bin/Xorg :0 -depth 24 -nobanner -auth
/var/dt/A:0-udaG8a
root 492 484 0 Sep 16 ?? 0:00
/usr/openwin/bin/fbconsole -n -d :0
root 522 1 0 Sep 16 ? 0:01
/usr/lib/snmp/snmpdx -y -c /etc/snmp/conf
root 559 1 0 Sep 16 ? 0:25
/usr/sfw/sbin/snmpd
root 9153 1 0 Oct 05 ? 0:20
tail -f /var/apache2/logs/access_log
chris 10139 10136 0 13:31:23 ? 0:03
/usr/lib/ssh/sshd
root 10549 10463 0 16:19:58 pts/3 0:00 ps
-ef
root 17769 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metamhd
root 10463 10141 0 16:10:16 pts/3 0:00
-bash
root 7960 1 0 Oct 01 ? 0:31
/usr/lib/sendmail -bd -q15m
webservd 19903 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 10136 9127 0 13:31:17 ? 0:00
/usr/lib/ssh/sshd
webservd 20168 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 20349 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
root 17762 261 0 Sep 19 ? 0:03
/usr/lib/netsvc/rusers/rpc.rusersd
root 15339 261 0 Sep 17 ? 0:00
/usr/dt/bin/rpc.ttdbserverd
chris 10141 10139 0 13:31:23 pts/3 0:00
-bash
root 15382 1 0 Sep 17 ? 66:10
/usr/java/bin/java
-Dviper.fifo.path=/var/run/smc898/boot.fifo -Xmx128m
-Dsun.s
webservd 19900 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 17793 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metad
root 18222 1 0 Sep 19 ? 2:22
/usr/apache2/bin/httpd -k start
webservd 20353 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 19898 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
webservd 19904 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
webservd 19897 18222 0 Sep 22 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 20352 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
-bash-3.00# ./mysqladmin -u root password 'mypassword
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/tmp/mysql.sock' exists!
-bash-3.00# ps -ef
UID PID PPID C STIME TTY TIME CMD
root 0 0 0 Sep 16 ? 0:49
sched
root 1 0 0 Sep 16 ? 0:44
/sbin/init
root 2 0 0 Sep 16 ? 0:00
pageout
root 3 0 1 Sep 16 ? 106:20
fsflush
root 275 7 0 Sep 16 console 0:00
/usr/lib/saf/ttymon -g -d /dev/console -l console -T
sun-color -m ldterm,ttcomp
root 7 1 0 Sep 16 ? 0:55
/lib/svc/bin/svc.startd
root 9 1 0 Sep 16 ? 1:20
/lib/svc/bin/svc.configd
daemon 240 1 0 Sep 16 ? 0:00
/usr/lib/nfs/lockd
root 267 264 0 Sep 16 ? 0:01
/usr/lib/saf/ttymon
root 261 1 0 Sep 16 ? 0:51
/usr/lib/inet/inetd start
root 348 1 0 Sep 16 ? 0:18
/usr/lib/autofs/automountd
root 85 1 0 Sep 16 ? 2:36
/usr/sbin/nscd
root 263 1 0 Sep 16 ? 0:00
/usr/sbin/cron
root 51 1 0 Sep 16 ? 0:00
/sbin/dhcpagent
daemon 237 1 0 Sep 16 ? 0:00
/usr/lib/nfs/statd
daemon 98 1 0 Sep 16 ? 0:13
/usr/lib/crypto/kcfd
root 264 7 0 Sep 16 ? 0:01
/usr/lib/saf/sac -t 300
root 274 1 0 Sep 16 ? 0:07
/usr/lib/utmpd
lp 408 407 0 Sep 16 ? 0:00
/usr/apache/bin/httpd -f
/etc/apache/httpd-standalone-ipp.conf
root 9127 1 0 Oct 05 ? 0:00
/usr/lib/ssh/sshd
root 407 1 0 Sep 16 ? 2:33
/usr/apache/bin/httpd -f
/etc/apache/httpd-standalone-ipp.conf
daemon 233 1 0 Sep 16 ? 0:00
/usr/sbin/rpcbind
root 97 1 0 Sep 16 ? 0:00
/usr/lib/picl/picld
root 389 1 0 Sep 16 ? 0:00
/usr/lib/lp/local/lpsched
root 104 1 0 Sep 16 ? 0:00
/usr/lib/power/powerd
root 565 484 0 Sep 16 ? 0:00
/usr/dt/bin/dtlogin -daemon
root 106 1 0 Sep 16 ? 0:00
/usr/lib/sysevent/syseventd
root 359 1 0 Sep 16 ? 0:04
/usr/sbin/syslogd
smmsp 7958 1 0 Oct 01 ? 0:02
/usr/lib/sendmail -Ac -q15m
root 429 1 0 Sep 16 ? 0:00
/usr/sbin/vold -f /etc/vold.conf
root 442 1 0 Sep 16 ? 0:00
devfsadmd
nobody 620 261 0 Sep 16 ? 0:02
/usr/openwin/bin/xfs
root 386 1 0 Sep 16 ? 0:50
/usr/lib/fm/fmd/fmd
webservd 19899 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 533 1 0 Sep 16 ? 0:00
/usr/lib/dmi/snmpXdmid -s solaris
root 597 596 0 - ? 0:00
<defunct>
root 596 565 0 Sep 16 ? 15:38
dtgreet -display :0
root 17767 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metamedd
root 529 1 0 Sep 16 ? 0:00
/usr/lib/dmi/dmispd
root 17763 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.mdcommd
root 484 1 0 Sep 16 ? 0:00
/usr/dt/bin/dtlogin -daemon
root 497 484 0 Sep 16 ? 22:22
/usr/X11/bin/Xorg :0 -depth 24 -nobanner -auth
/var/dt/A:0-udaG8a
root 492 484 0 Sep 16 ?? 0:00
/usr/openwin/bin/fbconsole -n -d :0
root 522 1 0 Sep 16 ? 0:01
/usr/lib/snmp/snmpdx -y -c /etc/snmp/conf
root 559 1 0 Sep 16 ? 0:25
/usr/sfw/sbin/snmpd
root 9153 1 0 Oct 05 ? 0:20
tail -f /var/apache2/logs/access_log
chris 10139 10136 0 13:31:23 ? 0:03
/usr/lib/ssh/sshd
root 10551 10463 0 16:21:17 pts/3 0:00 ps
-ef
root 17769 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metamhd
root 10463 10141 0 16:10:16 pts/3 0:00
-bash
root 7960 1 0 Oct 01 ? 0:31
/usr/lib/sendmail -bd -q15m
webservd 19903 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 10136 9127 0 13:31:17 ? 0:00
/usr/lib/ssh/sshd
webservd 20168 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 20349 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
root 17762 261 0 Sep 19 ? 0:03
/usr/lib/netsvc/rusers/rpc.rusersd
root 15339 261 0 Sep 17 ? 0:00
/usr/dt/bin/rpc.ttdbserverd
chris 10141 10139 0 13:31:23 pts/3 0:00
-bash
root 15382 1 0 Sep 17 ? 66:10
/usr/java/bin/java
-Dviper.fifo.path=/var/run/smc898/boot.fifo -Xmx128m
-Dsun.s
webservd 19900 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
root 17793 261 0 Sep 19 ? 0:00
/usr/sbin/rpc.metad
root 18222 1 0 Sep 19 ? 2:22
/usr/apache2/bin/httpd -k start
webservd 20353 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 19898 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
webservd 19904 18222 0 Sep 23 ? 0:02
/usr/apache2/bin/httpd -k start
webservd 19897 18222 0 Sep 22 ? 0:01
/usr/apache2/bin/httpd -k start
webservd 20352 18222 0 Sep 24 ? 0:01
/usr/apache2/bin/httpd -k start
-bash-3.00#
-bash-3.00#
-bash-3.00#
-bash-3.00#
-bash-3.00#
-bash-3.00#
-bash-3.00#
-bash-3.00# ./mysqladmin -u root password 'mypassword'
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/tmp/mysql.sock' exists!
-bash-3.00# ps -ef | grep my
-bash-3.00#
/usr/local/mysql_32bit/share/mysql/mysql.server
Usage: /usr/local/mysql_32bit/share/mysql/mysql.server
start|stop|restart|reload-bash-3.00#
/usr/local/mysql_32bit/share/mysql/mysql.server reload
ERROR! MySQL PID file could not be found!
-bash-3.00#
/usr/local/mysql_32bit/share/mysql/mysql.server start
Starting MySQL
................................... ERROR!
-bash-3.00# cd /usr/local/mysql_32bit ;
/usr/local/mysql_32bit/bin/mysqld_safe &[1] 10680
-bash-3.00# Starting mysqld daemon with databases from
/usr/local/mysql_32bit/data
STOPPING server from pid file
/usr/local/mysql_32bit/data/solaris.pid
061008 16:57:58 mysqld ended
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
More information about the gnu-sol-discuss
mailing list