selamlar olay sadece izinlerle alakali degil 1. mysql db olusmamisti. mysql_install_db ile olusturuldu 2. daha sonra olusan mysql db'nin izinleri degistirildi. eh simdi de bir ipucu rica edelim;) kolay gelsin On Wed, Oct 13, 2004 at 10:18:42AM +0300, Mesut G?LNAZ wrote: > olay tamamen izinlerle alakali imis. > chown -R mysql:mysql /d/mysql > olayi bitirdi.! > Tesekk?r ederim! > ----- Original Message ----- > From: Halil Demirezen > To: [EMAIL PROTECTED] > Sent: Wednesday, October 13, 2004 9:31 AM > Subject: Re: [freebsd] mysql ba?latma hatas?! > > > chown -R mysql:mysql mysql/ > > test eder misiniz? > > > > > > On Wed, Oct 13, 2004 at 09:51:09AM +0300, Mesut G?LNAZ wrote: > > ?alistirdim ve db olustu. > > ama bu seferde durum su > > su-2.05b# pwd > > /d/mysql > > su-2.05b# ls -l > > total 20540 > > -rw-rw---- 1 mysql mysql 5242880 Oct 13 09:10 ib_logfile0 > > -rw-rw---- 1 mysql mysql 5242880 Oct 12 16:51 ib_logfile1 > > -rw-rw---- 1 mysql mysql 10485760 Oct 12 16:59 ibdata1 > > drwx------ 2 root mysql 1536 Oct 13 09:05 mysql > > -rw-rw---- 1 mysql mysql 6503 Oct 13 09:10 net.mydomain.com.err > > drwx------ 2 root mysql 512 Oct 13 09:05 test > > su-2.05b# ls -l mysql/ > > total 402 > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 columns_priv.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 columns_priv.MYI > > -rw-rw---- 1 root mysql 8820 Oct 13 09:05 columns_priv.frm > > -rw-rw---- 1 root mysql 866 Oct 13 09:05 db.MYD > > -rw-rw---- 1 root mysql 4096 Oct 13 09:05 db.MYI > > -rw-rw---- 1 root mysql 9178 Oct 13 09:05 db.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 func.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 func.MYI > > -rw-rw---- 1 root mysql 8665 Oct 13 09:05 func.frm > > -rw-rw---- 1 root mysql 868 Oct 13 09:05 help_category.MYD > > -rw-rw---- 1 root mysql 3072 Oct 13 09:05 help_category.MYI > > -rw-rw---- 1 root mysql 8700 Oct 13 09:05 help_category.frm > > -rw-rw---- 1 root mysql 7300 Oct 13 09:05 help_keyword.MYD > > -rw-rw---- 1 root mysql 12288 Oct 13 09:05 help_keyword.MYI > > -rw-rw---- 1 root mysql 8612 Oct 13 09:05 help_keyword.frm > > -rw-rw---- 1 root mysql 5040 Oct 13 09:05 help_relation.MYD > > -rw-rw---- 1 root mysql 9216 Oct 13 09:05 help_relation.MYI > > -rw-rw---- 1 root mysql 8630 Oct 13 09:05 help_relation.frm > > -rw-rw---- 1 root mysql 169424 Oct 13 09:05 help_topic.MYD > > -rw-rw---- 1 root mysql 15360 Oct 13 09:05 help_topic.MYI > > -rw-rw---- 1 root mysql 8770 Oct 13 09:05 help_topic.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 host.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 host.MYI > > -rw-rw---- 1 root mysql 9148 Oct 13 09:05 host.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 tables_priv.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 tables_priv.MYI > > -rw-rw---- 1 root mysql 8925 Oct 13 09:05 tables_priv.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 time_zone.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 time_zone.MYI > > -rw-rw---- 1 root mysql 8636 Oct 13 09:05 time_zone.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 time_zone_leap_second.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 time_zone_leap_second.MYI > > -rw-rw---- 1 root mysql 8624 Oct 13 09:05 time_zone_leap_second.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 time_zone_name.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 time_zone_name.MYI > > -rw-rw---- 1 root mysql 8606 Oct 13 09:05 time_zone_name.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 time_zone_transition.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 time_zone_transition.MYI > > -rw-rw---- 1 root mysql 8686 Oct 13 09:05 time_zone_transition.frm > > -rw-rw---- 1 root mysql 0 Oct 13 09:05 time_zone_transition_type.MYD > > -rw-rw---- 1 root mysql 1024 Oct 13 09:05 time_zone_transition_type.MYI > > -rw-rw---- 1 root mysql 8748 Oct 13 09:05 time_zone_transition_type.frm > > -rw-rw---- 1 root mysql 176 Oct 13 09:05 user.MYD > > -rw-rw---- 1 root mysql 2048 Oct 13 09:05 user.MYI > > -rw-rw---- 1 root mysql 9992 Oct 13 09:05 user.frm > > su-2.05b# /usr/local/etc/rc.d/mysql-server.sh start > > mysqldsu-2.05b# ps ax > > PID TT STAT TIME COMMAND > > 0 ?? DLs 0:00.00 (swapper) > > 1 ?? SLs 0:00.52 /sbin/init -- > > 2 ?? DL 0:00.00 (taskqueue) > > 3 ?? DL 0:01.41 (pagedaemon) > > 4 ?? DL 0:00.00 (vmdaemon) > > 5 ?? DL 0:06.79 (bufdaemon) > > 6 ?? DL 0:06.39 (vnlru) > > 7 ?? DL 9:30.30 (syncer) > > 26 ?? Is 0:00.00 adjkerntz -i > > 71 ?? Is 0:02.28 /usr/sbin/syslogd -s > > 78 ?? Is 0:00.00 /usr/sbin/inetd -wW -C 60 > > 80 ?? Is 0:02.70 /usr/sbin/cron > > 82 ?? Is 0:04.63 /usr/sbin/sshd > > 48437 ?? I 0:00.04 sshd: mes [priv] (sshd) > > 48442 ?? S 0:01.22 sshd: [EMAIL PROTECTED] (sshd) > > 30787 p0 R+ 0:00.00 ps ax > > 48443 p0 Is 0:00.01 -bash (bash) > > 48445 p0 R 0:00.16 su (bash) > > 125 v0 Is 0:00.04 login [pam] (login) > > 271 v0 I+ 0:00.03 -bash (bash) > > 270 v1 Is+ 0:00.00 /usr/libexec/getty Pc ttyv1 > > 127 v2 Is+ 0:00.00 /usr/libexec/getty Pc ttyv2 > > 128 v3 Is+ 0:00.00 /usr/libexec/getty Pc ttyv3 > > 129 v4 Is+ 0:00.00 /usr/libexec/getty Pc ttyv4 > > 130 v5 Is+ 0:00.00 /usr/libexec/getty Pc ttyv5 > > 131 v6 Is+ 0:00.00 /usr/libexec/getty Pc ttyv6 > > 132 v7 Is+ 0:00.00 /usr/libexec/getty Pc ttyv7 > > su-2.05b# tail net.mydomain.com.err > > InnoDB: Restoring possible half-written data pages from the doublewrite > > InnoDB: buffer... > > 041013 9:50:58 InnoDB: Starting log scan based on checkpoint at > > InnoDB: log sequence number 0 43634. > > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > > 041013 9:50:58 InnoDB: Flushing modified pages from the buffer pool... > > 041013 9:50:58 InnoDB: Started; log sequence number 0 43634 > > 041013 9:50:58 [ERROR] Fatal error: Can't open privilege tables: Can't find > file: './mysql/host.frm' (errno: 13) > > 041013 09:50:58 mysqld ended > > su-2.05b# > > > > config ?iktisi ise su sekilde > > su-2.05b# mysql_config > > Usage: /usr/local/bin/mysql_config [OPTIONS] > > Options: > > --cflags [-I/usr/local/include/mysql -O -pipe -D_THREAD_SAFE] > > --include [-I/usr/local/include/mysql] > > --libs [-L/usr/local/lib/mysql -lmysqlclient -lcrypt -lm -lz] > > --libs_r [-L/usr/local/lib/mysql -lmysqlclient_r -pthread > -lcrypt -lm -pthread] > > --socket [/tmp/mysql.sock] > > --port [3306] > > --version [4.1.5-gamma] > > --libmysqld-libs [-L/usr/local/lib/mysql -lmysqld -pthread -lcrypt -lm > -pthread -lwrap -lcrypt -lm -lz] > > su-2.05b# > > > > ------------------gamma nedir? > > ----- Original Message ----- > > From: Ismail YENIGUL > > To: [EMAIL PROTECTED] > > Sent: Wednesday, October 13, 2004 8:37 AM > > Subject: Re: [freebsd] mysql ba?latma hatas?! > > > > > > Merhabalar > > > > mysql veritabani yok. olusturmak icin root olarak > > mysql_install_db > > komutunu calistirmayi deneyin. > > kolay gelsin > > On Wed, Oct 13, 2004 at 08:32:45AM +0300, Mesut G?LNAZ wrote: > > > su-2.05b# ls /var/db/pkg/ | grep mysql > > > mysql-client-4.1.5 > > > mysql-server-4.1.5 > > > > > > bu kurulum bittikten sonraki durum! > > > make clean ile denedim! > > > yine ayni? > > > zaten kurarken make ..... ...... .... ... install clean il ekurmustum... > > > > > > Ilginize tesekk?rler! > > > ----- Original Message ----- > > > From: Ismail YENIGUL > > > To: [EMAIL PROTECTED] > > > Sent: Tuesday, October 12, 2004 5:31 PM > > > Subject: Re: [freebsd] mysql ba?latma hatas?! > > > > > > > > > Merhabalar > > > sorun DB_DIR para kaynaklaniyor. > > > ama sanki mysql kurulumu tam yapilmamis gibi. Eger kurulum tam olsaydi > /db/mysql dizi altinda mysql veritabani olmaliydi. > > > make clean yapip tekrar kurulum yapin derim. > > > mysql'in hangi versiyonunu kuruyorsunuz? > > > kolay gelsin > > > > > > > > > On Tue, Oct 12, 2004 at 05:00:20PM +0300, Mesut G?LNAZ wrote: > > > > mysql i > > > > > > > > #make WITH_CHARSET=latin5 SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes > DB_DIR=/d/mysql install clean > > > > > > > > ile kurdum. > > > > ama ba?lat?nca ?al??m?yor ve ?u hatalar? al?yorum! > > > > > > > > su-2.05b# /usr/local/etc/rc.d/mysql-server.sh start > > > > su-2.05b# tail /d/mysql/net.iem.gov.tr.err > > > > InnoDB: log sequence number 0 36808. > > > > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > > > > 041012 16:59:24 InnoDB: Starting an apply batch of log records to the > database... > > > > InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 > 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 > 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 > 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 > > > > InnoDB: Apply batch completed > > > > 041012 16:59:24 InnoDB: Flushing modified pages from the buffer pool... > > > > 041012 16:59:24 InnoDB: Started; log sequence number 0 43634 > > > > 041012 16:59:24 [ERROR] Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > > > > 041012 16:59:24 mysqld ended > > > > > > > > su-2.05b# date > > > > Tue Oct 12 16:59:35 EEST 2004 > > > > su-2.05b# > > > > 041012 16:51:48 InnoDB: Started; log sequence number 0 0 > > > > 041012 16:51:48 [ERROR] Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > > > > 041012 16:51:48 mysqld ended > > > > > > > > DB_DIR dan desem? > > > > > > > > su-2.05b# ls /var/db/ | grep mysql > > > > su-2.05b# > > > > > > > > izinler ise ?u ?ekilde > > > > > > > > su-2.05b# ls -l /d/mysql/ > > > > total 20532 > > > > -rw-rw---- 1 mysql mysql 5242880 Oct 12 16:59 ib_logfile0 > > > > -rw-rw---- 1 mysql mysql 5242880 Oct 12 16:51 ib_logfile1 > > > > -rw-rw---- 1 mysql mysql 10485760 Oct 12 16:59 ibdata1 > > > > -rw-rw---- 1 mysql mysql 2159 Oct 12 16:59 net.iem.gov.tr.err > > > > su-2.05b# ls -l /d > > > > total 2 > > > > drwxr-xr-x 2 mysql mysql 512 Oct 12 16:59 mysql > > > > su-2.05b# cat /etc/passwd | grep mysql > > > > mysql:*:88:88:MySQL Daemon:/d/mysql:/sbin/nologin > > > > su-2.05b# > > > > > > > > nerede hata yapm???m...? > > > > > > > > Te?ekkr?ler! > > > -- > > > > > > Ismail YENIGUL > > > http://www.acikkod.com - Acikkod Yayinlari > > > http://www.EnderUNIX.org > > > http://ipucu.EnderUNIX.org / http://tips.EnderUNIX.org > > > http://haber.EnderUNIX.org / http://news.EnderUNIX.org > > > GnuPG Key: http://yenigul.net/ismail.gpg > > > > > > Dogru olsam ok gibi yabana atarlar beni. > > > Egri olsam yay gibi elde tutarlar beni... > > > > > > --------------------------------------------------------------------- > > > Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. > > > http://www.acikkod.com/freebsd.php > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > Liste arsivi: http://lists.enderunix.org ve > http://www.mail-archive.com/[EMAIL PROTECTED] > > > > > > > > > > > > > -- > > > > Ismail YENIGUL > > http://www.acikkod.com - Acikkod Yayinlari > > http://www.EnderUNIX.org > > http://ipucu.EnderUNIX.org / http://tips.EnderUNIX.org > > http://haber.EnderUNIX.org / http://news.EnderUNIX.org > > GnuPG Key: http://yenigul.net/ismail.gpg > > > > Dogru olsam ok gibi yabana atarlar beni. > > Egri olsam yay gibi elde tutarlar beni... > > > > --------------------------------------------------------------------- > > Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. > > http://www.acikkod.com/freebsd.php > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > Liste arsivi: http://lists.enderunix.org ve http://www.mail-archive.com/[EMAIL > PROTECTED] > > > > > > > > --------------------------------------------------------------------- > Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. > http://www.acikkod.com/freebsd.php > > To unsubscribe, e-mail: [EMAIL PROTECTED] > Liste arsivi: http://lists.enderunix.org ve http://www.mail-archive.com/[EMAIL > PROTECTED] > > >
-- Ismail YENIGUL http://www.acikkod.com - Acikkod Yayinlari http://www.EnderUNIX.org http://ipucu.EnderUNIX.org / http://tips.EnderUNIX.org http://haber.EnderUNIX.org / http://news.EnderUNIX.org GnuPG Key: http://yenigul.net/ismail.gpg Dogru olsam ok gibi yabana atarlar beni. Egri olsam yay gibi elde tutarlar beni... --------------------------------------------------------------------- Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. http://www.acikkod.com/freebsd.php To unsubscribe, e-mail: [EMAIL PROTECTED] Liste arsivi: http://lists.enderunix.org ve http://www.mail-archive.com/[EMAIL PROTECTED]