Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6C01E1337B2F for ; Thu, 7 Apr 2011 13:05:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 34506-01 for ; Thu, 7 Apr 2011 16:05:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from salmo.appl-ecosys.com (appl-ecosys.com [216.99.206.23]) by mail.postgresql.org (Postfix) with ESMTP id DF409133616B for ; Thu, 7 Apr 2011 13:05:45 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id 153E537BC6; Thu, 7 Apr 2011 09:05:45 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id 0D05637B42 for ; Thu, 7 Apr 2011 09:05:45 -0700 (PDT) Date: Thu, 7 Apr 2011 09:05:45 -0700 (PDT) From: Rich Shepard Reply-To: Rich Shepard To: pgsql-php@postgresql.org Subject: Connecting PHP-based Application to Postgres-9.0.3 Message-ID: User-Agent: Alpine 2.00 (LNX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="-1463811785-672725638-1302192345=:397" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/2 X-Sequence-Number: 4164 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. ---1463811785-672725638-1302192345=:397 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII I'm migrating our Web site to CMS Made Simple, it worked here with postgres-8.4, but stopped working when I upgraded to postgres-9.0.0 (and I'm now running 9.0.3). This is with php-5.2.17 on Slackware-13.1. I need help since I don't know PHP or ADOdb. /var/log/httpd/error_log shows: [Tue Apr 05 16:45:39 2011] [error] [client 127.0.0.1] PHP Fatal error: Attempt to connect to database cms on rshepard@localhost failed in /var/www/htdocs/cmsms/lib/adodb.functions.php on line 85 I've attached a copy of that function. So far the message I posted to the adodb mail list yesterday is the only one there, and there's no response to my help request on the phplens adodb-php Web forum. Rich ---1463811785-672725638-1302192345=:397 Content-Type: TEXT/PLAIN; charset=US-ASCII; name=adodb.functions.php Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: Content-Disposition: attachment; filename=adodb.functions.php PD9waHANCg0KLyoqDQogKiBAcGFja2FnZSBDTVMNCiAqLw0KDQovKioNCiAq IEEgbWV0aG9kIHRvIGluaXRpYWxpemUgdGhlIGNvbm5lY3Rpb24gd2l0aCB0 aGUgQ01TTVMgY29uZmlndXJlZCBkYXRhYmFzZS4NCiAqDQogKiBAaW50ZXJu YWwNCiAqIEBhY2Nlc3MgcHJpdmF0ZQ0KICovDQpmdW5jdGlvbiBsb2FkX2Fk b2RiKCkgDQp7DQogIGdsb2JhbCAkZ0NtczsNCiAgZ2xvYmFsICRBRE9EQl92 ZXJzOw0KICAkY29uZmlnID0mICRnQ21zLT5HZXRDb25maWcoKTsNCg0KCS8v IEBUT0RPOiBSZW1vdmUgZGVwZW5kZW5jZSBvbiBQRUFSIGZvciBlcnJvciBo YW5kbGluZwkNCglpZiAoJGNvbmZpZ1snZGVidWcnXSA9PSB0cnVlKQ0KCXsN CgkJI0BpbmNsdWRlX29uY2UoY21zX2pvaW5fcGF0aChkaXJuYW1lKF9fRklM RV9fKSwgJGNvbmZpZ1sndXNlX2Fkb2RiX2xpdGUnXSA9PSB0cnVlID8gJ2Fk b2RiX2xpdGUnIDogJ2Fkb2RiJywgJ2Fkb2RiLWVycm9ycGVhci5pbmMucGhw JykpOw0KCX0NCgkNCglkZWZpbmUoJ0FET0RCX09VVFAnLCAnZGVidWdfc3Fs Jyk7DQoJLy9kZWZpbmUoJ0FET0RCX0VSUk9SX0hBTkRMRVInLCAnYWRvZGJf ZXJyb3InKTsNCgkNCgkkbG9hZGVkX2Fkb2RiID0gZmFsc2U7DQoJDQoJaWYg KCRjb25maWdbJ3VzZV9hZG9kYl9saXRlJ10gPT0gZmFsc2UgfHwgKGlzc2V0 KCRVU0VfT0xEX0FET0RCKSAmJiAkVVNFX09MRF9BRE9EQiA9PSAxKSkNCgl7 DQoJIyBDTVNNUyBpcyBjb25maWd1cmVkIHRvIHVzZSBmdWxsIEFET2RiDQoJ CSRmdWxsX2Fkb2RiID0gY21zX2pvaW5fcGF0aChkaXJuYW1lKF9fRklMRV9f KSwnYWRvZGInLCdhZG9kYi5pbmMucGhwJyk7DQoJCWlmICghIGZpbGVfZXhp c3RzKCRmdWxsX2Fkb2RiKSkNCgkJew0KCQkJIyBGdWxsIEFET2RiIGNhbm5v dCBiZSBmb3VuZCwgc2hvdyBhIGRlYnVnIGVycm9yIG1lc3NhZ2UNCgkJCSRn Q21zLT5lcnJvcnNbXSA9ICdDTVMgTWFkZSBTaW1wbGUgaXMgY29uZmlndXJl ZCB0byB1c2UgdGhlIGZ1bGwgQURPZGIgRGF0YWJhc2UgQWJzdHJhY3Rpb24g bGlicmFyeSwgYnV0IGl0XCdzIG5vdCBpbiB0aGUgbGliJyAuRElSRUNUT1JZ X1NFUEFSQVRPUi4gJ2Fkb2RiIGRpcmVjdG9yeS4gU3dpdGNoZWQgYmFjayB0 byBBRE9kYiBMaXRlLic7DQoJCX0NCgkJZWxzZQ0KCQl7DQoJCQkjIExvYWQg KGZ1bGwpIEFET2RiDQoJCQlyZXF1aXJlKCRmdWxsX2Fkb2RiKTsNCgkJCSRs b2FkZWRfYWRvZGIgPSB0cnVlOw0KCQl9DQoJfQ0KCWlmICghJGxvYWRlZF9h ZG9kYikNCgl7DQoJCSRhZG9kYl9saWdodCA9IGNtc19qb2luX3BhdGgoZGly bmFtZShfX0ZJTEVfXyksJ2Fkb2RiX2xpdGUnLCdhZG9kYi5pbmMucGhwJyk7 DQoJCSMgVGhlIEFET2RiIGxpYnJhcnkgaXMgbm90IHlldCBpbmNsdWRlZCwg dHJ5IEFET2RiIExpdGUNCgkJaWYgKGZpbGVfZXhpc3RzKCRhZG9kYl9saWdo dCkpDQoJCXsNCgkJCSMgTG9hZCBBRE9kYiBMaXRlDQoJCQlyZXF1aXJlKCRh ZG9kYl9saWdodCk7DQoJCX0NCgkJZWxzZQ0KCQl7DQoJCQkjIEFET2RiIGNh bm5vdCBiZSBmb3VuZCwgc2hvdyBhIG1lc3NhZ2UgYW5kIHN0b3AgdGhlIHNj cmlwdCBleGVjdXRpb24NCgkJCWRpZSgnVGhlIEFET2RiIExpdGUgZGF0YWJh c2UgYWJzdHJhY3Rpb24gbGlicmFyeSBjYW5ub3QgYmUgZm91bmQsIENNUyBN YWRlIFNpbXBsZSBjYW5ub3QgbG9hZC4nKTsNCgkJfQ0KCX0NCgkNCglkZWZp bmUoJ0NNU19BRE9EQl9EVCcsICRjb25maWdbJ3VzZV9hZG9kYl9saXRlJ10g PyAnRFQnIDogJ1QnKTsNCn0NCg0KLyoqDQogKiBBIG1ldGhvZCB0byByZS1p bml0aWFsaXplIGNvbm5lY3Rpb25zIHRvIHRoZSBDTVNNUyBjb25maWd1cmVk IGRhdGFiYXNlLg0KICogVGhpcyBtZXRob2Qgc2hvdWxkIGJlIHVzZWQgYnkg YW55IFVEVCdzIG9yIG90aGVyIHBsdWdpbnMgdGhhdCB1c2UgYW55IG90aGVy IG1ldGhvZA0KICogdGhhbiB0aGUgc3RhbmRhcmQgQ01TTVMgc3VwcGxpZWQg ZGF0YWJhc2Ugb2JqZWN0IHRvIGNvbm5lY3QgdG8gYSBkYXRhYmFzZS4NCiAq DQogKi8NCmZ1bmN0aW9uICYgYWRvZGJfY29ubmVjdCgpDQp7DQoJZ2xvYmFs ICRnQ21zOw0KCSRjb25maWcgPSYgJGdDbXMtPkdldENvbmZpZygpOw0KCQ0K CSRkYmluc3RhbmNlID0mIEFET05ld0Nvbm5lY3Rpb24oJGNvbmZpZ1snZGJt cyddLCAncGVhcjpkYXRlOmV4dGVuZDp0cmFuc2FjdGlvbicpOw0KCSRkYmlu c3RhbmNlLT5yYWlzZUVycm9yRm4gPSAiYWRvZGJfZXJyb3IiOw0KCSRjb25u X2Z1bmMgPSAoaXNzZXQoJGNvbmZpZ1sncGVyc2lzdGVudF9kYl9jb25uJ10p ICYmICRjb25maWdbJ3BlcnNpc3RlbnRfZGJfY29ubiddID09IHRydWUpID8g J1BDb25uZWN0JyA6ICdDb25uZWN0JzsNCglpZighZW1wdHkoJGNvbmZpZ1sn ZGJfcG9ydCddKSkgJGRiaW5zdGFuY2UtPnBvcnQgPSAkY29uZmlnWydkYl9w b3J0J107DQoJJGNvbm5lY3RfcmVzdWx0ID0gJGRiaW5zdGFuY2UtPiRjb25u X2Z1bmMoJGNvbmZpZ1snZGJfaG9zdG5hbWUnXSwgJGNvbmZpZ1snZGJfdXNl cm5hbWUnXSwgJGNvbmZpZ1snZGJfcGFzc3dvcmQnXSwgJGNvbmZpZ1snZGJf bmFtZSddKTsNCgkNCglpZiAoRkFMU0UgPT0gJGNvbm5lY3RfcmVzdWx0KQ0K CXsNCgkgICRzdHIgPSAiQXR0ZW1wdCB0byBjb25uZWN0IHRvIGRhdGFiYXNl IHskY29uZmlnWydkYl9uYW1lJ119IG9uIHskY29uZmlnWydkYl91c2VybmFt ZSddfUB7JGNvbmZpZ1snZGJfaG9zdG5hbWUnXX0gZmFpbGVkIjsNCgkgIHRy aWdnZXJfZXJyb3IoJHN0cixFX1VTRVJfRVJST1IpOw0KCSAgZGllKCRzdHIp Ow0KCX0NCg0KCSRkYmluc3RhbmNlLT5yYWlzZUVycm9yRm4gPSBudWxsOw0K CQ0KCSRkYmluc3RhbmNlLT5TZXRGZXRjaE1vZGUoQURPREJfRkVUQ0hfQVNT T0MpOw0KCQ0KCWlmICgkY29uZmlnWydkZWJ1ZyddID09IHRydWUpDQoJew0K CQkkZGJpbnN0YW5jZS0+ZGVidWcgPSB0cnVlOw0KCQkjJGRiaW5zdGFuY2Ut PkxvZ1NRTCgpOw0KCX0NCgkNCglpZiAoJGNvbmZpZ1snZGJtcyddID09ICdz cWxpdGUnKQ0KCXsNCgkJJGRiaW5zdGFuY2UtPkV4ZWN1dGUoJ1BSQUdNQSBz aG9ydF9jb2x1bW5fbmFtZXMgPSAxOycpOw0KCQlzcWxpdGVfY3JlYXRlX2Z1 bmN0aW9uKCRjb25maWdbJ3VzZV9hZG9kYl9saXRlJ10gPyAkZGItPmNvbm5l Y3Rpb25JZCA6ICRkYi0+X2Nvbm5lY3Rpb25JRCwgJ25vdycsICd0aW1lJywg MCk7DQoJfQ0KCWVsc2UNCgl7DQoJCWlmKCFlbXB0eSgkY29uZmlnWydkZWZh dWx0X2VuY29kaW5nJ10pICYmICRjb25maWdbJ2RlZmF1bHRfZW5jb2Rpbmcn XSA9PSAndXRmLTgnICYmICRjb25maWdbJ3NldF9uYW1lcyddID09IHRydWUp DQoJCXsNCgkJCSRkYmluc3RhbmNlLT5FeGVjdXRlKCJTRVQgTkFNRVMgJ3V0 ZjgnIik7DQoJCX0NCgl9DQoJDQoJJGRiID0mICRkYmluc3RhbmNlOw0KCXJl dHVybiAkZGI7DQp9DQoNCg0KLyoqDQogKiBAaWdub3JlDQogKi8NCmZ1bmN0 aW9uIGFkb2RiX2Vycm9yKCRkYnR5cGUsICRmdW5jdGlvbl9wZXJmb3JtZWQs ICRlcnJvcl9udW1iZXIsICRlcnJvcl9tZXNzYWdlLCAkaG9zdCwgJGRhdGFi YXNlLCAmJGNvbm5lY3Rpb25fb2JqKQ0Kew0KCWlmKGZpbGVfZXhpc3RzKGNt c19qb2luX3BhdGgoZGlybmFtZShDT05GSUdfRklMRV9MT0NBVElPTiksICdk Yl9lcnJvci5odG1sJykpKQ0KCXsNCgkJaW5jbHVkZV9vbmNlIGNtc19qb2lu X3BhdGgoZGlybmFtZShDT05GSUdfRklMRV9MT0NBVElPTiksICdkYl9lcnJv ci5odG1sJyk7DQoJCWV4aXQ7DQoJfQ0KCWVsc2UNCgl7DQoJCWVjaG8gIjxz dHJvbmc+RGF0YWJhc2UgQ29ubmVjdGlvbiBGYWlsZWQ8L3N0cm9uZz48YnIg Lz4iOw0KCQllY2hvICJFcnJvcjogeyRlcnJvcl9tZXNzYWdlfSAoeyRlcnJv cl9udW1iZXJ9KTxiciAvPiI7DQoJCWVjaG8gIkZ1bmN0aW9uIFBlcmZvcm1l ZDogeyRmdW5jdGlvbl9wZXJmb3JtZWR9PGJyIC8+IjsNCgkJZWNobyAiSG9z dC9EQjogeyRob3N0fS97JGRhdGFiYXNlfTxiciAvPiI7DQoJCWVjaG8gIkRh dGFiYXNlIFR5cGU6IHskZGJ0eXBlfTxiciAvPiI7DQoJfQ0KfQ0KDQo/Pg0K ---1463811785-672725638-1302192345=:397--