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

£±¡Ë¡¡nss_mysql.spec ¤Ç¡¡shadow ¤¬¥³¥á¥ó¥È¥¢¥¦¥È¤Ë¤Ê¤Ã¤Æ¤Þ¤¹¤¬
¡¡¡¡¡¡shadow ¥Ñ¥¹¥ï¡¼¥É¤Ï»È¤Ã¤Æ¤¤¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
¡¡¡¡¡¡

£²¡Ë¥æ¡¼¥¶hoho ¤ËÆþ¤ì¤Æ¤ë¥Ñ¥¹¥ï¡¼¥É¤ÏÀ¸¥Ñ¥¹¥ï¡¼¥É¤Ç¤Ï¤Ê¤¤¤Ç¤¹¤è¤Í¡©
¡¡¡¡¤³¤³¤ËÆþ¤ì¤ë¤Ù¤­¥Ñ¥¹¥ï¡¼¥É¤Ï crypt¥¨¥ó¥³¡¼¥É¤µ¤ì¤¿¤â¤Î¤«
¡¡¡¡¤¢¤ë¤¤¤ÏMD5¤Ç¥¨¥ó¥³¡¼¥É¤µ¤ì¤¿¥Ñ¥¹¥ï¡¼¥É¤¬É¬ÍפǤ¹

¡¡¡¡¡¡À¸¤Ç¤¢¤ì¤Ð encrypt('hoppfcCGi9P8I') ¤È½ñ¤¯¤³¤È¤â¤Ç¤­¤Þ¤¹
¡¡¡¡¡¡salt¤ò»ØÄꤹ¤ë¤Ê¤é¤Ð¡¡encrypt('hoppfcCGi9P8I','xx')
       salt ¤Ï°Å¹æ²½¤Î¤¿¤á¤Î¼ï¡¡xx ¤ÏǤ°Õ¤Î£²Ê¸»ú
¡¡¡¡¡¡¡¡¡Ê¤·¤Ã¤Æ¤Þ¤¹¤è¤ÍÇ°¤Î¤¿¤á¡Ë
¡¡¡¡¡¡¡ôgrant ¤Ç½ñ¤¯¥Ñ¥¹¥ï¡¼¥É¤ÏÀ¸¤Ç¤¹¤¬¡¢¤³¤ÎÉôʬ¤Ï°ã¤¤¤Þ¤¹¤Î¤Ç
¡¡¡¡¡¡¡ôº®Æ±¤·¤Ê¤¤¤è¤¦¤Ë¤Í¤§

¤³¤ÎÊÕ¤Înss_ ¤Ë´Ö¤¹¤ë¾ðÊó¤È¤·¤Æ¤Ï¤¢¤È¤Ï
/etc/nsswitch.conf ¤¬¤É¤¦ÀßÄꤷ¤Æ¤¤¤ë¤«
¤È¤¤¤¦¤Î¤â¾ðÊó¤È¤·¤Æ¤ÏɬÍפǤ¹

°ÊÁ°½ñ¤¤¤¿¤â¤Î¤Ç¤Ï
passwd:         files mysql
group:          files mysql
shadow:         files mysql

¤Ç¤¹¤¬¡¡¤¿¤¤¤Æ¤¤¤Ïcompat¤Ä¤«¤Ã¤Æ¤¿¤ê¤·¤Þ¤¹¤Î¤Ç
passwd:         compat mysql
group:          compat mysql
shadow:         compat mysql

¤Ç¤â²Ä¤Ç¤·¤¿



¿ʬ¡¡¤É¤Ã¤«°ì²Õ½ê¤À¤±°ã¤Ã¤Æ¤ë¤³¤È¤Ç¤¦¤Þ¤¯Æ°¤«¤Ê¤¤¾õ¶·¤È»×¤¤¤Þ¤¹
¤ï¤«¤Ã¤¿¤é¡¡¤Ê¤ó¤À¤¡¡¡¡¡¤Ã¤Æ´¶¤¸¤À¤È»×¤¦¤Ç¤¹

Yasuhide OMORI / Â翹ÊݱѤµ¤ó¤Î
Âê̾¡Ö[mysql 04176] Re: nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re: ¥¢¥«¥¦¥ó¥È´ÉÍý)¡×¤Î¥á¡¼¥ë¤«¤é¤Î°úÍѤǤ¹
> Â翹ÊݱѤǤ¹¡£

> 
> ¾åµ­¤Î 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
> 
> ¤È¤¤¤¦É÷¤Ê¥í¥°¤¬Íî¤Á¤Æ¤¤¤Þ¤·¤¿¡£
¤È¤¤¤¦¤³¤È¤Ï¡¡libnss_mysql¤Ïǧ¼±¤µ¤ì¤Æ¤Þ¤¹¤Î¤Ç
¤¢¤È¤Ï¡¡ËÜÅö¤ËÀßÄê¥Õ¥¡¥¤¥ë¤«¥³¥ó¥Ñ¥¤¥ë¥ª¥×¥·¥ç¥ó¤¬°­¤¤¤À¤±¤È»×¤¤¤Þ¤¹

> MySQL-3.23.37
> glibc-2.1.3
> linux-2.2.18
> (Vine-2.1.5 + updates)
> 
> ¤È¤¤¤¦´Ä¶­¤Ê¤Î¤Ç¤¹¤¬¡Ä°ìÂΤɤ³¤ËÌäÂ꤬¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«?
> 
> ¥½¡¼¥¹¤ò¤Á¤ç¤Ã¤ÈÆɤó¤Ç¤ß¤¿¤Î¤Ç¤¹¤¬¡¢_nss_mysql_endpwent ¤Î¸Æ½Ð¸µ¤¬²¿¤Ê
> ¤Î¤«¡¢¤µ¤Ã¤Ñ¤êʬ¤«¤é¤ººÃÀÞ¤·¤Þ¤·¤¿ (;_;)
¤¨¤Ã¤È¡¡¤³¤ÎÊդϤ⤦¡¡man nsswitch.conf ¤«¤é¤¿¤É¤Ã¤¿¤ê¤·¤Ê¤±¤ì¤Ð...
¤·¤Þ¤¤¤Ë¤Ï¡¡pam ¤â¤«¤«¤ï¤Ã¤Æ¤­¤Æ...
Æͤùþ¤Þ¤ì¤ë¤È»ä¤â¤ª¼ê¾å¤²¤Ç¤¹
=================
  ×Ä×Äк        ¤¿¤Æ¤ä¤ó¤Ã¤¹
 d¢¢/¢¢-£â      <tateyan@xxxxxxxxxx>
 ¡³"¡¼"Ш

¤Õ¤¦¡¡¥Ç¥£¥¹¥¯¥¯¥é¥Ã¥·¥å¤Ç¡¡¤è¤¦¤ä¤¯¥á¡¼¥ë¤ä¤ê¼è¤ê¤Ç¤­¤ë´Ä¶­¤Ë¤Ê¤Ã¤¿