Where I can get full country list ? I need it to my new site and there missing lot of country in the list. I have 109 country but world have more ....
List must be like this:
(1, 'af', 'Afghanistan'),
(2, 'dz', 'Algeria'),
(3, 'ar', 'Argentina'),
(4, 'au', 'Australia'),
Have search on internet but not find good sites!
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'
[code]....
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?
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?
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.
View 4 Replies View RelatedI'm trying to get a list of all sites on a Plesk 12 server. This is the request:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<packet version="1.6.6.0">
<site>
[Code].....
Plesk: 12.0.18
phpMyAdmin: 4.2.5
When I try to access phpMyAdmin directly from the link: [URL] ....
I get the following error:
Welcome to phpMyAdmin
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
Retry to connectClick to expand...
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.
View 3 Replies View RelatedI 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.
View 6 Replies View RelatedI'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?
View 2 Replies View Relatedwhy a client orders a dedicated server from Russia but then they inform us they have transferred the money from Hong Kong bank Telegraphic transfer, different person?
We really do our best to be reasonable but what is the logic behind that?
I installed Plesk on a VPS running on Ubuntu 14.04. When I try to open phpMyAdmin the following error message appears:
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: cannot connect: invalid settings.
When I try to click on the setup script link another error message pops up:
Error in Processing Request
Error code: 404
Error text: Not Found
What do I have to do to make phpMyAdmin work?
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.
One of my users is unable to connect to his database using phpMyAdmin. The query is:
LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '
And mysql reports:
#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)
The funny part is that I can connect without any problems from a shell like this:
mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>.
This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.
today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?
I don't remember to update anything during this days to this happen.
Impossible to find a way to show, by default, all domains and websites...
When I log on the Plesk Admin, I come first on a list of websites and domains, but they are not «all» listed. I have to go to the full bottom of the page to click on «Show all».
I didn't find a preference or anything else to change that, and I don't understand why all domains are not listed.
I would find an easy way to add a list of IP in Fail2ban whitelist in linux console.What is the file to modify ? Is there a command line or a process ?
View 4 Replies View RelatedI'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.
Is there any way of updating this?
Is it possible to query for a list of system users using the API RPC? I know it's possible with a MySQL query
Code:
select id, login, account_id from sys_users order by login;
I've searched through the API RPC manual, but I don't see a way to do this. I always have to specify a filter, I can't find a way to just query for all users.
After a migration I did this weekend I mis a couple of the migrated domains in the subscription list. The domains are working great, but I cannot find them in Plesk.
I got this errors in the migration manager:
Info:
The password was generated for user 'Domain Administrator (domain.com)'. New password is 'GA66QgQ'
Warning:
Execution of /opt/psa/admin/plib/api-cli/user.php --create domain.com -owner admin -guid cfa43606-e8b0-444c-a005-660984840498 -cname Domain Administrator (domain.com) -passwd '' -status disabled -domain-admin true -email '' -external-email true -role Domain Administrator (domain.com) -country NL -legacy-user false -subscription-name domain.com -ignore-nonexistent-options failed with return code 1.
Stderr is
Error during user creation: Owner with id 1 has not subscription with id 69
Warning: domain "domain.com"
Execution of /opt/psa/admin/bin/backup_restore_helper --restore-legacy-dlu domain.com -dlu-info /opt/psa/PMM/tmp/deployer_legacy_dluIrjcWa -ignore-nonexistent-options failed with return code 1.
Stderr is
Unable to create Account object: Account: unable to select: no such row in the tableClick to expand...
In my documents I have command:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select name from domains" | grep -v 'name' > domains.txt; while read i; do echo $i; /usr/local/psa/bin/domain_pref -i $i | grep nonexistent; done < domains.txtClick to expand...
I have Plesk 12 on Centos6.I require a list of every subscription which has consumed the most data on the server. Disk space used by the following files and directories in the subscription:
Websites
Mail accounts
Databases
Logs
Backups
Chroot directories
Configuration files
Anonymous FTP directory
The Plesk bible only listed that this was possible through Subscriptions > Statistics. URL....However viewing the Subscriptions > Statistics is not an option because there are many subscriptions..I also have access to SSH/terminal and found a script for finding large file and directories here URL....However i rather have it in excel or HMTL format.
I have a customer that would like a list of their email addresses including all aliases and forwarders. Is there an option to export email addresses to CSV? I can't seem to find anything in the control panel and I dont want to copy and paste 300 addresses.
View 8 Replies View RelatedI am trying to update Plesk but whenever i try do so with the installer, the update fails because data is somehow added to /etc/apt/sources.list and sources cannot be read anymore. This happens both with the admin panel and the command lines.
Here is the command I'm running:
Code:
plesk installer --all-versions --select-product-id plesk --select-release-latest --show-components >/dev/null && plesk installer --version
Here is the output :
Code:
Doing restart of Parallels Installer...
File downloading products.inf3: 100% was finished.
File downloading plesk.inf3: 10%..20%..30%..40%..50%..60%..70%..80%..90%..100% was finished.
File downloading ppsmbe.inf3: 18%..79%..99%..100% was finished.
[Code] ....
And here is the content of my /etc/apt/sources.list file after the command is ran:
Code:
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/usr/sbin/nologin
bin:x:2:2:bin:/bin:/usr/sbin/nologin
sys:x:3:3:sys:/dev:/usr/sbin/nologin
sync:x:4:65534:sync:/bin:/bin/sync
games:x:5:60:games:/usr/games:/usr/sbin/nologin
[Code] ....
The piece of data above the sources keeps coming back everytime I run the command even though I'm deleting it.
I'm trying to setting plesk backups to own ftp server.. My ftp server is listening by the port 31..
My conf:
Server: mydomain:31
Directory: vpsbkp
User and password...
Passive mode checked
Here the error display: "Transport error: unable to list directory: Curl error: Couldn't connect to server"
Where are the bkp ftp logs?
I'm attempting to utilize the WordPress Toolkit. After clicking scan on a webspace with WordPress installed the panel returns the error "'plugin list' is not a registered wp command. See 'wp support'.".
I've tried it on a few servers that has the WordPress Toolkit installed, but they all return the same error.
apparently Envelope-From, Sender and Errors-To headers are set to a wrong address for messages from mailman to the list-owner. This is particularly true for mails like 'message requires approval'.
It seems like the plesk<->mailman magic results in all list-domains being written to the end of /var/lib/mailman/Mailman/mm_cfg.py in the following format: add_virtualhost('list.DOMAIN').This in return results in mail headers Envelope-From, Sender and Errors-To of mailman system mails like described above being set to mailman-bounces@DOMAIN, where DOMAIN is the one from the last add_virtualhost entry.
In my opinion, this obviously is a bug. Maintainance mails from mailinglists have wrong headers set, often with a domain that belongs to a completely different customer than the mailinglist.
I found the following discussion on mailman-users mailinglist from 2008 which discusses the same issue - also a plesk setup: URL....
I have a problem with on domain. The domain is the "main-domain" of the customer but it is not shown in the overview /smb/web/view
Not with the User logged in and not with the admin logged in.
But I can change setting, when I call the detail-page manually: /smb/web/overview/id/d:26
I tried to lock/unlock the domain/account, but nothing worked.
I could not see any mistakes in the database.
Deleting and adding the domain would be a trick, but because of having many domains/subdomains and dns-entries this is not my first choice.