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

mysql:4181

From: Yasuhide OMORI / Â翹ÊÝ±Ñ <Yasuhide OMORI / Â翹ÊÝ±Ñ <omori@xxxxxxxxxx>>
Date: Fri, 17 Aug 2001 08:52:44 +0900
Subject: [mysql 04181] Re: nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re: ¥¢¥«¥¦¥ó¥È´ÉÍý)

On Thu, Aug 16, 2001 at 08:17:06PM +0900,
¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tommy@xxxxxxxxxx> wrote:
> > ¾åµ­¤Î SQL ʸ¤ò¼Â¹Ô¤·¤¿¾å¤Çǧ¾Ú¤ò»î¤ß¤Þ¤·¤¿¤¬¡¢¤ä¤Ï¤ê¥í¥°¤ò¸«¤ë¸Â¤ê¤Ç
> > ¤Ï password ¤ò SELECT ¤·¤Æ¤¤¤ëÍͻҤϤʤ¯¡¢/var/log/messages ¤Ç¤Ï
> > 
> > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent called
> > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent: pwent was NULL
> > Aug 16 11:25:19 vine libnss_mysql[2307]: endpwent finished
> > 
> > ¤È¤¤¤¦É÷¤Ê¥í¥°¤¬Íî¤Á¤Æ¤¤¤Þ¤·¤¿¡£
> 
> MySQL ¤Î¥í¥°¤Ë½ÐÎϤµ¤ì¤Æ¤¤¤ë SELECT ʸ¤ò¡¢mysql ¥³¥Þ¥ó¥É¤«¤é¤½¤Î¤Þ¤Þ
> ¼Â¹Ô¤·¤Æ¤ß¤Æ¡¢½ÐÎÏ·ë²Ì¤ò¸«¤Æ¤ß¤ë¤È¤«¡Ä¡£
> 
> # ñ¤Ë SELECT ¤Ç²¿¤â°ú¤Ã³Ý¤«¤Ã¤Æ¤Ê¤¤¤Ã¤Æ¤³¤È¤Ï¤Ê¤¤¤Ã¤¹¤«¤Í¡Ä¡£

SELECT ¤Ç¤Ï¤­¤Á¤ó¤È¹Ô¤¬¼è¤ê½Ð¤»¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¡£/var/log/mysql.log ¤Ë

010817  8:50:27      58 Connect     nss@localhost on nss_mysql
                     58 Init DB     nss_mysql
                     58 Query       select user_name,uid,uid,realname,shell,home
dir from user where user_name='hoho' and uid is not null and user.status = 'A'
                     58 Quit       

¤ÈÍ­¤Ã¤¿¤Î¤Ç¡¢mysql ¥³¥Þ¥ó¥É¤Ç»î¤·¤¿¤È¤³¤í

mysql> select user_name,uid,uid,realname,shell,homedir from user where user_name='hoho' and uid is not null and user.status = 'A';
+-----------+------+------+-----------+-----------+-----------+
| user_name | uid  | uid  | realname  | shell     | homedir   |
+-----------+------+------+-----------+-----------+-----------+
| hoho      | 1000 | 1000 | hoho hoho | /bin/bash | /dev/null |
+-----------+------+------+-----------+-----------+-----------+
1 row in set (0.00 sec)

¤È½Ð¤Þ¤·¤¿¡£¤Ê¤ª¡¢

[omori@vine omori]$ grep 1000 /etc/passwd
[omori@vine omori]$ grep 1000 /etc/group

¤¤¤Å¤ì¤â¥Þ¥Ã¥Á¤¹¤ë¹Ô¤Ï¤¢¤ê¤Þ¤»¤ó¡£
-- 
Yasuhide OMORI / Â翹ÊݱÑ

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

      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]