[BUGS] query related to pgsql
sir, while connecting php with database created in postgres,we r facing one error ..errror is that its demanding a password of postgres..but while installing or using postgres we hadnt gave any password.. so hw cn we solve this problem..
Re: [BUGS] query related to pgsql
Abhishek Maurya wrote: > while connecting php with database created in postgres,we r facing > one error ..errror is that its demanding a password of > postgres..but while installing or using postgres we hadnt gave any > password.. so hw cn we solve this problem.. You haven't really given enough information to allow me to advise you with much confidence. In general, you might want to check the documentation of the pg_hba.conf file. If this doesn't do it for you, please read the "Guide to reporting problems" page: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems If you repost, you should choose a more appropriate list, like pgsql-admin or pgsql-general. Oh, and messages are easier to read and understand if some attempt is made at conventional spelling, capitalization, and punctuation. I understand that many posters don't speak English as their first language, but please do what you can. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5429: Driver issue
This has to be reported to the .Net driver people.
---
goutham wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5429
> Logged by: goutham
> Email address: jgowt...@gmail.com
> PostgreSQL version: 8.1.9
> Operating system: Windows
> Description:Driver issue
> Details:
>
> I am using Driver = PostgreSQL UNICODE.
> I am retrieving the dataset using this connection string.
>
> I am using .Net application.
> when i try to user OdbcDataAdapter and fill the dataset its failing.
>
> code snippet:
> OdbcDataAdapter odbcAdapt = new OdbcDataAdapter("Select * from
> table1;"+"Select * from Table2", connection);
>
> odbcAdapt.Fill(dataset);
>
> dataSet.Count is 0.
>
> If I use Driver = postgres instead of Postgres Unicode. this is working.
>
>
>
>
> DRIVER={PostgreSQL
> UNICODE};UID=postgres;PASSWORD=password;UseServerSidePrepare=0;ByteaAsLongVa
> rBinary=0;BI=0;TrueIsMinus1=0;DisallowPremature=0;Upd
>
> atableCursors=1;pga_;;LFConversion=1;ExtraSysTablePrefixes=dd_;CancelAsFreeS
> tmt=0;Parse=0;UnknownsAsLongVarchar=0;TextAsLongVarch
>
> ar=1;BoolsAsChar=0;UseDeclareFetch=0;Ksqo=0;Optimizer=0;CommLog=0;Debug=0;Ma
> xLongVarcharSize=8190;MaxVarcharSize=254;UnknownSizes
>
> =0;Socket=4096;Fetch=100;ConnSettings=;ShowSystemTables=0;RowVersioning=0;Sh
> owOidColumn=0;FakeOidIndex=0;Protocol=6.4;Rea;Only=0;
>
> PORT=5433;SERVER=localhost;DATABASE=TESTDB
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5429: Driver issue
ODBC driver people I think you mean. CC'd.
On Tue, Apr 20, 2010 at 4:12 PM, Bruce Momjian wrote:
>
> This has to be reported to the .Net driver people.
>
> ---
>
> goutham wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: 5429
>> Logged by: goutham
>> Email address: jgowt...@gmail.com
>> PostgreSQL version: 8.1.9
>> Operating system: Windows
>> Description: Driver issue
>> Details:
>>
>> I am using Driver = PostgreSQL UNICODE.
>> I am retrieving the dataset using this connection string.
>>
>> I am using .Net application.
>> when i try to user OdbcDataAdapter and fill the dataset its failing.
>>
>> code snippet:
>> OdbcDataAdapter odbcAdapt = new OdbcDataAdapter("Select * from
>> table1;"+"Select * from Table2", connection);
>>
>> odbcAdapt.Fill(dataset);
>>
>> dataSet.Count is 0.
>>
>> If I use Driver = postgres instead of Postgres Unicode. this is working.
>>
>>
>>
>>
>> DRIVER={PostgreSQL
>> UNICODE};UID=postgres;PASSWORD=password;UseServerSidePrepare=0;ByteaAsLongVa
>> rBinary=0;BI=0;TrueIsMinus1=0;DisallowPremature=0;Upd
>>
>> atableCursors=1;pga_;;LFConversion=1;ExtraSysTablePrefixes=dd_;CancelAsFreeS
>> tmt=0;Parse=0;UnknownsAsLongVarchar=0;TextAsLongVarch
>>
>> ar=1;BoolsAsChar=0;UseDeclareFetch=0;Ksqo=0;Optimizer=0;CommLog=0;Debug=0;Ma
>> xLongVarcharSize=8190;MaxVarcharSize=254;UnknownSizes
>>
>> =0;Socket=4096;Fetch=100;ConnSettings=;ShowSystemTables=0;RowVersioning=0;Sh
>> owOidColumn=0;FakeOidIndex=0;Protocol=6.4;Rea;Only=0;
>>
>> PORT=5433;SERVER=localhost;DATABASE=TESTDB
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>
> --
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql
Would you report this to the RPM maintainers?
---
Jamie Strachan wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5430
> Logged by: Jamie Strachan
> Email address: frostfr...@yahoo.com
> PostgreSQL version: 8.4.3-2PGDG.el4
> Operating system: CentOS 4
> Description:initdb fails due to permissions of /usr/share/pgsql
> Details:
>
> Hello,
>
> Downloaded the following RPM:
> http://yum.pgsqlrpms.org/8.4/redhat/rhel-4-i386/postgresql-server-8.4.3-2PGD
> G.el4.i386.rpm
>
> for my CentOS 4 install.
>
> service postgresql initdb fails with no error message.
>
> So, I su'd to postgres, and ran
>
>initdb --pgdata=/var/lib/pgsql/data --auth=ident
> which is what service postgresql initdb does.
> This command failed, with the error message:
>
> could not open directory "/usr/share/pgsql/timezonesets"
>
>
> I did a
> chown -R postgres:postgres /usr/share/pgsql
> and then it worked fine.
>
> Using rpm2cpio {file} | cpio -tv
> I see:
> drwxr-xr-x 6 root root0 Mar 17 16:21 ./usr/share/pgsql
> which is fine, however there is no specific entry for
> /usr/share/timezone.
> The post-install script doesn't seem to fix it, either.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5429: Driver issue
Hi.
Um, It is a problem report about psqlODBC.
I'm not sure of what as a result of basing it on a multi-statement, return becomes.
Therefore, I had tried the environment to reproduce. Though it is necessary to
acquire a certain amount of information, the point is not held yet
Other someone may have an early reply.
Regards,
Hiroshi Saito
- Original Message -
From: "Bruce Momjian"
This has to be reported to the .Net driver people.
---
goutham wrote:
The following bug has been logged online:
Bug reference: 5429
Logged by: goutham
Email address: jgowt...@gmail.com
PostgreSQL version: 8.1.9
Operating system: Windows
Description:Driver issue
Details:
I am using Driver = PostgreSQL UNICODE.
I am retrieving the dataset using this connection string.
I am using .Net application.
when i try to user OdbcDataAdapter and fill the dataset its failing.
code snippet:
OdbcDataAdapter odbcAdapt = new OdbcDataAdapter("Select * from
table1;"+"Select * from Table2", connection);
odbcAdapt.Fill(dataset);
dataSet.Count is 0.
If I use Driver = postgres instead of Postgres Unicode. this is working.
DRIVER={PostgreSQL
UNICODE};UID=postgres;PASSWORD=password;UseServerSidePrepare=0;ByteaAsLongVa
rBinary=0;BI=0;TrueIsMinus1=0;DisallowPremature=0;Upd
atableCursors=1;pga_;;LFConversion=1;ExtraSysTablePrefixes=dd_;CancelAsFreeS
tmt=0;Parse=0;UnknownsAsLongVarchar=0;TextAsLongVarch
ar=1;BoolsAsChar=0;UseDeclareFetch=0;Ksqo=0;Optimizer=0;CommLog=0;Debug=0;Ma
xLongVarcharSize=8190;MaxVarcharSize=254;UnknownSizes
=0;Socket=4096;Fetch=100;ConnSettings=;ShowSystemTables=0;RowVersioning=0;Sh
owOidColumn=0;FakeOidIndex=0;Protocol=6.4;Rea;Only=0;
PORT=5433;SERVER=localhost;DATABASE=TESTDB
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] query related to pgsql
Firstly, this doesn't seem like a bug at all. So, I think you're in the wrong list. That said, here are some hints that might help you get started through the troubleshooting necessary: 1) Are you able to connect to the server using the psql command line utility (it's best to start there before moving on to layers of complexity)? [Do this from the actual server machine--not from a remote machine to eliminate other sources of error] 2) If not, is the PostgreSQL service started? (If the server is not started, consult your OS documentation on how to start the service) 3) If the service is started: Is it listening on the default port or another, or not listening at all? Check your configuration files if not. 4) If the service is started and listening, can you access it from another system (WITHOUT USING PHP)? 5) If so, begin troubleshooting PHP. Is your web server actively serving PHP (have you run a test document through it)? 6) If so, is the pgsql module loaded? 7) If so, are there any permissions errors or other confounding items in the server setup? That's as much as I can think of off the top of my head. I'm pretty new to all of this myself as I'm self-taught over the past several months. You may find more capable and knowledgeable assistance on another mailing list. Maybe the ADMIN list? I hope this helps, Geoff On Tue, Apr 20, 2010 at 9:48 AM, Kevin Grittner wrote: > Abhishek Maurya wrote: > > > while connecting php with database created in postgres,we r facing > > one error ..errror is that its demanding a password of > > postgres..but while installing or using postgres we hadnt gave any > > password.. so hw cn we solve this problem.. > > You haven't really given enough information to allow me to advise > you with much confidence. In general, you might want to check the > documentation of the pg_hba.conf file. If this doesn't do it for > you, please read the "Guide to reporting problems" page: > > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems > > If you repost, you should choose a more appropriate list, like > pgsql-admin or pgsql-general. > > Oh, and messages are easier to read and understand if some attempt > is made at conventional spelling, capitalization, and punctuation. > I understand that many posters don't speak English as their first > language, but please do what you can. > > -Kevin > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql
Affirmative...
Jamie Strachan
- Original Message
From: Bruce Momjian
To: Jamie Strachan
Cc: pgsql-bugs@postgresql.org
Sent: Tue, April 20, 2010 11:29:57 AM
Subject: Re: [BUGS] BUG #5430: initdb fails due to permissions of
/usr/share/pgsql
Would you report this to the RPM maintainers?
---
Jamie Strachan wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5430
> Logged by: Jamie Strachan
> Email address: frostfr...@yahoo.com
> PostgreSQL version: 8.4.3-2PGDG.el4
> Operating system: CentOS 4
> Description:initdb fails due to permissions of /usr/share/pgsql
> Details:
>
> Hello,
>
> Downloaded the following RPM:
> http://yum.pgsqlrpms.org/8.4/redhat/rhel-4-i386/postgresql-server-8.4.3-2PGD
> G.el4.i386.rpm
>
> for my CentOS 4 install.
>
> service postgresql initdb fails with no error message.
>
> So, I su'd to postgres, and ran
>
>initdb --pgdata=/var/lib/pgsql/data --auth=ident
> which is what service postgresql initdb does.
> This command failed, with the error message:
>
> could not open directory "/usr/share/pgsql/timezonesets"
>
>
> I did a
> chown -R postgres:postgres /usr/share/pgsql
> and then it worked fine.
>
> Using rpm2cpio {file} | cpio -tv
> I see:
> drwxr-xr-x 6 root root0 Mar 17 16:21 ./usr/share/pgsql
> which is fine, however there is no specific entry for
> /usr/share/timezone.
> The post-install script doesn't seem to fix it, either.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
--
Bruce Momjian http://momjian.us
EnterpriseDBhttp://enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql
Hi, On Mon, 2010-04-19 at 14:22 +, Jamie Strachan wrote: > > for my CentOS 4 install. > > service postgresql initdb fails with no error message. > > So, I su'd to postgres, and ran > >initdb --pgdata=/var/lib/pgsql/data --auth=ident > which is what service postgresql initdb does. > This command failed, with the error message: > > could not open directory "/usr/share/pgsql/timezonesets" Cannot reproduce it on my 8.4+CentOS 4 box: -bash-3.00$ initdb --pgdata=/var/lib/pgsql/data --auth=ident ... Success. You can now start the database server using: ... timezonesets directory has already *enough* permissions for postgres user to read it: drwxr-xr-x 2 root root 4096 2010-03-19 09:45 timezonesets Are you sure that you did not chmod somewhere between installing package and initdb'ing? Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql
I have posted the bug to the RPM maintainers, over at Command Prompt. So, 5430 can be closed. This is affecting my CentOS 4 release. (I have to support RHEL/CentOS 4, 5, and some others too.) [r...@isotest ~]# more /etc/redhat-release Red Hat Enterprise Linux ES release 4 (Nahant Update 3) [r...@isotest ~]# rpm -e postgresql-server [r...@isotest ~]# rm -fr /usr/share/pgsql/ [r...@isotest ~]# rpm -i postgresql-server-8.4.3-2PGDG.el4.i386.rpm warning: postgresql-server-8.4.3-2PGDG.el4.i386.rpm: V3 DSA signature: NOKEY, key ID e8e345b8 [r...@isotest ~]# ls -ld /usr/share/pgsql/timezone drwxr-x--- 19 root root 4096 Apr 20 16:27 /usr/share/pgsql/timezone [r...@isotest ~]# ls -ld /usr/share/pgsql/timezonesets/ drwxr-x--- 2 root root 4096 Apr 20 16:27 /usr/share/pgsql/timezonesets/ other is denied access. Thanks, Jamie Strachan. - Original Message From: Devrim GÜNDÜZ To: Jamie Strachan Cc: pgsql-bugs@postgresql.org Sent: Tue, April 20, 2010 3:38:05 PM Subject: Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql Hi, On Mon, 2010-04-19 at 14:22 +, Jamie Strachan wrote: > > for my CentOS 4 install. > > service postgresql initdb fails with no error message. > > So, I su'd to postgres, and ran > >initdb --pgdata=/var/lib/pgsql/data --auth=ident > which is what service postgresql initdb does. > This command failed, with the error message: > > could not open directory "/usr/share/pgsql/timezonesets" Cannot reproduce it on my 8.4+CentOS 4 box: -bash-3.00$ initdb --pgdata=/var/lib/pgsql/data --auth=ident ... Success. You can now start the database server using: ... timezonesets directory has already *enough* permissions for postgres user to read it: drwxr-xr-x 2 root root 4096 2010-03-19 09:45 timezonesets Are you sure that you did not chmod somewhere between installing package and initdb'ing? Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
