mysql:4182

On Fri, Aug 17, 2001 at 12:59:58AM +0900,
tateyan <tateyan@xxxxxxxxxx> wrote:
> ㄠ﹌﹛nss_mysql.spec 匹﹛shadow 互戊丟件玄失它玄卞卅勻化引允互
> ﹛﹛﹛shadow 由旦伐□玉反銀勻化中卅中及匹仄斤丹井〝

shadow 毛肣躲卞仄化⑹井卅井勻凶及匹﹜方曰扑件皿伙卅杅互中中及匹反卅中
井午閤中﹜魂仄卞 shadow 毛拑躲卞仄化中引允﹝
扑旦氾丞及礎及澀爛午仄化反﹜shadow + MD5 password 匹允﹝

> ㄡ﹌交□扒hoho 卞じ木化月由旦伐□玉反戲由旦伐□玉匹反卅中匹允方友〝
> ﹛﹛仇仇卞じ木月屯五由旦伐□玉反 crypt巨件戊□玉今木凶手及井
> ﹛﹛丐月中反MD5匹巨件戊□玉今木凶由旦伐□玉互优邰匹允
> 
> ﹛﹛﹛戲匹丐木壬 encrypt('hoppfcCGi9P8I') 午踏仁仇午手匹五引允
> ﹛﹛﹛salt毛隙爛允月卅日壬﹛encrypt('hoppfcCGi9P8I','xx')
>        salt 反剪寞祭及凶戶及潘﹛xx 反エ啦及ㄡ妐儂
> ﹛﹛﹛﹛﹋仄勻化引允方友ゴ及凶戶﹌
> ﹛﹛﹛↑grant 匹踏仁由旦伐□玉反戲匹允互﹜仇及朿坌反啜中引允及匹
> ﹛﹛﹛↑漁⑺仄卅中方丹卞友之

encrypt 楮醒反襞曰引六氏匹仄凶﹝丐曰互午丹仍介中引允﹝

$ perl -e "print crypt('password','XX')"

午井中丹氘卞撢墊仄化 password 巨件玄伉毛綜嶽仄化引仄凶﹝

> 仇及彶及nss_ 卞棉允月樹扷午仄化反丐午反
> /etc/nsswitch.conf 互升丹澀爛仄化中月井
> 午中丹及手樹扷午仄化反优邰匹允
> 
> 動蟆踏中凶手及匹反
> passwd:         files mysql
> group:          files mysql
> shadow:         files mysql
> 
> 匹允互﹛凶中化中反compat勾井勻化凶曰仄引允及匹
> passwd:         compat mysql
> group:          compat mysql
> shadow:         compat mysql
> 匹手第匹仄凶

$ egrep '^(passwd|group|shadow):' /etc/nsswitch.conf 
passwd:     files nisplus nis mysql
shadow:     files nisplus nis mysql
group:      files nisplus nis mysql

午中丹〇芢匹﹜庍凳〇芢反

$ rcsdiff -u /etc/nsswitch.conf 
===================================================================
RCS file: /etc/RCS/nsswitch.conf,v
retrieving revision 1.1
diff -u -r1.1 /etc/nsswitch.conf
--- /etc/nsswitch.conf  2001/08/06 07:24:28     1.1
+++ /etc/nsswitch.conf  2001/08/16 02:23:30
@@ -30,9 +30,9 @@
 #shadow:    db files nisplus nis
 #group:     db files nisplus nis
 
-passwd:     files nisplus nis
-shadow:     files nisplus nis
-group:      files nisplus nis
+passwd:     files nisplus nis mysql
+shadow:     files nisplus nis mysql
+group:      files nisplus nis mysql
 
 #hosts:     db files nisplus nis dns
 hosts:      files nisplus nis dns

午中丹丐氏壬中匹允﹝

> > 曉筏及 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 手井井歹勻化五化...
> ⼳勻慇引木月午颱手云澎曉仆匹允

GNU/Linux 及樺寧﹜nss 楮溢反 info libc 毛厶戈及互域⺀中中及匹仄斤丹井＿?

PAM 及礎匹輔嗶卞卅月及反
http://www.kernel.org/pub/linux/libs/pam/Linux-PAM-html/pam_modules.html
丐凶曰互域慼樹扷及方丹匹允﹝

帎蟾萌中匹中月沭匹反卅中及匹允互﹜聶坌劑仄內勾凜棉毛潸勻化壅祭仄化云井
卅中午棒艘卅午五卞卅勻化學月仇午卞卅曰公丹＿﹝

> 孔丹﹛犯奴旦弁弁仿永扑亙匹﹛方丹支仁丟□伙支曰潸曰匹五月棕雁卞卅勻凶

云⺾木今引匹允﹝
颱及憤鎘穴扑件反 7/29 卞皿仿奶穴伉穴旦正及 HDD (Win 95 迕) 互云侅仁卅
曰卞卅勻化﹜公木動侳齬蜓じ木化引六氏 ^^;;;
-- 
Yasuhide OMORI / 釐蕨忡敗