Intalling latest verions getting need table prefix

[scrummie02]

I have one in there, but it doesn't see it. I keep getting table prefix required.

[scrummie02]

I get this error ERROR: "Table Prefix" must not be empty.

[scrummie02]

I edited the config.php and connected but it won't take a username. It keeps saying put in a valid user name even though I do.

[patrickebates]

Can you walk me through your install steps? I just performed a fresh install using Deploy to Azure and did not experience any issues.

[scrummie02]

Sure,

Uzipped name to a folder. Gave IUSR write permissions to directory (which are taken away after that – except for wp-content) I already have a database created in MSSQL.

Accessing the website and running though the regular wordpress type setup where it gets my information. When asking for DB info, it says I need a table prefix.

I just edited the wp-config to get around that, but now when asking for my site info, it says I need a valid name. Is there a setting in the DB or something else I need to set?

From: Patrick Bates [mailto:notifications@github.com] Sent: Sunday, September 11, 2016 8:43 PM To: ProjectNami/projectnami projectnami@noreply.github.com Cc: scrummie02 dain.bentley@gmail.com; Author author@noreply.github.com Subject: Re: [ProjectNami/projectnami] Intalling latest verions getting need table prefix (#131)

Can you walk me through your install steps? I just performed a fresh install using Deploy to Azure and did not experience any issues.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ProjectNami/projectnami/issues/131#issuecomment-246216052 , or mute the thread https://github.com/notifications/unsubscribe-auth/AAi9D1jAODp6gy1H3g3B0cyheM5Z44jZks5qpKADgaJpZM4J6JWd . https://github.com/notifications/beacon/AAi9D5-RLxYlkDnF2H1Tv2C6xSEBVvq2ks5qpKADgaJpZM4J6JWd.gif

[scrummie02]

My collation is SQL Latin

[patrickebates]

You're leaving the write permissions in place until you complete the initial setup, yes? The initial setup will create the wp-config.php file.

[scrummie02]

Yes sir

Get Outlook for iOS

On Sun, Sep 11, 2016 at 8:48 PM -0400, "Patrick Bates" notifications@github.com wrote:

You're leaving the write permissions in place until you complete the initial setup, yes? The initial setup will create the wp-config.php file.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[patrickebates]

So did the wp-config.php get created properly during setup? It should be almost 100 lines long.

Is wp-config-sample.php still present in the root? It's used during the creation process.

[scrummie02]

I ended up copying it and naming it wp-config. So from wp-config-sample to wp-config and put in my database info.

[scrummie02]

before I was getting I need a table prefix, even though one is in there.

[patrickebates]

It sounds like a permissions problem with wp-config.php, though I can't be certain. Anything in the php_error.log that might point to the issue?

[scrummie02]

IUSR has modify to the whole directory. As does the app pool identity. Nothing in the logs

[patrickebates]

Not sure what to say, but it sounds like WP couldn't read from wp-config.php

Not sure you would want to repeat the install from scratch, but I suspect you will find that after the file was created IUSR was missing read and/or execute rights on the file.

[scrummie02]

I haven’t gotten anywhere yet, so I can retry it. I’ll extract it again to that directory and give it a shot

From: Patrick Bates [mailto:notifications@github.com] Sent: Sunday, September 11, 2016 9:10 PM To: ProjectNami/projectnami projectnami@noreply.github.com Cc: scrummie02 dain.bentley@gmail.com; Author author@noreply.github.com Subject: Re: [ProjectNami/projectnami] Intalling latest verions getting need table prefix (#131)

Not sure what to say, but it sounds like WP couldn't read from wp-config.php

Not sure you would want to repeat the install from scratch, but I suspect you will find that after the file was created IUSR was missing read and/or execute rights on the file.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ProjectNami/projectnami/issues/131#issuecomment-246217902 , or mute the thread https://github.com/notifications/unsubscribe-auth/AAi9D-ZlhfwdNWJp7EBnu2Oq0VUMEGt-ks5qpKZ7gaJpZM4J6JWd . https://github.com/notifications/beacon/AAi9D2AW1oWAZWGkMDzTl3ZQYTzY5zmyks5qpKZ7gaJpZM4J6JWd.gif

[scrummie02]

Same error.

Extracted project name to the newest folder, gave IUSR write permissions, used PHP5.6, start setup.

I pick the language, input database info and I get:

ERROR: "Table Prefix" must not be empty.

From: Patrick Bates [mailto:notifications@github.com] Sent: Sunday, September 11, 2016 9:10 PM To: ProjectNami/projectnami projectnami@noreply.github.com Cc: scrummie02 dain.bentley@gmail.com; Author author@noreply.github.com Subject: Re: [ProjectNami/projectnami] Intalling latest verions getting need table prefix (#131)

Not sure what to say, but it sounds like WP couldn't read from wp-config.php

Not sure you would want to repeat the install from scratch, but I suspect you will find that after the file was created IUSR was missing read and/or execute rights on the file.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ProjectNami/projectnami/issues/131#issuecomment-246217902 , or mute the thread https://github.com/notifications/unsubscribe-auth/AAi9D-ZlhfwdNWJp7EBnu2Oq0VUMEGt-ks5qpKZ7gaJpZM4J6JWd . https://github.com/notifications/beacon/AAi9D2AW1oWAZWGkMDzTl3ZQYTzY5zmyks5qpKZ7gaJpZM4J6JWd.gif

[patrickebates]

What are the permissions on wp-config.php for IUSR and for the app pool identity?

[scrummie02]

Both have modify.

[scrummie02]

even if I put in erroneous information, the result is the same. It seems like that field isn't getting passed in the sessions or something.

[scrummie02]

I'm using php 5.6.24

[scrummie02]

SQLSRV support is also enabled. I have pdo_sqlsrv and the sqlsrv .dll's enabled.

[patrickebates]

But what other rights than modify? It's possible to have Modify rights to a file, but not be able to Read or Execute.

[scrummie02]

I has from modify down...ie...modify, read, write, execute...

[patrickebates]

Afraid I don't know what else to tell you, except to compare the permissions between wp-config.php and wp-config-sample.php as something must be different if you can copy the second one to create a useable file.

[scrummie02]

Even when I go through the process where the wp-config isn't there and the setup creates it, I get that prefix error. Is there a setting for SQL that needs to be selected? Collation setting or something liket hat?

[patrickebates]

No, that's handled only at the DB level.

It works properly after you copy the wp-config-sample and make the edits yourself, right?

[scrummie02]

It works until I fill in the info for username/site name..etc It won't accept a username. Even it's something simple like "admin".

[patrickebates]

So if you don't successfully complete the setup routine, no user gets created. Which I think is your problem about being unable to login.

I still think you have a permission problem. What if you start fresh but grant Everyone access to Read and Execute in the root of the site?

[scrummie02]

same error: ERROR: "Table Prefix" must not be empty.

This is when I do the default wordpress installation. I select language, input infor (db bame, passowrd, table prefix)...and this error comes up

[patrickebates]

So wp-config.php exists and appears to have the values written properly?

What about permissions for Network Service?

Beyond that, I don't know what else we can do for you. There is obviously a local configuration issue which we are not going to be able to assist you with much further.

[patrickebates]

Oh, I do see one thing that might be helpful. The error you mention is actually attempting to retrieve the table prefix from the POST object. So we're not to the point of using wp-config.php yet. It's as though the values didn't survive the submit.

[scrummie02]

that's it is there a workaround?

[patrickebates]

Never heard of this before, so no idea. How did you configure the PHP environment on the server? Did you use the Web Platform Installer from Microsoft?

[scrummie02]

Yes.  Used WPI.  And I installed the PHP tool so you can select the version via the IIS GUI

Get Outlook for iOS

On Mon, Sep 12, 2016 at 4:01 PM -0400, "Patrick Bates" notifications@github.com wrote:

Never heard of this before, so no idea. How did you configure the PHP environment on the server? Did you use the Web Platform Installer from Microsoft?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[patrickebates]

Did you install URL Rewrite 2.0 as part of the WPI packages? I know it's required for permalinks to function properly. Not sure if it would apply here. It now seems that IIS may not be passing all of the data to PHP, or that IIS doesn't have it either.

[scrummie02]

Yes.  I had generic Wordpress on here before 

Get Outlook for iOS

On Mon, Sep 12, 2016 at 4:05 PM -0400, "Patrick Bates" notifications@github.com wrote:

Did you install URL Rewrite 2.0 as part of the WPI packages? I know it's required for permalinks to function properly. Not sure if it would apply here. It now seems that IIS may not be passing all of the data to PHP, or that IIS doesn't have it either.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[patrickebates]

There's a few things I could find via Google https://www.google.com/?gws_rd=ssl#q=iis+php+%24_post+empty

They center around modules that may be interfering with the POST data, the possibility that the POST verb has been disabled, etc.

[scrummie02]

Ah.  I have url scan installed as a security measure.  I'll temporarily disable to see if that's the issue. 

Get Outlook for iOS

On Mon, Sep 12, 2016 at 4:19 PM -0400, "Patrick Bates" notifications@github.com wrote:

There's a few things I could find via Google

https://www.google.com/?gws_rd=ssl#q=iis+php+%24_post+empty

They center around modules that may be interfering with the POST data, the possibility that the POST verb has been disabled, etc.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[scrummie02]

I disabled URLSCAN and also granted everyone access, still no luck

[scrummie02]

Mod security on IIS was the culprit. We need to change some rules around. After disabling the module it worked.