I am new to open source technology and have no idea what I am seeing when I open source code files, still very much in the monkey-see, monkey-do stage. My business runs an expensive generic (Windows) accounting software package that is excellent in what it can do, but prohibitively expensive for each module. We are opening a shop on 1 March, and I want to see if SQL-Ledger is what our business needs.
SQL- Ledger Installation
I have managed to install all the required modules in my signature below successfully on my local server from the command line.
The install from Ubuntu Software Centre doesn't appear to work. It has installed somewhere on my system, but I couldn't find it anywhere on the system.
1. I downloaded SQL-Ledger tar to /downloads, extracted to same and moved the setup.pl file into the /usr/local/sql-ledger and ran the perl setup.pl setup option. - successfully installed into /usr/local/sql-ledger
2. Went to PREPARE YOUR SQL DATABASE SERVER.
2.1 # su postgres
2.2 createuser -d sql-ledger
No question Shall the new user be allowed to create more new users?
Created a password user
2.3 createuser -d -P sql-ledger
2.4 Password entered and accepted
3. Went to CREATE DATASET WITHOUT CREATE PRIVILEGES
Have absolutely no idea what to do with this app. The connect option opens a window with:
3.1. Name - I tried Apache2, Apache my name
3.2 Host ? - left blank
3.3 Port - 5432
3.4 Service - left blank
3.5 Maintenance DB - postgres
3.6 Username - postgres
3.7 Password - My Password- I have used the same password throughout.
Opened Help. Huh? Tried all kinds of combinations of names
/localhost displays Apache2 Ubuntu Default Page
4. Permissions set to:
chown -R patrick:patrick sql-ledger
chown -R patrick:patrick apache2
chown -hR www-data:www-data users templates css spool doc
This may be the problem - but like I said above, I am newbie and am walking blind
I can't get past /localhost/sql-ledger/admin.pl or /localhost/sql-ledger/login.pl. My browser just wants me to download or open those files.
Thanks in advance
Ubuntu 14.04 LTS
php5.5.9, Apache 2, Perl 5.18.2 pSQL 9.5.0