olay tamamen izinlerle alakalı imiş.
chown -R mysql:mysql /d/mysql
olayı bitirdi.!
Teşekkür ederim!
----- Original Message -----
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]
|
- Re: [freebsd] mysql ba?latma hatas?! Mesut GÃœLNAZ
-