Jump to content
Karl_T

Installation stuck when using remote database(AWS RDS)

Recommended Posts

The database connection is successful. But I stuck with this screen without any buttons after the page entering database info. I cannot make it to reach the set admin info page. I have inspected the remote database and all the tables and fields are looking good(I use site exporter).

stuck1.thumb.jpg.ad5a83586a8ca004a5249d4eae1827c1.jpg

Share this post


Link to post
Share on other sites

Looks like the problem arises in the profileImport section. Try to ramp up logging in php.ini and/or look in the server error log to see what's going wrong.

  • Like 1

Share this post


Link to post
Share on other sites

Thanks for the reply and link.

I have tried install the site profile with local database and it has no problem. But when I try using remote database, the same issue appears.

I have the debug mode on already, but no errors shown during the installation. Once I go back to homepage after stuck, the error shown 

 Fatal error: Exception: Template 'admin' is used by the homepage and thus must have the 'guest' role assigned. (in wire\core\Templates.php line 145)

but it seems like the error due to incomplete installation. The error log also has the same error only.

Share this post


Link to post
Share on other sites

Any guess I could come up with would be stabbing in the dark, so I'd probably look for the usual suspects, like full tmp drive, sql_mode settings, file/directory permissions and PHP memory limits.

  • Like 1

Share this post


Link to post
Share on other sites

Thanks for your opinion. I just try to use a blank site profile to start installation. This time it has no problem arouse. I am trying to figure out what is happening.

  • Like 1

Share this post


Link to post
Share on other sites

Unfortunately, I cannot find any clue to get my exported site profile running by connecting remote AWS RDS. The issue should be due to the exported database file.

install exported site profile and remote connect RDS database > stuck

install exported site profile and local database > success

install blank site profile and remote connect RDS database > success

And then I tried not using the default processwire installer but import directly to the database and copy the existing files. It shows error that I don't have page "view" permission, then I gave up. I rebuild everything from blank profile again and connect processwire to the aws rds at the beginning and everything is fine.

So, the conclusion is if you want to use aws with rds, maybe you should connect to rds at the beginning, otherwise you may stuck like me.

And one small piece of information. RDS is very slow when using remotely. The response waiting time increase to 2 seconds from around 100ms. The normal ping from my place to their server is 70ms.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By mushmush45
      Hi, 
      Could anyone advise me on the following system requirements, which I am missing for ProcessWire installation:
      DO (pdo_mysql) is required (for MySQL database)
      Fail: GD 2.0 or newer  Fail: JSON support ZipArchive support was not found. This is recommended, but not required to complete installation.    
    • By neosin
      During the install process I can never get to Step 4 for setting up an admin account.
      It creates the database and in the screen it shows it installed the database and imported the SQL
      and under that it shows "Profile Import" but nothing else.
      I have the same result with master & dev branch.
      I looked in the database and do not see a user table of any kind, unless it has some other name than "users"
    • By godmok
      Hi everyone,
      I can't get my head around this, so maybe someone can help: I want to know how install the dev branch of processwire with composer.
      I use laragon and the "quick create" function and there you can run composer like this: "composer create-project processwire/processwire %s". OK, this is working, so I will get the master branch from it, but how about dev? I found some examples for laravel on this question, but no luck with it. Here some examples:
      composer create-project processwire/processwire %s --prefer-dist --stability=dev composer create-project processwire/processwire:dev %s composer create-project processwire/processwire:dev %s --stability=dev composer create-project processwire/processwire:dev %s --prefer-dist --stability=dev composer create-project processwire/processwire:dev-master %s --prefer-dist --stability=dev composer create-project processwire/processwire:dev-branch %s --prefer-dist --stability=dev composer create-project processwire/processwire:@dev %s --prefer-dist --stability=dev and so on... Maybe someone got this already and would like to share?
    • By devlisa
      Hello. I'm not new to Processwire (I've been using it on a Mac environment for multiple site builds), but I am new to installing it on a Windows environment. I have unsuccessfully installed Processwire 3.0.62 both via downloaded zip file and GitHub on my Windows machine. The Site Installation Profile and Compatibility Checks are successful, and I am able to get past the MySql Database screen. However, this is where the installation process stops (step 3). The Test Database and Save Configuration screen says my database connection was successful and the configuration was saved to ./site/config.php and that's it, but I know from my ProcessWire experience I should also see fields for setting up the admin login etc. on this screen. I can't go any further after this. I've redone this process multiple times. I am running XAMPP, if that helps. Any clue what could be stopping the installation process?
    • By rushy
      Hello
      I've got off to a bad start trying to install PW on my local offline server, I must be doing something wrong as I have a bit of experience with Wordpress and it's running fine on my server, but I like the look of PW and hope to try it. Anyway I downloaded and unzipped the PW installation, the installation seemed to go right through ok, everything passed on the check lists. I selected the Default profile, and then when I try to click on Admin access or view the site I get "Not Found - The requested URL /processwire-master/about/ was not found on this server. Apache/2.4.10 (Ubuntu) Server at localhost Port 80"   Simply because the /about folder does not exist! It seems the profile has not been installed by the installation process despite everything else being ok? If I type localhost/processwire-master in the browser I get the Minimal Site Profile  "What is ProcessWire?" page but the links work "About" & "Site Map" don't work as the folders are not there. Bit confused as to why this is missing.
      Please put me out of my misery if it's something obvious I am doing / not doing!
      Many thanks - rushy
       
×
×
  • Create New...