tabiki hemen ekliyorum!
:-DD
----- Original Message -----
Sent: Wednesday, October 13, 2004 12:09
PM
Subject: Re: [freebsd] mysql ba?latma
hatas?!
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]
|