Thread: [Personalbackup-users] Web login cycling

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Kind list's members

in order to restest the whole install process
before starting with production phase,
this morning I've made a fresh Fedora 2 install
on a test machine and fresh downloaded Personalbackup
from CVS.

Installation has gone fine, like in previous tests, but
when I try to log in personalbackup's web interface
as admin, the browser reloads the login.cgi page with
no-erros or warns.
If I submit wrong user/password the
"Wrong password or username, please try again"
message is correctly displayed, but with correct
one the log-in is reloaded forever.

I've tryed to figure-out the problem with no success.

Hope you can help me.

Logs in attachment:
httpd.conf
httpd's access_log
personalbackup.conf
postgresql's log
httpd's error_log

Thank you for your kind support.

Best regards

Raf

####### httpd.conf

# PERSONALBACKUP
Alias personalbackup /var/www/html/personalbackup
<DirectoryMatch /var/www/html/personalbackup>
       DirectoryIndex index.cgi
       AllowOverride None
       Order allow,deny
       Allow from all
       Options ExecCGI
       AddHandler cgi-script .cgi
</DirectoryMatch>

####### access_log:

192.168.0.1 - - [01/Feb/2006:10:49:22 +0100] "POST /personalbackup/login.cgi
HTTP/1.1" 200 105 "http://192.168.0.3/personalbackup/login.cgi" "Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
192.168.0.1 - - [01/Feb/2006:10:49:28 +0100] "GET
/personalbackup/index.cgi?CGISESSID=650060641ceef884b2391b70c7b4bbdf
HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
NET CLR 1.1.4322)"
192.168.0.1 - - [01/Feb/2006:10:49:36 +0100] "GET /personalbackup/style.css
HTTP/1.1" 304 - "http://192.168.0.3/personalbackup/login.cgi" "Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"
192.168.0.1 - - [01/Feb/2006:10:49:31 +0100] "GET /personalbackup/login.cgi
HTTP/1.1" 200 1576 "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
SV1; .NET CLR 1.1.4322)"
192.168.0.1 - - [01/Feb/2006:10:49:36 +0100] "GET
/personalbackup/images/background.gif HTTP/1.1" 304 -
"http://192.168.0.3/personalbackup/login.cgi" "Mozilla/4.0 (compatible; MSIE
6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)"

###### PERSONALBACKUP.CONF

#
# PersonalBackup configuration file
#

# $Header: /cvsroot/personalbackup/personalbackup/personalbackup.conf,v 1.29 
2006/01/09 01:32:21 linuxtuxie Exp $

#############################################################################
# PersonalBackup -  A company-wide solution for backing up all your 
#
#                   Windows machines and Samba shares 
#
# 
#
# Copyright (C) 2004 Kim Kuylen / Melexis 
#
# 
#
# This program is free software; you can redistribute it and/or 
#
# modify it under the terms of the GNU General Public License 
#
# as published by the Free Software Foundation. 
#
#############################################################################

# The site name displayed on all HTML pages
$sitename = "PersonalBackup";

# The servername where the postgres database for PersonalBackup is located
$dbserver = "127.0.0.1";

# The database name which holds the PersonalBackup database schema
$dbname = "personalbackup";

# The postgres user which has access to the PersonalBackup database schema
$dbuser = "pbuser";

# The password of the postgres user mentioned above
$dbpasswd = "secret";

# The port on which the postgres database is listening
# The default port 5432 should be ok
$dbport = "5432";

# The server on which the PersonalBackup web-interface is installed.
# This can be the same machine as the database server
$webserver = "127.0.0.1";

# Enter the ip address of your wins server here so that PersonalBackup
# can find the ip-addresses of the netbios names
$winsserver = "127.0.0.1";

# The ip range which defines vpn access
$vpnrange = "10.32.0.0:10.32.0.100";

# Who will receive all the administration mails?
# The $suffix will automatically be added to this name, so do NOT place
# a @ here!
$administrator = "root";

# Where may PersonalBackup store its logfiles created pro machine?
$clientlogdir = "/var/log/personalbackup";

# Where are the PersonalBackup executables installed?
$installdir = "/usr/sbin";

# Where is is the PersonalBackup web interface installed?
$webinstalldir = "/var/www/html/personalbackup";

# The location of the PersonalBackup library
$libinstalldir = "/usr/lib/personalbackup";

# Where are the html templates stored?
$templatedir = "/var/www/html/personalbackup/templates";

# Where can PersonalBackup store its temporary files?
# Make sure it is big enough, this folder will also be used as temporary
# placeholder during restore operations.
$tempdir = "/backup/tmp";

# This folder holds the backups, make sure it is big enough.
$pooldir = "/backup/personalbackup/pool";

# Where is the configuration file located?
$confdir = "/etc/personalbackup";

# Which languages are available to the users?
$languages = {
#       "nl" => "Nederlands",
#       "fr" => "Francais",
#       "de" => "Deutch",
        "en" => "English"
};

# What's the default language we present new users?
# By default we are using Shakespeare's language ;)
$defaultlang = "en";

# What's the domain name
$suffix = "raf.local";

# What's the windows domain/workgroup name?
$workgroup = "RAF";

# Which Authentication method will you be using?
# Valid values are: ldap, passwd and database
$authentication = "database";

# Do you allow the creation of new accounts?
# If you select database as authentication method you need to set this
# value to 1. Otherwise you are not able to register new users.
$allowcreation = 0;

# Do you allow updates of the accounts in personalbackup?
# If set to 1 the users can change their password.
$allowupdate = 0;

# If you are using an ldap server to authenticate...define it's name here
$ldapserver = "ldap.acme.com";

# What's the ldap base?
$ldapbase = "dc=base";

# Where can I find the executables?
$mailprog = "/usr/sbin/sendmail";

$smbclient = "/usr/bin/smbclient";

$nmblookup = "/usr/bin/nmblookup";

$echo = "/bin/echo";

$mkdir = "/bin/mkdir";

$cp = "/bin/cp";

# At what time of the day do we start backing up again?
# By default the database will be reset at 23 hours
# If defined, we will also run the cleanup script at this moment.
$resettime = "23:00";

# Parameter which defines the maximum number of clients that PersonalBackup
# may start simultaniously
$maxclients = 5;

# How may seconds are we going to sleep if personalbackupd has processed all
# the machines ones?
$idletime = 900;

# Timeout in seconds when waiting for a successful backup. If no output
# is received during this
# time, then it is assumed that something has gone wrong during the backup,
# and the backup is terminated.
$clienttimeout = 7200;

# When PersonalBackup is actually busy with backing up the share it will
# perform regular pings to make sure the machine is still alive and
# kicking. You can set the interval between these checks here
# The default is set to 30 minutes
$pinginterval = 1800;

# Delay in seconds to wait for starting to backup after the user has
# received his warning message via mail
$messagedelay = 60;

# Set here the maximum retry value for unreachable shares pro day
$maxretry = 5;

# This parameters informs PersonalBackup when we think a backup may
# receive the label successful.
# If for example we set this parameter to 90, it means that if 
PersonalBackup
# backed up 90% or more datafiles from the remote machine, we label the
# backup as successful.
# You can set this parameter to 100%, however keep in mind that if
# PersonalBackup isn't able to backup one file of a complete backup
# of for example 1.000.000 files....the complete backup is marked as 
Failed!!
$backupthreshold = 90;

# If the next parameter is set to 1 PersonalBackup will read the CVS Entries
# file on the remote machine and skips all files that are
# referenced in this file.
# We are assuming that the files under cvs are already backed up by the
# CVS server :)
# If you still want to backup all the files that are located under CVS set
# the parameter to 0
$excludecvs = 1;

# Determine the default maximum backup size in Mb for each share.
# Set this parameter to 0 to disable this feature.
# The maximum backup size can also be set pro share in the administrator
# interface.
$defaultbackupsize = 0;

# Determine the default maximum vpn backup size in Mb for each share.
# Set this parameter to 0 to disable this feature.
# The maximum vpn backup size can also be set pro share in the administrator
# interface and the user also has the ability to set this parameter.
$defaultvpnsize = 0;

# Determine here the maximum allowed restore size in Mb which can be used
# by the end users with the restore web interface.
# You can set this to 0 to disable this feature.
# However keep in mind that you will probably bounce against the 2Gb file
# limit (Unless you are using Apache >=  2.2.0). Also keep in mind that
# this size is the uncompressed one...Each restore via the web interface
# will go through a zipping program...which will take a long time and 
consume
# a lot of cpu/memory for a big restore.
# A possible workaround is to provide a Samba share for the pool, so that
# users can directly copy there data from this share.
# So in conclusion...the idea behind the restore interface is to get some
# files back quickly by the end user. It is not intended to restore a
# complete disk...that's currently beyond its purpose.
$maxrestoresize = 500;

# Do not backup the following folder/files!
# Also note that the matching performed is done case
# insensitive (so .Mp3 = .mp3 = .MP3 = .mP3)
# You can use all the regex expressions you know here :)
$excludefiles = [
        # do not backup bmp, gif, jpg, jpeg, mpg, mpeg, avi, asf, exe, pif,
        # src, bat, ppt, pps, com, vbs, mpe, pcx, png, vcf, wav, mp3,
        # mov and midi files from the attach folder
        "\/attach\/.*\.bmp",
        "\/attach\/.*\.gif",
        "\/attach\/.*\.jpg",
        "\/attach\/.*\.jpeg",
        "\/attach\/.*\.mpg",
        "\/attach\/.*\.mpeg",
        "\/attach\/.*\.avi",
        "\/attach\/.*\.wmv",
        "\/attach\/.*\.asf",
        "\/attach\/.*\.exe",
        "\/attach\/.*\.pif",
        "\/attach\/.*\.scr",
        "\/attach\/.*\.bat",
        "\/attach\/.*\.ppt",
        "\/attach\/.*\.pps",
        "\/attach\/.*\.com",
        "\/attach\/.*\.vbs",
        "\/attach\/.*\.mpe",
        "\/attach\/.*\.pcx",
        "\/attach\/.*\.png",
        "\/attach\/.*\.vcf",
        "\/attach\/.*\.wav",
        "\/attach\/.*\.mp3",
        "\/attach\/.*\.mov",
        "\/attach\/.*\.midi",

        # Do not backup the netscape caching folders
        "\/netscape.*cache\/.*",

        # Do not backup the Eudora adds caching folders
        "\/eudpriv.*cache\/.*",

        # Do not backup the sockscap folders
        "\/users.*cache\/.*",

        # Do not backup windows installation files
        "\/win..\/.*\.cab",

        # Do not backup the windows recycle bin
        "\/recycled\/.*"
];

# This parameter defines the number of weeks we are going to wait before
# sending the users a mail to notify them that there backup was unsuccessful
# during these weeks. The user will only receive a mail if the backup is
# enabled AND if the user enabled mail notification.
# Set to 0 to disable this feature completely.
# The default value is set to 2 weeks
$notifyuser = 2;

# This parameter defines the number of backup sets you want to keep on disk.
# By default this is set to 3 backup sets, which means that 3 weeks of
# backups will be kept on disk. All backup sets
# greater than 3 will be processed by the cleanupscript.
# Set the parameter to 0 if you want to keep the backups forever on disk ;)
$maxbackup = 3;

# Define here what you want to do with backup sets that need to be archived
# A few suggestions come to mind :-)
# You could for example just delete them by using:
# "rm -rf \$backup_set";
#
# Or you could just copy them to a different location with the command:
# "cp -r \$backup_set /some_drive/some_folder";
#
# Or you could copy them to a different machine with the command
# (make sure you have an ssh-trust relation between the personalbackup
# machine and the remote machine)
# "scp -r \$backup_set remote_user@remote_machine:/remote_path";
#
# Or you could even write the names of the backup set to a file and process
# them later on yourself :)
# "echo \$backup_set >> /tmp/archive_files";
#
# Or....
#
# By default we are just going to write the backup set to a temp file :)
# Take note of the \$backup_set it MUST be there or the backup  will not
# be processed!!
$cleanupscript = "echo \$backup_set >> /tmp/archive_files";

# Change value to 1 to enable debugging
$DEBUG = 1;

1;

########### POSTGRESQL LOG

Feb  1 10:36:21 backup postgresql: Starting postgresql service:  succeeded
Feb  1 10:36:42 backup postgres[2726]: [4-1] LOG:  00000: connection 
received: host=backup.raf.local port=32787
Feb  1 10:36:42 backup postgres[2726]: [4-2] LOCATION:  BackendFork, 
postmaster.c:2395
Feb  1 10:36:42 backup postgres[2726]: [5-1] LOG:  00000: connection 
authorized: user=pbuser database=personalbackup
Feb  1 10:36:42 backup postgres[2726]: [5-2] LOCATION:  BackendFork, 
postmaster.c:2457
Feb  1 10:36:42 backup postgres[2726]: [6-1] LOG:  00000: statement: SELECT 
version()
Feb  1 10:36:42 backup postgres[2726]: [6-2] LOCATION:  pg_parse_query, 
postgres.c:464
Feb  1 10:36:43 backup postgres[2727]: [5-1] LOG:  00000: connection 
received: host=backup.raf.local port=32788
Feb  1 10:36:43 backup postgres[2727]: [5-2] LOCATION:  BackendFork, 
postmaster.c:2395
Feb  1 10:36:43 backup postgres[2727]: [6-1] LOG:  00000: connection 
authorized: user=pbuser database=personalbackup
Feb  1 10:36:43 backup postgres[2727]: [6-2] LOCATION:  BackendFork, 
postmaster.c:2457
Feb  1 10:36:43 backup postgres[2727]: [7-1] LOG:  00000: statement: SELECT 
version()
Feb  1 10:36:43 backup postgres[2727]: [7-2] LOCATION:  pg_parse_query, 
postgres.c:464
Feb  1 10:36:43 backup postgres[2727]: [10-1] LOG:  00000: statement: 
SELECT password, realname, emailadres FROM users WHERE
Feb  1 10:36:43 backup postgres[2727]: [10-2]  username='admin'
Feb  1 10:36:43 backup postgres[2727]: [10-3] LOCATION:  pg_parse_query, 
postgres.c:464
Feb  1 10:36:43 backup postgres[2726]: [9-1] LOG:  00000: statement: 
SELECT id FROM users WHERE username = 'admin'
Feb  1 10:36:43 backup postgres[2726]: [9-2] LOCATION:  pg_parse_query, 
postgres.c:464
Feb  1 10:36:46 backup postgres[2729]: [8-1] LOG:  00000: connection 
received: host=backup.raf.local port=32789
Feb  1 10:36:46 backup postgres[2729]: [8-2] LOCATION:  BackendFork, 
postmaster.c:2395
Feb  1 10:36:46 backup postgres[2729]: [9-1] LOG:  00000: connection 
authorized: user=pbuser database=personalbackup
Feb  1 10:36:46 backup postgres[2729]: [9-2] LOCATION:  BackendFork, 
postmaster.c:2457
Feb  1 10:36:46 backup postgres[2729]: [10-1] LOG:  00000: statement: SELECT 
version()
Feb  1 10:36:46 backup postgres[2729]: [10-2] LOCATION:  pg_parse_query, 
postgres.c:464
Feb  1 10:36:52 backup postgres[2731]: [10-1] LOG:  00000: connection 
received: host=backup.raf.local port=32790
Feb  1 10:36:52 backup postgres[2731]: [10-2] LOCATION:  BackendFork, 
postmaster.c:2395
Feb  1 10:36:52 backup postgres[2731]: [11-1] LOG:  00000: connection 
authorized: user=pbuser database=personalbackup
Feb  1 10:36:52 backup postgres[2731]: [11-2] LOCATION:  BackendFork, 
postmaster.c:2457
Feb  1 10:36:52 backup postgres[2731]: [12-1] LOG:  00000: statement: SELECT 
version()
Feb  1 10:36:52 backup postgres[2731]: [12-2] LOCATION:  pg_parse_query, 
postgres.c:464

######APACHE ERROR_LOG

[Wed Feb 01 10:42:32 2006] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Wed Feb 01 10:42:32 2006] [notice] LDAP: SSL support unavailable
[Wed Feb 01 10:42:32 2006] [notice] suEXEC mechanism enabled (wrapper: 
/usr/sbin/suexec)
[Wed Feb 01 10:42:32 2006] [info] Init: Initializing OpenSSL library
[Wed Feb 01 10:42:32 2006] [info] Init: Seeding PRNG with 256 bytes of 
entropy
[Wed Feb 01 10:42:32 2006] [info] Init: Generating temporary RSA private 
keys (512/1024 bits)
[Wed Feb 01 10:42:34 2006] [info] Init: Generating temporary DH parameters 
(512/1024 bits)
[Wed Feb 01 10:42:34 2006] [info] Init: Initializing (virtual) servers for 
SSL
[Wed Feb 01 10:42:34 2006] [info] Server: Apache/2.0.49, Interface: 
mod_ssl/2.0.49, Library: OpenSSL/0.9.7a
[Wed Feb 01 10:42:34 2006] [notice] Digest: generating secret for digest 
authentication ...
[Wed Feb 01 10:42:34 2006] [notice] Digest: done
[Wed Feb 01 10:42:34 2006] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Wed Feb 01 10:42:34 2006] [notice] LDAP: SSL support unavailable
[Wed Feb 01 10:42:34 2006] [info] Init: Initializing OpenSSL library
[Wed Feb 01 10:42:34 2006] [info] Init: Seeding PRNG with 256 bytes of 
entropy
[Wed Feb 01 10:42:34 2006] [info] Init: Generating temporary RSA private 
keys (512/1024 bits)
[Wed Feb 01 10:42:35 2006] [info] Init: Generating temporary DH parameters 
(512/1024 bits)
[Wed Feb 01 10:42:35 2006] [info] Shared memory session cache initialised
[Wed Feb 01 10:42:35 2006] [info] Init: Initializing (virtual) servers for 
SSL
[Wed Feb 01 10:42:35 2006] [info] Server: Apache/2.0.49, Interface: 
mod_ssl/2.0.49, Library: OpenSSL/0.9.7a
[Wed Feb 01 10:42:35 2006] [notice] Apache/2.0.49 (Fedora) configured --  
resuming normal operations
[Wed Feb 01 10:42:35 2006] [info] Server built: May  6 2004 07:15:13
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] LOG:  statement: 
SELECT version(), referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  parse tree:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {QUERY 
:commandType 1 :querySource 0 :canSetTag true :utilityStmt <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resultRelation 0 
:into <> :hasAggs false :hasSubLinks false :rtable <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :jointree {FROMEXPR 
:fromlist <> :quals <>} :rowMarks () :targetList, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] ({TARGETENTRY 
:resdom {RESDOM :resno 1 :restype 25 :restypmod -1 :resname, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] version 
:ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false} :expr, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] {FUNCEXPR :funcid 89 
:funcresulttype 25 :funcretset false :funcformat 0 :args, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] <>}}) :groupClause 
<> :havingQual <> :distinctClause <> :sortClause <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :limitOffset <> 
:limitCount <> :setOperations <> :resultRelations ()}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] , referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  plan:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {RESULT 
:startup_cost 0.00 :total_cost 0.01 :plan_rows 1 :plan_width 0, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :targetlist 
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 25 :restypmod -1, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resname version 
:ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] false} :expr 
{FUNCEXPR :funcid 89 :funcresulttype 25 :funcretset false, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :funcformat 0 :args 
<>}}) :qual <> :lefttree <> :righttree <> :initPlan <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :extParam () 
:allParam () :nParamExec 0 :resconstantqual <>}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] , referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] LOG:  statement: 
SELECT version(), referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  parse tree:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {QUERY 
:commandType 1 :querySource 0 :canSetTag true :utilityStmt <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resultRelation 0 
:into <> :hasAggs false :hasSubLinks false :rtable <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :jointree {FROMEXPR 
:fromlist <> :quals <>} :rowMarks () :targetList, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] ({TARGETENTRY 
:resdom {RESDOM :resno 1 :restype 25 :restypmod -1 :resname, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] version 
:ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false} :expr, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] {FUNCEXPR :funcid 89 
:funcresulttype 25 :funcretset false :funcformat 0 :args, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] <>}}) :groupClause 
<> :havingQual <> :distinctClause <> :sortClause <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :limitOffset <> 
:limitCount <> :setOperations <> :resultRelations ()}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] , referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  plan:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {RESULT 
:startup_cost 0.00 :total_cost 0.01 :plan_rows 1 :plan_width 0, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :targetlist 
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 25 :restypmod -1, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resname version 
:ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] false} :expr 
{FUNCEXPR :funcid 89 :funcresulttype 25 :funcretset false, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :funcformat 0 :args 
<>}}) :qual <> :lefttree <> :righttree <> :initPlan <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :extParam () 
:allParam () :nParamExec 0 :resconstantqual <>}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] , referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] LOG:  statement: 
SELECT password, realname, emailadres FROM users WHERE username='admin', 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  parse tree:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {QUERY 
:commandType 1 :querySource 0 :canSetTag true :utilityStmt <>, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resultRelation 0 
:into <> :hasAggs false :hasSubLinks false :rtable ({RTE, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :alias <> :eref 
{ALIAS :aliasname users :colnames ("id" "username" "password", referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] "realname" 
"emailadres" "language" "admin")} :rtekind 0 :relid 17523 :inh true, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :inFromCl true 
:checkForRead true :checkForWrite false :checkAsUser 0}), referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :jointree {FROMEXPR 
:fromlist ({RANGETBLREF :rtindex 1}) :quals {OPEXPR :opno, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 98 :opfuncid 0 
:opresulttype 16 :opretset false :args ({RELABELTYPE :arg {VAR, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varno 1 :varattno 2 
:vartype 1043 :vartypmod 260 :varlevelsup 0 :varnoold 1, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varoattno 2} 
:resulttype 25 :resulttypmod -1 :relabelformat 2} {CONST, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :consttype 25 
:constlen -1 :constbyval false :constisnull false :constvalue 9, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] [ 9 0 0 0 97 100 109 
105 110 ]})}} :rowMarks () :targetList ({TARGETENTRY, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resdom {RESDOM 
:resno 1 :restype 1043 :restypmod 260 :resname password, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :ressortgroupref 0 
:resorigtbl 17523 :resorigcol 3 :resjunk false} :expr {VAR, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varno 1 :varattno 3 
:vartype 1043 :vartypmod 260 :varlevelsup 0 :varnoold 1, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varoattno 3}} 
{TARGETENTRY :resdom {RESDOM :resno 2 :restype 1043 :restypmod, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 260 :resname 
realname :ressortgroupref 0 :resorigtbl 17523 :resorigcol 4, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resjunk false} 
:expr {VAR :varno 1 :varattno 4 :vartype 1043 :vartypmod 260, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varlevelsup 0 
:varnoold 1 :varoattno 4}} {TARGETENTRY :resdom {RESDOM :resno, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 3 :restype 1043 
:restypmod 260 :resname emailadres :ressortgroupref 0, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resorigtbl 17523 
:resorigcol 5 :resjunk false} :expr {VAR :varno 1 :varattno, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 5 :vartype 1043 
:vartypmod 260 :varlevelsup 0 :varnoold 1 :varoattno 5}}), referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :groupClause <> 
:havingQual <> :distinctClause <> :sortClause <> :limitOffset, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] <> :limitCount <> 
:setOperations <> :resultRelations ()}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] , referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DEBUG:  plan:, 
referer: http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] DETAIL:  {INDEXSCAN 
:startup_cost 0.00 :total_cost 4.82 :plan_rows 2 :plan_width 438, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :targetlist 
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 1043 :restypmod, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 260 :resname 
password :ressortgroupref 0 :resorigtbl 17523 :resorigcol 3, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resjunk false} 
:expr {VAR :varno 1 :varattno 3 :vartype 1043 :vartypmod 260, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :varlevelsup 0 
:varnoold 1 :varoattno 3}} {TARGETENTRY :resdom {RESDOM :resno, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 2 :restype 1043 
:restypmod 260 :resname realname :ressortgroupref 0, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] :resorigtbl 17523 
:resorigcol 4 :resjunk false} :expr {VAR :varno 1 :varattno, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [client 192.168.0.1] 4 :vartype 1043 
:vartypmod 260 :varlevelsup 0 :varnoold 1 :varoattno 4}}, referer: 
http://192.168.0.3/personalbackup/login.cgi
[Wed Feb 01 10:42:48 2006] [error] [...

[truncated message content]

Thread: [Personalbackup-users] Web login cycling

personalbackup-users