Hi,
I do not know if it's too much to ask, but would it be possible to write a new tutorial for Linux beginners with no previous experience?
I'm in 2 other game development scenes, but there is Windows the main OS, so I don't have a big clue about Linux.
I'm pretty sure if somebody do this, this would help many people here.
But thanks anyway for the great tutorial!
(PS.: Sorry for my bad English)
Hi.
I've been having a problem where in Navicat the postgresql connection keeps failing. I have tried everything I can think of (I'm no expert) and I have seen posts of others having the same/similar problem, but have solved it and have not giving any info on how.
I have tried a lot of things and would rather not at the moment because I'm afraid further experiments of mine may cause me to go backwards instead of going forwards. Anyone who knows the solution would be helpful.
I have changed the config from md5 and trust on the connections and nothing changes.
I have tried other commands that ended up causing the service to fail.
I have fixed my VMware problem where it needed to have a bridged connection.
Every other change I made I also restarted the service and rebooted to see if anything would change.
make sure your network settings in vm are set to bridged connection and promiscuous mode is set to allow allOriginally Posted by Geordan9
Hi.
I've been having a problem where in Navicat the postgresql connection keeps failing. I have tried everything I can think of (I'm no expert) and I have seen posts of others having the same/similar problem, but have solved it and have not giving any info on how.
I have tried a lot of things and would rather not at the moment because I'm afraid further experiments of mine may cause me to go backwards instead of going forwards. Anyone who knows the solution would be helpful.
I have changed the config from md5 and trust on the connections and nothing changes.
I have tried other commands that ended up causing the service to fail.
I have fixed my VMware problem where it needed to have a bridged connection.
Every other change I made I also restarted the service and rebooted to see if anything would change.
go to /var/lib/pgsql/9.3/data/postgresql.conf
add or make sure this is there: listen_addresses='*'
go to /var/lib/pgsql/9.3/data/pg_hba.conf
make sure these are the only uncommitted entrys in the file.
local all all peer
host all all 127.0.0.1/32 md5
host all all samenet md5
host all all ::1/128 ident
restart pgsql or server
Hey i don't understand how to make the server work on VPS / enable an IP like 5.1.90.80
Did i miss somehting?
Server is still rolling on 0.0.0.0 :(
Already used IP patcher
Last edited by nevudu; 31-01-16 at 06:39 PM.
Thanks for reply, but...
What would be the method in allowing promiscuous mode in my virtual machine (VMware). I tried "chmod a+rw /dev/vmnet0" and it said no file or directory found. I went into /etc/sysconfig/network-scripts/ifcfg-eth0 and edited it to have PROMISC=yes. Nothing seems to have a change. If it is changing and it is set to be allowed etc. Then why am I unable to connect with Navicat.
look @ your pg_hba.conf @ IPv4 it should look like this.Thanks for reply, but...
What would be the method in allowing promiscuous mode in my virtual machine (VMware). I tried "chmod a+rw /dev/vmnet0" and it said no file or directory found. I went into /etc/sysconfig/network-scripts/ifcfg-eth0 and edited it to have PROMISC=yes. Nothing seems to have a change. If it is changing and it is set to be allowed etc. Then why am I unable to connect with Navicat
Code:# IPv4 local connections: host all all <your ip>/32 trust
Ugh. O_O I tried but nothing changes. When it says <your ip> I'm not sure which one but i tried the one my computer has then the one my virtual machine has and then tried my external ip. Nothing...
Here is everything thing I think is important to know about my problem:
This is my pg_hba.conf:
This is my postgresql.conf:
This is my ifconfig of my virtual machine:
This is how I am connecting with Navicat:
Anything look off or odd?
Put your windows ip there
I mean lan ip ofc
Tapatalk-kal küldve az én LG-D802-el
Does anybody have a live demo of this?
Now tell me how to solve the server is rolling on 0.0.0.0 bug :c
0.0.0.0 is a dynamic ip, are you trying to set it up for yourself on local computer or public?
Rolling on 0.0.0.0 means u made smth wrong
Tapatalk-kal küldve az én LG-D802-el
Im running a VPS
and ik 0.0.0.0 means something is wrong :(
Run it with 127.0.0.1
Yeah.. how to manage this im completly overwhelmed. rip.
My Worlds & Serverstatus tables are looking like this
Somebody told me int_adress cant be 127.0.0.1 dunno if its true.
Screenshot by Lightshot
Screenshot by Lightshot
Reply With Quote
