Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2009-08

SQLdb PQConnection Port

15 messages · 5 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Giuseppe Luigi Punzi Ruiz

Hi,

It's possible to change the port of a TPQConnection?

I have postgress installed on 5433 (instead 5432), but I can't find where to change this.

Cheers.

Giuseppe Luigi Punzi Ruiz
Blog: http://www.lordzealon.com
Twitter & Skype & GoogleTalk accounts: glpunzi

Reply by email

Michael Van Canneyt
to Giuseppe Luigi Punzi Ruiz
Giuseppe Luigi Punzi Ruiz wrote 6 lines
Hi, It's possible to change the port of a TPQConnection? I have postgress installed on 5433 (instead 5432), but I can't find where to change this.

Add something like
port=5433
to the params property.

Michael.

Reply by email

Giuseppe Luigi Punzi
to Michael Van Canneyt

Hi,

El vie, 07-08-2009 a las 08:50 +0200, Michael Van Canneyt escribi?:

Show quoted text 13 lines
On Thu, 6 Aug 2009, Giuseppe Luigi Punzi Ruiz wrote: > Hi, > > It's possible to change the port of a TPQConnection? > > I have postgress installed on 5433 (instead 5432), but I can't find where to > change this. Add something like port=5433 to the params property.

I tried yesterday, but, I got an Access Violation, when I changed "Connected" to true. I opened "Params" again, and was in blank, and lazarus become unstable.

The component must be removed to back to stability.

I forgot to mention:

Lazarus revision: 0.9.27 from last night svn
FPC: 2.2.4
O.S.: OSX 10.5
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090807/aa7409d6/attachment.html>

Reply by email

Michael Van Canneyt
to Giuseppe Luigi Punzi
Giuseppe Luigi Punzi wrote 22 lines
Hi, El vie, 07-08-2009 a las 08:50 +0200, Michael Van Canneyt escribi?: > > On Thu, 6 Aug 2009, Giuseppe Luigi Punzi Ruiz wrote: > >> Hi, >> >> It's possible to change the port of a TPQConnection? >> >> I have postgress installed on 5433 (instead 5432), but I can't find where to >> change this. > > Add something like > port=5433 > to the params property. I tried yesterday, but, I got an Access Violation, when I changed "Connected" to true. I opened "Params" again, and was in blank, and lazarus become unstable.

Nevertheless, what I described above is how it should be done. There seems to be an additional problem on your machine. What it is, I do not know.

Can you try to set the properties and do a connection at runtime, and then see what the stack backtrace says ?

Michael.

Reply by email

Graeme Geldenhuys
to Michael Van Canneyt: Add something like port=5433 to the params property. Michael.
Michael Van Canneyt wrote
Add something like port=5433 to the params property.

I can confirm that setting the Database.Params property is correct and works 100%. I just switched our PostgreSQL server to listen on port 5433 instead and it worked perfectly via the SqlDB components.

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://opensoft.homeip.net/fpgui/

Reply by email

Giuseppe Luigi Punzi
to Graeme Geldenhuys

El vie, 07-08-2009 a las 10:32 +0200, Graeme Geldenhuys escribi?:

Show quoted text 10 lines
Michael Van Canneyt wrote: > > Add something like > port=5433 > to the params property. I can confirm that setting the Database.Params property is correct and works 100%. I just switched our PostgreSQL server to listen on port 5433 instead and it worked perfectly via the SqlDB components.

Great, I will try it later. Probably I wrote "portnumber" instead "port", I don't remember.

Cheers.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090807/0abaf5a6/attachment-0001.html>

Reply by email

Giuseppe Luigi Punzi Ruiz
to Giuseppe Luigi Punzi

Hi all,

El 07/08/2009, a las 10:38, Giuseppe Luigi Punzi escribi?:

Show quoted text 14 lines
El vie, 07-08-2009 a las 10:32 +0200, Graeme Geldenhuys escribi?: > > Michael Van Canneyt wrote: > > > > Add something like > > port=5433 > > to the params property. > > > I can confirm that setting the Database.Params property is correct > and > works 100%. I just switched our PostgreSQL server to listen on port > 5433 > instead and it worked perfectly via the SqlDB components.

Sorry for the delay :P

Don't works.

Open a New Project.
Add a TPQConnection.
Configure database, hostname, user and password.
Open Params, and write, "port=5433"
Change Connected to True.
Access Violation.
Try to delete TPQConnection.
Access Violation and Lazarus Crash

Lazarus 0.9.27 r21092M FPC 2.2.4 i386-darwin-carbon (beta)

Cheers

Giuseppe Luigi Punzi Ruiz
Blog: http://www.lordzealon.com
Twitter & Skype & GoogleTalk accounts: glpunzi

Reply by email

Mattias Gaertner
to Giuseppe Luigi Punzi Ruiz
Show quoted text 32 lines
Hi all, El 07/08/2009, a las 10:38, Giuseppe Luigi Punzi escribi?: > El vie, 07-08-2009 a las 10:32 +0200, Graeme Geldenhuys escribi?: >> >> Michael Van Canneyt wrote: >> > >> > Add something like >> > port=5433 >> > to the params property. >> >> >> I can confirm that setting the Database.Params property is >> correct and >> works 100%. I just switched our PostgreSQL server to listen on >> port 5433 >> instead and it worked perfectly via the SqlDB components. Sorry for the delay :P Don't works. Open a New Project. Add a TPQConnection. Configure database, hostname, user and password. Open Params, and write, "port=5433" Change Connected to True. Access Violation. Try to delete TPQConnection. Access Violation and Lazarus Crash

Please start the IDE in gdb, create a backtrace and a bug report:

http://wiki.lazarus.freepascal.org/Creating_a_Backtrace_with_GDB

Lazarus 0.9.27 r21092M FPC 2.2.4 i386-darwin-carbon (beta)

Mattias

Reply by email

Giuseppe Luigi Punzi Ruiz
to Mattias Gaertner

Hi Mattias,

Please start the IDE in gdb, create a backtrace and a bug report: http://wiki.lazarus.freepascal.org/Creating_a_Backtrace_with_GDB

I tried, but I can't get to crash it. I only get Access Violation, but I can't get anything on the output.

Giuseppe Luigi Punzi Ruiz
Blog: http://www.lordzealon.com
Twitter & Skype & GoogleTalk accounts: glpunzi

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090813/704d0c37/attachment-0001.html>

Reply by email

Giuseppe Luigi Punzi Ruiz
to Mattias Gaertner

galilea:lazarus glpunzi$ gdb startlazarus
GNU gdb 6.3.50-20050815 (Apple version gdb-966) (Tue Mar 10 02:43:13 UTC 2009)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-apple-darwin"...Reading symbols for shared libraries ......... done

(gdb) break fpc_raiseexception
Breakpoint 1 at 0xfbe6
(gdb) run --pcp=./config
Starting program: /Users/glpunzi/svn/lazarus/startlazarus --pcp=./config Reading symbols for shared libraries +++++++
+
......................................................................... done Reading symbols for shared libraries . done
Reading symbols for shared libraries . done
Adding "--pcp=./config" as a parameter
Reading symbols for shared libraries ....... done
TLazarusManager.Run starting /Users/glpunzi/svn/lazarus/lazarus.app/ Contents/MacOS/lazarus ...
TCarbonPrinter.ValidatePageFormat Error: PMSessionValidatePageFormat failed with result -30876
SetPrimaryConfigPath NewValue="./config" -> "/Users/glpunzi/svn/ lazarus/config"
TMainIDE.ParseCmdLineOptions:
PrimaryConfigPath="/Users/glpunzi/svn/lazarus/config" SecondaryConfigPath="/etc/lazarus"
TCarbonMenu.SetCaption Error: ChangeMenuItemAttributes failed with result -50
TCarbonMenu.SetCaption Error: SetMenuItemTextWithCFString failed with result -50
TCarbonMenu.Update Error: SetMenuItemHierarchicalMenu failed with result -50
TCarbonMenu.SetBitmap Error: SetMenuItemIconHandle failed with result -50
TCarbonMenu.SetVisible Error: ChangeMenuItemAttributes show failed with result -50
TMainIDE.DoLoadLFM A /Users/glpunzi/desarrollo/postgres/unit1.pas IsPartOfProject=True
QuickCheckLFMBuffer LFMBuffer=/Users/glpunzi/desarrollo/postgres/ unit1.lfm
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TMainIDE.DoNewProject A
TMainIDE.CloseUnitComponent /Users/glpunzi/desarrollo/postgres/ unit1.pas Form1:TForm1
TProject.UpdateUnitComponentDependencies checking properties ... Search UnitComponent=Form1:TForm1
AComponent=PQConnection1:TPQConnection ReferenceUnit=False TProject.UpdateUnitComponentDependencies checking designers ... TProject.UpdateUnitComponentDependencies used by designer: /Users/ glpunzi/desarrollo/postgres/unit1.pas
TMainIDE.CloseUnitComponent freeing component and designer: /Users/ glpunzi/desarrollo/postgres/unit1.pas Form1:TForm1 TProject.UpdateUnitComponentDependencies checking designers ... TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
TCustomFormEditor.CreateComponent Form1:TForm1 True TMainIDE.DoNewEditorFile END unit1.pas
TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
Parent is 'Form1:TForm1'
TCustomFormEditor.CreateComponent PQConnection1:TPQConnection True TMainIDE.OnPropHookPersistentAdded A PQConnection1:TPQConnection TPkgManager.AddUnitDependenciesForComponentClasses Adding Project Dependency project1 -> SQLDBLaz
TPkgManager.AddUnitDependenciesForComponentClasses Extending Uses unit1.pas pqconnection
[TEventsCodeTool.CompleteComponent]
CurComponent=PQConnection1:TPQConnection
TCarbonEdit.SetFocus Error: SetKeyboardFocus failed with result -30585 #################### TOICustomPropertyGrid.DoCallEdit for TStringsPropertyEditor Edit=True
TCarbonEdit.SetFocus Error: SetKeyboardFocus failed with result -30585 TCarbonEdit.SetFocus Error: SetKeyboardFocus failed with result -30585 TCarbonBitBtn.SetFocus Error: SetKeyboardFocus failed with result -30585
TCarbonBitBtn.SetFocus Error: SetKeyboardFocus failed with result -30585
TMainIDE.CloseUnitComponent unit1.pas Form1:TForm1 TProject.UpdateUnitComponentDependencies checking properties ... Search UnitComponent=Form1:TForm1
AComponent=PQConnection1:TPQConnection ReferenceUnit=False TProject.UpdateUnitComponentDependencies checking designers ... TProject.UpdateUnitComponentDependencies used by designer: unit1.pas TMainIDE.CloseUnitComponent freeing component and designer: unit1.pas Form1:TForm1
TryFreeComponent ERROR: "PQConnection1:TPQConnection" Access violation Stack trace:
$00000000
$00485874
$00486082
$00485E8C
$0047B46A
$00056BD7
$0005AE51
$0005F735
$00042361
$00025A18
$000258A2
$001A1268
$90494648
$9049D7BE
$904A05AB
$925F64CF
$92674DD1
[TJITComponentList.DestroyJITComponent] ERROR destroying component Error: Access violation
Stack trace:
$005FF5F6
$0017FFC1
$00173B43
$00181E4E
$000217AA
$00022360
$0000E755
$0046E066
$00485EF9
$0047B46A
$00056BD7
$0005AE51
$0005F735
$00042361
$00025A18
$000258A2
$001A1268
TCustomFormEditor.JITListException List.CurReadStreamClass=nil nil TProject.UpdateUnitComponentDependencies checking designers ... TCarbonTabsControl.SetFocus Error: SetKeyboardFocus failed with result -30585
LAZARUS END - cleaning up ...
[TMainIDE.Destroy] A
[TMainIDE.Destroy] B -> inherited Destroy... TMainIDE [TMainIDE.Destroy] END

Program exited normally.

Once the Access Violation, is showed, I close lazarus, and I get other AV about deleting TPConnection

Giuseppe Luigi Punzi Ruiz
Blog: http://www.lordzealon.com
Twitter & Skype & GoogleTalk accounts: glpunzi

Reply by email

Giuseppe Luigi Punzi
to Giuseppe Luigi Punzi Ruiz: I tried, but I can't get to crash it. I only get Access Violation, but I can't get…

Same behaviour on:
Lazarus 0.9.27 rUnknown FPC 2.2.4 x86_64-linux-gtk 2 (beta)

I don't know exactly this release, because is from Graeme's GIT repo.

If you open params dialog, write "port=5433" and "OK", try to open Params dialog again, and is empty.

Acces Violation trying to change Connected to True.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090814/647b6f41/attachment.html>

Reply by email

Graeme Geldenhuys
to Giuseppe Luigi Punzi
Giuseppe Luigi Punzi wrote
Same behaviour on: Lazarus 0.9.27 rUnknown FPC 2.2.4 x86_64-linux-gtk 2 (beta) I don't know exactly this release, because is from Graeme's GIT repo.
   $ git log

...and look for the first line that has the following format in the commit comments.

"git-svn-id: http://svn2.freepascal.org/svn/lazarus/trunk at 21150 4005530d-fff6-..."

The SVN revision in this case is r21150. I still need to update the Lazarus About dialog to detect revisions when SVN or Git is used. That isn't difficult, I just need to make the time.

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://opensoft.homeip.net/fpgui/

Reply by email

Giuseppe Luigi Punzi
to Graeme Geldenhuys

El vie, 14-08-2009 a las 10:35 +0200, Graeme Geldenhuys escribi?:

Show quoted text 18 lines
Giuseppe Luigi Punzi wrote: > Same behaviour on: > Lazarus 0.9.27 rUnknown FPC 2.2.4 x86_64-linux-gtk 2 (beta) > > I don't know exactly this release, because is from Graeme's GIT repo. $ git log ...and look for the first line that has the following format in the commit comments. "git-svn-id: http://svn2.freepascal.org/svn/lazarus/trunk at 21150 4005530d-fff6-..." The SVN revision in this case is r21150. I still need to update the Lazarus About dialog to detect revisions when SVN or Git is used. That isn't difficult, I just need to make the time.

Thanks, then, I have:
Lazarus 0.9.27 r21151 FPC 2.2.4 x86_64-linux-gtk 2 (beta)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20090814/8c491e09/attachment.html>

Reply by email