[Symfony] Błąd połączenia z bazą, Po przeniesieniu skryptu na serwer Opcje

[zalazdi]

Witam,
mam mały problem z symfony (orm - doctrine). Chciałem przenieść skrypt z localhosta na serwer, aby pokazać klientowi postępy. Wrzuciłem wszystko, zmieniłem dane do bazy, wrzuciłem zrzut bazy przez PMA i ... nie działa.

Kod

Notice: Undefined index: in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 302

Notice: Undefined index: in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 303

Fatal error: Call to a member function getFieldName() on a non-object in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 304

Taki jest błąd przy pierwszym pobraniu i wyświetleniu danych z bazy (w moim przypadku menu). Dalej strona się nie renderuje. Nie mogę zrobić testów, bo jest to wirtualny serwer.

Łączyłem się z bazą danych w oddzielnym skrypcie php, wszystko działa w porządku. Normalnie pobiera tabele, wyświetla itd.

Z czym może być problem?

[l3l0]

Witam,

Może to ci pomoże:
http://symfonyexperts.com/question/show/id/178

Ktoś miał podobny problem. Spróbuj odpalić "./symfony doctrine:clean-model-files" i sprawdz scheme.

Pozdrawiam

[zalazdi]

Kod

C:\Users\buba\Desktop\tz>php symfony doctrine:clean-model-files
>> file+     C:\Users\buba\AppData\Local\Temp/doctrine_schema_70873.yml
>> doctrine  Could not find any files that need to be removed

C:\Users\buba\Desktop\tz>php symfony doctrine:build --model
>> doctrine  generating model classes
>> file+     C:\Users\buba\AppData\Local\Temp/doctrine_schema_32815.yml
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...octrine/base/BaseBets.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ne/base/BaseBookmaker.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ine/base/BaseCategory.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...rine/base/BaseComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...trine/base/BaseGarpes.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ase/BaseGarpesComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...trine/base/BaseLatest.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...octrine/base/BaseNews.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ne/base/BaseSpelskola.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../BaseSpelskolaComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...sfGuardForgotPassword.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...base/BasesfGuardGroup.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...fGuardGroupPermission.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...BasesfGuardPermission.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...asesfGuardRememberKey.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../base/BasesfGuardUser.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../BasesfGuardUserGroup.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...sfGuardUserPermission.class.php
>> autoload  Resetting application autoloaders
>> file-     C:/Users/buba/Desktop/tz/cache/.../config/config_autoload.yml.php
>> file-     C:/Users/buba/Desktop/tz/cache/.../config/config_autoload.yml.php

Wykonałem to polecenie i przebudowałem modele, plik schema jest odpowiedni (na localhoście działa). Niestety błędu to nie naprawiło.

EDIT: W razie czego, to cache czyszczę co chwilę i testuję na "dev", chociaż nawet nie dochodzi do etapu wyświetlenia web bara.

Ten post edytował zalazdi 15.04.2011, 17:29:05

[l3l0]

Witam,

Rozumiem że swoją maszynę developerską masz na Windowsie, a prod stoi na linuxie? Taski powinny być uruchomione tam gdzie wystąpił problem czyli na serwerze liniuxowym. Jako iż to wirtualny, współdzielony hosting możesz mieć problem. Możesz spróbować usunąć wszystkie wygenerowane klasy z lib/model/base/* , i skopiować te pliki z deva ale nie jestem pewien czy coś Ci to pomoże. Spróbuj też usunąć wszystko z katalogu cache/*

Tak na marginesie najlepiej zautomatyzować proces deploymentu np. używając tego https://github.com/everzet/capifony

Pozdrawiam

[zalazdi]

Sprawdziłem wszystko na innym serwerze współdzielonym i ... działa... Wygląda na jakiś problem z serwerem. Sprawdzałem jeszcze czy ogólnie doctrine chce się połaczyć z bazą, i jak zmieniłem hasło na niepoprawne w databases.yml to jest błąd

Kod

PDO Connection Error: SQLSTATE[28000] [1045] Access denied for user 'crowntuf_tz'@'localhost' (using password: TAK)

EDIT:
Dorzucam jeszcze logi, hosting gdzie skrypt nie działa:

Kod

Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Match route "homepage" (/) for / with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:35:04 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:35:04 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:35:04 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:35:04 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:35:04 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Match route "default_index" (/:module) for /news with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:35:08 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:35:08 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:35:08 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:35:08 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:35:08 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()

Hosting gdzie skrypt działa jak powinien

Kod

Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Match route "homepage" (/) for / with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:33:31 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:33:31 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:33:31 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()
Apr 16 11:33:31 symfony [info] {sfPHPView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/news/templates/indexSuccess.php"
Apr 16 11:33:31 symfony [info] {main} Set slot "title"
Apr 16 11:33:31 symfony [info] {main} Call "expert->executeExperttips()"
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/expert/templates/_experttips.php"
Apr 16 11:33:31 symfony [info] {main} Call "expert->executeExpertstats()"
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/expert/templates/_expertstats.php"
Apr 16 11:33:31 symfony [info] {sfPHPView} Decorate content with "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/templates/layout.php"
Apr 16 11:33:31 symfony [info] {sfPHPView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/templates/layout.php"
Apr 16 11:33:31 symfony [info] {main} Get slot "title"
Apr 16 11:33:31 symfony [info] {main} Get slot "background"
Apr 16 11:33:31 symfony [info] {main} Call "category->executeMenu()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} query : SELECT c.id AS c__id, c.name AS c__name, c.background AS c__background, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM category c - ()
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/category/templates/_menu.php"
Apr 16 11:33:31 symfony [info] {main} Call "sfGuardUser->executeMenu()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.name AS s__name, s.description AS s__description, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_group s WHERE (s.name = ?) - (expert)
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/sfGuardUser/templates/_menu.php"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s2.user_id AS s2__user_id, s2.group_id AS s2__group_id, s2.created_at AS s2__created_at, s2.updated_at AS s2__updated_at FROM sf_guard_user s LEFT JOIN sf_guard_user_group s2 ON s.id = s2.user_id WHERE (s2.group_id IN (?)) - (3)
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send status "HTTP/1.1 200 OK"
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Configuration 1.79 ms (14)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Factories 25.02 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Action "news/index" 25.75 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.02 ms (5)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} View "Success" for "news/index" 39.28 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "expert/experttips" 0.01 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "expert/_experttips" 0.32 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "expert/expertstats" 0.01 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "expert/_expertstats" 0.31 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "category/menu" 2.34 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "category/_menu" 0.69 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "sfGuardUser/menu" 6.07 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "sfGuardUser/_menu" 9.08 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send content (58371 o)

Ten post edytował zalazdi 16.04.2011, 10:35:50

[lukas.skowronski]

Brak dostępu do bazy można odebrać jednoznacznie. Albo złe dane (literowka), albo użytkownik nie ma praw do łączenia się z zewnątrz, albo próbujesz łączyć się na porcie który jest niedostępny.