On Tue, Oct 4, 2011 at 12:13 AM, Dave Babb <[email protected]> wrote: > I used the script to delete the database, then launched the setup.pl script > from > the web browser. Here is what happened. This is just an FYI. > > I can get back up and running by running the bsah scripts....But you said to > use > one or the other....So I choose to attempt to setup things in the web-browser > as > a test. The roadmap to recreate follows and the results... > > a) Used script to remove DB in the 'orthodox' fashion. Told the script to > remove > the ledgersmb and admin users at the same time. > b) Went to '/var/loag/apache2' and deleted the error.log file. > c) Restarted Apache2. > d) "su postgres" verified that ledgersmb and admin did not exist, neither did > the "aci" database. > e) createuser -d -P admin:admin, superuser "y". > f) Restarted postgresql. > g Logged in with "admin:admin:aci" > h) Was prompted "Database does not exist. Create Database?. I answered yes and > then pressed next. The HDD in the VM got busy for a while > f) I selected the country code of US. Pressed next. > g) Selected "Manufacturing.sql", pressed Next. > h) the following error in the web browser: > > 42883:ERROR: function public.person__list_salutations() does not exist > LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No > function > matches the given name and argument types. You might need to add explicit type > casts. > > > Contents of the apache2 'error.log": > > [Tue Oct 04 01:08:42 2011] [notice] Apache/2.2.16 (Debian) configured -- > resuming normal operations > DBI connect('dbname=aci','admin',...) failed: FATAL: database "aci" does not > exist at LedgerSMB/Database.pm line 181 > Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db > handle dbname=template1 at scripts/setup.pl line 57. > DBD::Pg::st execute failed: ERROR: function public.person__list_salutations() > does not exist > LINE 1: SELECT * FROM "public"."person__list_salutations"() > ^ > HINT: No function matches the given name and argument types. You might need > to > add explicit type casts. at LedgerSMB.pm line 781. > 2011/10/04 01:10:56 - ERROR Logging SQL State 42883, error 7, string ERROR: > function public.person__list_salutations() does not exist > LINE 1: SELECT * FROM "public"."person__list_salutations"() > ^ > HINT: No function matches the given name and argument types. You might need > to > add explicit type casts. > ERROR - Logging SQL State 42883, error 7, string ERROR: function > public.person__list_salutations() does not exist > LINE 1: SELECT * FROM "public"."person__list_salutations"() > ^ > HINT: No function matches the given name and argument types. You might need > to > add explicit type casts. > [Tue Oct 04 01:11:00 2011] [error] [client 127.0.0.1] File does not exist: > /var/www/favicon.ico > Could you include the following files here: /tmp/dblog /tmp/dblog_stderr /tmp/dblog_stdout
if not there, try creating a new db and if the same error occurs attach those files. Best Wishes, Chris Travers ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
