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

[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

[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

[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

[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]