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!