Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#3855 Unable to save group permissions in MySQL database

1.530
closed-fixed
Jamie Cameron
5
2011-02-25
2011-02-24
David Gibbs
No

I'm unable to save the correct group permissions when they are stored in a mysql database.

The following is the log entry after enabling the postfix module for my 'admin' group:
1298574507.16042.0 [24/Feb/2011 13:08:27] root 059f7b91fe5ef4fdac5609fefa7c319f dlinkap acl save_group.cgi "modify" "group" "admin" acl_security_form='1' desc='Administrators' feedback='0' fileunix='root' fileunix_def='0' gedit_can='' gedit_cannot='' gedit_gid='' gedit_gid2='' gedit_mode='0' mod='backup-config' mod='change-user' mod='webmincron' mod='webminlog' mod='webmin' mod='servers' mod='acl' mod='init' mod='passwd' mod='quota' mod='mount' mod='fsdump' mod='inittab' mod='logrotate' mod='mailcap' mod='pam' mod='proc' mod='at' mod='cron' mod='package-updates' mod='software' mod='man' mod='syslog' mod='system-status' mod='useradmin' mod='apache' mod='bind8' mod='pserver' mod='dhcpd' mod='dhcp-dns' mod='dovecot' mod='mysql' mod='postfix' name='admin' negative='0' nodot='0' old='admin' otherdirs='' readonly='0' root='/' root_def='0' rpc='2' uedit_can='' uedit_cannot='' uedit_group='' uedit_mode='0' uedit_uid='' uedit_uid2='' webminsearch='1'

I just tried enabling ALL modules in the group ... and all modules UP TO "System Logs" were enabled. None after that though.

Same thing happens when I create a new group and enable all modules ... just those up to "System Logs" are enabled, the rest are disabled.

Here's the log entry from that attempt:
1298574824.17496.0 [24/Feb/2011 13:13:44] root 059f7b91fe5ef4fdac5609fefa7c319f dlinkap acl save_group.cgi "create" "group" "admin" desc='Administrators' mod='backup-config' mod='change-user' mod='webmincron' mod='usermin' mod='webminlog' mod='webmin' mod='servers' mod='acl' mod='awstats' mod='bacula-backup' mod='init' mod='passwd' mod='quota' mod='mount' mod='fsdump' mod='inittab' mod='ldap-client' mod='ldap-useradmin' mod='logrotate' mod='mailcap' mod='mon' mod='pam' mod='certmgr' mod='proc' mod='at' mod='cron' mod='sentry' mod='package-updates' mod='software' mod='man' mod='syslog' mod='syslog-ng' mod='system-status' mod='useradmin' mod='apache' mod='bind8' mod='pserver' mod='cyrus-imapd' mod='dhcpd' mod='dhcp-dns' mod='dovecot' mod='exim' mod='fetchmail' mod='frox' mod='jabber' mod='ldap-server' mod='majordomo' mod='htpasswd-file' mod='mysql' mod='openldap2' mod='openslp' mod='postfix' mod='postgresql' mod='proftpd' mod='procmail' mod='qmailadmin' mod='mailboxes' mod='sshd' mod='samba' mod='sendmail' mod='spam' mod='squid' mod='sarg' mod='wuftpd' mod='webalizer' mod='adsl-client' mod='bandwidth' mod='ipsec' mod='krb5' mod='firewall' mod='mrtg' mod='exports' mod='nis' mod='net' mod='xinetd' mod='inetd' mod='pap' mod='ppp-client' mod='pptp-client' mod='pptp-server' mod='stunnel' mod='shorewall' mod='tcpwrappers' mod='idmapd' mod='filter' mod='burner' mod='grub' mod='lilo' mod='raid' mod='lvm' mod='fdisk' mod='lpadmin' mod='smart-status' mod='time' mod='ntp' mod='vgetty' mod='iscsitarget' mod='cluster-passwd' mod='cluster-copy' mod='cluster-cron' mod='cluster-shell' mod='cluster-software' mod='cluster-usermin' mod='cluster-useradmin' mod='cluster-webmin' mod='cfengine' mod='heartbeat' mod='shell' mod='custom' mod='file' mod='tunnel' mod='phpini' mod='cpan' mod='htaccess-htpasswd' mod='telnet' mod='status' mod='updown' name='admin' old=''

I just noticed that the size for the value column in table webmin_group_attr is only 255 bytes ... which seems pretty short. I dropped the column and re-added it with a size of 4096 and it works better.

ALTER TABLE `webmin_user_attr` CHANGE `value` `value` VARCHAR( 4096 ) NULL DEFAULT NULL

Discussion

  • David Gibbs
    David Gibbs
    2011-02-24

    Might be related to #3169760

     
  • Jamie Cameron
    Jamie Cameron
    2011-02-25

    Thanks for pointing this out - that field is indeed way too narrow, I will fix it in the next Webmin release. Your size increase is a reasonable work-around ..

     
  • Jamie Cameron
    Jamie Cameron
    2011-02-25

    • status: open --> closed-fixed