Database "propel" does not exist

[mmikit...@gmail.com]

Hello,

I am stuck at Step 2 in the Atom Web installer (version 2.1.0) - the installer is saying "Database propel does not exist". I cannot find any mention of Propel in the installation guide (see https://www.accesstomemory.org/en/docs/2.1/admin-manual/installation/linux/).

I created the "propel" database and granted the atom DB user access to it.

There was mention of this on the following thread, but unfortunately the resolution steps are not included: https://groups.google.com/forum/#!topic/ica-atom-users/Yb4sjOvsmpo

matt

[Jesús García Crespo]

Hi Matt,

I don't know exactly what could be causing that error. I'd try to delete config/config.php and access to http://yourhost/index.php/sfInstallPlugin/checkSystem again.

Let me know if the problem persists!

--
You received this message because you are subscribed to the Google Groups "ICA-AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at http://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/3a3ccddd-73d9-44c4-8c89-de05e0f3fd87%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Jesús García Crespo

[mmikit...@gmail.com]

Hi Jesús,

Thank you for the quick response! The config/config.php file does not exist on my system -- I assume that the web installer does not have sufficient information to create it.

I confirmed that the atom db user permissions align with the installation guide:

mysql> select Db,User,Index_priv,Create_priv,Select_priv,Insert_priv,Update_priv,Delete_priv,Alter_priv,Lock_tables_priv from db where Db='atom';

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

| Db   | User           | Index_priv | Create_priv | Select_priv | Insert_priv | Update_priv | Delete_priv | Alter_priv | Lock_tables_priv |

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

| atom | ica_atom_admin | Y          | Y           | Y           | Y           | Y           | Y           | Y          | Y                |

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

1 row in set (0.00 sec)

Am I supposed to create the "propel" database before running the web installer?

Since I am having problems with the web installer, do you have any docs on manually configuring the system and bypassing the installer?

Thanks,

matt

[Jesús García Crespo]

Hi again,

A "propel" database is definitely not necessary. I'm not sure what could have triggered that error. Most of the problems I see during the installation are due to the fact that the installer has to create some configuration files hence the web server needs to have write permissions. In particular, the directories that need to be writable are data/, log/, apps/qubit/config/ and config/. Later on, you can re-adjust the permissions manually.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/17205aa5-1269-461b-90ee-33b6b371558f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Jesús García Crespo,
Software Engineer, Artefactual Systems Inc.
http://www.artefactual.com | +1.604.527.2056

[Matthew Mikitka]

Hi Jesús,

I double-checked that Apache has read/write access to all the folders that you mentioned below, there are no warning messages at the "Check system" step of the web installer, I removed all the contents in the cache folder, and performed the installation again. I still get the same error: "Database "propel" does not exist."

The log/qubit_prod.log contains the following:

Nov 07 12:42:22 symfony [err] {PropelException} No connection information in your runtime configuration file for datasource [propel]

Note that I did *not* try to install Propel separately.

I am at a dead end. Are there manual installation instructions?

Thanks,

matt

---

From: ica-ato...@googlegroups.com <ica-ato...@googlegroups.com> on behalf of Jesús García Crespo <je...@artefactual.com>
Sent: Friday, November 7, 2014 12:37
To: ica-ato...@googlegroups.com
Subject: Re: [ica-atom-users] Database "propel" does not exist

 

You received this message because you are subscribed to a topic in the Google Groups "ICA-AtoM Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ica-atom-users/Cii7aUUSs-g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ica-atom-user...@googlegroups.com.

To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at http://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CA%2BunNDLR-oukJwLZTJXQyZhSAoiqmmqZphan__tKiZELFQZEPQ%40mail.gmail.com.

[Jesús García Crespo]

On Fri, Nov 7, 2014 at 10:08 AM, Matthew Mikitka <mmik...@wlu.ca> wrote:

I am at a dead end. Are there manual installation instructions?

Not officially, but we've shared some instructions in this list in the past and I'm happy to do it again.

The steps are:

- Create the database as explained in the docs.

- $ cp apps/qubit/config/settings.yml.tmpl apps/qubit/config/settings.yml

- $ cp config/propel.ini.tmpl config/propel.ini

- Create config/config.php like the following: https://gist.github.com/sevein/f06dfe3d433494e9766e

  Customize the dsn, username and password fields with your own settings (MySQL).

- $ php symfony cc

- $ php symfony tools:purge

Let me know how it goes,

--

Jesús García Crespo

[Matthew Mikitka]

That did it! However, you may wish to know that the "php symfony tools:purge" command failed on the first invocation with the following error message:

 DROP TABLE IF EXISTS `accession`
[propel-sql-exec] SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user 'ica_atom_admin'@'localhost' for table 'accession'
[propel-sql-exec] Failed to execute: 

And, looking at the installation guide, https://www.accesstomemory.org/en/docs/2.1/admin-manual/installation/linux/#create-the-database, it does not say that the DROP grant is required for the atom DB user.

Perhaps if I used the root user in the web installer I would not have encountered a problem?

But, the installation is complete, and thank you for your help.

matt

---

From: ica-ato...@googlegroups.com <ica-ato...@googlegroups.com> on behalf of Jesús García Crespo <je...@sevein.com>
Sent: Friday, November 7, 2014 13:14

To: ica-ato...@googlegroups.com
Subject: Re: [ica-atom-users] Database "propel" does not exist

--

You received this message because you are subscribed to a topic in the Google Groups "ICA-AtoM Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ica-atom-users/Cii7aUUSs-g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ica-atom-user...@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at http://groups.google.com/group/ica-atom-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CA%2BunNDLW%2BZ7CTn8bKy671ngxwh5HHpC0BTvaKcksc7VeVBBCmw%40mail.gmail.com.