I'm assuming you want to use a PDO connection, and not a Propel connection as well.
In that case, simply remove the "propelom" database definition from
databases.xml. It is trying to load the given "config" file (project-conf.php)
on startup, but you're apparently not using Propel, so that <database>
shouldn't even be there.
David
P.S. $this->getContext()->getDatabaseConnection('pdo_mysql_main') is shorter,
and since "pdo_mysql_main" is your default connection,
$this->getContext()->getDatabaseConnection() will work too.
On 11.01.2012, at 11:38, Xavier O wrote:
> Hi,
>
> I am a new Agavi user. I just followed the tutorial :
> http://www.agavi.org/documentation/tutorial/step5/the-database-manager.html
>
>
> I set up the file /app/config/database.xml to create a database connexion :
> <ae:configurations
> xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0";;
> xmlns="http://agavi.org/agavi/config/parts/databases/1.0";;>
>
> <ae:configuration>
> <databases default="pdo_mysql_main">
>
> <database name="pdo_mysql_main" class="AgaviPdoDatabase">
> <ae:parameter
> name="dsn">mysql:host=localhost;dbname=benchmark</ae:parameter>
> <ae:parameter name="username">root</ae:parameter>
> <ae:parameter name="password">root</ae:parameter>
> </database>
>
> <database name="propelom" class="AgaviPropelDatabase">
> <ae:parameter
> name="config">%core.app_dir%/config/project-conf.php</ae:parameter>
> </database>
>
> </databases>
> </ae:configuration>
> </ae:configurations>
>
> I set up /app/config/settings.xml as follow :
>
> <settings>
> <setting name="app_name">Benchmark Agavi</setting>
>
> <setting name="available">true</setting>
> <setting name="debug">false</setting>
>
> <setting name="use_database">true</setting>
> <setting name="use_logging">false</setting>
> <setting name="use_security">true</setting>
> <setting name="use_translation">false</setting>
> </settings>
>
>
> I my model file, i open an new database connexion to request the database
>
> class Sii_PopulationManagerModel extends benchmark_agaviSiiBaseModel
> {
> public function retrieveAll() {
> $sql = 'SELECT idPopulation, effectif, anneeNaissance
> FROM population p
> ORDER BY anneeNaissance';
>
> $stmt =
> $this->getContext()->getDatabaseManager()->getDatabase('pdo_mysql_main')->getConnection()->prepare($sql);
> $stmt->execute();
> $populationsRowSet = $stmt->fetch(PDO::FETCH_ASSOC);
> ...
> }
>
> }
>
>
> When I open the web page, I get this message :
>
> Warning:
> require(/home/ebp/share/benchmark-agavi/app/config/project-conf.php): failed
> to open stream: No such file or directory in
> /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviPropelDatabase.class.php
> on line 172 Call Stack: 0.0009 315988 1. {main}()
> /home/ebp/share/benchmark-agavi/pub/index.php:0 4.6446 1284144 2.
> AgaviContext::getInstance() /home/ebp/share/benchmark-agavi/pub/index.php:23
> 4.6447 1285544 3. AgaviContext->initialize()
> /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:274
> 4.9455 1616572 4.
> include('/home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php')
> /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:307
> 4.9456 1621884 5. AgaviDatabaseManager->initialize()
> /home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php:53
> 5.1733
> 1634324 6.
> require('/home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php')
>
> /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviDatabaseManager.class.php:142
> 5.1829 1706944 7. AgaviPropelDatabase->initialize()
> /home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php:19
> Fatal error: require(): Failed opening required
> '/home/ebp/share/benchmark-agavi/app/config/project-conf.php'
> (include_path='.:/usr/share/php') in
> /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviPropelDatabase.class.php
> on line 172 Call Stack: 0.0009 315988 1. {main}()
> /home/ebp/share/benchmark-agavi/pub/index.php:0 4.6446 1284144 2.
> AgaviContext::getInstance() /home/ebp/share/benchmark-agavi/pub/index.php:23
> 4.6447 1285544 3. AgaviContext->initialize()
> /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:274
> 4.9455 1616572 4.
> include('/home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php')
> /home/ebp/share/benchmark-agavi/libs/agavi/core/AgaviContext.class.php:307
> 4.9456 1621884 5. AgaviDatabaseManager->initialize()
> /home/ebp/share/benchmark-agavi/app/cache/config/factories.xml_development_web_69aae32eef99ca40bf7c9c316e9a218b6ceac608.php:53
> 5.1733 1634324 6.
> require('/home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php')
>
> /home/ebp/share/benchmark-agavi/libs/agavi/database/AgaviDatabaseManager.class.php:142
> 5.1829 1706944 7. AgaviPropelDatabase->initialize()
> /home/ebp/share/benchmark-agavi/app/cache/config/databases.xml_development__dcf4b4d340933ac9a4058757038e9dd9b7c094a6.php:19
>
>
> Can somebody tell me why I get this message ? How to fix it ?
>
> Best regards,
>
> Xavier
>
> _______________________________________________
> users mailing list
> [email protected]
> http://lists.agavi.org/mailman/listinfo/users
>
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ users mailing list [email protected] http://lists.agavi.org/mailman/listinfo/users
