From mrdaniel@singnet.com.sg Fri Aug 22 05:19:57 2003 X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7830FD1BB11 for ; Fri, 22 Aug 2003 02:19:57 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 93755-04 for ; Fri, 22 Aug 2003 02:19:27 -0300 (ADT) Received: from smtp22.singnet.com.sg (smtp22.singnet.com.sg [165.21.101.202]) by svr1.postgresql.org (Postfix) with ESMTP id 595ACD1BB12 for ; Fri, 22 Aug 2003 02:19:25 -0300 (ADT) Received: from wdc200 (bb-203-125-69-90.singnet.com.sg [203.125.69.90]) by smtp22.singnet.com.sg (8.12.9/8.12.9) with SMTP id h7M5JKNU012583; Fri, 22 Aug 2003 13:19:20 +0800 Message-ID: <00e101c3686c$d4e8f760$8b00a8c0@wdc200> From: "daniel" To: Subject: kylix3 connection problem Date: Fri, 22 Aug 2003 13:18:33 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DE_01C368AF.E2E17DE0" X-Priority: 1 X-MSMail-Priority: High X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.4 tagged_above=0.0 required=5.0 tests=HTML_50_60, X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH X-Spam-Level: ** X-Archive-Number: 200308/6 X-Sequence-Number: 7 This is a multi-part message in MIME format. ------=_NextPart_000_00DE_01C368AF.E2E17DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable allo, I am stalling over this kylix3 connection problem with postgresql 7.2 in Re= dhat7.3 I had unmarked the line in [1] pg_hba.conf in /usr/local/pgsql/data1 host all 127.0.0.1 255.255.255.255 trust. [2] postgres.conf=20=20 tcpip__sock =3D true [3] in the hidden dbxdriver file, VendorLib =3D libpq.so.2 [4] in kylix3 dbexpress SQLConnection properties :- hostname localhost username daniel password daniel [5] the postmaster is started via :- daniel@localhost daniel]$ pg_ctl start -D /usr/local/pgsql/data1 > logfile = 2>&1 & i hope to get some experienced postgresql_kylix3 to help me out of this loo= p. ciao daniel ------=_NextPart_000_00DE_01C368AF.E2E17DE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
allo,
 
I am stalling over this kylix3 connection = problem=20 with postgresql 7.2 in Redhat7.3
 
I had unmarked the line in
[1] pg_hba.conf in=20 /usr/local/pgsql/data1
host all 127.0.0.1 255.255.255.255=20 trust.
[2] postgres.conf 
tcpip__sock =3D true
 
[3] in the hidden dbxdriver file,
VendorLib =3D libpq.so.2
 
[4] in kylix3 dbexpress SQLConnection prop= erties=20 :-
hostname localhost
username daniel
password daniel
 
[5] the postmaster is started via :-
daniel@localhost daniel]$ pg_ctl start= -D=20 /usr/local/pgsql/data1 > logfile 2>&1 &
 
i hope to get some experienced postgresql_= kylix3 to=20 help me out of this loop.
 
ciao
daniel
 
 
------=_NextPart_000_00DE_01C368AF.E2E17DE0-- From alvis@piladzi-2.biz Fri Aug 22 11:23:41 2003 X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 74CFDD1B9F2 for ; Fri, 22 Aug 2003 08:23:41 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 01345-05 for ; Fri, 22 Aug 2003 08:23:13 -0300 (ADT) Received: from Tiger.server100.com (unknown [207.44.158.4]) by svr1.postgresql.org (Postfix) with ESMTP id 65A9ED1B92C for ; Fri, 22 Aug 2003 08:23:10 -0300 (ADT) Received: from [195.13.175.104] (helo=Xeon) by Tiger.server100.com with asmtp (Exim 4.20) id 19qA0e-0005zL-QA; Fri, 22 Aug 2003 06:23:13 -0500 Message-ID: <001e01c3689f$5b085f70$1401010a@Xeon> Reply-To: From: To: Cc: Subject: Re: kylix3 connection problem Date: Fri, 22 Aug 2003 14:20:10 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-4" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - Tiger.server100.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - piladzi-2.biz X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.2 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, RCVD_IN_RFCI X-Spam-Level: ** X-Archive-Number: 200308/7 X-Sequence-Number: 8 Hello, >I am stalling over this kylix3 connection problem with postgresql 7.2 in Redhat7.3 Can you gimme exact error message? > 4] in kylix3 dbexpress SQLConnection properties :- >hostname localhost >username daniel >password daniel I don't know much about dbexpress, but I am not sure you have created database (you have to mention name of the database somewhere) with username&password daniel I am using Kylix2 (and Delphi6) and zeoslib components (http://www.zeoslib.net) with PostgreSQL 7.3.4 and have no problems at all. Consider to switch to open source components and you will always have someone to ask your questions. ..or at least you will be able to look at the source and, hopefully, will find solution yourself. I recommend you to get latest stable source from Postgresql.org & latest stable zeosdbo version (currently 6.01.2). Please cc or bcc me if you want to contact me. Good Luck & Regards, Alvis From mrdaniel@singnet.com.sg Sat Aug 23 03:15:03 2003 X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2F43AD1B99A for ; Sat, 23 Aug 2003 00:15:03 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 57389-08 for ; Sat, 23 Aug 2003 00:14:52 -0300 (ADT) Received: from smtp23.singnet.com.sg (smtp23.singnet.com.sg [165.21.101.203]) by svr1.postgresql.org (Postfix) with ESMTP id 2A154D1B89D for ; Sat, 23 Aug 2003 00:14:51 -0300 (ADT) Received: from wdc200 (bb-203-125-76-237.singnet.com.sg [203.125.76.237]) by smtp23.singnet.com.sg (8.12.9/8.12.9) with SMTP id h7N3EfgO022180; Sat, 23 Aug 2003 11:14:41 +0800 Message-ID: <00a201c36924$96be5120$8b00a8c0@wdc200> From: "daniel" To: , References: <001e01c3689f$5b085f70$1401010a@Xeon> Subject: Re: kylix3 connection problem Date: Sat, 23 Aug 2003 11:13:56 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-4" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/8 X-Sequence-Number: 9 allo i had downloaded the zeos - dbo version 6 and in kylix 3 did the build and got the err dialog with :- cannot load bplZComponent and bplZDbc.so: can't opened shared object file . what do you think is missing and what can i do. ciao daniel ----- Original Message ----- From: To: Cc: Sent: Friday, August 22, 2003 7:20 PM Subject: Re: [pgsql-chat] kylix3 connection problem > Hello, > > >I am stalling over this kylix3 connection problem with postgresql 7.2 in > Redhat7.3 > Can you gimme exact error message? > > 4] in kylix3 dbexpress SQLConnection properties :- > >hostname localhost > >username daniel > >password daniel > I don't know much about dbexpress, but I am not sure you have created > database > (you have to mention name of the database somewhere) with username&password > daniel > > I am using Kylix2 (and Delphi6) and zeoslib components > (http://www.zeoslib.net) > with PostgreSQL 7.3.4 and have no problems at all. > Consider to switch to open source components and you will always have > someone to ask your questions. > ..or at least you will be able to look at the source and, hopefully, will > find solution yourself. > > I recommend you to get latest stable source from Postgresql.org & latest > stable zeosdbo version (currently 6.01.2). > > > Please cc or bcc me if you want to contact me. > > Good Luck & Regards, > Alvis > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org From alvis@piladzi-2.biz Sat Aug 23 13:14:15 2003 X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 07B84D1D291 for ; Sat, 23 Aug 2003 10:14:15 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 06821-05 for ; Sat, 23 Aug 2003 10:13:46 -0300 (ADT) Received: from Tiger.server100.com (unknown [207.44.158.4]) by svr1.postgresql.org (Postfix) with ESMTP id E2D72D1BB37 for ; Sat, 23 Aug 2003 10:13:42 -0300 (ADT) Received: from [195.13.175.104] (helo=Xeon) by Tiger.server100.com with asmtp (Exim 4.20) id 19qYDC-0007y9-8B; Sat, 23 Aug 2003 08:13:46 -0500 Message-ID: <000501c36977$f417a1c0$1401010a@Xeon> Reply-To: From: To: "daniel" Cc: References: <001e01c3689f$5b085f70$1401010a@Xeon> <00a201c36924$96be5120$8b00a8c0@wdc200> Subject: Re: kylix3 connection problem Date: Sat, 23 Aug 2003 16:10:38 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-4" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - Tiger.server100.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - piladzi-2.biz X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=BAYES_30, HOT_NASTY, NO_REAL_NAME, ORIGINAL_MESSAGE, RCVD_IN_RFCI, REFERENCES X-Spam-Level: * X-Archive-Number: 200308/9 X-Sequence-Number: 10 ----- Original Message ----- From: "daniel" To: ; Sent: Saturday, August 23, 2003 6:13 AM Subject: Re: [pgsql-chat] kylix3 connection problem > allo > > i had downloaded the zeos - dbo version 6 and in kylix 3 did the build and > got the err dialog with :- > cannot load bplZComponent and bplZDbc.so: can't opened shared object file . > > what do you think is missing and what can i do. > > ciao > daniel > Hello, You should try to install zeosdbo v.5.5.0 stable: 1)IMHO old 5.5 branch is currently much better . (for example, you have TZMonitor + I have kind of my own extension for v5.5.). 2)You have to choose between ver. 5.5 and 6.0, but you have to try both versions yourself to make your decision. 3)Hopefully you will learn how to install 6.0 while installing 5.5. ;-) Instructions for 5.5. install: -begin cut of Linux Install LINUX INSTALL 1. Unpack the archive with components 2. Unpack XXX/kylix/desprop50562.tar.gz into kylix/lib directory (Files dbdesign.dcp and std.dcp should be there). For support PostgreSQL or MySql servers must be intalled mysql-shared-xxx.rpm or postgresql-libs-xxx.rpm packages or this servers must be compilled and installed with client shared libraries. 3. Edit Zeos.inc file. You may set there you language, maximum quantity of supported memo fields, etc. 4. Add to Kylix Library Path pathes to XXX, XXX\common, XXX\dbase, where XXX - ZeosDBO directory. 5. Check pathes to shared libraries in ZLibXXSql.pas 6. Compile and install dpk files in the next sequence: ZCommonK, ZDbwareK, { ZMySqlK | ZPgSqlK | ZIbSqlK} -end of cut Linux install HTH. Best Regards, alvis.