Plesk 12.x / Linux :: PHPMyAdmin Permissions Change
Jan 28, 2015
CentOS 6.6
Plesk 12.0.18
64-bit
At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.
Is there a fix to get the permissions set so that I can make these changes again?
I am running Plesk 11.5.30 on CentOS and trying to change the default permissions of the /httpdocs folder and the skeleton site that is in .skel/0/httpdocs that appears when a domain is created. I have failed to find the event that I need to use to trigger the command.
I believe the product we are using is Parallels Operations Automation.
We have a customer that we want to be able to give the right to unlock user accounts. The only way to do this seems to be to enable "Billing" as one of the privileges. Unfortunately this gives them more access than we really want to. Is there some trick we can use to give this user only these rights?
I'm SURE this is me being stupid but I cannot find where to change folder permissions in the new Plesk interface?
I go to the file manager but all I have are the basic file/folder operations (Create, Delete, Upload File, etc) - I can't find anywhere to change permissions on the folders to give the MYSERVER_IUSR permission, etc.
I have a client on a dedicated IP, today we needed to downgrade the web hosting plan. As the web hosting plan puts users on a default shared IP, this plan change also changed the dedicated IP to the shared one causing some propagation issues for a small period of time.
I have contacted WHMCS about this asking if they had a way of changing the clients plan but keeping the IP address intact as this could lead to some very undesirable outcomes. They explained that it is not their fault and to contact Parallels.
I know I can change the plan directly in Plesk however by initiating the plan change via WHMCS, everything is automated.
Recently i installed the latest Multiple PHP functionality for Plesk and assigned PHP version 5.6 to a subdomain (for example demo.mywebsite.com) and i installed a Wordpress. So i thought i would try something out by installing a custom standalone version of phpmyadmin (version 4.4.1.1) and when i load the setup i ran into the following issue on the index.php page:
Code: Warning in ./libraries/session.inc.php#101 session_start(): open(/var/lib/php/sessions/sess_dubv0rqju6bejfplkgcsl98qsonviukg, O_RDWR) failed: No such file or directory (2) Backtrace ./libraries/session.inc.php#101: session_start() ./libraries/common.inc.php#352: require(./libraries/session.inc.php) ./phpinfo.php#12: require_once(./libraries/common.inc.php) note 1. Due to privacy i have called domain 'demo.mywesite.com' and subfolder 'root'
I made a backup of my website with plesk backup manager on an external FTP, now I want to restore this backup on a new server which isn't using plesk, for test purposes. I've downloaded the backup (which is in .tar) on my PC, and extracted all files firstly from the general .tar archive, then the user_data from .tgz. Then to extract all the databases (they were in a folder "databases" after I've extracted the general .tar file), I extracted them from database_name_145536536.tgz, then from database_name_145536536.tar, so that now I've a series of "database_name_145536536" files. (145536536 are some example numbers).
I'm interested in restoring both files and mysql databases.
To restore the files, I can simply use the extracted files from the user_data archive.
To restore the mysql databases, I tried to do "mysql -p -u username database_name < file" and everything seemed to work fine.
Is this process ok? Is it 100% safe and sure or I could face some bugs?
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
i've uninstalled nginx and php-fm from plesk panel.but phpmyadmin info still showing it is running on nginx 1.6 and while uploading sql file i'm getting 503 gateway error.
I deleted Nginx web server and reverse proxy support from Plesk. There is no this service on server, but I still see on the web server informations like nginx/1.6.0 at phpmyadmin page.
I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?
I had a old virtual Server with Ubuntu+Plesk12. I build a new dedicated Server with CentOS6+Plesk12 and migrate all Domains. Now i have a strange problem:
When i upload a file with FTP-User "user1", the file has the permissions Group=psacln & Owner=user1. All is fine, i can see and edit this file in a FTP-Program. But when my website create a file (cache html files or installed plugin folders in wordpress), I can't see, can't edit and can't download this files.
When i login to plesk with the admin account, i can see and edit this files. They have also Group=psacln & Owner=user1 and i can give them 0666 rights but when i login with FTP-User "user1" with my FTP-Program, I didn't see that files?!
Whenever I setup a new FTP user in Plesk and then configure my FTP client with exactly the same username and password and transfer files and folders onto the server then the file permissions allocated are incorrect. Folders get allocated a permission of 700 and files a permission of 600, whereas I want all folders to have a permission of 755 and files a permission of 644. How can I change my setup so that files and folders get the permissions I want ?
under Plesk 12.0.18 PHPMyAdmin is failing to import a 3 MB SQL dump of a simple Joomla website. "Error 505 Bad Gateway", it says.It happens with other dumps too, some as small as ~500 KB. The format (SQL or ZIP) of the file uploaded doesn't seem to matter, because the upload itself seems to work; it seems it's the post-processing what is raising the error.
The funny thing is that the import itself seems to work (the contents of the SQL dump are imported), but the error message appears and causes confusion and support requests from our clients./var/log/sw-cp-server/error_log says:
2015/05/15 03:19:31 [error] 10215#0: *5 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: XX.XX. XXX. XXX, server: , request: "POST /domains/databases/phpMyAdmin/import.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "xxxx. xxxxxxx.com:8443", referrer: URL.....To me it sounds like a timeout.
This seems to be a "popular" error among Plesk users, and I have tried this, this and this with no luck.
I have a problem where every folder I ftp onto the server gets given a 700 permission and every file gets a Zero permission. Most of the sites I am adding to this server will be WordPress sites and most of the folders I want to have a permission of 755 and for the files a permission of 644 so my question is how do I change the settings so that any new files ftp'd onto the server get the permission 755 and files get the permission of 644 ?
How can I make it so only the system (scheduled task or the server itself) can access to the file to execute it. I tried placing CHMOD 700 to the PHP file but everyone is still able to access to it and executive it.
I'm running Plesk 12. I install it today, using the ISO which parallels provides, which includes centos 6.5 and preinstalled Plesk 12 in my vps. Then I logged in plesk, and I did everything it wants. Then I upgraded my php, to php 5.4.36 according to the manual that Paralells provides, and then I tried to increase the max upload file size for phpmyadmin. I have edited my /usr/local/psa/admin/conf/php.ini file and tried to restart using with 3 different ways using terminal:
1st: service sw-cp-server restart 2st: /etc/init.d/psa stop /etc/init.d/psa start 3st: reboot (which rebooted all the vps)
My php.ini file is:
short_open_tag = On y2k_compliance = Off output_buffering = Off max_execution_time = 600 max_input_time = 600 memory_limit = 256M max_file_uploads = 99999 max_input_vars = 2000
[Code] ....
However, when I'm trying to import a 31mb sql file, I always get that error, and only some of my tables are being imported:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
I am runing ubuntu server 64bit with plesk v.11.5.30, phpmyadmin v.4:3.4.10.1-1.
When i try to acces phpmyadmin from : myserverIP/phpmyadmin - it gives me 500 error.
When I try to acces phpmyadmin from: mydomainserver/phpmyadmin - it saves file at login into the disk instead login. I was going through different threads on the web to solve that problem but no success at all.
I have real basic knowledge about webservers, phpmyadmin and mysql server. I am runing my first cloud server just few days.
There is no possibility to access preconfigured phpmyadmin from plesk according that thread: link So what for do I need plesk?
I found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?
This is how to reproduce:
From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.
Update the user privileges to the new Database name and remove the old privileges (save) Then manually update the wp-config file which contains the 'Database name' (save) Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings
Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.
I'm using wsftp checking permissions in domain.net in this directory: /public_html/mambots/content/plugin_jw_sig
through wsftp i saw chmod 755 but when i try to delete this directory appears with 550 and i can't delete it
So i used File Manager tool in Cpanel, selected directory to erase it, seems like was done, but when i refresh page the directory it's still there, so i try to change permissions because apparently it has 755 but i can't do anything with it, so when i click button to change permission i got an error message [a fatal error or timeout occurred while processing this directive]
Then i go trough wsftp to check again and this directory it's still there
