Hi,
i've just tried to recreate the index (Links SQL 2.02) via browser: after a while there where no reaction back from nph-index.cgi - so i tried to start this via telnet.
Here's what i saw:
server% /usr/local/bin/virtual /www/htdocs/cgi-bin/admin/nph-index.cgi
GT::SQL (95150): OBJECT CREATED at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL.pm line 139.
Started at Thu Mar 1 00:54:56 2001.
Reindexing Links SQL Database ...
GT::SQL::Table (95150): Loading state for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 161.
GT::SQL::Table (95150): State loaded for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 165.
GT::SQL::Table (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
Links::Link (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
GT::SQL (95150): CREATING Links::Link OBJECT at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Base.pm line 66.
GT::SQL::Driver::MYSQL (95150): New driver object loaded from table: Links. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 53.
GT::SQL::Driver::MYSQL (95150): Connecting to database with: 'DBI:mysql:ea_links:localhost', 'root', '******' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 77.
GT::SQL::Driver::MYSQL (95150): Connected successfully to database. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 82.
Links::Link (95150): Query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes'
GT::SQL::Driver::MYSQL (95150): Preparing query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
GT::SQL::Driver::MYSQL (95150): Creating GT::SQL::Driver::MYSQL::sth object at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 38.
And tons more of this ... cpu-load was about 95% while running this ... on a second installation on the same server everything is working fine ...
What's wrong?
Thanks for hints.
i've just tried to recreate the index (Links SQL 2.02) via browser: after a while there where no reaction back from nph-index.cgi - so i tried to start this via telnet.
Here's what i saw:
server% /usr/local/bin/virtual /www/htdocs/cgi-bin/admin/nph-index.cgi
GT::SQL (95150): OBJECT CREATED at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL.pm line 139.
Started at Thu Mar 1 00:54:56 2001.
Reindexing Links SQL Database ...
GT::SQL::Table (95150): Loading state for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 161.
GT::SQL::Table (95150): State loaded for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 165.
GT::SQL::Table (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
Links::Link (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
GT::SQL (95150): CREATING Links::Link OBJECT at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Base.pm line 66.
GT::SQL::Driver::MYSQL (95150): New driver object loaded from table: Links. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 53.
GT::SQL::Driver::MYSQL (95150): Connecting to database with: 'DBI:mysql:ea_links:localhost', 'root', '******' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 77.
GT::SQL::Driver::MYSQL (95150): Connected successfully to database. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 82.
Links::Link (95150): Query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes'
GT::SQL::Driver::MYSQL (95150): Preparing query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
GT::SQL::Driver::MYSQL (95150): Creating GT::SQL::Driver::MYSQL::sth object at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 38.
And tons more of this ... cpu-load was about 95% while running this ... on a second installation on the same server everything is working fine ...
What's wrong?
Thanks for hints.