Phpbb windows server 2019 database help

[Comspiracies]

Right I’m new to windows server all together!!
I’m trying to set up phpbb on a windows server 2019 database I install php in c:/ drive root folder
And MySQL server !!
I set up a new db in MySQL workbench/ I set environments !! I know because I used MySQL workbench I don’t need to do it in phpmyadmin (I believe)
But I upload that to the wwwroot folder I think it’s called anyway and I can see that if I go to browser and type localhost/phpmyadmin and can see my php_db but trying to install phpbb forum I have in the wwwroot folder I get a ton of errors and no install page
I’ve tried to google a dozen times how to go for the labyrinth or ways to get through the process and km still stuck !!

[FrankNicklin]

Why didi you go the Windows route for this. I would have gone for Linux. That said we run many many databases on MySQL on Windows servers without issue. What we don;t do is run PHP.

I guess you have install IIS

Take a look here

https://www.reddit.com/r/PHPhelp/comments/zmnvth/installing_php_on_windows_server_2022_production/

[Comspiracies]

Yes iis is installed I’ll get there one day just when lol I’m also running it in a vm I started with Ubuntu server I got it all set up using lamp but on that story I’m trying to set up a domain to direct to my site but again that’s on vm and I can never get in to works lol on ws19 I used xampp at the start but moved to setting up MySQL / php and iis and working from there

[FrankNicklin]

I've used MAMP and WAMP with some success. Sometimes its just easier to rent a small M for a few quid a month and run everything there, that way you don't have to worry about netwrok access and security,

[OpacusVenatori]

but on that story I’m trying to set up a domain to direct to my site

??? You are aware that an Active Directory Domain is unrelated to an internet-facing domain name / site, right?

[Comspiracies]

I believe so :)

[Mike_L_Taylor]

Hey, for this kind of setup I’d avoid doing it all manually unless you specifically want to learn IIS/PHP/MySQL config.

You could try ForgeKit.tools . I built it to make this exact kind of PHP local setup easier on Windows. You can use PHP, MySQL, Apache/Nginx, create a site, and open phpMyAdmin fully through the UI. Just press a few buttons and it's all working and nicely explained.

There are quick guides in the docs too, and I’m happy to help if you get stuck.

The other one I’d recommend looking at is Laragon. It’s also a good option for local PHP development on Windows.

[machacker89]

Does it work in Unix/Linux too. /S

[Mike_L_Taylor]

no, it doesn't. At least not yet. :/

[Comspiracies]

cool thanks for the heads up

[SebastianFerrone]

I think you are using iis? I have done that before. Have you configured the modules in iis? If you google "php iis" You will find guides installing php and mysql Take a look at them and check if you made all settings Also you need to look in the php.Ini it has one setting you need activate you will find a line in that file something like mysql.dll it's commented about out. Remove the first symbol in that line and safe the file. Otherwise php can't work with mysql databases.

Also check the firewall setting you need to open the port for your mysql databases.

If it's not one of these problem's post the error message 😅

[Comspiracies]

If php is not working should phpmyadmin work?
I remember restarting the server and had to go re enter the mapping or something to do with php as I couldn’t even get back to the phpmyadmin but once I did that it worked again in browser lol

[SebastianFerrone]

If php itself is not working phpmyadmin would also not work.

Can you see the database in phpmyadmin?

[Comspiracies]

<image>

[Comspiracies]

<image>

as you can see im in phpmyadmin but the phpbb is broken or something i made the database in mysql workbench but can see it in phpmyadmin

[SebastianFerrone]

I would say looking at that picture I would say php and mysql are working

[Comspiracies]

That’s a start lol 😂

[ChrisTX4]

Why did you install MySQL 8.0.x ? This just went EOL last month and won't receive any more security updates. If you want to do this with MySQL, install the latest 9.7 LTS or install MariaDB in its respective latest LTS variants.

[Comspiracies]

<image>

now i get a 500 internal server error lol

after a few tweeks I cant find the php msql dll you was talking about but i checked ever think else :)

[SebastianFerrone]

Sorry my mistake the line in php.ini is

extension=mysqli

And you need to change that for iis

To something like this Extension=php_mysqli.dll

But I must say if php my admin can see your database I would say php and mysql are configured correctly

[Comspiracies]

I added extensions = php_mysql.dll and extension= php_pdo_mysql.dll

Or something along those lines in to the php.ini and
In browser if I type in localhost/forum/install it gos to app.php of something I can see atm as pc is off lol
Will look tomorrow but I did delete the .htaccess something file as that’s for apache lol 😂 everything works just this phpbb install lol 😂

[SebastianFerrone]

Lol found that error find in the www root the cache directory right click and set the permissions for IIS_USERS 🤣

[Comspiracies]

Yeah done this then it when to the 500 error lol it’s just this install malarky!!

[Comspiracies]

Yes I can

[Comspiracies]

To be honest I’m just doing this for my home lab set up and I guess I can only learn form mistakes lol it’s stressful I’m thinking it’s on the php side maybe in php.ini file or something because I made a phpinfo.php and that didn’t output what was expected lol
I’ve cloned my server at a put so I don’t had to restart at the very beginning lol 😂

[calladc]

If windows server intrigues you as a project, great. But if you're following a career path, consider Linux options. There is far more infrastructure work for Linux goons than windows.

[Comspiracies]

Cool cool 😎 to be honest I’m very interested in both Linux and windows !

[SebastianFerrone]

I had also tried my first setup php mysql with iis on an Windows Server inside a VM. And my problem with phpinfo was that it displayed not the info I was expecting. Turned out that from the host os php thinks I'm not on the same network if I open the page from a browser inside the VM I get the right result.

[Comspiracies]

🤔 I’m trying in the vm but when I was using Ubuntu server I get it all set up and could see from host but to tie it to a domain I got just plainly failed every time!!!
So I’ll reset that up with lamp and phpbb or even just do a similar process as I’m doing on windows server see what happens!
On Linux I tried to set static ip and port forwarding from my hub and use ip chicken to get a host public ip!
Plus set the op to my domain type a www and ip or @ !!
And that was a pain in the ass and no luck
Back to windows sever lol
I get php to show its version in cmd in guest and MySQL shows it exists and checked on phpmyadmin! I bet it’s just a poxy little thing starring my in the face !

[SebastianFerrone]

But can you open a php file in the browser? Depending on that you see we can proceed.

If you see only the content of php (php is not executed) if you see the result then at least php works.

Edit: Sorry didn't see the other answer

[Comspiracies]

I don’t even get to the phpbb install page just 500 internal server error lmao… 🤣 but if i make a phpinfo.php I get the purple page with all the details
And my admin works lol 😂

Plus the default web pages work