Re: [VuFind-Tech] Vufind Installation: DataBase Error

[Demian K. <dem...@vi...>]

Are the debug messages the only things you are seeing on screen?  If you turn debug back off again, exactly what error do you get?  (I just want to make sure there isn't another problem happening at the same time as the database issue).

- Demian
________________________________________
From: Sean F [str...@ya...]
Sent: Wednesday, April 04, 2012 12:57 PM
To: Demian Katz; tu...@ma...; vuf...@li...
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error

Thank you for all your responses,


I set login and password and able to access the database with them but I still have the same error message:


DB_DataObject : CONNECT : Checking for database specific ini ('') : database_ in options DB_DataObject : CONNECT : NEW CONNECTION TP DATABASE :

DB_DataObject : CONNECT : mysql://vufind:monroe@localhost/vufind d473ce860e7eaa275a8284ac8ddf4d1b




--- On Wed, 4/4/12, Demian Katz <dem...@vi...> wrote:

From: Demian Katz <dem...@vi...>
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error
To: "Sean F" <str...@ya...>, "vuf...@li..." <vuf...@li...>
Date: Wednesday, April 4, 2012, 1:43 PM

I think your credentials are missing from the database setting.

When you ran the VuFind install script, you were asked for a username and password for the VuFind database.  You should add these to that line, so it looks like this:

database = mysql://username:password@localhost/vufind

(that is, replace the first vufind in the string with your username, then a colon, then your password).

- Demian
________________________________________
From: Sean F [str...@ya...</mc/compose?to=str...@ya...>]
Sent: Tuesday, April 03, 2012 3:23 PM
To: vuf...@li...</mc/compose?to=vuf...@li...>
Subject: Re: [VuFind-Tech] Vufind Installation: DataBase Error

Hi Demian,


This is my DataBase conf:


[Database]

database = mysql://vufind@localhost/vufind

schema_location = /usr/local/vufind/web/conf

class_location = /usr/local/vufind/web/services/MyResearch/lib

require_prefix =

class_prefix =

quote_identifiers = 1

debug = 5


This is the errors I am getting, and I don't know what to make out of this

DB_DataObject   : CONNECT       : Checking for database specific ini ('') : database_ in options
DB_DataObject   : CONNECT       : NEW CONNECTION TP DATABASE :
DB_DataObject   : CONNECT       : mysql://vufind@localhost/vufind ccca3abcd7108b119e2b8fd71495357d


Thank you


--- On Tue, 4/3/12, Demian Katz <dem...@vi...</mc/compose?to=dem...@vi...>> wrote:

From: Demian Katz <dem...@vi...</mc/compose?to=dem...@vi...>>
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error
To: "Sean F" <str...@ya...</mc/compose?to=str...@ya...>>, "vuf...@li...</mc/compose?to=vuf...@li...>" <vuf...@li...</mc/compose?to=vuf...@li...>>
Date: Tuesday, April 3, 2012, 3:49 AM

Take a look at the [Database] section of web/conf/config.ini.  The first thing to check is whether the connection string is correct.  If it is, the next thing you can try is setting the debug level in that section up to 5, which should give you more detail on what is going wrong.

If you still have questions after trying this, let us know what is happening and we'll try to offer more advice!

- Demian
________________________________________
From: Sean F [str...@ya...</mc/compose?to=str...@ya...>]
Sent: Monday, April 02, 2012 4:05 PM
To: vuf...@li...</mc/compose?to=vuf...@li...>
Subject: [VuFind-Tech] Vufind Installation: DataBase Error

Hi all,


I have a problem installing vufind on mac.

After installing vufind and mysql, I able to see the interaction between my sql and vufind. however, running localhost/vufind gives me a DB error and there is no error in apache error log. I am able to connect to mysql and see the vufind DB.

Is it possible to configure to get a better error message or is there somewhere else for me to look?



mysql> show databases;

+--------------------+

| Database                  |

+--------------------+

| information_schema   |

| mysql                        |

| performance_schema |

| test                           |

| vufind                        |

+--------------------+

5 rows in set (0.00 sec)