java - Error in connecting to PostgreSQL database using data inserted from android application through PHP -


my current android application allows user key in chat room name i'll utilizing name stored database name. hence name stored used connect database using php web service. understand there're solutions editing pg_ident.conf file, allowing www-data recognized 1 of users access database. however, i'm hoping have better solution. in advance given.

this error message got

warning: pg_connect() [function.pg-connect]: unable connect postgresql server: fatal: role "www-data" not exist.

php code (blabla.php)

<?php  $host = "localhost";  $user = "bbcc";  $db=$_post['name'];  $passwd = "abc";   $con = pg_connect("host=$host dbname=$db user=$user password=$passwd") or die ("could not connect server\n" . pg_last_error()); ?>

java code snippet

   private void valid() {           string room = "abcd";         try{              httpparams params = new basichttpparams();              httpconnectionparams.setconnectiontimeout(params, 20 * 1000);              httpconnectionparams.setsotimeout(params, 30 * 1000);              httpclient httpclient = new defaulthttpclient(params);              httppost httppost = new httppost("http://111.11.111.000/script/blabla.php");              list<namevaluepair> namevaluepairs = new arraylist<namevaluepair>();                  namevaluepairs.add(new basicnamevaluepair("name", room));              httppost.setentity(new urlencodedformentity(namevaluepairs));              httpresponse response = httpclient.execute(httppost);         }catch(exception e){             e.printstacktrace();         }   }

check settings pg_hba.conf

this file controls: hosts allowed connect, how clients authenticated, postgresql user names can use, databases can access. records take 1 of these forms:

local      database  user  method  [options] host       database  user  cidr-address  method  [options] hostssl    database  user  cidr-address  method  [options] hostnossl  database  user  cidr-address  method  [options]

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more