Randy; After you install Sql-ledger, be sure to get the patch and apply that too. I neglect that step and had some slight problems.
I installed Sql-Ledger about 2 weeks ago. To create the user, the command to it is: /usr/local/pgsql/bin/createuser -d -P myuser -d means that this user can create data bases -P means that you will be prompted for a password (My system is Red Hat 7.1, but since I installed PostgreSQL afterwards from sources, my path may be different from yours). If you make a mistake just use: /usr/local/pgsql/bin/dropuser myuser You can get more details from http://www.postgresql.org/idocs/index.php?app-createuser.html After that it was reall easy. I connetced with the admin user to http://your.url/sql-ledger/admin.pl (you have to set up the web server to recgnize the url this way) and went into Pg Database Administration. There I created a data base for each "company" I plan to use, using the user created previously. No problem at all. This set up all the tables and created a set of accounts. Then I went in and changed the admin password. Finally I created some users for each "company" (database). Then it was ready to go. Miguel Randy Just wrote: >Hello there fellow SQL-Ledger users. > >I tried out the demo mode of the product and like what I see. However, >trying to get things up and running on my server here has been a problematic >process. > >I have Red Hat 7.3 up and running on my server. PostgreSQL is installed >as well. > >Working through the instructions >(http://abacus.sql-ledger.org/source/readme.txt) >I am up to SET PERMISSION: That has been completed and everything looks >good. > >Now the problems start. I am trying to do "PREPARE YOUR SQL SERVER:" > >My experience level with PostgreSQL can be measured in minutes, so the >instruction of "add on database user with create database privileges >to manage the datasets and tables for SQL-Ledger > >You can add more database users to keep dataset separated. Each >dataset belongs to one company" > >I am uncertain as to how I go about any of the above. Reviewing the PostgreSQL >documentation goes into the process of setting up users, but I am uncertain >of the tie-in between SQL-Ledger and the setting up of the database and tables. > >Also, once I complete the above, there is the step on SETUP A DATABASE AND THE >TABLES: I am assuming once I complete PREPARE YOUR SQL SERVER, >this will come easily. > >In a nutshell, how do I go about the process of doing "PREPARE YOUR SQL >SERVER:"? > >Thanks! > >Just Computers! - Phone: 209-369-6550 FAX: 209-367-8518 >E-mail: [EMAIL PROTECTED] > > >------------------------------------------------------- >Sponsored by: >ThinkGeek at http://www.ThinkGeek.com/ >_______________________________________________ >sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >Archive http://www.mail-archive.com/[email protected]/ > ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/
