Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#22 Patch to force "flush privileges" on password change

open-remind
None
1
2008-08-28
2004-01-06
Michael Birk
No

When a password is changed it updates the MySQL
database accordingly. However, MySQL requires a
special "flush privileges" command to be invoked for the
changes to apply. See the MySQL documentation
section 4.4.3:

http://www.mysql.com/documentation/mysql/bychapter/
manual_MySQL_Database_Administration.html#Privilege_c
hanges

The attached patch forces the "flush privileges"
command after a successful password change.

Discussion

  • Michael Birk
    Michael Birk
    2004-01-06

    Patch to force "flush privileges" on password change

     
    Attachments
  • Logged In: NO

    pam_mysql don't use the MySQL privileges but plain tables
    instead.

     
  • Michael Birk
    Michael Birk
    2004-11-16

    Logged In: YES
    user_id=97575

    To correct the previous comment, pam_mysql can use any
    MySQL table. However, by default it queries and updates
    the "user" table, which controls MySQL authentication. In
    that case, the "flush privileges" command, and therefore this
    patch, is useful.

     
  • Logged In: YES
    user_id=995831

    I'll look into this.

     
    • assigned_to: nobody --> moriyoshi
    • status: open --> open-remind
     
  • (C)0||3N
    (C)0||3N
    2008-08-28

    • priority: 5 --> 1