[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Setup.pl not connecting completely on windows xp
- Subject: Re: Setup.pl not connecting completely on windows xp
- From: D J <..hidden..>
- Date: Fri, 9 Nov 2012 00:34:59 -0800 (PST)
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" <..hidden..>
On Thu, Nov 8, 2012 at 4:58 AM, D J <..hidden..> 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.)