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]