closer Posted July 25, 2018 Share Posted July 25, 2018 Hi team, I need remote access to the postgresql database from any ip. Server: tommy.heliohost.orgPostgresql user: "ducquang_main"Postgresql database: "ducquang_crowdworks" Thank you in advance Link to comment Share on other sites More sharing options...
wolstech Posted July 25, 2018 Share Posted July 25, 2018 Let's have Krydos set this up for you. Link to comment Share on other sites More sharing options...
closer Posted July 25, 2018 Author Share Posted July 25, 2018 Let's have Krydos set this up for you.Thanks you! Link to comment Share on other sites More sharing options...
Krydos Posted July 25, 2018 Share Posted July 25, 2018 Remote access enabled. Link to comment Share on other sites More sharing options...
closer Posted July 25, 2018 Author Share Posted July 25, 2018 Remote access enabled.Thanks you so much ! Link to comment Share on other sites More sharing options...
closer Posted July 25, 2018 Author Share Posted July 25, 2018 Remote access enabled.Hi Krydos,I have an error insert data with id type serial:"ERROR: permission denied for sequence users_id_seqSQL state: 42501"please help me.Thank you in advance Link to comment Share on other sites More sharing options...
Krydos Posted July 25, 2018 Share Posted July 25, 2018 Did you synchronize grants? Link to comment Share on other sites More sharing options...
closer Posted July 25, 2018 Author Share Posted July 25, 2018 Did you synchronize grants?Yes, I synchronized grants but not working Link to comment Share on other sites More sharing options...
Krydos Posted July 25, 2018 Share Posted July 25, 2018 Which postgresql user are your trying with? Link to comment Share on other sites More sharing options...
closer Posted July 25, 2018 Author Share Posted July 25, 2018 Which postgresql user are your trying with?user : ducquang_mainOnly when I execute query use phppgadmin on cpanel it's fine. Run on others, it not working Link to comment Share on other sites More sharing options...
Krydos Posted July 25, 2018 Share Posted July 25, 2018 Try changing the password of ducquang_main. I deleted that user and recreated it and reassigned it to the database, but obviously I don't know what the password was. Link to comment Share on other sites More sharing options...
closer Posted July 26, 2018 Author Share Posted July 26, 2018 Krydos, on 26 Jul 2018 - 12:08 AM, said: Try changing the password of ducquang_main. I deleted that user and recreated it and reassigned it to the database, but obviously I don't know what the password was.thank you so much! it working Link to comment Share on other sites More sharing options...
Recommended Posts