Hi Bob, Thanks for your helping:)
I can log in fossology now!
The reason is fossology does not connect postgresql.
I modified /usr/local/share/fossology/www/plugins/core-db.php, remove:
$this->_pg_conn = pg_pconnect(str_replace(";", " ",
file_get_contents($path))); and add: $this->_pg_conn =
pg_pconnect("dbname=fossology user=fossy");
function db_init($Options="")
{
global $DATADIR, $PROJECT, $SYSCONFDIR;
if (isset($this->_pg_conn)) { return(1); }
$path="$SYSCONFDIR/$PROJECT/Db.conf";
if (empty($Options))
{
$this->_pg_conn = pg_pconnect("dbname=fossology user=fossy");
//$this->_pg_conn = pg_pconnect(str_replace(";", " ",
file_get_contents($path)));
}
else
{
$this->_pg_conn = pg_pconnect(str_replace(";", " ", $Options));
}
if (!isset($this->_pg_conn)) return(0);
$this->Error = 0;
return(1);
}
in my Db.conf:
dbname=fossology;
host=localhost;
user=fossy;
password=fossy;
but it is very strangely that after I run fo-postinstall, it says connect
db success. So I think it succuess, but when run php, it does not connect
at all....
Regards
Alice
Alice Liu/BJ/MTK
刘冰, DT/SED
Ext:83385 To
Bob Gobeille <bob.gobei...@hp.com>
2009-05-09 10:24 cc
fossology@fossology.org
Subject
Re: [FOSSology] [Fossology]I can't
login fossology, please help!
(Document link: Alice Liu)
Hi bob,
Thanks for your replying:)
This is a new 1.0 install. I have never used fossology before:)
This is my db infoamtion, How can I do next?
Thanks a lot:)
fossology=> \d
List of relations
Schema | Name | Type | Owner
--------+--------------------------------------------+----------+-------
public | agent | table | fossy
public | agent_agent_pk_seq | sequence | fossy
public | agent_lic_meta | table | fossy
public | agent_lic_meta_agent_lic_meta_pk_seq | sequence | fossy
public | agent_lic_phrases | table | fossy
public | agent_lic_raw | table | fossy
public | agent_lic_raw_lic_pk_seq | sequence | fossy
public | agent_lic_status | table | fossy
public | agent_wc | table | fossy
public | attrib | table | fossy
public | attrib_attrib_pk_seq | sequence | fossy
public | folder | table | fossy
public | folder_folder_pk_seq | sequence | fossy
public | foldercontents | table | fossy
public | foldercontents_foldercontents_pk_seq | sequence | fossy
public | folderlist | view | fossy
public | job | table | fossy
public | job_job_pk_seq | sequence | fossy
public | jobdepends | table | fossy
public | jobqueue | table | fossy
public | jobqueue_jq_pk_seq | sequence | fossy
public | key | table | fossy
public | key_key_pk_seq | sequence | fossy
public | keyagent | view | fossy
public | licgroup | table | fossy
public | licgroup_grps | table | fossy
public | licgroup_grps_licgroup_grps_pk_seq | sequence | fossy
public | licgroup_licgroup_pk_seq | sequence | fossy
public | licgroup_lics | table | fossy
public | licgroup_lics_licgroup_lics_pk_seq | sequence | fossy
public | licterm | table | fossy
public | licterm_grps_licterm_grps_pk_seq | sequence | fossy
public | licterm_licterm_pk_seq | sequence | fossy
public | licterm_map | table | fossy
public | licterm_map_licterm_map_pk_seq | sequence | fossy
public | licterm_maplic | table | fossy
public | licterm_maplic_licterm_maplic_pk_seq | sequence | fossy
public | licterm_name | table | fossy
public | licterm_name_licterm_name_pk_seq | sequence | fossy
public | licterm_words | table | fossy
public | licterm_words_licterm_words_pk_seq | sequence | fossy
public | log_log_pk_seq | sequence | fossy
public | mimetype | table | fossy
public | mimetype_mimetype_pk_seq | sequence | fossy
public | pfile | table | fossy
public | pfile_pfile_pk_seq | sequence | fossy
public | report_cache | table | fossy
public | report_cache_report_cache_pk_seq | sequence | fossy
public | report_cache_user | table | fossy
public | report_cache_user_report_cache_user_pk_seq | sequence | fossy
public | scheduler_status | table | fossy
public | sqlagentproc | table | fossy
public | sqlagentproc_sap_pk_seq | sequence | fossy
public | upload | table | fossy
public | upload_upload_pk_seq | sequence | fossy
public | uploadtree | table | fossy
public | uploadtree_uploadtree_pk_seq | sequence | fossy
public | users | table | fossy
public | users_user_pk_seq | sequence | fossy
(59 rows)
fossology=> select * from users_user_pk_seq ;
sequence_name | last_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called
-------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
users_user_pk_seq | 4 | 1 | 9223372036854775807 |
1 | 1 | 0 | f | t
(1 row)
Thanks,
Alice
Bob Gobeille
<bob.gobei...@hp.
com> To
Bob Gobeille Alice Liu <alice....@mediatek.com>
<bob.gobei...@hp. cc
com> fossology@fossology.org
Subject
2009-05-08 22:12 Re: [FOSSology] [Fossology]I can't
login fossology, please help!
Hi Alice,
I can't tell from the information you supplied - are you upgrading from a
previous version to 1.0? Or upgrading from a previous version to the
subversion top of tree? Or is this a new 1.0 install?
Thanks,
Bob
On May 8, 2009, at 8:08 AM, Gobeille, Robert wrote:
Hi Alice,
This all looks ok except for the not being able to log in part. Can
you use psql to query the fossology users table?
Thanks,
Bob Gobeille
On May 8, 2009, at 7:34 AM, Alice Liu wrote:
Hello,
I try to use Fossology, but after installation, use fossy as
username and pwd, but can't log in
about 'Search' 'Browse' can not access....
<07267908.gif>
Some Information:
[r...@localhost fossology]#
/usr/local/lib/fossology/fo-postinstall
*** Running postinstall for everything ***
*** Setting up the FOSSology database ***
NOTE: fossology database already exists, not creating
*** Checking for plpgsql support ***
NOTE: plpgsql already exists in fossology database, good
*** Creating user and group ***
NOTE: group 'fossy' already exists, good.
NOTE: user 'fossy' already exists, good.
*** Making sure needed dirs exist with right
ownership/permissions ***
NOTE: Repository already exists at /srv/fossology/repository
NOTE: /srv/fossology/repository/localhost directory already
exists
*** Checking database connectivity ***
NOTE: Connect succeeded, database is working.
*** Initializing database tables ***
PHP Notice: Undefined index: updcache in
/usr/local/share/fossology/www/plugin s/ui-license.php on line
114
PHP Notice: Undefined offset: 1 in
/usr/local/share/fossology/www/common/commo n-parm.php on line
98
PHP Notice: Undefined variable: PageHex in
/usr/local/share/fossology/www/plugi ns/ui-view.php on line 92
PHP Notice: Undefined variable: PageText in
/usr/local/share/fossology/www/plug ins/ui-view.php on line 93
PHP Notice: Undefined variable: PageText in
/usr/local/share/fossology/www/plug ins/ui-view.php on line 94
Applying database schema
Applying database functions
Migrating database records
Removing obsolete views
Removing obsolete columns
Committing changes...
Purging cached results
Initializing new tables and columns
Initializing plugins
PHP Notice: Undefined variable: Verbose in
/usr/local/share/fossology/www/plugi ns/core-schema.php on line
826
Initializing agents.
Initializing data files. This may take a few minutes.
Processing 356 license templates.
..................................................50
..................................................100
..................................................150
..................................................200
..................................................250
..................................................300
..................................................350
......!
New schema applied and initialization completed.
Initialization completed successfully.
*** Setting up scheduler ***
*** Checking Scheduler.conf ***
WARNING: /usr/local/etc/fossology/Scheduler.conf already
exists,
consider checking it or recreating with mkschedconf.
*** Setting up the web interface ***
FOSSology postinstall complete, but sure to complete the
remaining
steps in the INSTALL instructions.
[r...@localhost fossology]# /etc/init.d/fossology start
Starting FOSSology job scheduler: FATAL: Another scheduler is
running (pid=4781).
scheduler.
[r...@localhost fossology]# /etc/init.d/fossology restart
Restarting FOSSology job scheduler: Waiting 20 seconds for
process to complete
Some information in pg_hba.conf:
local all all trust
# IPv4 local connections:
host all all 192.168.162.0/24 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 0.0.0.0 0.0.0.0 trust
Some infomation in /httpd.conf:
#Alias /icons/ "/usr/local/share/fossology/www/"
<Directory "/var/www/icons">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
Alias /repo/ "/usr/local/share/fossology/www/"
<Directory "/usr/local/share/fossology/www/">
Options FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
#
Thanks
Alice
<ATT00001.txt>
<ATT00001.txt>
<<inline: graycol.gif>>
<<inline: ecblank.gif>>
<<inline: doclink.gif>>
<<inline: pic19954.gif>>
_______________________________________________ fossology mailing list fossology@fossology.org http://fossology.org/mailman/listinfo/fossology
