Not Able To Export SQL Database Using phpmyadmin 4.9.2 As Standard Windows 10 User
Posted by: bill@wgvallance.com (---.spkn.qwest.net)
Date: July 29, 2020 01:52AM

I'm logged into a Windows 10 Professional v1909 machine as a STANDARD user. I am using WampServer v3.2.2 with phpmyadmin 4.9.2 and MariaDB 10.4.10. I log into phpmyadmin as the root user. When I try to export a SQL database as a .zip file using phpmyadmin 4.9.2 it looks like the file was saved in my Downloads folder. But when I check the folder nothing is there (I always keep my Downloads folder empty).

When I do the same thing when I'm logged in as and ADMINISTRATOR user, the SQL file is exported correctly to the Downloads folder for the administrative user. Why doesn't the file get exported when I'm logged in as a STANDARD user?

Options: ReplyQuote
Re: Not Able To Export SQL Database Using phpmyadmin 4.9.2 As Standard Windows 10 User
Posted by: Otomatic (Moderator)
Date: July 29, 2020 11:26AM

Hello,

Maybe because with a standard user you don't have sufficient write permissions in the downloads folder. You have to look for errors in the php and apache log files.

Perhaps the following will solve this problem.

This is a translation of a contribution that I had posted on the French forum Wampserver.

I have test launching of WampServer - thus starting services - in a "standard" user session that is to say without administrator privileges, and it works on my session W7 or W10 Pro 64-bit with two users:
- "Dominique" administrator
- "Otomatic" standard user

Everything that follows is to be performed in an administrator session:
This means that if you want to do this on a workstation that is part of an enterprise network, you will need to call your network administrator or IT manager.

Download the utility "Setacl.exe" the free version from the command line on the website [helgeklein.com]
This version:
Administrators: Download the EXE version of SetACL 3.0.6 for 32-bit and 64-bit Windows.

Unzip the file, which will create a folder: SetACL (executable Version)\ in which there are two other folder for 32 bit and 64 bit versions.
Open a command window into the 32 or 64 bits folder depending on the version of Windows. If you have a Windows 64-bit, it is imperative to run the 64-bit version of setacl.
In the command window, we will give the rights to a user to start, stop and read wampapache, wampmysqld and wampmariadb services, in my case the user without rights "Otomatic."
Generic command is:
setacl -on "service_name" -ot srv -ace "n:user_name_without_rights;p:start_stop,read" -actn ace
which gives the following two commands for WampServer:
setacl -on "wampapache" -ot srv -ace "n:Otomatic;p:start_stop,read" -actn ace
setacl -on "wampmysqld" -ot srv -ace "n:Otomatic;p:start_stop,read" -actn ace
setacl -on "wampmariadb" -ot srv -ace "n:Otomatic;p:start_stop,read" -actn ace
Of course:
- you replace Otomatic by the name of the user you want to allow to start the services.
- you replace service names by wampapache64, wampmysqld64 and wampmariadb64 if uou use Wampserver 64 bit.
The user account must exist before performing the commands.

By connecting with Otomatic session, I can start WampServer, which starts the services and pass the icon green with access to localhost and phpMyAdmin.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.3 32 bit - Apache 2.4.46 - PHP 7.4.9…5.6.40 - MySQL 5.7.31 - MariaDB 10.5.4
Wampserver 3.2.3 64 bit - Apache 2.4.46 - PHP 7.4.9…5.6.40 - MySQL 5.7.31/8.0.21 - MariaDB 10.5.4
PhPMyadmin 5.0.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Not Able To Export SQL Database Using phpmyadmin 4.9.2 As Standard Windows 10 User
Posted by: bill@wgvallance.com (---.spkn.qwest.net)
Date: July 29, 2020 04:48PM

Otomatic, thanks for the detailed suggestion. I was using Chrome v84 when I accessed phpmyadmin and wasn't allowed to save the SQL database to my Downloads folder as a STANDARD user.. I tried using the Edge browser and I was prompted to save the file to the default Downloads folder, or I could do a "Save as" and save it anywhere on my computer. I chose the Downloads folder and it saved perfectly.

The problem seems to be Chrome v84. Any ideas what may be causing Chrome to not allow saving to the Downloads folder when logged into Windows 10 as a STANDARD user?

Options: ReplyQuote
Re: Not Able To Export SQL Database Using phpmyadmin 4.9.2 As Standard Windows 10 User
Posted by: RiggsFolly (Moderator)
Date: July 29, 2020 05:08PM

We are not Chrome specialists but I have heard of some extensions getting in the way of this process in the past.
Basically the possibilities for Chrome to get in the way of what developers need to do over the last few years have become huge.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.0 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.19>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Not Able To Export SQL Database Using phpmyadmin 4.9.2 As Standard Windows 10 User
Posted by: bill@wgvallance.com (---.spkn.qwest.net)
Date: July 29, 2020 05:50PM

I found the problem.

When I installed WampServer, I was logged in to Windows 10 with an ADMINISTRATOR account. For whatever reason, the default downloads folder in Chrome v84 was set to the Downloads folder OF THE LOGGED-IN ADMINISTRATOR ACCOUNT. After WampServer had been installed and was working, I logged in to Windows 10 using a STANDARD user account. When I attempted to export a sql.zip file, Chrome v84 saved it to the Downloads folder of the ADMINISTRATOR account that I used to install WampServer!

In Chrome v84 there is a setting under Advanced\Downloads. It has two options; 1.) Select the default downloads folder, and 2.) Enable the "Save As" dialog box when "downloading" (in other words, saving) files. It appears that the Chrome v84 browser that is launched when PHPMYAdmin is launched from the WampServer tray icon has its Advanced\Downloads path hard-coded and doesn't recognize that a different user account is using PHPMyAdmin.

The workaround for this issue is to make sure that the second option in the Chrome v84 Advanced\Downloads setting, "Ask where to save each file before downloading" is enabled. Once this setting is enabled, the classic "Save As" dialog window will appear whenever you attempt to export a file using PHPMyAdmin. If you select the Downloads folder that is displayed in the "Save As" dialog box THAT WON'T WORK. It will save the file to the default downloads folder that is specified in option #1. If you want to save the file to the Downloads folder of the currently logged-in user YOU HAVE TO NAVIGATE THROUGH THE Users FOLDER to get to the Downloads folder of the currently logged-in user. If you want to save the file to a location other than the Downloads folder of the currently logged-in user that operation works correctly.



Edited 1 time(s). Last edit at 07/29/2020 05:51PM by bill@wgvallance.com.

Options: ReplyQuote


Sorry, only registered users may post in this forum.