The problem could be the location of the MySQL socket file. I finally remembered having that problem, and it was kind of horrible to figure out.

The MySQL distribution for Mac (from the MySQL site) creates it's socket file at /tmp/mysql.sock by default, but the PHP installation looks for /var/mysql/mysql.sock by default.

Test this by starting up MySQL and see where it creates mysql.sock.

If the location of the socket file looks like the problem, you can change the PHP settings easily enough. Copy /etc/php.ini.default to /etc/php.ini and change all of the instances of /var/mysql/mysql.sock to /tmp/msql.sock.

You might need to restart apache for this to take effect.

-Tod

On Apr 6, 2012, at 11:49 AM, Sean F wrote:

Hi Damian,

Changing debug mode to 0 does not show me much. I attached the screenshot of the message. 
THANK YOU




--- On Thu, 4/5/12, Demian Katz <demian.katz@villanova.edu> wrote:

From: Demian Katz <demian.katz@villanova.edu>
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error
To: "Sean F" <strela83@yahoo.com>, "tulie@mail.iucc.ac.il" <tulie@mail.iucc.ac.il>, "vufind-tech@lists.sourceforge.net" <vufind-tech@lists.sourceforge.net>
Date: Thursday, April 5, 2012, 12:32 PM

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 [strela83@yahoo.com]
Sent: Wednesday, April 04, 2012 12:57 PM
To: Demian Katz; tulie@mail.iucc.ac.il; vufind-tech@lists.sourceforge.net
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 <demian.katz@villanova.edu> wrote:

From: Demian Katz <demian.katz@villanova.edu>
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error
To: "Sean F" <strela83@yahoo.com>, "vufind-tech@lists.sourceforge.net" <vufind-tech@lists.sourceforge.net>
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 [strela83@yahoo.com</mc/compose?to=strela83@yahoo.com>]
Sent: Tuesday, April 03, 2012 3:23 PM
To: vufind-tech@lists.sourceforge.net</mc/compose?to=vufind-tech@lists.sourceforge.net>
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 <demian.katz@villanova.edu</mc/compose?to=demian.katz@villanova.edu>> wrote:

From: Demian Katz <demian.katz@villanova.edu</mc/compose?to=demian.katz@villanova.edu>>
Subject: RE: [VuFind-Tech] Vufind Installation: DataBase Error
To: "Sean F" <strela83@yahoo.com</mc/compose?to=strela83@yahoo.com>>, "vufind-tech@lists.sourceforge.net</mc/compose?to=vufind-tech@lists.sourceforge.net>" <vufind-tech@lists.sourceforge.net</mc/compose?to=vufind-tech@lists.sourceforge.net>>
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 [strela83@yahoo.com</mc/compose?to=strela83@yahoo.com>]
Sent: Monday, April 02, 2012 4:05 PM
To: vufind-tech@lists.sourceforge.net</mc/compose?to=vufind-tech@lists.sourceforge.net>
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)





<Screen Shot 2012-04-06 at 11.46.01 AM.png>------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2_______________________________________________
Vufind-tech mailing list
Vufind-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/vufind-tech