I got a new workstation laptop at work and I of course I use Laragon for my local dev server needs. I am running into this issue where whenever any server request is made there is a HUGE request wait times of over 2 seconds in my laravel application. If I create a simple 2 page html product that just have a anchor to each page navigation is super fast.

Any ideas as to why I am seeing this long wait time? I am including a screenshot to my "main" page of my laravel project to show the timings from the network tab of the initial get request when hitting the root endpoint. The rest of the requests (loading js, css, font awesome, etc.) are all maxed out at 158ms of wait time.

Re: how do I surf in to my .dev site from my android if I am on same wifi

I found this post that describes my issue by @nermamax, it's from 2017 so I was advised to start a new thread.
the solution was:
*server {
listen 80;
server_name myapp.dev .myapp.dev 192.168.1.80;
but I don't quiet understand how to put this into action or in my address bar,
so for example, if my IP to my wired (lan) desktop is:
10.0.0.62
and my Laragon localhost site is:
test.test
does that mean that I should use the address in my Android address bar (wifi):
test.test/10.0.0.62:80/ ?
It must not be right as it's not working.

Thanks for any help

I have a query like this

SELECT tt.* FROM `laravel-sb`.`chats` tt INNER JOIN (SELECT chatroom_id, MAX(created_at) AS MaxDateTime FROM `laravel-sb`.`chats` WHERE `receiver_id`=7 GROUP BY chatroom_id) groupedtt ON tt.chatroom_id = groupedtt.chatroom_id AND tt.created_at = groupedtt.MaxDateTime WHERE `receiver_id`=7 -- and `sender_id` = 1 Order By Not isNull( seen_at ), created_at DESC, millisecond DESC

I try to put it into laravel like this

$query = DB::select( DB::raw('select tt.* FROM `chats` tt INNER JOIN (SELECT chatroom_id, MAX(created_at) AS MaxDateTime FROM `chats` WHERE `receiver_id`= ' . $profileId . ' GROUP BY chatroom_id) groupedtt ON tt.chatroom_id = groupedtt.chatroom_id AND tt.created_at = groupedtt.MaxDateTime WHERE `receiver_id`= ' . $profileId . ' Order By Not isNull( seen_at ), created_at DESC, millisecond DESC ') )->get();

The query works in my sql editor, but not in laravel.

I get the error:
Illuminate/Database/QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea

SERVICE Apache can not start, Reason

Port 80 is use!

To find out which program is using the port.

Click Menu >tools>netstat.

any help , thanks

I'am using Laragon 4.0.16 (190914) and MySQL 8.0.16 but when I want to start MySQL server it throws an error "Service MySQL can not start. Reason: Unknown. Please check MySQL log file".

I'am on Windows 10.

Attached is MySQL log file for review : 0_1574132412948_mysqld.log

Hi,
I have recently Installed laragon 4.0.15 on windows 10 and when i start the servers Apache works fine but for MySQL i get this error message saying MySQL can't start reason Can't create test file C:\laragon\data\mysql???.lower-test,
Now What's causing this error???
I've set full permission to C:\laragon Folder It still doesn't work, then i completely removed it and installed it again on (D:) Drive Still doesn't seem to work.....
any Help?????

Please HELP ME:

I for some reason deleted the ibdata1, ib_logfile1, ib_logfile0 mysql data folder, then i realized all my databases are gone. I have also cleared my recycle bin.

Is a there a way I can recover or restore the databases?

Thank you.

Re: Avoid Site access with url.dev:8888/ with Nginx

This is an older topic, but though the previous solution (in the link referenced) of swapping the Nginx Port numbers with Apache ports numbers is pretty hacky.

Though it's a quick solution that works, I'm left wondering... Is there a better way to get Pretty URL's using Nginx on Windows besides swapping the port numbers?

Want to change this: https://mysite.oo:8443 to only this: https://mysite.oo

Anyone know how to solve this? The apache failed to start after i switched my php from 7.2.19 to 5.6.9. Thanks

I recently installed Laragon and updated php to 7.VC15 x64 TS and updated MySQL to 8.0.18 winx64 However MySQL fails to start. The error log shows the following:

2019-10-25T19:25:57.983319Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2019-10-25T19:25:58.535346Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:58.924966Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:59.026855Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-25T19:25:59.031943Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2019-10-25T19:25:59.033424Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2019-10-25T19:25:59.035749Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2019-10-25T19:25:59.039508Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-10-25T19:25:59.041000Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2019-10-25T19:25:59.047275Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-25T19:26:00.287089Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.18-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.

I thought that I should be able to easily switch between MySQL/MariaDB versions. Apparently I was wrong.

Any help will be greatly appreciated

Hello people. I hope you are all good, I discovered the laragon recently and brother, this is going to take the place of xammp quickly, is a very, very very good server.

I want help with something, I have a local network, and I'm using laragon to host sites that will only be accessible to anyone on the network, but I can only access the site through the ip address of the machine where is installed argon, I happen to not want it to be ip, I want it to be a domain name just like the localtunnel program but with a custom url.

I researched some programs like ngrok, and if paying for this program puts my site online I do not want it, I want it to be accessed only on the local network but with a domain name without ip

can you help me please.

I've already edited the httpd.conf. Mod_rewrite is enabled.

LoadModule rewrite_module modules/mod_rewrite.so

DocumentRoot "C:/Users/mda/Desktop/Work/example.com"
<Directory "C:/Users/mda/Desktop/Work/example.com">
Options All
AllowOverride All
order allow,deny
allow from all
</Directory>

Have a .htaccess file in document root. No matter what i change it to, nothing happens How do i solve?

In my config file I have set: define('BASE', 'http://site.test/');

In production it works (changing .test to .com), but in the localhost, no one of the links work (css, js, nothing). In view-source I see something like: <link rel="stylesheet" href="http://site.test/assets/bootstrap/css/bootstrap.css">, and if I click on it, it give me the DNS_PROBE_FINISHED_NXDOMAIN message.

Currently, when clicking a project under the "www" menu list, Laragon takes us to the projects' main home page for the CMS (WordPress) install.

http://localhost/(WordPress Project Name)/

I am trying to find how I can change it, to make the "www" menu link go directly to the WordPress "wp-login.php" page instead.

http://localhost/(WordPress Project Name)/wp-login.php

Is this possible?

Thanks

Laragon 4.0.15 on Windows 10

I'm trying to manually enter into Windows hosts file, a few hosts of my local network (192.168.x.x), but they get automatically commented out (a hash # sign before host's entry)!?

Does Laragon control hosts file?

Thanks for any advice!

Hi @leokhoa I have difficulties to use XDebug with the last php 7.0.8
I have added to PHP extensions directory, the last version of XDebugfor PHP 7 NTS 32bits.
And in php.ini :

[XDebug] zend_extension = php_xdebug.dll xdebug.default_enable = 1 xdebug.remote_autostart = 1

In phpinfo() I could see that XDEBUG is correctly loaded and listen on port 9000.

But I don't success to debuggPHP code in Microsoft Visual Studio Code and its PHP Debug extension:
https://marketplace.visualstudio.com/items?itemName=felixfbecker.php-debug

With php 5.6.16 it was working nicely.
Not sure what I am missing here.

Thanks for an awesome platform!

Quick q when I use the Menu > www > share > project_name It says thats it's working, but I noticed that it didn't automatically change the auto hosts file. I had to rename it and remove the auto. part from the file name, for the ngrok hostname to be added automatically.

is it a bug? It doesn't seem automatic.

Also where do I add my .yml file to use my login for an unlimited time domain? All my shares have a 7 hour limit. after creating an account it saved a file to C:/users/paulka/.ngrok2/ngrok.yml and if I manually setup ngrok it works, but not when using the auto setup.

Want to use Laragon on Ubuntu, is it possible?

Hi

I've run into some issue setting up unit testing for WordPress plugins using PHPUnit.

Following this guide for setting it up, I've run into a problem with the command "bin/install-wp-tests.sh wordpress_test root '' localhost latest".

Cmder appears to use Git Bash to execute this command and I get the error "install-wp-tests.sh: line 150: mysqladmin: command not found".

I've tried adding "C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin" to PATH for "mysqladmin.exe". However, it still won't recognize it.

I use codeigniter 3.1.9 to do project. But there is a database problem. I can not completely turn off sql mode only_full_group_by. I used phpmyadmin to stop but after every reboot laragon, only_full_group_by mode is automatically turned on.
"Error Number: 1055
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigproject.site_log.access_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"