Installing MultiUser xTuple, got db into Postgre,cant connect with Clients

 

jlmartinjr's picture

I am attempting to install xTuple on a server so that I can have 6 different folks in my company evaluate the software, I have downloaded Postgre and installed it on a server, I followed the instructions to restore the demo data. It appears to have installed properly. The service is running. I downloaded the client s/w and installed it on a workstation.
When I go to attempt to load the client I get the cannot connect to xTuple ERP server
Are there any "tools" that I could use to figure out what I have wrong?

 
ned
ned's picture
Offline
Joined: 10/20/2008
Postgres settings?

By default, PostgreSQL is configured only to allow connections from the same local machine - for security reasons. Take a look at your pg_hba.conf and postgresql.conf files - the two text files that control user access and other settings.

 
jlmartinjr's picture
Offline
Joined: 04/27/2009
Thank you for the quick

Thank you for the quick resonse, I have looked at the files that are in c:\program files\Pos....\8.3\data
I looked with them both using the pgAdmin and the notebook editor, any idea of what I would be looking for to make the change

 
ned
ned's picture
Offline
Joined: 10/20/2008
Re: Reply posted in xTuple Forum topic How do I ...?: Installing MultiUser xTuple, got db into Postgre,cant connect with Clients

Check the links to the two pages of Postgres documentation I included. Understanding how those files work is important.

 
jlmartinjr's picture
Offline
Joined: 04/27/2009
Thank for your help I have

Thank for your help
I have read over the information that you provided, thanks. I have tried a couple of things but I have not had much luck.
I did put the client s/w on the server computer to make sure that I have a working PostgreSQL, get into xtuple on the server.

I have a network running on 192.168.50.0/254

Any Ideas???

 
gmoskowitz's picture
Offline
Joined: 12/10/2008
Re: Installing MultiUser xTuple, got db into Postgre,cant connec

jlmartinjr,

You didn't give many details so it's hard to know what's wrong.

In your pg_hba.conf, change 192.168.50.0/254 to 192.168.50.0/24 (remove the 5 in the middle of the address mask). If you haven't done so already, you should also change the listen_address value in postgresql.conf. Then you need to restart your database server:
pg_ctl -D your-pg-data-directory restart

Gil

 
jlmartinjr's picture
Offline
Joined: 04/27/2009
Gil the machine that I am

Gil the machine that I am trying to connect to on the network is 192.168.50.12 (to Start with) I am unclear about the 0/24 from 0/254. I went to change listen_address value, Not sure exactly what I was doing as you can see. Once I put a line under the listen_address 192.168.50.0/24. Once I did that I was not able to reconnect from the client or the server, I put it back to see what I had done wrong. Once I took out the second line of listen_address I was able to do everything back again on the server but still not the 192.168.50.112 machine, I will keep fiddling with it.

 
jlmartinjr's picture
Offline
Joined: 04/27/2009
I have begun to play with the

I have begun to play with the system on the server using the client s/w, I have found that if I create a user and give them privledges to everything, if I exit and log in as that user I do not get the icons across the top on all the modules like I do with the admin login account

 
gmoskowitz's picture
Offline
Joined: 12/10/2008
missing toolbar icons

jlmartinjr,

This is a common problem - the act of giving a user permissions does not make the menus or toolbars visible. To make them visible, either the admin or the user has to go to System -> Preferences (might be xTuple -> Preferences on a Mac) and turn on particular menus and toolbars. Note that the user needs the MaintainPreferencesSelf privilege to do this him/herself; otherwise an admin user has to do it.

Gil

 
jlmartinjr's picture
Offline
Joined: 04/27/2009
can log in now

I have gotten the Postgres installed so that I can access the SQL server from clients on different machines, How ever I can only log in as admin, and when I do I get an error message "A critical Error occured at guiclient.cpp::296", and when I click OK it goes ahead and loads the program and I get the menus etc. I have created other user names and give them priviledges but they are not able to log in.

 
hameed's picture
Offline
Joined: 11/09/2008
I had the same problem and

I had the same problem and I'm not finding a clear help to solve this issue which must be clear by xtuple team , the scenario is two laptops with windows xp one of them maintain the server which has this IP (169.254.20.225) the other is the client which maintain the client which has this IP (169.254.70.48) , I modified the pg_hba.conf and postgresql.conf but the question here in the client machine when I'm going to start xtuple the login windows appear and then I press the login options which include the server field , what can I write in the server field here ? is it the IP address of the server or what , anyway I tried this but I failed to connect to postgresql server

can anybody help in that important topic , and also can any body in the developing team make video about the setup of multiuser environment specially in windows platform .

Thanks

 
hameed's picture
Offline
Joined: 11/09/2008
I had the same problem and

I had the same problem and I'm not finding a clear help to solve this issue which must be clear by xtuple team , the scenario is two laptops with windows xp one of them maintain the server which has this IP (169.254.20.225) the other is the client which maintain the client which has this IP (169.254.70.48) , I modified the pg_hba.conf and postgresql.conf but the question here in the client machine when I'm going to start xtuple the login windows appear and then I press the login options which include the server field , what can I write in the server field here ? is it the IP address of the server or what , anyway I tried this but I failed to connect to postgresql server

can anybody help in that important topic , and also can any body in the developing team make video about the setup of multiuser environment specially in windows platform .

Thanks

 
hameed's picture
Offline
Joined: 11/09/2008
I had the same problem and

I had the same problem and I'm not finding a clear help to solve this issue which must be clear by xtuple team , the scenario is two laptops with windows xp one of them maintain the server which has this IP (169.254.20.225) the other is the client which maintain the client which has this IP (169.254.70.48) , I modified the pg_hba.conf and postgresql.conf but the question here in the client machine when I'm going to start xtuple the login windows appear and then I press the login options which include the server field , what can I write in the server field here ? is it the IP address of the server or what , anyway I tried this but I failed to connect to postgresql server

can anybody help in that important topic , and also can any body in the developing team make video about the setup of multiuser environment specially in windows platform .

Thanks

 
hameed's picture
Offline
Joined: 11/09/2008
are there anybody here reply

are there anybody here reply on this important topic ?

 
hameed's picture
Offline
Joined: 11/09/2008
OK , I found a solution for

OK , I found a solution for that

Server Side

you have to open the pg_hba.confg and modify or add a new record through pgAdmin by opening pg_hba.confg file through it

in the type you have to select host
in the database select all
in user select all
in ip-address select 0.0.0.0 0.0.0.0
in Method you have to select md5
select check box enable
then save the pg_hba.confg file

then open file postgresql.confg file through pgadmin and select the record of listen_address and change its value from "localhost" to "*"
then save the postgresql.confg

now go to your control panel in windows xp and open windows firewall then go to the exceptions tab and click in add port and in the name write " postgres " and the port number will be 5432 then press OK

you have to configure the IP Address to a static IP address ( I'm writing here about per to per network under windows platform )

now your server will be ready to receive any requests from any xtuple client

Client Side

you have to change the server through the options of login windows from "localhost" to the preconfigured static IP of the server that we already configure before

then you write the database name , then click save

then you can enter the database user name and the password and connect to your xtuple

the previous steps for windows platform small networking type per to per

Thanks

 
Aprilolivia's picture
Offline
Joined: 07/19/2012
Has anyone found a solution

Has anyone found a solution for multiple connections to a Mac server from Mac client? Both running latest version of lion.

 

mead