From unknown Wed Jun 18 23:08:01 2025
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Mailer: MIME-tools 5.509 (Entity 5.509)
Content-Type: text/plain; charset=utf-8
From: bug#7664 <7664@debbugs.gnu.org>
To: bug#7664 <7664@debbugs.gnu.org>
Subject: Status: sql.el: In interactive sql-<product> command, Add C-u to
 set connection port
Reply-To: bug#7664 <7664@debbugs.gnu.org>
Date: Thu, 19 Jun 2025 06:08:01 +0000

retitle 7664 sql.el: In interactive sql-<product> command, Add C-u to set c=
onnection port
reassign 7664 emacs
submitter 7664 Jari Aalto <jari.aalto@cante.net>
severity 7664 wishlist

thanks


From debbugs-submit-bounces@debbugs.gnu.org Fri Dec 17 12:31:41 2010
Received: (at submit) by debbugs.gnu.org; 17 Dec 2010 17:31:42 +0000
Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <debbugs-submit-bounces@debbugs.gnu.org>)
	id 1PTe9d-00026j-16
	for submit@debbugs.gnu.org; Fri, 17 Dec 2010 12:31:41 -0500
Received: from emh02.mail.saunalahti.fi ([62.142.5.108])
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <jari.aalto@cante.net>) id 1PTe9Y-00026S-Lz
	for submit@debbugs.gnu.org; Fri, 17 Dec 2010 12:31:38 -0500
Received: from saunalahti-vams (vs3-12.mail.saunalahti.fi [62.142.5.96])
	by emh02-2.mail.saunalahti.fi (Postfix) with SMTP id 356EBEF2F4
	for <submit@debbugs.gnu.org>; Fri, 17 Dec 2010 19:37:57 +0200 (EET)
Received: from emh06.mail.saunalahti.fi ([62.142.5.116])
	by vs3-12.mail.saunalahti.fi ([62.142.5.96])
	with SMTP (gateway) id A012F01D48F; Fri, 17 Dec 2010 19:37:57 +0200
Received: from picasso.cante.net (a91-155-187-216.elisa-laajakaista.fi
	[91.155.187.216])
	by emh06.mail.saunalahti.fi (Postfix) with ESMTP id 11339E51A4
	for <submit@debbugs.gnu.org>; Fri, 17 Dec 2010 19:37:55 +0200 (EET)
From: Jari Aalto <jari.aalto@cante.net>
To: submit@debbugs.gnu.org
Subject: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
Mail-Copies-To: poster
Date: Fri, 17 Dec 2010 19:37:54 +0200
Message-ID: <87ipys2tcd.fsf@picasso.cante.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Antivirus: VAMS
X-Spam-Score: -2.5 (--)
X-Debbugs-Envelope-To: submit
X-BeenThere: debbugs-submit@debbugs.gnu.org
X-Mailman-Version: 2.1.11
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <http://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=unsubscribe>
List-Archive: <http://debbugs.gnu.org/pipermail/debbugs-submit>
List-Post: <mailto:debbugs-submit@debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request@debbugs.gnu.org?subject=help>
List-Subscribe: <http://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=subscribe>
Sender: debbugs-submit-bounces@debbugs.gnu.org
Errors-To: debbugs-submit-bounces@debbugs.gnu.org
X-Spam-Score: -2.5 (--)

Package: emacs
Version: 23.2+1-5.1
Severity: wishlist

In production environments the database servers run in multiple ports, like

    M-x sql-mysql

It would be nice to be able to specify PORT number during interactive call,=
 like:

    C-u M-x sql-mysql
    ...
    Port: .....

Related read:

   "At Digg, we have a lot of databases (...) What we=E2=80=99ve settled on=
 is one
   physical host running four different MySQL instance, one for each pool,
   each listening on a different port."

    * Better SQL buffer names
    * Support TCP ports
    * Support for preset connections

    http://atomized.org/2008/10/enhancing-emacs%E2%80%99-sql-mode/

Jari

-- System Information
Debian Release: squeeze/sid
  APT Prefers testing
  APT policy: (990, testing) (500, unstable) (1, experimental)
Architecture: amd64
Kernel: Linux picasso 2.6.32-5-amd64 #1 SMP Fri Sep 17 21:50:19 UTC 2010 x8=
6_64 GNU/Linux
Locale: LANG=3Den_DK.UTF-8

-- Versions of packages `emacs depends on'.
Depends:
emacs23         23.2+1-5.1      GNU Emacs is the extensible self-documentin=
g=20
emacs23-lucid   23.2+1-5.1      GNU Emacs is the extensible self-documentin=
g=20
emacs23-nox     23.2+1-5.1      GNU Emacs is the extensible self-documentin=
g=20




From debbugs-submit-bounces@debbugs.gnu.org Tue Dec 21 01:53:19 2010
Received: (at 7664) by debbugs.gnu.org; 21 Dec 2010 06:53:20 +0000
Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <debbugs-submit-bounces@debbugs.gnu.org>)
	id 1PUw63-00060g-IP
	for submit@debbugs.gnu.org; Tue, 21 Dec 2010 01:53:19 -0500
Received: from vm-emlprdomr-05.its.yale.edu ([130.132.50.146])
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <cyd@stupidchicken.com>) id 1PUw61-00060U-Gk
	for 7664@debbugs.gnu.org; Tue, 21 Dec 2010 01:53:17 -0500
Received: from furball (bb116-14-228-227.singnet.com.sg [116.14.228.227])
	(authenticated bits=0)
	by vm-emlprdomr-05.its.yale.edu (8.14.4/8.14.4) with ESMTP id
	oBL6xfum010828
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT);
	Tue, 21 Dec 2010 01:59:44 -0500
Received: by furball (Postfix, from userid 1000)
	id BF2AD161C19; Tue, 21 Dec 2010 14:59:40 +0800 (SGT)
From: Chong Yidong <cyd@stupidchicken.com>
To: "Michael R. Mauger"  <mmaug@yahoo.com>
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
References: <87ipys2tcd.fsf@picasso.cante.net>
Date: Tue, 21 Dec 2010 14:59:40 +0800
In-Reply-To: <87ipys2tcd.fsf@picasso.cante.net> (Jari Aalto's message of "Fri, 
	17 Dec 2010 19:37:54 +0200")
Message-ID: <87y67jtxur.fsf@stupidchicken.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
X-Scanned-By: MIMEDefang 2.71 on 130.132.50.146
X-Spam-Score: -2.6 (--)
X-Debbugs-Envelope-To: 7664
Cc: 7664@debbugs.gnu.org, Jari Aalto <jari.aalto@cante.net>
X-BeenThere: debbugs-submit@debbugs.gnu.org
X-Mailman-Version: 2.1.11
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <http://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=unsubscribe>
List-Archive: <http://debbugs.gnu.org/pipermail/debbugs-submit>
List-Post: <mailto:debbugs-submit@debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request@debbugs.gnu.org?subject=help>
List-Subscribe: <http://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=subscribe>
Sender: debbugs-submit-bounces@debbugs.gnu.org
Errors-To: debbugs-submit-bounces@debbugs.gnu.org
X-Spam-Score: -2.6 (--)

Jari Aalto <jari.aalto@cante.net> writes:

> In production environments the database servers run in multiple ports,
> like
>
>     M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>     C-u M-x sql-mysql
>     ...
>     Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.





From debbugs-submit-bounces@debbugs.gnu.org Tue Dec 21 21:57:58 2010
Received: (at 7664) by debbugs.gnu.org; 22 Dec 2010 02:57:58 +0000
Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <debbugs-submit-bounces@debbugs.gnu.org>)
	id 1PVEtq-0003OJ-GT
	for submit@debbugs.gnu.org; Tue, 21 Dec 2010 21:57:58 -0500
Received: from web62507.mail.re1.yahoo.com ([69.147.75.99])
	by debbugs.gnu.org with smtp (Exim 4.69)
	(envelope-from <mmaug@yahoo.com>) id 1PVEtp-0003O6-IA
	for 7664@debbugs.gnu.org; Tue, 21 Dec 2010 21:57:57 -0500
Received: (qmail 45364 invoked by uid 60001); 22 Dec 2010 03:04:30 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1292987070; bh=/gQLNaYjZ3Tvs/8RUvtAJ+WBbaiXaMAZ8fH5AdM3itA=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=6UJx9BUva1UvCHiiq4bPrXuw9QSoIHjwWqEPhqYAgi5HWNU0kCa3J4hJnBzDDazmCAwGHIhuosUyjGcSyRnBZgyQMNhE9Frtcje0WTZAIIEfWYWbrRYIJt5g0hZEhxYQ0HPDePHfE5rC2ySUoVHN1DHefUk/lQBL7ByUMplAjtE=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=Q9cfzfMTxZb8i8JPy5T8MKu/gynu1UetKRmy0wm0AapywWjvSq5tHsa3+6umMp9wYA8w3ExWZpo5BR24Ns26XLtF1OleImew5dUntMsIwwanpY47AJYeeygkQyAWGIQ4dhavwl9YsMhMKX5EtKXkvPo7oUxYiYm/IGu3qKySrPA=;
Message-ID: <729725.45346.qm@web62507.mail.re1.yahoo.com>
X-YMail-OSG: Xd3GGkUVM1nywJ.q0ENrnDY.nEUqSecxKMqy2DZCpQ27a72
	S9TBBk56Md.kQ02jfAB9o.abxKHkPwUJ0YyckyuN4HDMNtgvDImj9PWmxt3f
	dVD6avt6P6dUMs9yIFLQ_JohYR.EOrKpImpXhrYyYd72kRJVksKPxjQ_9F2N
	xHW506Ii8w.._vd66.YCM0T.yPVEC2zQ4NqQMvByJuy0RQLexcbKTsUvwBI2
	3t_AWvJGTx0YGR59feJnSvyx1Mtq8dUVOKcahBBlEcS_3FzuSwb6mBBuKI_Z
	zNYzioETxsmKqyVb8ljFBWDd1rZ2eKMJqk3vJMcDMl_hfCDhIPofd3zMqUeZ
	1QuHaFdEPJ7FIx8W4wVwswTBML5qY023Byo1U8RfOw_iENC62PbTHNjRHl6w
	OkY43Il5CivnrC0IrL6IvZlIWXDKMKg--
Received: from [98.216.52.54] by web62507.mail.re1.yahoo.com via HTTP;
	Tue, 21 Dec 2010 19:04:30 PST
X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259
References: <87ipys2tcd.fsf@picasso.cante.net>
	<87y67jtxur.fsf@stupidchicken.com>
Date: Tue, 21 Dec 2010 19:04:30 -0800 (PST)
From: Michael Mauger <mmaug@yahoo.com>
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command,
	Add C-u to set connection port
To: Chong Yidong <cyd@stupidchicken.com>
In-Reply-To: <87y67jtxur.fsf@stupidchicken.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-986543547-1292987070=:45346"
X-Spam-Score: -2.4 (--)
X-Debbugs-Envelope-To: 7664
Cc: 7664@debbugs.gnu.org, Jari Aalto <jari.aalto@cante.net>
X-BeenThere: debbugs-submit@debbugs.gnu.org
X-Mailman-Version: 2.1.11
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <http://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=unsubscribe>
List-Archive: <http://debbugs.gnu.org/pipermail/debbugs-submit>
List-Post: <mailto:debbugs-submit@debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request@debbugs.gnu.org?subject=help>
List-Subscribe: <http://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=subscribe>
Sender: debbugs-submit-bounces@debbugs.gnu.org
Errors-To: debbugs-submit-bounces@debbugs.gnu.org
X-Spam-Score: -2.4 (--)

--0-986543547-1292987070=:45346
Content-Type: text/plain; charset=us-ascii

In Emacs 24, SQL.el supports the port login parameter.  

By customizing `sql-mysql-login-params'  to include the atom `port' the port 
will be prompted for during login.  If you don't specify a value, it will not be 
specified when you connect so it will use the default.   You can also set a 
default value for port by customizing `sql-port'.

   (setq sql-mysql-login-params '(user password server port database))

Both MySQL and Postgres support the use of port during login. 





________________________________
From: Chong Yidong <cyd@stupidchicken.com>
To: Michael R. Mauger <mmaug@yahoo.com>
Cc: Jari Aalto <jari.aalto@cante.net>; 7664@debbugs.gnu.org
Sent: Tue, December 21, 2010 1:59:40 AM
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command, Add C-u to 
set connection port

Jari Aalto <jari.aalto@cante.net> writes:

> In production environments the database servers run in multiple ports,
> like
>
>     M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>     C-u M-x sql-mysql
>     ...
>     Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.
--0-986543547-1292987070=:45346
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:lucida console,sans-serif;font-size:10pt">In Emacs 24, SQL.el supports the port login parameter.&nbsp; <br><br>By customizing `sql-mysql-login-params'&nbsp; to include the atom `port' the port will be prompted for during login.&nbsp; If you don't specify a value, it will not be specified when you connect so it will use the default. &nbsp; You can also set a default value for port by customizing `sql-port'.<br><br>&nbsp;&nbsp; (setq sql-mysql-login-params '(user password server port database))<br><br>Both MySQL and Postgres support the use of port during login.&nbsp; <br><div><br></div><div style="font-family: lucida console,sans-serif; font-size: 10pt;"><br><div style="font-family: tahoma,new york,times,serif; font-size: 10pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Chong Yidong
 &lt;cyd@stupidchicken.com&gt;<br><b><span style="font-weight: bold;">To:</span></b> Michael R. Mauger &lt;mmaug@yahoo.com&gt;<br><b><span style="font-weight: bold;">Cc:</span></b> Jari Aalto &lt;jari.aalto@cante.net&gt;; 7664@debbugs.gnu.org<br><b><span style="font-weight: bold;">Sent:</span></b> Tue, December 21, 2010 1:59:40 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: bug#7664: sql.el: In interactive sql-&lt;product&gt; command, Add C-u to set connection port<br></font><br>
Jari Aalto &lt;<a ymailto="mailto:jari.aalto@cante.net" href="mailto:jari.aalto@cante.net">jari.aalto@cante.net</a>&gt; writes:<br><br>&gt; In production environments the database servers run in multiple ports,<br>&gt; like<br>&gt;<br>&gt;&nbsp; &nbsp;  M-x sql-mysql<br>&gt;<br>&gt; It would be nice to be able to specify PORT number during interactive<br>&gt; call, like:<br>&gt;<br>&gt;&nbsp; &nbsp;  C-u M-x sql-mysql<br>&gt;&nbsp; &nbsp;  ...<br>&gt;&nbsp; &nbsp;  Port: .....<br><br>Michael, could you take a look at this wishlist item?&nbsp; Currently,<br>sql-mysql already uses a prefix argument to output into a new buffer.<br>If you decide this suggestion is worth implementing, there are a couple<br>of possibilities: (i) add another interactive command that prompts for a<br>port number, or (ii) change the interactive spec so that a prefix arg<br>prompts the user about whether to use a new buffer and what port to use.<br>I don't use sql.el, so I don't
 know which makes more sense.<br><br></div></div>
</div></body></html>
--0-986543547-1292987070=:45346--




From debbugs-submit-bounces@debbugs.gnu.org Wed Dec 22 02:13:38 2010
Received: (at control) by debbugs.gnu.org; 22 Dec 2010 07:13:38 +0000
Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <debbugs-submit-bounces@debbugs.gnu.org>)
	id 1PVItF-0000Ne-QA
	for submit@debbugs.gnu.org; Wed, 22 Dec 2010 02:13:38 -0500
Received: from vm-emlprdomr-06.its.yale.edu ([130.132.50.147])
	by debbugs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <cyd@stupidchicken.com>) id 1PVItE-0000NT-8K
	for control@debbugs.gnu.org; Wed, 22 Dec 2010 02:13:36 -0500
Received: from furball (bb116-14-228-227.singnet.com.sg [116.14.228.227])
	(authenticated bits=0)
	by vm-emlprdomr-06.its.yale.edu (8.14.4/8.14.4) with ESMTP id
	oBM7K6cj013204
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <control@debbugs.gnu.org>; Wed, 22 Dec 2010 02:20:09 -0500
Received: by furball (Postfix, from userid 1000)
	id 7A6C0160738; Wed, 22 Dec 2010 15:20:05 +0800 (SGT)
From: Chong Yidong <cyd@stupidchicken.com>
To: control@debbugs.gnu.org
Subject: close 7664
Date: Wed, 22 Dec 2010 15:20:05 +0800
Message-ID: <874oa6uvdm.fsf@stupidchicken.com>
MIME-Version: 1.0
Content-Type: text/plain
X-Scanned-By: MIMEDefang 2.71 on 130.132.50.147
X-Spam-Score: -2.6 (--)
X-Debbugs-Envelope-To: control
X-BeenThere: debbugs-submit@debbugs.gnu.org
X-Mailman-Version: 2.1.11
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <http://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=unsubscribe>
List-Archive: <http://debbugs.gnu.org/pipermail/debbugs-submit>
List-Post: <mailto:debbugs-submit@debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request@debbugs.gnu.org?subject=help>
List-Subscribe: <http://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>,
	<mailto:debbugs-submit-request@debbugs.gnu.org?subject=subscribe>
Sender: debbugs-submit-bounces@debbugs.gnu.org
Errors-To: debbugs-submit-bounces@debbugs.gnu.org
X-Spam-Score: -2.6 (--)

close 7664
thanks




From unknown Wed Jun 18 23:08:01 2025
Received: (at fakecontrol) by fakecontrolmessage;
To: internal_control@debbugs.gnu.org
From: Debbugs Internal Request <help-debbugs@gnu.org>
Subject: Internal Control
Message-Id: bug archived.
Date: Wed, 19 Jan 2011 12:24:04 +0000
User-Agent: Fakemail v42.6.9

# This is a fake control message.
#
# The action:
# bug archived.
thanks
# This fakemail brought to you by your local debbugs
# administrator