setting up clients

Hi--

I should actually say that there aren't any user limits inherent in PostBooks. There are a couple of things that can trip up user creation, however, and the database can be configured to limit connections.

First, if the users you are creating contain special characters such as an apostrophe, you'll run into problems. Same thing with spaces.

If the problem is getting more than 10 concurrently connected, you'll need to check the postgresql.conf file. There is a setting there (max_connections) that determine how many concurrent connections are allowed by the database. The default is 100 so under normal circumstances this shouldn't be an issue, but depending on your installation this may be different.

Regards,
Steven C. Buttgereit
Muse Systems
www.musesystems.com

thanks for the feedback. users only have letters of the alphabet and numbers, user1, user2, user3, etc... Iam also connectiong using the server(im logging in thru the same computer used to install posgresql).

I decided to delete the login roles and make the m again. This time I got the following command when trying to log in to xtuple.

¨The specified Username does not exist in the specified Database. Contact your Systems Administrator to report this issue¨

it goes without saying that i am the owner and only user of the computer. Any ideas why this comes up now?

Using the pgAdmin III utility, click twice in your database, then twice in Login Roles, and check if your username is there

the usernames are there, and i still can login to my databaase. A few more details, I downloaded the demo database from the xtuple website..
The version of my xtuple is 3.2.2(as well as the demo).

Is this the only instance of PostgreSQL running? To Sergio's point, xTuple users are nothing more than PostgreSQL users with some additional attributes associated with them by xTuple. So the following conditions must be true for these accounts to work:

1. In xTuple they must be 'active'. (On the Maintain Users screen there's a checkbox for active). If when you earlier said that you 'deleted the login roles', if you meant that you made the accounts inactive in xTuple, they would still appear in pgAdmin III as regular users.
2. They must exist in PostgreSQL as login roles and the must have the login privilege ('Can Login?' in pgAdmin III).
3. They must have permission to connect in the pg_hba.conf file. If PostgreSQL is on your desktop computer, was installed using the xTuple installer, and you are only trying to use these other users from your desktop then this shouldn't be an issue for you.

(NOTE: I made a bad assumption in my original reply that the xTuple installer had been used, rereading the thread I realized that I shouldn't have concluded that and have removed that commentary)

Really, based on your description of symptoms it almost sounds like the client is trying to connect to a different PostgreSQL instance than your pgAdmin III.

I think if I were in your position, I would do the following troubleshooting steps:

1. Make sure that there is only one instance of PostgreSQL installed and that it is listening on the expected TCP port (usually 5432). I would probably do this with: netstat -lnp from the command line for Linux.
2. Make sure the connect options in the xTuple client match localhost, the port from the above step, and the database that you installed.
3. Look at pgAdmin III and be sure the users are in the PostgreSQL instance and are able to login, much as you've done.
4. Run the following query from pgAdmin against the xTuple database:
   

   select usr_username, usr_active from usr;
   

   and be sure that the usr_active field = 't'. This is a query against a view of the legacy user xTuple data structure, but gives a nice concise view of if the users can log into xTuple.

Beyond this, I'd need specific details related to xTuple connect options, Postgresql config files and some additional query outputs to help. Hopefully this is enough to get you started.

Regards,
Steven C. Buttgereit
Muse Systems
www.musesystems.com

actually it was a little simpler than that. i didnt have setup the acounts to be viewed thru xtuple. In other words, i created users in pgadmin but forgot to create the users in admin account for xtuple. your post made me look into the admin account and that is where i realized it.

hi5