For LedgerSMB I have tried three different users and the result is always the same when using the setup.pl (Internal Server Error/Error Creating Back) but essentially no password supplied.
After I click login on first screen the second screen shows me 1.User logged in as USERNAME inputted 2. Database does not exist. 3. Create Database? ---only option is Yes 4. Backup ---Backup DB --Backup Roles I select Yes to create Database Then Internal Server Error with the following in the error report: [Fri Nov 09 01:14:46 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:46 2012] [error] [client 127.0.0.1] Fri Nov 9 01:14:43 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:46 2012] [error] [client 127.0.0.1] Use of uninitialized value $msg_plus in concatenation (.) or string at LedgerSMB/Auth.pm line 79.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:46 2012] [error] [client 127.0.0.1] DBI connect('dbname=template1','',...) failed: fe_sendauth: no password supplied at LedgerSMB.pm line 986.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:50 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:50 2012] [error] [client 127.0.0.1] Fri Nov 9 01:14:47 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:55 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:55 2012] [error] [client 127.0.0.1] Fri Nov 9 01:14:51 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:14:55 2012] [error] [client 127.0.0.1] DBI connect('dbname=exampleco','ledgersmb',...) failed: FATAL: database "exampleco" does not exist at LedgerSMB/Database.pm line 287.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] Premature end of script headers: setup.pl, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] Fri Nov 9 01:15:08 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] DBI connect('dbname=template1','',...) failed: fe_sendauth: no password supplied at LedgerSMB/Database.pm line 424.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] Can't call method "quote_identifier" on unblessed reference at LedgerSMB/Database.pm line 428.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:15:11 2012] [error] [client 127.0.0.1] Compilation failed in require at C:/wamp/apps/ledgersmb/setup.pl line 8.\r, referer: http://localhost:8080/ledgersmb/setup.pl If i try pointing the script at a database that does exist I get the following which indicates to me that a connection was made After I click login on first screen the second screen shows me 1.User logged in as USERNAME inputted 2. Unknown Database Found 3. Cancel? ---only option is Yes 4. Backup ---Backup DB --Backup Roles I select Cancel and am taken back to the setup home screen with the following in the error report: [Fri Nov 09 01:49:03 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r [Fri Nov 09 01:49:03 2012] [error] [client 127.0.0.1] Fri Nov 9 01:48:59 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r [Fri Nov 09 01:49:27 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:27 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:23 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:27 2012] [error] [client 127.0.0.1] Use of uninitialized value $msg_plus in concatenation (.) or string at LedgerSMB/Auth.pm line 79.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:27 2012] [error] [client 127.0.0.1] DBI connect('dbname=template1','',...) failed: fe_sendauth: no password supplied at LedgerSMB.pm line 986.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:31 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:31 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:27 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:35 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:35 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:31 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:35 2012] [error] [client 127.0.0.1] Use of uninitialized value $msg_plus in concatenation (.) or string at LedgerSMB/Auth.pm line 79.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:35 2012] [error] [client 127.0.0.1] DBI connect('dbname=template1','',...) failed: fe_sendauth: no password supplied at LedgerSMB.pm line 986.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:31 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT version FROM defaults\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 326.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT value FROM defaults WHERE setting_key = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 341.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 342.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] LINE 1: SELECT fldvalue FROM defaults WHERE fldname = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 359.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:36 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 360.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:39 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:39 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:36 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:40 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] LINE 1: SELECT version FROM defaults\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 326.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] LINE 1: SELECT value FROM defaults WHERE setting_key = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 341.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 342.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] LINE 1: SELECT fldvalue FROM defaults WHERE fldname = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 359.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:44 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 360.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:56 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:49:56 2012] [error] [client 127.0.0.1] Fri Nov 9 01:49:52 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl If i try pointing the script at a database that does exist I get the following which indicates to me again that a connection was made After I click login on first screen the second screen shows me 1.User logged in as USERNAME inputted 2. Unknown Database Found 3. Cancel? ---only option is Yes 4. Backup ---Backup DB --Backup Roles I select create Backup DB Then Error! Error creating backup file with the following in the error report: [Fri Nov 09 01:21:58 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r [Fri Nov 09 01:21:58 2012] [error] [client 127.0.0.1] Fri Nov 9 01:21:54 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r [Fri Nov 09 01:26:46 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:46 2012] [error] [client 127.0.0.1] Fri Nov 9 01:26:42 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:46 2012] [error] [client 127.0.0.1] Use of uninitialized value $msg_plus in concatenation (.) or string at LedgerSMB/Auth.pm line 79.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:46 2012] [error] [client 127.0.0.1] DBI connect('dbname=template1','',...) failed: fe_sendauth: no password supplied at LedgerSMB.pm line 986.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:50 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:50 2012] [error] [client 127.0.0.1] Fri Nov 9 01:26:46 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] Fri Nov 9 01:26:50 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] LINE 1: SELECT version FROM defaults\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 326.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] LINE 1: SELECT value FROM defaults WHERE setting_key = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 341.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 342.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR: relation "defaults" does not exist\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] LINE 1: SELECT fldvalue FROM defaults WHERE fldname = $1\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] ^ at LedgerSMB/Database.pm line 359.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:26:54 2012] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 360.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:18 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:18 2012] [error] [client 127.0.0.1] Fri Nov 9 01:28:14 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] The syntax of the command is incorrect.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] Fri Nov 9 01:28:31 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=256\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] 'pg_dump' is not recognized as an internal or external command,\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] operable program or batch file.\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] 2012/11/09 01:28:35 - ERROR - LedgerSMB::Database::db_backup LedgerSMB/Database.pm (166) -- backup failed: non-zero exit code from pg_dump\r, referer: http://localhost:8080/ledgersmb/setup.pl [Fri Nov 09 01:28:35 2012] [error] [client 127.0.0.1] Directory index forbidden by Options directive: C:/wamp/apps/ledgersmb/css/, referer: http://localhost:8080/ledgersmb/setup.pl I have look at the ledgersmb. conf and made sure that this was done # For Windows, uncomment the pathsep line: pathsep : ; and that the contrib_dir was set correctly. The only thing that I am noticing is that the temp directory does not appear to be created even though the error records are indicating that it is. Specs: Windows XP SP3 Strawberry Perl 5.16.2 PostgreSQL 9.2 From: "Robert J. Clay" <rjc...@gmail.com> On Thu, Nov 8, 2012 at 4:58 AM, D J <renderzdr...@yahoo.com> wrote: > Hopefully someone can assist me with this problem. > I can access the page setup page with no problem, and additionally > enter my credentials Which ones? > which allows me to go to the next screen in which I am informed > that the database needs to be created and would I like for it to be > created I indicate yes. Then the next thing that happens is an internal > server error. > > Which lists the following: .... > in the ledgersmb.conf I do not see where I am supposed to put a db usr > and password so how is this supposed to connect using setup.pl? You're not entering one on that setup.pl screen? Or at least a password for it, since IIRC it defaults to the user postgres? (Though even for a windows install, I'd create a separate DB superuser for LedgerSMB related ops.) ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
