Issues with new opigno installation - timing out before configuration

georgiawebgurl
Forums
Hi all, I have successfully installed opigno 2.0 on one site & server with no issues. However, I have a second site that I would like to use Opigno on. On the second site, I keep having issues with connection timeout right before the configuration screen. I've tried manually in MySQL adding in an admin password using a MD5 tool to generate the password hash. It didn't work for some reason. I am using PHP 7.2 and I have increased the php.ini max_execution_time to 760 which seems hugely high. In fact all of my values on the second site are really high. I have the max input at -1. Any suggestions? This is a fresh install on an empty server, so I need all of the dependencies. I just can't figure out why it works on one site and not the other, when the server is the same. Since I use cpanel for the server, I am not using Drush. (Although Drush has been on my list for a while to explore). Thanks much, Robin @georgiawebgurl
georgiawebgurl

error log

14-Mar-2019 15:41:17 UTC] TypeError: Argument 1 passed to Drupal\Core\Config\Entity\ConfigEntityStorage::updateFromStorageRecord() must implement interface Drupal\Core\Config\Entity\ConfigEntityInterface, null given, called in .../public_html/core/lib/Drupal/Core/Config/ConfigInstaller.php on line 337 in .../public_html/core/lib/Drupal/Core/Config/Entity/ConfigEntityStorage.php on line 447 #0 .../public_html/core/lib/Drupal/Core/Config/ConfigInstaller.php(337): Drupal\Core\Config\Entity\ConfigEntityStorage->updateFromStorageRecord(NULL, Array) #1 .../public_html/core/lib/Drupal/Core/Config/ConfigInstaller.php(241): Drupal\Core\Config\ConfigInstaller->createConfiguration('', Array, true) #2 .../public_html/core/lib/Drupal/Core/ProxyClass/Config/ConfigInstaller.php(84): Drupal\Core\Config\ConfigInstaller->installOptionalConfig(Object(Drupal\Core\Config\ExtensionInstallStorage), Array) #3 .../public_html/core/includes/install.core.inc(1671): Drupal\Core\ProxyClass\Config\ConfigInstaller->installOptionalConfig() #4 .../public_html/core/includes/install.core.inc(709): install_install_profile(Array) #5 .../public_html/core/includes/install.core.inc(584): install_run_task(Array, Array) #6 .../public_html/core/includes/install.core.inc(125): install_run_tasks(Array, NULL) #7 .../public_html/core/install.php(44): install_drupal(Object(Composer\Autoload\ClassLoader)) #8 {main} [14-Mar-2019 15:45:33 UTC] Uncaught PHP Exception Symfony\Component\Routing\Exception\RouteNotFoundException: "Route "view.opigno_training_catalog.training_catalogue" does not exist." at .../public_html/core/lib/Drupal/Core/Routing/RouteProvider.php line 201 [14-Mar-2019 15:45:34 UTC] Uncaught PHP Exception Symfony\Component\Routing\Exception\RouteNotFoundException: "Route "view.opigno_training_catalog.training_catalogue" does not exist." at .../public_html/core/lib/Drupal/Core/Routing/RouteProvider.php line 201 [14-Mar-2019 15:45:46 UTC] Uncaught PHP Exception Drupal\Core\Database\DatabaseExceptionWrapper: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'edubrary_edux.opigno_learning_path_step_achievements' doesn't exist: SELECT DISTINCT sa.entity_id AS entity_id, sa.typology AS typology, sa.name AS name, sa.score AS score, sa.status AS status, sa.time AS time, sa.completed AS completed, omfd.badge_name AS badge_name, omfd.badge_description AS badge_description, omfd.badge_criteria AS badge_criteria, mi.field_media_image_target_id AS field_media_image_target_id, pa.gid AS gid, pa.name AS training FROM {opigno_learning_path_step_achievements} sa INNER JOIN {opigno_module_field_data} omfd ON omfd.id = sa.entity_id AND sa.typology = :typology INNER JOIN {opigno_learning_path_achievements} pa ON pa.gid = sa.gid INNER JOIN {media__field_media_image} mi ON mi.entity_id = omfd.badge_media_image WHERE (sa.typology = :db_condition_placeholder_0) AND (sa.uid = :db_condition_placeholder_1) AND (omfd.badge_active = :db_condition_placeholder_2) ORDER BY sa.completed DESC; Array ( [:db_condition_placeholder_0] => Module [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => 1 [:typology] => Module ) " at .../public_html/core/lib/Drupal/Core/Database/Connection.php line 686 [14-Mar-2019 15:46:29 UTC] Uncaught PHP Exception Symfony\Component\Routing\Exception\RouteNotFoundException: "Route "view.opigno_training_catalog.training_catalogue" does not exist." at .../public_html/core/lib/Drupal/Core/Routing/RouteProvider.php line 201 [14-Mar-2019 15:46:42 UTC] Uncaught PHP Exception Symfony\Component\Routing\Exception\RouteNotFoundException: "Route "view.opigno_training_catalog.training_catalogue" does not exist." at .../public_html/core/lib/Drupal/Core/Routing/RouteProvider.php line 201 [14-Mar-2019 15:48:37 UTC] Uncaught PHP Exception Symfony\Component\Routing\Exception\RouteNotFoundException: "Route "view.opigno_training_catalog.training_catalogue" does not exist." at .../public_html/core/lib/Drupal/Core/Routing/RouteProvider.php line 201
nikolay

Reinstall the Opigno

Hi, Robin. The first thing that comes to mind when I see your errors log - the installation was ended with the problems. So, if you have a fresh installation I recommend to you to drop the database for the instance with the issue and try to reinstall Opigno. This should help.
georgiawebgurl

New error message

What would be the missing dependencies? https://www.opigno.org/sites/default/files/opigno-with-dependencies-v2.2.tar.gz which I thought had all dependencies needed. The website encountered an unexpected error. Please try again later. Drupal\Core\Config\UnmetDependenciesException: Configuration objects provided by platon have unmet dependencies: image.style.frontpage_slider (image) in Drupal\Core\Config\UnmetDependenciesException::create() (line 98 of core/lib/Drupal/Core/Config/UnmetDependenciesException.php). Drupal\Core\Config\UnmetDependenciesException::create('platon', Array) (Line: 485) Drupal\Core\Config\ConfigInstaller->checkConfigurationToInstall('theme', 'platon') (Line: 132) Drupal\Core\ProxyClass\Config\ConfigInstaller->checkConfigurationToInstall('theme', 'platon') (Line: 169) Drupal\Core\Extension\ThemeInstaller->install(Array, 1) (Line: 166) Drupal\Core\Extension\ThemeHandler->install(Array) (Line: 1649) install_profile_themes(Array) (Line: 709) install_run_task(Array, Array) (Line: 584) install_run_tasks(Array, NULL) (Line: 125) install_drupal(Object) (Line: 44)
georgiawebgurl

Resolved

I just wanted to give an update. I finally got Opigno installed using an earlier version ( https://ftp.drupal.org/files/projects/opigno_lms-8.x-1.0-beta3-core.zip ) and then separately downloading the libraries for Tincup and pdf.js. I also did a bit of installing PHP extensions through PEAR for 7.1 (7.2 never worked for me) including curl and also support for mail, since that seems to be an issue for Drupal for some server setups. I don't have access to Composer, SSH, but I do have access to php.ini, the .htaccess, and PHP extensions. PHP 7.1, MySQL 5.6 I'll post my php.ini when I get a chance.
axel

Hello,

Hello,

Just be careful with beta3 version, it's an old version, there were several security upgrades in the meantime.

And in addition to that there is no upgrade script available with beta version, so you won't be able to upgrade to the next versions of Opigno.

georgiawebgurl

Hmm.

Hmm. I'll try 2.3 again with the dependencies. I had hoped by getting that version to install I would be able to upgrade, but that sounds not doable. Can I manually upgrade?
sdiaz

Drupal\Core\Config\UnmetDependenciesException: Configuration obj

Hi georgiawebgurl and axel, I am finding the same problem when trying to install opigno 2.3. I am using Acquia dev desktop locally and I have tested the same thing with the same result. Do you know what is the reason of the error?
axel

Upgrading manually from beta3

Upgrading manually from beta3 will be very complicated, a lot of things changed. It's for sure possible to do it, but it will take time.

georgiawebgurl

Time out error before configuration

My issue is the same as it's been from day 1 - Time out before configuration screen. I extended the max_execution_time = 0 and I've added a max_input_time = -1 I have plenty of memory. Ridiculous the numbers I've put in. I've upped xdedbug to 500. I install manually since I can't use composer on this host setup. I have access to php.ini via cpanel; access to .htaccess, settings.php thru my sftp access. PHP 7.1 (tried 7.2); native is 5.6, so I'm overriding that MySQL 5.6.43 - MySQL Community Server (GPL) - No control over this - set by the web host co. Error messages are almost always the same related to timeout. Same issue every time. It installs until it gets to the configuration screen at which point it times out. Sometimes, it installs anyhow, but since I did not go thru config it creates a blank user for the admin. The user name is placeholder-1 . There is no password (checked as null in the db via phpadmin). I can't get Drupal to send emails because of the php email thing, I can't reset the email. I don't know the password salt, so I can't manually create a properly hashed password in the db, either. I do have access to php.ini via cpanel. I am beginning to suspect I need to make ALL of my edits to the settings.php. In poking around in the files, it looks like the .htaccess file gets overwritten when I modify the php.ini via the cpanel. It does append my tweaks to the .htaccess file but I am wondering if that is an issue. I'd love to see what someone's php.ini is for 2.3 and even better, if they have successfully installed via those tweaks to the settings.php; I'd LOVE to see that. I will be moving to VPS in the near future. I was briefly (&erroneously by my webhost co) in a VPS setting and was able to install Opigno with no problem on a Mariadb. I was then kicked back to the reseller level, at which point my Mariadb downgraded to MySQL. (Yeah... I can't move back until I do some site cleanup) I can install Drupal 8.6.x with no issue if I go thru the self-installer softaculous. I'm thinking that it has dif server permissions than I have. So, I've thought about installing as a module, but I'd rather install as the distro. I have used composer on a dif project in the past, but not everyone can do that. I certainly can't until I move to VPS or a dif web hosting co. Thanks, Robin
georgiawebgurl

Update

Hi all, I've been working with my web hosting co. tech support and I finally got opigno 2.4 installed. Here is what I think happened with all the various weird install fails 1)I was running installations during the server upgrade and nightly backups (I had no idea the backup was running when I was trying to install opigno - first I had heard of that!) - so I think that was the cause of some of the install fails 2) Timeout - Yeah, the well documented timeout issue. I tried: tweaking my php.ini, adding a user.ini, and adding the php.ini tweaks in the settings.php file per a suggestion in drup forums - all failed. When I would make those changes and customizations, it looked like it worked. I honestly think that because I don't have root access on this server, that all of the changes I made did not actually apply to my whole site. Opigno is installed at root (public_html). When I tried to install opigno in subfolder, it went fine. I've got it installed now and I can move forward. I do want to move all of my sites over to VPS, but I need to clean up some accounts first.
asikuy

VPS

to avoid all those issues on install, Opigno has to be installed on a VPS, not share hosting, where you have root access... more work, but you can have all the settings opigno needs to run smoothly...
georgiawebgurl

As I mentioned in my previous

As I mentioned in my previous post, I can't move to VPS right now. Honestly, I ceased to be a fan of Drupal when it moved to Composer. I do NOT think you should need to be a developer to use a CMS, including Drupal or Opigno, for that matter. I do develop on other dedicated servers, but I also take on very small projects, with no staff, no funding, and no dedicated server. I can't (and won't) fund every project myself on my own server, either. There are so many small projects out there that could use the scalability of Drupal, but I fear they will never be able to. I suppose one can migrate from WP to Drupal (as I've done for a couple of projects), but then if WP works, why migrate? Drupal use will plummet if there is no consideration for these smaller sites.
asikuy

VPS

true, but opigno has more requirements that are easier to address when you have root access.. now, once its installed, it should work fine. For plain drupal sites, and small projects, multisite is best. I am installing Opigno on digital ocean, only $5 for a VPS... but I have full control. No waiting for support.
pat

All I can say is a lot of

All I can say is a lot of shared host nowdays offer Jailed SSH, which allows you to execute composer very easily and get running quite quickly. If this isn't an option with your current host, maybe looking for an alternative host might be a solution rather than moving to a VPS. I've installed Opigno under cPanel on a shared host without much trouble. cPanel itself does offer the possibility of Jailed SSH. My 2 cents.