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 _______________________________________________ opensolaris-discuss mailing list opensolaris-discuss@opensolaris.org