Re: nie dziala

18 Lut 2005


      ...
Rtfm dokumentacja, okolice zakładania bazy.
Popatrz też na dokumentację i konfigurację apache, zajżyj do logów etc.
kd.
Ok jeśli pytasz czy baza została założona to została
dokładnie tak jak jest w dokumentacji, chociaż polecenie:
/usr/local/pgsql/bin/psql -d lms -U lms -f /lms/doc/lms.pgsql
wyrzuciło trochę błędów:
psql:/temp/lms/doc/lms.pgsql:6: ERROR:  sequence "admins_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:8: ERROR:  table "admins" does not exist
psql:/temp/lms/doc/lms.pgsql:23: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "admins_pkey" for table "admins"
psql:/temp/lms/doc/lms.pgsql:23: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "admins_login_key" for table "admins"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:28: ERROR:  sequence "assignments_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:30: ERROR:  table "assignments" does not exist
psql:/temp/lms/doc/lms.pgsql:42: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "assignments_pkey" for table "assignments"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:47: ERROR:  sequence "cash_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:49: ERROR:  table "cash" does not exist
psql:/temp/lms/doc/lms.pgsql:61: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cash_pkey" for table "cash"
CREATE TABLE
CREATE INDEX
psql:/temp/lms/doc/lms.pgsql:67: ERROR:  sequence "networks_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:69: ERROR:  table "networks" does not exist
psql:/temp/lms/doc/lms.pgsql:86: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "networks_pkey" for table "networks"
psql:/temp/lms/doc/lms.pgsql:86: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "networks_name_key" for table "networks"
psql:/temp/lms/doc/lms.pgsql:86: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "networks_address_key" for table "networks"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:91: ERROR:  sequence "nodes_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:93: ERROR:  table "nodes" does not exist
psql:/temp/lms/doc/lms.pgsql:111: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
psql:/temp/lms/doc/lms.pgsql:111: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "nodes_name_key" for table "nodes"
psql:/temp/lms/doc/lms.pgsql:111: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "nodes_ipaddr_key" for table "nodes"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:116: ERROR:  sequence "tariffs_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:118: ERROR:  table "tariffs" does not exist
psql:/temp/lms/doc/lms.pgsql:134: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "tariffs_pkey" for table "tariffs"
psql:/temp/lms/doc/lms.pgsql:134: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "tariffs_name_key" for table "tariffs"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:139: ERROR:  sequence "payments_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:141: ERROR:  table "payments" does not exist
psql:/temp/lms/doc/lms.pgsql:151: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "payments_pkey" for table "payments"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:156: ERROR:  sequence "invoices_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:158: ERROR:  table "invoices" does not exist
psql:/temp/lms/doc/lms.pgsql:175: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "invoices_pkey" for table "invoices"
CREATE TABLE
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:194: ERROR:  table "timestamps" does not exist
psql:/temp/lms/doc/lms.pgsql:199: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "timestamps_tablename_key" for table "timestamps"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:204: ERROR:  sequence "users_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:206: ERROR:  table "users" does not exist
psql:/temp/lms/doc/lms.pgsql:232: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:237: ERROR:  sequence "usergroups_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:239: ERROR:  table "usergroups" does not exist
psql:/temp/lms/doc/lms.pgsql:246: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "usergroups_pkey" for table "usergroups"
psql:/temp/lms/doc/lms.pgsql:246: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "usergroups_name_key" for table "usergroups"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:252: ERROR:  sequence "userassignments_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:254: ERROR:  table "userassignments" does not exist
psql:/temp/lms/doc/lms.pgsql:261: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "userassignments_pkey" for table "userassignments"
psql:/temp/lms/doc/lms.pgsql:261: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "userassignments_usergroupid_key" for table "userassignments"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:266: ERROR:  table "stats" does not exist
psql:/temp/lms/doc/lms.pgsql:273: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "stats_pkey" for table "stats"
CREATE TABLE
CREATE INDEX
psql:/temp/lms/doc/lms.pgsql:281: ERROR:  sequence "netdevices_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:283: ERROR:  table "netdevices" does not exist
psql:/temp/lms/doc/lms.pgsql:294: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "netdevices_pkey" for table "netdevices"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:299: ERROR:  sequence "netlinks_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:301: ERROR:  table "netlinks" does not exist
psql:/temp/lms/doc/lms.pgsql:308: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "netlinks_pkey" for table "netlinks"
psql:/temp/lms/doc/lms.pgsql:308: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "netlinks_src_key" for table "netlinks"
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
psql:/temp/lms/doc/lms.pgsql:335: ERROR:  table "rtattachments" does not exist
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:342: ERROR:  sequence "rtqueues_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:344: ERROR:  table "rtqueues" does not exist
psql:/temp/lms/doc/lms.pgsql:352: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "rtqueues_pkey" for table "rtqueues"
psql:/temp/lms/doc/lms.pgsql:352: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "rtqueues_name_key" for table "rtqueues"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:354: ERROR:  sequence "rttickets_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:356: ERROR:  table "rttickets" does not exist
psql:/temp/lms/doc/lms.pgsql:368: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "rttickets_pkey" for table "rttickets"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:370: ERROR:  sequence "rtmessages_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:372: ERROR:  table "rtmessages" does not exist
psql:/temp/lms/doc/lms.pgsql:387: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "rtmessages_pkey" for table "rtmessages"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:389: ERROR:  sequence "rtrights_id_seq" does not exist
CREATE SEQUENCE
psql:/temp/lms/doc/lms.pgsql:391: ERROR:  table "rtrights" does not exist
psql:/temp/lms/doc/lms.pgsql:399: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "rtrights_pkey" for table "rtrights"
psql:/temp/lms/doc/lms.pgsql:399: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "rtrights_adminid_key" for table "rtrights"
CREATE TABLE
psql:/temp/lms/doc/lms.pgsql:409: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "dbinfo_pkey" for table "dbinfo"
CREATE TABLE
INSERT 19175 1
Po dostaniu sie do bazy przez psql widac jednak ze
tabelki zostają założone...
Jeśli chodzi o logi to wygląda to tak:
(przy pobieraniu strony http://127.0.0.1/lms/)
httpd/access_log:
127.0.0.1 - - [18/Feb/2005:11:01:35 +0100] "GET /lms/ HTTP/1.1" 200 -
httpd/error_log - żadnych komunikatów
syslog - żadnych komunikatów chociaż podczas łączenia
się z postgresem ręcznie przez psql - jest to logowane
w php.ini mam:
display_errors = On
log_errors = On
error_reporting = E_ALL
Cała rzecz rozbija się właśnie o to że nie widać
nigdzie żadnych błędów! A jednocześnie nic się nie
wyświetla. Być może gdzieś jest jakiś głupi błąd ale
jak go znaleść?!
Krzysiek
------------------------------------------------------------------
Sprawdz NOWE parametry hostingu!
...
...
http://link.interia.pl/f1857 <<

Krzysiek

znaczniki (0)

uczestnicy (1)