Bug #26540 for XML-Comma: improve convenience of config dialog

Sun Apr 22 08:43:25 2007 ANDK [...] cpan.org - Ticket created

Subject:

improve convenience of config dialog

I'd have two wishes left for the config dialog: (1) My mysql installation needs a furthe parameter in the DSN: mysql_socket=/var/run/mysqld/mysqld.sock Could you provide a dialog for this or maybe for a complete DSN? (2) The mysql root password is not available, so I'd prefer to give you a username/password combination for the database only. This would provide access to the database. You would for this case not try to create the database but simply use it. Without support for these two things I cannot come past 'make test'. Thanks,

Sun Apr 22 15:23:08 2007 brianski [...] cpan.org - Correspondence added

On Sun Apr 22 08:43:25 2007, ANDK wrote: Show quoted text

> I'd have two wishes left for the config dialog: > > (1) My mysql installation needs a furthe parameter in the DSN: > mysql_socket=/var/run/mysqld/mysqld.sock > Could you provide a dialog for this or maybe for a complete DSN?

I'll add this to comma-create-config.pl tonight, and hopefully release 1.99 as well. Show quoted text

> (2) The mysql root password is not available, so I'd prefer to give > you a username/password combination for the database only. This would > provide access to the database. You would for this case not try to > create the database but simply use it.

This is something we should have. I am going to rewrite comma-create-config.pl a bit so that it supports postgres as well as mysql, and I'll add this to my list of goals for when I do. I'd expect this in whatever comes after 1.99 (I haven't decided if that's 2.0, 1.991, or something else). For now, you should be able to simply edit lib/XML/Comma/Configuration.pm by hand, change the name of the directories in question, and then proceed with make && make test && sudo make install. Please contact me if you need further assistance with this, and thanks for your interest!

Sun Apr 22 15:23:09 2007 The RT System itself - Status changed from 'new' to 'open'

Sun Apr 22 19:25:21 2007 andreas.koenig.7os6VVqR [...] franz.ak.mind.de - Correspondence added

CC:	ANDK [...] cpan.org
Subject:	Re: [rt.cpan.org #26540] improve convenience of config dialog
Date:	Mon, 23 Apr 2007 01:24:46 +0200
To:	bug-XML-Comma [...] rt.cpan.org
From:	andreas.koenig.7os6VVqR [...] franz.ak.mind.de (Andreas J. Koenig)

Show quoted text

>>>>> On Sun, 22 Apr 2007 15:23:09 -0400, "Brian Szymanski via RT" <bug-XML-Comma@rt.cpan.org> said:

Show quoted text

> <URL: http://rt.cpan.org/Ticket/Display.html?id=26540 >

Show quoted text

> On Sun Apr 22 08:43:25 2007, ANDK wrote:

>> I'd have two wishes left for the config dialog: >> >> (1) My mysql installation needs a furthe parameter in the DSN: >> mysql_socket=/var/run/mysqld/mysqld.sock >> Could you provide a dialog for this or maybe for a complete DSN?

Show quoted text

> I'll add this to comma-create-config.pl tonight, and hopefully release > 1.99 as well.

Thanks! Show quoted text

>> (2) The mysql root password is not available, so I'd prefer to give >> you a username/password combination for the database only. This would >> provide access to the database. You would for this case not try to >> create the database but simply use it.

Show quoted text

> This is something we should have. I am going to rewrite > comma-create-config.pl a bit so that it supports postgres as well as > mysql, and I'll add this to my list of goals for when I do. I'd expect > this in whatever comes after 1.99 (I haven't decided if that's 2.0, > 1.991, or something else). For now, you should be able to simply edit > lib/XML/Comma/Configuration.pm by hand, change the name of the > directories in question, and then proceed with make && make test && sudo > make install. Please contact me if you need further assistance with > this, and thanks for your interest!

I'm really only after a solution that allows me fully automated testing and installation. With CPAN.pm I can configure the interactive dialog but pre- and post-installation scripts is something I'd like to avoid. But take your time, this is not urgent, of course I can put some interactive commands in any time to see how it fares. Thanks & Regards, -- andreas

Sun Apr 22 23:28:49 2007 brianski [...] cpan.org - Taken

Sun Apr 22 23:38:24 2007 brianski [...] cpan.org - Correspondence added

On Sun Apr 22 08:43:25 2007, ANDK wrote: Show quoted text

> I'd have two wishes left for the config dialog: > > (1) My mysql installation needs a furthe parameter in the DSN: > mysql_socket=/var/run/mysqld/mysqld.sock > Could you provide a dialog for this or maybe for a complete DSN?

As of 1.99 (which is percolating thru CPAN as of 04/23 03:37:31 GMT), this is now done. I provided a dialog for an (optional) string to append to the DSN. Show quoted text

> (2) The mysql root password is not available, so I'd prefer to give > you a username/password combination for the database only. This would > provide access to the database. You would for this case not try to > create the database but simply use it.

This is also done in 1.99. What we do is try to connect to the database given the information provided, and if we cannot, then try to create the database with the information provided, assuming you have access. Eventually we should probably make clear we are prompting for a non-superuser account in the initial dialog, and then ask for superuser credentials which will be used to create any databases or users needed if and only if connecting to the database with the supplied information fails. Hopefully I'll get this out in 1.991 as well as postgres support in the config script. Please let me know if you can build comma successfully now, ANDK, and thanks again!

Sun May 06 08:36:20 2007 brianski [...] cpan.org - Correspondence added

this is resolved as of 1.994

Sun May 06 08:37:39 2007 brianski [...] cpan.org - Status changed from 'open' to 'resolved'