Home › Forums › Software Support ›

DCB Installation Unclear

Submitted by Murphy Shewchuk on Sat, 10/17/2009 - 05:41
in

I am trying to install DCB on a local Ubuntu server, but all the instructions refer to ICA-AtoM or QUBIT.  I have dowloaded DCB and unzipped it to a directory on a local "client" computer that sees the server.  I have also tried downloading it and unzipping it directly on the server using Gnome.

From that point things get confusing.  Is there an on-line reference to installing DCB?  Can I use Gnome or Webmin?

Murphy at the Nicola Valley Museum

‹ DCB vs. ICA-AtoM Install error ›

DCB web application

Submitted by david@artefactu... on Tue, 10/20/2009 - 17:33.

Hi Murphy,

The Digital Collection Builder is a web application, and to be more specific, it's a PHP web application. As a PHP web application, DCB is meant to be installed on a web server that is configured with the PHP script engine and a Database Management System (DBMS).  The combination of a Linux operating system (like Ubuntu), Apache web-server, MySQL DBMS, and the PHP script processor is often referred to as a "LAMP" stack (from the first letter of Linux-Apache-MySQL-PHP).  This makes installing DCB more complicated then installing a desktop application (like Open Office or Skype) via the Gnome installer or configuring your system via Webmin.

Installing and configuring Apache, MySQL and PHP can be quite technical and time consuming - so it is usually handled by an IT professional or at least an experienced hobbyist.  If you do not have IT resources available internally, there are also many 3rd party internet hosting companies that provide access to a server environment, pre-configured with a LAMP stack, for a reasonable monthly or annual fee (usually around $10-$30/month).

Here is a listing of the minimum technical requirements for running Qubit (which is the technology DCB is based on, as explained in Evelyn's comment); whether you choose to install DCB internally or at a hosting company, the server you install DCB on must meet these minimum requirements.

I hope that clarifies what the DCB application is and how it works.

 

David Juhasz

DCB Technical Support

PDO Connection Error

Submitted by Murphy Shewchuk on Fri, 10/23/2009 - 00:07.

It took some sleuthing, but I finally made it to the DCB "Database configuration" screen before getting hung up again with this error:

Unable to open PDO connection [wrapped: SQLSTATE[28000] [1045] Access denied for user 'nicola'@'localhost' (using password: YES)]

It doesn't seem to make much difference what I try, including the suggestions in the installation guide, but I can't seem to move forward.

Thanks,  Murphy

Username & password?

Submitted by david@artefactu... on Fri, 10/23/2009 - 16:38.

Hi Murphy,

That looks like the standard error you'd get trying to access a MySQL database with the the wrong username and/or password.

Try the following steps:

1) Open the "config/database.yml" file in your DCB directory with a text editor (the default editor on Ubuntu is in the  "Applications > Accessories > Text Editor" menu).  You should see something like the following lines:

dsn: 'mysql:dbname=qubitDB;host=localhost;port='
username: nicola
password: yourPassword

2) Open the Ubuntu terminal (Once again in the accessories menu: "Applications > Accessories > Terminal"), and type the following command, using the information from above:

> mysql -u nicola -p qubitDB

3) You will be prompted to type in your password, then you should be logged in to the MySQL command-line client.  You will see something like this, if it all went well:

david-juhaszs-macbook-pro:qubit david$ mysql -u root -p david_qubit
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 102
Server version: 5.0.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

4) Post back here with your results from the mysql command above.

5) To exit the mysql client type "\q<Enter>"

 

Regards,

David Juhasz

DCB Technical Support

 

Hi Murphy, You're right, the

Submitted by Evelyn McLellan on Tue, 10/20/2009 - 16:35.

Hi Murphy,

You're right, the documentation is not as clear as it could be. The DCB is based on Qubit, and the more well-established publicly-used branch of Qubit is called ICA-AtoM. The download page for the DCB is at http://dcb-gcn.canadiana.org/node/2, which explains the relationship between Qubit and the DCB and takes you to installation instructions. However, the installation instructions refer only to Qubit and ICA-AtoM. I'll update the documentation so it's less confusing.

As for your questions about the installation yourself, I've forwarded them to one of our developers, who will get back to you as soon as possible.

 

Evelyn McLellan

DCB Community Manager