[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:4183

From: Seiji Tateyama <Seiji Tateyama <tateyan@xxxxxxxxxx>>
Date: Fri, 17 Aug 2001 12:46:06 +0900
Subject: [mysql 04183] Re: nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re: ¥¢¥«¥¦¥ó¥È´ÉÍý)

¤¿¤Æ¤ä¤ó¤Ã¤¹

Yasuhide OMORI / Â翹ÊÝ±Ñ <omori@xxxxxxxxxx> ¤µ¤ó¤Ï nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re: ¥¢¥«¥¦¥ó¥È´ÉÍý) ¤Ë¤Æ
YO/Âç> On Fri, Aug 17, 2001 at 12:59:58AM +0900,
YO/Âç> tateyan <tateyan@xxxxxxxxxx> wrote:
YO/Âç> > £±¡Ë¡¡nss_mysql.spec ¤Ç¡¡shadow ¤¬¥³¥á¥ó¥È¥¢¥¦¥È¤Ë¤Ê¤Ã¤Æ¤Þ¤¹¤¬
YO/Âç> > ¡¡¡¡¡¡shadow ¥Ñ¥¹¥ï¡¼¥É¤Ï»È¤Ã¤Æ¤¤¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
YO/Âç> 
YO/Âç> shadow ¤òÍ­¸ú¤Ë¤·¤ÆÆ°¤«¤Ê¤«¤Ã¤¿¤Î¤Ç¡¢¤è¤ê¥·¥ó¥×¥ë¤ÊÊý¤¬¤¤¤¤¤Î¤Ç¤Ï¤Ê¤¤
YO/Âç> ¤«¤È»×¤¤¡¢»î¤·¤Ë shadow ¤ò̵¸ú¤Ë¤·¤Æ¤¤¤Þ¤¹¡£
YO/Âç> ¥·¥¹¥Æ¥à¤Î¦¤ÎÀßÄê¤È¤·¤Æ¤Ï¡¢shadow + MD5 password ¤Ç¤¹¡£
¤³¤Î¡¡¥ª¥×¥·¥ç¥ó¤¬¡¡»ØÄꤵ¤ì¤Æ¤Ê¤¯¤Æ¤â
¡¡ --disable-shadow ¤ÈÌÀ¼¨¤µ¤ì¤Æ¤Ê¤±¤ì¤Ð
¥Á¥§¥Ã¥¯¤·¤Æ¡¡¡¡config.h ¤ÎÄêµÁ¤Ç
#define USE_SHADOW 1
¤È¤·¤Á¤ã¤¦¤è¤¦¤Ç¤¹¤Í¡¡¤È¤¤¤¦¤³¤È¤Ç¡¡¤³¤ì¤Ï̵´Ø·¸¤Ç¤·¤¿


YO/Âç> $ egrep '^(passwd|group|shadow):' /etc/nsswitch.conf 
YO/Âç> passwd:     files nisplus nis mysql
YO/Âç> shadow:     files nisplus nis mysql
YO/Âç> group:      files nisplus nis mysql
YO/Âç> 
YO/Âç> ¤È¤¤¤¦ÆâÍƤǡ¢Êѹ¹ÆâÍƤÏ
¤¦¡¼¤à¡¡nisplus  / nis ¤Þ¤Ç¤ª»È¤¤¤Ç¤¹¤«...

YO/Âç> > > ¾åµ­¤Î SQL ʸ¤ò¼Â¹Ô¤·¤¿¾å¤Çǧ¾Ú¤ò»î¤ß¤Þ¤·¤¿¤¬¡¢¤ä¤Ï¤ê¥í¥°¤ò¸«¤ë¸Â¤ê¤Ç
YO/Âç> > > ¤Ï password ¤ò SELECT ¤·¤Æ¤¤¤ëÍͻҤϤʤ¯¡¢/var/log/messages ¤Ç¤Ï
YO/Âç> > > 
YO/Âç> > > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent called
YO/Âç> > > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent: pwent was NULL
YO/Âç> > > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent finished
YO/Âç> > > 
YO/Âç> > > ¤È¤¤¤¦É÷¤Ê¥í¥°¤¬Íî¤Á¤Æ¤¤¤Þ¤·¤¿¡£
YO/Âç> > ¤È¤¤¤¦¤³¤È¤Ï¡¡libnss_mysql¤Ïǧ¼±¤µ¤ì¤Æ¤Þ¤¹¤Î¤Ç
YO/Âç> > ¤¢¤È¤Ï¡¡ËÜÅö¤ËÀßÄê¥Õ¥¡¥¤¥ë¤«¥³¥ó¥Ñ¥¤¥ë¥ª¥×¥·¥ç¥ó¤¬°­¤¤¤À¤±¤È»×¤¤¤Þ¤¹
YO/Âç> 
YO/Âç> »ÅÀÚ¤ê¤Ê¤ª¤·¤¿Êý¤¬Áᤫ¤Ã¤¿¤ê¤¹¤ë¤Î¤«¤Ê¤¡¡Ä?
¤¨¤Ã¤È¡¡¤»¤Ã¤«¤¯¤Î¡¡messages ¤Î¥í¥°¤Ç¤¹¤¬¥Ç¥Ð¥Ã¥¯¥ª¥×¥·¥ç¥ó¤ò»ØÄꤷ¤Æ¤Þ¤¹¤Î¤Ç
¤â¤Ã¤È¾Ü¤·¤¤¾ðÊó¤ò½Ð¤·¤Æ¤¤¤ë¤È¤ª¤â¤¦¤Î¤Ç¤¹¤¬...
auth¥Õ¥¡¥·¥ê¥Æ¥£¤òÀßÄꤷ¤¿¥í¥°¾ðÊó¤Ë¤Ê¤Ë¤«¤â¤Ã¤È½ÐÎϤµ¤ì¤Æ¤Þ¤»¤ó¤«¡©

»ä¤Î¾ì¹ç
/etc/syslog.conf
auth,authpriv.*                 /var/log/auth.log
¤È¤«¤«¤ì¤Æ¤Þ¤¹¤Î¤Ç

auth.log¡¡¤Ë

Aug 17 12:34:52 ns1 libnss_mysql[4921]: read_conf_file called for section groups
Aug 17 12:34:52 ns1 libnss_mysql[4921]: read_conf_file ended for section groups
Aug 17 12:34:52 ns1 libnss_mysql[4921]: select max(group_id) from groups
Aug 17 12:34:52 ns1 libnss_mysql[4921]: setgrent finished
Aug 17 12:34:52 ns1 libnss_mysql[4921]: getgrent entered
Aug 17 12:34:52 ns1 libnss_mysql[4921]: read_conf_file called for section groups
Aug 17 12:34:52 ns1 libnss_mysql[4921]: read_conf_file ended for section groups
Aug 17 12:34:52 ns1 libnss_mysql[4921]: g_fill_struct called
Aug 17 12:34:52 ns1 libnss_mysql[4921]: select group_name from groups where grou
p_id=1 and groups.status = 'A'
Aug 17 12:34:52 ns1 libnss_mysql[4921]: nssmysql gid is 2001
Aug 17 12:34:52 ns1 libnss_mysql[4921]: select user_name from user_group,user wh
ere user_group.user_id=user.user_id and user_group.group_id=1 and user.status =
'A'
Aug 17 12:34:52 ns1 libnss_mysql[4921]: found 2 member(s)
Aug 17 12:34:52 ns1 libnss_mysql[4921]: abcdef is a member of nssmysql(1)
Aug 17 12:34:52 ns1 libnss_mysql[4921]: ghijkl is a member of nssmysql(1)
Aug 17 12:34:52 ns1 libnss_mysql[4921]: getgrent has successfully exited
Aug 17 12:34:52 ns1 libnss_mysql[4921]: getgrent entered
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endgrent called
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endgrent finished
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endgrent called
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endgrent: grent was NULL
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endgrent finished
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endpwent called
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endpwent: pwent was NULL
Aug 17 12:34:52 ns1 libnss_mysql[4921]: endpwent finished

¤È¤¤¤¦¶ñ¹ç¤Ë¡¡½ÐÎϤµ¤ì¤Æ¤Þ¤¹
¥æ¡¼¥¶¤Ï¡¡abcdef / ghijkl ¡Ê²¾Ì¾¡¡¡¡¡Ê¾Ð¡Ë¡Ë¤Î2¤Ä

¤Ê¤Ë¤«¡¡¥Ò¥ó¥È¤Ë¤Ê¤ì¤Ð...

YO/Âç> 
YO/Âç> > ¤Õ¤¦¡¡¥Ç¥£¥¹¥¯¥¯¥é¥Ã¥·¥å¤Ç¡¡¤è¤¦¤ä¤¯¥á¡¼¥ë¤ä¤ê¼è¤ê¤Ç¤­¤ë´Ä¶­¤Ë¤Ê¤Ã¤¿
YO/Âç> 
YO/Âç> ¤ªÈè¤ì¤µ¤Þ¤Ç¤¹¡£
YO/Âç> »ä¤Î¼«Âð¥Þ¥·¥ó¤Ï 7/29 ¤Ë¥×¥é¥¤¥Þ¥ê¥Þ¥¹¥¿¤Î HDD (Win 95 ÍÑ) ¤¬¤ªË´¤¯¤Ê
YO/Âç> ¤ê¤Ë¤Ê¤Ã¤Æ¡¢¤½¤ì°ÊÍèÅŸ»Æþ¤ì¤Æ¤Þ¤»¤ó ^^;;;
¥á¡¼¥ë¤Î¤ä¤ê¼è¤ê¤ò¤·¤Æ¤¤¤ë¥Þ¥·¥ó¤Ç¤·¤¿¤Î¤Ç...
¸Ä¿Í¤Î¤ä¤ê¼è¤ê¥á¡¼¥ë¤¬¾Ã¤¨¤¿¤Î¤¬Äˤ«¤Ã¤¿¤ê¤·¤Þ¤¹¡¡(;_;)

============
  ×Ä×Äк        ¤¿¤Æ¤ä¤ó¤Ã¤¹
 d¢¢/¢¢-£â      <tateyan@xxxxxxxxxx>
 ¡³"¡¼"Ш



[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

      2707 2000-11-17 02:42 [tateyan <tateyan@xxx] ¥¢¥«¥¦¥ó¥È´ÉÍý                          
      2710 2000-11-18 21:12 ¨²[Tatsuo Hiramatsu <ta]                                       
      2711 2000-11-19 00:32 ¨­¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                     
      2712 2000-11-19 00:50 ¨­¨±[inano <inano@xxxxxxx]                                     
      2721 2000-11-19 19:25 ¨­¡¡¨±[Tatsuo Hiramatsu <ta] Ê¡²¬»ÙÉô¡©                        
      2726 2000-11-21 14:29 ¨­¡¡¡¡¨²[Tatsuo Hiramatsu <ta]                                 
      2727 2000-11-21 15:37 ¨­¡¡¡¡¨±[Tatsuo Hiramatsu <ta]                                 
      2730 2000-11-24 11:53 ¨­¡¡¡¡¡¡¨±[Michiaki Mitachi <mi]                               
      2731 2000-11-24 14:14 ¨­¡¡¡¡¡¡¡¡¨±[Tatsuo Hiramatsu <ta]                             
      2732 2000-11-24 20:55 ¨­¡¡¡¡¡¡¡¡¡¡¨±[inano <inano@xxxxxxx]                           
      2734 2000-11-25 19:14 ¨­¡¡¡¡¡¡¡¡¡¡¡¡¨±[Tatsuo Hiramatsu <ta]                         
   @  4168 2001-08-13 20:06 ¨±[Yasuhide OMORI / Âç¿] nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re:  ¥¢¥«¥¦¥ó¥È´ÉÍý)
      4169 2001-08-13 22:40 ¡¡¨±[tateyan <tateyan@xxx]                                     
      4170 2001-08-13 23:04 ¡¡¡¡¨±[tateyan <tateyan@xxx]                                   
      4176 2001-08-16 11:32 ¡¡¡¡¡¡¨±[Yasuhide OMORI / Âç¿]                                 
      4178 2001-08-16 20:17 ¡¡¡¡¡¡¡¡¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                               
      4181 2001-08-17 08:52 ¡¡¡¡¡¡¡¡¨­¨±[Yasuhide OMORI / Âç¿]                             
      4180 2001-08-17 00:59 ¡¡¡¡¡¡¡¡¨±[tateyan <tateyan@xxx]                               
      4182 2001-08-17 09:11 ¡¡¡¡¡¡¡¡¡¡¨±[Yasuhide OMORI / Âç¿]                             
->    4183 2001-08-17 12:46 ¡¡¡¡¡¡¡¡¡¡¡¡¨±[Seiji Tateyama <tate]                           
      4184 2001-08-17 23:04 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tateyan <tateyan@xxx]