Bug#330655: sarge /usr/share/sympa/db/install-mysql-db script wrong use of host for account

2005-10-28 Thread Geoff Crompton
I noticed the change log for 4.1.5-5 indicates that this has been fixed.
However the Bug Tracking System doesn't indicate that it has been fixed.
Can you sort that out? (I'm not a DD, but I suspect that the format for
the changelog didn't trigger a bug close in the BTS).


Stefan Hornburg wrote:
 On Thu, 29 Sep 2005 11:53:02 +1000
 [EMAIL PROTECTED] wrote:
 
 
Package: sympa
Version: 4.1.5-2
Severity: important

The -h parameter of /usr/share/sympa/db/install-mysql-db is used to form
the dsn to connect to the database.
It is also used for the GRANT ALL.

So if you are using a mysql server on another host, you can't connect to
the database as the sympa user.
 
 
 Thanks for the patch !
 
 Bye
   Racke
 


-- 
Geoff Crompton
Debian System Administrator
Strategic Data
+61 3 9340 9000


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#330655: sarge /usr/share/sympa/db/install-mysql-db script wrong use of host for account

2005-10-28 Thread Stefan Hornburg
On Fri, 28 Oct 2005 16:38:30 +1000
Geoff Crompton [EMAIL PROTECTED] wrote:

 I noticed the change log for 4.1.5-5 indicates that this has been fixed.
 However the Bug Tracking System doesn't indicate that it has been fixed.
 Can you sort that out? (I'm not a DD, but I suspect that the format for
 the changelog didn't trigger a bug close in the BTS).

Sorry, I messed this up - there was never a 4.1.5-5 release. I'll close
the bug manually.

Bye
Racke


-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#330655: sarge /usr/share/sympa/db/install-mysql-db script wrong use of host for account

2005-09-29 Thread Stefan Hornburg
On Thu, 29 Sep 2005 11:53:02 +1000
[EMAIL PROTECTED] wrote:

 Package: sympa
 Version: 4.1.5-2
 Severity: important
 
 The -h parameter of /usr/share/sympa/db/install-mysql-db is used to form
 the dsn to connect to the database.
 It is also used for the GRANT ALL.
 
 So if you are using a mysql server on another host, you can't connect to
 the database as the sympa user.

Thanks for the patch !

Bye
Racke

-- 
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#330655: sarge /usr/share/sympa/db/install-mysql-db script wrong use of host for account

2005-09-28 Thread geoff . crompton
Package: sympa
Version: 4.1.5-2
Severity: important

The -h parameter of /usr/share/sympa/db/install-mysql-db is used to form
the dsn to connect to the database.
It is also used for the GRANT ALL.

So if you are using a mysql server on another host, you can't connect to
the database as the sympa user.

Patch is:
--- install-mysql-db2005-09-29 11:52:42.0 +1000
+++ install-mysql-db.orig   2005-09-29 11:52:26.0 +1000
@@ -76,7 +76,7 @@
 }

 # Create user sympa
-my $command=GRANT ALL on $database.* TO [EMAIL PROTECTED];
+my $command=GRANT ALL on $database.* TO [EMAIL PROTECTED];
 if ($userpass ne ) {
 $command .=  IDENTIFIED BY '$userpass';
 }


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]