Bug#677844: [Pkg-nagios-devel] Bug#677844: icinga-web: postinst fails to set root passwd - MYSQL_PWD env var not working

2012-06-18 Thread tomdeb
Hello Markus,

Thanks for your quick reply.

Here is the output of the postinst script:
==
Creating config file /etc/icinga-web/conf.d/database-ido.xml with new version
database config successful: /etc/icinga-web/conf.d/database-ido.xml
ERROR 1045 (28000): Access denied for user 'icinga_web'@'localhost'
(using password: YES)
dpkg: error processing icinga-web (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 icinga-web
E: Sub-process /usr/bin/dpkg returned an error code (1)
==

Following your reply, I did some more testing and the cause is
definitely my .my.cnf.
I can reproduce the error when install as my user (who has a .my.cnf) with sudo.
The issue does not occur when .my.cnf is removed.

I had a look at
http://dev.mysql.com/doc/refman/5.5/en/password-security-user.html and
even though using the -p parameter is not advised, the use of
MYSQL_PWD is not recommended either.

Regards,

Thomas Debost

On 17 June 2012 13:09, Markus Frosch mar...@lazyfrosch.de wrote:
 tags 677844 unreproducible moreinfo
 thanks

 Hello Tom,
 thanks for your report.

 The password previously stored in $MYSQL_PWD is not working.


 I'm afraid I can't confirm the problem with my sid VM, MySQL is the same
 version as yours.

 Is it possible to share the output of the postinst script, what exactly is
 the error?

 Do you have any mysql connection info defined via .my.cnf or the global
 my.cnf?

 Are there any special chars in your password that might cause the problem?

        echo UPDATE nsm_user SET user_password='$pwhash_e', user_salt
 = '$salt_e' WHERE user_name = 'root'; \
                     | mysql -h ${dbc_dbhost:=localhost} -u $dbc_dbuser
 -p$dbc_dbpass $dbc_dbname


 I'd not like to use this due to the root password will be visible via ps or
 the /proc filesystem...

 Please
 see http://dev.mysql.com/doc/refman/5.5/en/password-security-user.html

 Best Regards
 Markus Frosch

 --
 Markus Frosch
 mar...@lazyfrosch.de
 http://www.lazyfrosch.de



--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



Bug#537717: mdadm assembles raid-arrays in initrd to early

2009-07-20 Thread tomdeb...@gmx.de
Package: mdadm
Version: 2.6.9-3
Severity: normal

My Raid-Devices are started within initrd. But when mdadm starts to assemble 
the raid devices, the scsi-controller hasn't finished the
recognition of the local scsi devices = madadm fails for md0-md2
If I insert a sleep 10 in scripts/local-top/mdadm just at the start:

MDADM=/sbin/mdadm
[ -x $MDADM ] || exit 0


# 09.07.09 Fix tr
sleep 15


verbose()
{
  case $quiet in y*|Y*|1|t*|T*)
return 1;;
  *)
return 0;;
  esac
}

then everything work. Also if I stop initrd with the commandline-option 
break=mount, I see that the initrd stopps, then
after 1-2 seconds the detected scsi-devices are reported by the kernel. Then I 
can continue without problems.
It seem to be a timeing issue.

Hardwar: 

4xSATA sda,sdb,sdc,sdd
4xSCSI sde,sdf,sdg,sdh

Tom

-- Package-specific info:
--- mount output
/dev/md1 on / type ext3 (rw,errors=remount-ro)
tmpfs on /lib/init/rw type tmpfs (rw,nosuid,mode=0755)
proc on /proc type proc (rw,noexec,nosuid,nodev)
sysfs on /sys type sysfs (rw,noexec,nosuid,nodev)
procbususb on /proc/bus/usb type usbfs (rw)
udev on /dev type tmpfs (rw,mode=0755)
tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev)
devpts on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=620)
fusectl on /sys/fs/fuse/connections type fusectl (rw)
/dev/md0 on /boot type ext3 (rw,errors=remount-ro)
/dev/md2 on /vmware type ext3 (rw)
/dev/md7 on /archiv type ext3 (rw,errors=remount-ro)
/dev/md3 on /archiv/intern type ext3 (rw,errors=remount-ro)
/dev/md4 on /datentempel type ext3 (rw,errors=remount-ro)
/dev/md6 on /archiv/sc-archiv type ext3 (rw,errors=remount-ro)
/dev/md8 on /data type ext3 (rw,errors=remount-ro)
/dev/md9 on /amanda type ext3 (rw,errors=remount-ro)
/dev/md11 on /scratch type ext3 (rw,errors=remount-ro)
/dev/md10 on /debiancopy type ext3 (rw,errors=remount-ro)
binfmt_misc on /proc/sys/fs/binfmt_misc type binfmt_misc 
(rw,noexec,nosuid,nodev)

--- mdadm.conf
# mdadm.conf
#
# Please refer to mdadm.conf(5) for information about this file.
#

# by default, scan all partitions (/proc/partitions) for MD superblocks.
# alternatively, specify devices to scan, using wildcards if desired.
DEVICE partitions

# auto-create devices with Debian standard permissions
CREATE owner=root group=disk mode=0660 auto=yes

# automatically tag new arrays as belonging to the local system
HOMEHOST system

# instruct the monitoring daemon where to send mail alerts
MAILADDR root

# This file was auto-generated on Fri, 23 Feb 2007 16:02:42 +
# by mkconf $Id: mkconf 261 2006-11-09 13:32:35Z madduck $
#
ARRAY /dev/md0 level=raid1 num-devices=4  
UUID=19f38bc6:763d266b:132783e8:19cdff95
ARRAY /dev/md1 level=raid10 num-devices=4 
UUID=e4ff4a38:03e7f205:132783e8:19cdff95
ARRAY /dev/md2 level=raid10 num-devices=4 
UUID=c2378f71:7ce2aff8:132783e8:19cdff95
ARRAY /dev/md3 level=raid10 num-devices=4 
UUID=55eb7745:93ec3d64:02ebe09c:3f9c8f88
ARRAY /dev/md4 level=raid10 num-devices=4 
UUID=0fd85265:9b33d39f:02ebe09c:3f9c8f88
ARRAY /dev/md6 level=raid10 num-devices=4 
UUID=3e65df1c:40619cf5:02ebe09c:3f9c8f88
ARRAY /dev/md7 level=raid10 num-devices=4 
UUID=827f0a18:996a60df:02ebe09c:3f9c8f88
ARRAY /dev/md8 level=raid10 num-devices=4 
UUID=3ba9e1bd:50659501:02ebe09c:3f9c8f88
ARRAY /dev/md9 level=raid10 num-devices=4 
UUID=07bc43be:4b6d0642:02ebe09c:3f9c8f88
ARRAY /dev/md10 level=raid1 num-devices=2 
UUID=9855bb81:60f39571:02ebe09c:3f9c8f88
ARRAY /dev/md11 level=raid0 num-devices=2 
UUID=ccd46f0b:1cf6f6cd:02ebe09c:3f9c8f88

--- /proc/mdstat:
Personalities : [raid0] [raid1] [raid10] 
md11 : active raid0 sda10[0] sdc10[1]
  98253312 blocks 64k chunks
  
md3 : active raid10 sdd1[0] sdc1[3] sda1[2] sdb1[1]
  781256832 blocks 64K chunks 2 near-copies [4/4] []
  
md4 : active raid10 sdd5[0] sdc5[3] sda5[2] sdb5[1]
  390620288 blocks 64K chunks 2 near-copies [4/4] []
  
md6 : active raid10 sdd6[0] sdc6[3] sda6[2] sdb6[1]
  390620288 blocks 64K chunks 2 near-copies [4/4] []
  
md7 : active raid10 sdd7[0] sdc7[3] sda7[2] sdb7[1]
  390620288 blocks 64K chunks 2 near-copies [4/4] []
  
md8 : active raid10 sdd8[0] sdc8[3] sda8[2] sdb8[1]
  390620288 blocks 64K chunks 2 near-copies [4/4] []
  
md9 : active raid10 sdd9[0] sdc9[3] sda9[2] sdb9[1]
  488279424 blocks 64K chunks 2 near-copies [4/4] []
  
md10 : active raid1 sdd10[0] sdb10[1]
  49126656 blocks [2/2] [UU]
  
md2 : active raid10 sde6[0] sdh6[3] sdg6[2] sdf6[1]
  182241152 blocks 64K chunks 2 near-copies [4/4] []
  
md1 : active raid10 sde2[0] sdh2[3] sdg2[2] sdf2[1]
  97658880 blocks 64K chunks 2 near-copies [4/4] []
  
md0 : active raid1 sde1[0] sdh1[3] sdg1[2] sdf1[1]
  489856 blocks [4/4] []
  
unused devices: none

--- /proc/partitions:
major minor  #blocks  name

   80 1465138584 sda
   81  390628507 sda1
   82  1 sda2
   85  195310237 sda5
   86  195310237 sda6
   87