Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

non-Azure SQL Server #364

Open
JoeBergen opened this issue Aug 21, 2019 · 7 comments

Comments

@JoeBergen
Copy link

commented Aug 21, 2019

I am doing a project that will require WordPress on a SQL server, but I have been told not to use Azure so I am trying to deploy it on a SQL server that we have running IIS.

@JoeBergen

This comment has been minimized.

Copy link
Author

commented Aug 22, 2019

I downloaded the git repo and tried to deploy it but I am getting the error:
Your PHP installation appears to be missing the SQLSrv extension which is required by Project Nami. even though I have SQLSrv installed in the ext folder and listed in the ini file under extensions. What am I missing?

@patrickebates

This comment has been minimized.

Copy link
Member

commented Aug 22, 2019

It might be that you have some sort of mismatch between your PHP and SqlSrv versions.

Per our instructions at https://projectnami.org/download/ we highly recommend using the MS Web Platform Installer to prepare your environment.

@JoeBergen

This comment has been minimized.

Copy link
Author

commented Aug 22, 2019

Hey I just saw you in the video, hello.
Anyway, I installed IIS, Platform installer and the github repo. Then I searched SQLSrv in the Platform installer and looked for the version for 7.2 (my version of PHP) and installed that ALTHOUGH after installation it gave me a message that said PI failed to install, saying"this product cannot be installed because the product that it depends on did not install correctly." I assume that means that PHP did not install correctly?
Do I have to uninstall PHP, reinstall PHP then try to install SQLSrv again? If that is what I have to do, can I fully uninstall PHP simply by deleting the PHP directory or is there another step?

@patrickebates

This comment has been minimized.

Copy link
Member

commented Aug 22, 2019

Not knowing how you installed PHP initially, I can't be sure if all you need to do is delete the folder. But I would recommend removing it somehow and allowing WebPI to install everything.

@JoeBergen

This comment has been minimized.

Copy link
Author

commented Aug 22, 2019

yea I just changed the PATH, restarted and then tried to delete the extra PHP installation but apparently some of the files are open and cannot be deleted which is weird because I am not using this version of php anymore (I confirmed that the other version is being used with php --ini but I guess that is not really conclusive)

I also had to comment out this line in my php.ini file: ;extension=php_sqlsrv_72_ts_x64.dll It looks like my system is referencing some things from the old version of php and some things from the correct version... I cannot find any documentation or anything on how to switch PHP versions on windows not using XAMPP or Composer.. Do you have any idea how I do that?

@patrickebates

This comment has been minimized.

Copy link
Member

commented Aug 22, 2019

Maybe stop all IIS-related services and try the delete again?

@JoeBergen

This comment has been minimized.

Copy link
Author

commented Aug 22, 2019

ok there is only one installation of PHP now, the other one is deleted. I am still getting that error telling me that SQLSrv is missing even though I uncommented the line that specifies it as a PHP extension and copied the file "php_sqlsrv_72_ts_x64.dll" into my PHP extensions folder. This system is x64, but PHP installed into the x86 folder. Should I be using a different dll for the PHP extension?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.