• RELEVANCY SCORE 4.68

    DB:4.68:Plesk And Mysql Database Dont Work... mp







    I, since 3 days, all of my website dont works, because Plesk and Mysql is out.

    This is the report when I try to launch Plesk :

    Code:

  • RELEVANCY SCORE 3.83

    DB:3.83:Mysql Root Password af







    Dear All,
    I am new to plesk and have been given assignment to work on it. I even dont know the version on plesk installed on the server. I have written shell script that takes the MySQL database backup but I dont know root password. Can you please help me to get root password so that I can test my shell script? I even cant login to MySQL using user admin and same password as plesk panel. PLease guide me about it and I will be thankful to you guys.

  • RELEVANCY SCORE 3.72

    DB:3.72:Question On Mysql Database Replication 83







    We are running a load balanced environment with two servers. We dont have a need for mysql clustering, but we did setup mysql database replication.

    This seems to work fine - except:
    Within the plesk interface on the slave server the databases do not show up. We can log in via a shell and see that the databases have replicated and that data is there, the slave updates fine whenever we change data in the main server.

    What is kind of weird about this is that we did a test earlier with one of the databases (no databases were defined on the slave at all), started replication and that database shows up in the plesk interface however the subsequent additional databases are not there.

    Anyone have any ideas?

    DB:3.72:Question On Mysql Database Replication 83




    We are running a load balanced environment with two servers. We dont have a need for mysql clustering, but we did setup mysql database replication.

    This seems to work fine - except:
    Within the plesk interface on the slave server the databases do not show up. We can log in via a shell and see that the databases have replicated and that data is there, the slave updates fine whenever we change data in the main server.

    What is kind of weird about this is that we did a test earlier with one of the databases (no databases were defined on the slave at all), started replication and that database shows up in the plesk interface however the subsequent additional databases are not there.

    Anyone have any ideas?

  • RELEVANCY SCORE 3.68

    DB:3.68:Odbc Error #08s01: [Unixodbc][Mysql][Odbc 5.3(W) Driver]Cant Connect To Local Mysql m7





    Im getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. However database seems to work fine, I can access phpMyAdmin without problems under Settings - Database Servers. PHP 5.5 using Remi repository.

    Code:

    DB:3.68:Odbc Error #08s01: [Unixodbc][Mysql][Odbc 5.3(W) Driver]Cant Connect To Local Mysql m7




    So youve determined that either MySQL server has changed socket location, or that your ODBC driver changed socket location. I am guessing the latter, because your pHPMyAdmin still works fine.
    Maybe you can change the ODBC config file? What you can also do is change the MySQL hostname from localhost to 127.0.0.1

    This is a subtle differences, but it causes ODBC to connect over TCP/IP instead of using UNIX sockets.

  • RELEVANCY SCORE 3.66

    DB:3.66:Adding Mssql Database Server Type 87





    Hi Guys,

    I am looking for a way to add my instance of MSSQL server via the plesk control panel as an alternative to the mySQL that is available by default.

    If I go to SERVERDATABASESERVER the only option for Database Server is mySQL and want it to be MSSQL as I do not use mySQL.

    I am happy to leave the service on, just dont need it (currently)

    Many thanks

    DB:3.66:Adding Mssql Database Server Type 87




    Hi Guys,

    I am looking for a way to add my instance of MSSQL server via the plesk control panel as an alternative to the mySQL that is available by default.

    If I go to SERVERDATABASESERVER the only option for Database Server is mySQL and want it to be MSSQL as I do not use mySQL.

    I am happy to leave the service on, just dont need it (currently)

    Many thanks

  • RELEVANCY SCORE 3.62

    DB:3.62:Plesk Using External Mysql 8k





    I know there has been talk of Plesk expand allowing distributed services, but what I really want to know is, is it possible to have Plesk use the psa database that exists on an external database, instead of the local server?

    DB:3.62:Plesk Using External Mysql 8k




    Does this SQLrelay thing also work for the clients? Are the database clients create, created on the remote server?

  • RELEVANCY SCORE 3.58

    DB:3.58:Connecting To Mysql Database Via Asp s1





    Hello

    I have created a mysql database on my plesk control panle and created a user with name and password.

    But for what ever reaosn my dnsless connection does not work.

    I have used both drivers MySQL ODBC 3.51 Driver and mySQL, but neither worked

    my connection string is:

    Conn = Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=visits; UID=callum; PWD=russell;

    Which I have used many times without the plesk control panel, but for some reason its not working, I noticed that on my hosted companies help files it mention setting permissions but i keep getting this error message:

    Microsoft OLE DB Provider for ODBC Drivers error 80004005

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /Index.asp, line 8

    Any help or advice would be appriciated

    Cheers
    Dave

  • RELEVANCY SCORE 3.58

    DB:3.58:Web /Mysql Server Setup ? dp





    any problematic issues with having a plesk server as a web server but connecting to a 2nd mysql database server ?

    can the plesk control panel manage databases remotely ??

    DB:3.58:Web /Mysql Server Setup ? dp




    The control panel wont connect to remote database servers. Although there shouldnt be any problem using php to connect to the remote database server. Just so you know you can connect to a mysql database on a plesk server from a remote machine to administer the database.

  • RELEVANCY SCORE 3.56

    DB:3.56:Migrating From Cpanel/Helm To Plesk f3





    If I setup a remote MySQL/PostGres database in plesk and migrate from cpanel. Would it setup the database on the remote server properly?

    DB:3.56:Migrating From Cpanel/Helm To Plesk f3




    If I setup a remote MySQL/PostGres database in plesk and migrate from cpanel. Would it setup the database on the remote server properly?

  • RELEVANCY SCORE 3.54

    DB:3.54:Migrate Database 3c





    I have Centos and Plesk 11 as I could help migrate mysql 5.0 to mysql 5.1

    Thanks for your help

    DB:3.54:Migrate Database 3c




    http://forum.parallels.com/showthread.php?290814

  • RELEVANCY SCORE 3.51

    DB:3.51:Dont See Ms Sql In Plesk? d8





    MS SQL is installed on the server but I dont see it in Plesk under the database button - only MySQL. I have a company that built and manages the server and they said that they installed it it in the correct order - sql then plesk.

    No one seems to know why it isnt showing up.

    Any suggestions?

    Oh yeah and did I mention that I cant get web mail to work or even logon through Frontpage because of permission problems which I know are good.

    It looks like a great product - if it worked.

    BTW its a win2003 box.

    Any help is greatly appreciated.

    DB:3.51:Dont See Ms Sql In Plesk? d8




    i just got a Dedicated server with plesk (no SQL support) then i installed SQL server 2000 Standard and asked my server provider to install SQL support in plesk.

    it worked for a couple hours and then stopped. while it was working i was able to create 1 database and was able to go into enterprise manager and see that there were 2 instances of SQL server (Local and the named instance that i installed) the local install must have been MSDE - the local was the one that my databse was created in.

    at this point i realized that the plesk SQL support pack must have installed MSDE, but i want plesk to use the SQL server standard, not MDSE.

    so.... i uninstalled my named instance of SQL server and then with the SQL Server install program, upgraded MSDE to SQL server 2000 standard.

    thats when plesk stopped working with the database.

    and enterprise manager woudl nto open the local instance either.

    so my quetions are:

    1) how do i fix plesk so it interacts with SQL correctly?
    2) what is the proper way to make plesk work with SQL Server 2000 Standard instead of MSDE.

  • RELEVANCY SCORE 3.51

    DB:3.51:Catastrophic Login Failure: Plesk 7.0.4 xf





    We cant login to Plesk.

    Version: 7.0.4

    We have had to reset passwords to terminate an admin, and have changed passwords in our MySQL database but dont know how to change the Plesk interface so that we can run our business!

    We get this message:

    Unable to connect to database: saved admin password is incorrect.
    0: /usr/local/psa/admin/auto_prepend/auth.php3:438 psaerror(string Unable to connect to database: saved admin password is incorrect.)

    If someone can point us to the corrrect docs we will be on our way.

    Thanks!

    DB:3.51:Catastrophic Login Failure: Plesk 7.0.4 xf




    We fixed it.

    We stopped/restarted Plesk.

    All appears normal now, but did see this:

    /usr/local/psa/admin/bin/httpsdctl stop: httpd stopped
    Stopping Plesk: [ OK ]
    Stopping xinetd: [ OK ]
    Stopping named: [ OK ]
    Stopping MySQL: [ OK ]
    Stopping Courier-IMAP server: [ OK ]
    Stopping imap [ OK ]
    Stopping imap-ssl [ OK ]
    Stopping pop3 [ OK ]
    Stopping pop3-ssl [ OK ]

    Shutting down spamd: [ OK ]

    Stopping httpd: [ OK ]
    [root@theserver htdocs]# /etc/init.d/psa start
    === Reading /etc/psa/psa.conf ...
    Starting xinetd: [ OK ]
    Starting named: [ OK ]
    Starting MySQL: [ OK ]
    Starting qmail: [ OK ]
    Starting Courier-IMAP server:
    Starting imapd [ OK ]
    Starting imap-ssl [ OK ]
    Starting pop3 [ OK ]
    Starting pop3-ssl [ OK ]

    Starting spamd: [ OK ]
    Starting psa-spamassassin service: [ OK ]
    0
    websrvmng: Service httpd failed to gracefully restart.
    websrvmng: Service httpd failed to gracefully restart.
    0
    /usr/local/psa/admin/bin/httpsdctl start: httpd started
    Starting Plesk: [ OK ]

  • RELEVANCY SCORE 3.48

    DB:3.48:Moving A Mysql Database 7k





    Okay, I dont really want to move the database. What I want to do is change the domain that the database is associated with in the Plesk control panel. I have found the proper table to change, I believe it is data_base, unfortunately the column I need to change is name and it is of type tinyblob. So I dont know how to resolve the name of the MySQL database so that I can change the column dom_id so that it appears under a different domain in Plesk. I hope all that makes sense.

    DB:3.48:Moving A Mysql Database 7k




    Okay, I dont really want to move the database. What I want to do is change the domain that the database is associated with in the Plesk control panel. I have found the proper table to change, I believe it is data_base, unfortunately the column I need to change is name and it is of type tinyblob. So I dont know how to resolve the name of the MySQL database so that I can change the column dom_id so that it appears under a different domain in Plesk. I hope all that makes sense.

  • RELEVANCY SCORE 3.47

    DB:3.47:Mysql Upgrade Issue, Upgrade Instuctions Dont Work. Error Message. 13





    Hi all,

    Running 9.2.3 plesk for windows and Im trying to update to the latest stable version of mysql (5.1.40).

    Ive followed the parallels instructions below to the letter, to try and update both instances (A B) of mysql :

    http://kb.odin.com/en/1077

    but after I have installed the new files but when I go to restart the Plesk SQL Server service (using the plesk services monitor) I get an error kicked back:

    The system cannot find the file specified. (Error code 2) at StartService MySQL

    So I have to resort to reverting back to the original mysql version installation.

    Can anyone help explain the problem and possibly give working instructions on how to upgrade the mysql within plesk.

    Someone else also got the same error but hasnt been responded to: http://forum.parallels.com/showthread.php?t=61821highlight=startservice

    Jay

    DB:3.47:Mysql Upgrade Issue, Upgrade Instuctions Dont Work. Error Message. 13




    For any other people having this issue, I did a file by file comparison of all EXE files in the /bin/ directory from version 5.0.x which shipped with my installation of Plesk 9.2 and the lastest 5.1.x version. THERE IS A FILE NAME CHANGE!!!

    The Windows NT style daemon (IE, service executable) in version 5.0.x is called MYSQLD-NT.EXE where as the new version in 5.1.x is called MYSQLD.EXE ... simply rename this file to MYSQLD-NT.EXE and restart the service. All should be well.

  • RELEVANCY SCORE 3.47

    DB:3.47:Plesk Keeps Querying Mysql a9





    Somehow plesk keeps querying the mysql database.

    this is the query:

    SELECT s.dom_id, s.sys_user_type, s.name, u.login, a.password, s.coldfusion,s.ssi, s.php, s.cgi, s.perl, s.python, s.asp, s.asp_dot_net FROM subdomains s, sys_users u LEFT OUTER JOIN accounts a ON a.id = u.account_id WHERE u.id = s.sys_user_id AND (s.dom_id = [a_domain])

    And it never quits!

    DB:3.47:Plesk Keeps Querying Mysql a9




    It is not really an error, but the process of checking the domains (or something like that) keeps running.

  • RELEVANCY SCORE 3.43

    DB:3.43:Setting Mysql On Port 8306 cf





    Dear,
    I have a problem with MySQL and Plesk. At first, I will describe you state of some files

    C:\SWSoft\Plesk\MySQL\Data\my.ini file contains
    [PleskSQLServer]
    port=8306
    .
    .
    .
    skip_grant_tables=1
    [client]
    port=8306

    Services:
    PleskSQLServer - executable file property holds C:\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe --defaults-file=C:\SWsoft\Plesk\MySQL\Data\my.ini PleskSQLServer

    Ive restarted this service.
    I also have C:\SWSoft\Plesk\Databases\MySQL, but I havent touch that

    In C:\SWSoft\Plesk\MySQL\bin there is file MySQLInstanceConfig.exe. I tried to set mysql to work on port 8306, but it didnt help me, so I started that file again and removed instance (I was trying that and before and after changing file my.ini).

    When go to plesk - Server - DatabaseServers, there is some mysql which has red icon, I suppose it is not important. I also tried to add new DB server. I filled data like this:
    Database server type - MySQL
    Host name or IP address - localhost
    Port number - 8306

    Authentication:
    Administrators login - admin
    Administrators password - [password] (later I will explain about that)
    Confirm: same as above

    With C:\SWSoft\Plesk\MySQL\bin\mysql -P 8306 -u admin -p
    I am asked about password. Here I input same password as administrators password is ([password]). I can create database, view it and so on.

    I want to set mysql so it is listening on port 8306. I also want to be able to see MySQL DB through plesk. In my ASP files I use this line to connect
    DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; Port=8306; DATABASE=[dbname]; UID=admin;PASSWORD=[password]; OPTION=4

    I have no idea what I should do. Can someone help me, please?

    Thank you in advance.

    EDIT:
    Ive read a href=http://forum.swsoft.com/showthread.php?threadid=31434this/a page. Now Im thinking about another mistake. So, if I want to use [dbname] which is clients database, should I set that in C:\SWSoft\Plesk\MySQL\Data (I restored [dbname] with mysql -u admin -p [dbname] [dbname].sql) or in C:\SWSoft\Plesk\Databases\MySQL\Data?
    If I use both services, which ports I should set? Should I use Plesk reconfigurator? I will appreciate if someone give me detail description of setting up those stuffs. Thank you again.

    DB:3.43:Setting Mysql On Port 8306 cf




    Hello boba5555,

    Please does not allow to register two external SQL servers as localhost - you should use other name for second server.

  • RELEVANCY SCORE 3.42

    DB:3.42:Error: Pleskmaindbexception a8





    Dear All;

    I didnt find mysql admin password or password change information. My server is down. Because I dont forget my database passwords.

    ERROR:

    PleskMainDBException
    [MySQL][ODBC 3.51 Driver]Access denied for user admin@localhost (using password: YES)

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:610
    reconnect()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:592
    db_connect()
    2: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:63

    DB:3.42:Error: Pleskmaindbexception a8




    Hello,

    Please try the solution described in SWSoft Knowledge Base:

    http://kb.swsoft.com/en/1561

    This should help you to reset admin password.

  • RELEVANCY SCORE 3.37

    DB:3.37:Mysql 4 mk





    MySQL 4 has finally been released as production. Anyone know if it will work with Plesk 5?

    DB:3.37:Mysql 4 mk




    MySQL 4 has finally been released as production. Anyone know if it will work with Plesk 5?

  • RELEVANCY SCORE 3.36

    DB:3.36:Mysql Dump...?? xx





    I have a support database from another server and i dumped everything into a nice little file and would like to import it into a database that was created on a server running plesk 2.0. to my amazement, the regular dump command does not work and i am wondering how do i import that data??

    DB:3.36:Mysql Dump...?? xx




    Yeah, you think it would be logical you could do something like that eh?

    Im using 1.3.1 but there you can only edit the help files and the images. Nothing more. Its because they are using encrypted php. You should think if they could use encrypted php they also could use CSS and stuff ... but ... Im afraid thats too much to ask

    Kark

  • RELEVANCY SCORE 3.36

    DB:3.36:Mysql Access From Outside 7k





    I´m searching in Plesk the Configurationspoint to configure which mysql-database have access from outside the server as well in Confixx.
    Is this Feature not included ???

    DB:3.36:Mysql Access From Outside 7k




    Not included.
    But can be changed...
    (For example via phpMyAdmin)

  • RELEVANCY SCORE 3.36

    DB:3.36:How Do I Can Change Php.Ini And My.Ini In Mysql mx





    Hello,
    I have been setup server with ubuntu 10.04 and parallels plesk 10.01. When I import database, parallel to allowe import database Max size: 2,048MiB. I want change max size to 25000MiB. so, I want change php.ini and my.in. I connect and manage server through parallel (internet). I dont find php.ini and my.ini.
    help me please,
    Thanks,

    DB:3.36:How Do I Can Change Php.Ini And My.Ini In Mysql mx




    sorry, i replace url to images you can see.
    I have a parallels plesk: http://chimcat.org/paralles.png http://chimcat.org/paralles_plesk.png
    how i can download php.ini and my.cnf. I want change it, so i upload and replace it.
    help me please,
    thanks,

  • RELEVANCY SCORE 3.36

    DB:3.36:Php Mysql Connection fd





    Ive just upgraded from a previous version of plesk and now my MySQL connection from the PHP application no longer works. The database has been created in Plesk and the correct username is there. This is what Im using:

    $dbhost = localhost;
    $dbuser = user;
    $dbpass=password;
    $dbname=database1;

    $link = mysql_connect($dbhost, $dbuser, $dbpass);
    mysql_select_db($dbname, $link) or die(mysql_error());

    Can anyone see a reason why this doesnt work.

    DB:3.36:Php Mysql Connection fd




    Not sure if this helps but after upgrading from Plesk 7.x to Plesk 8.x some of my PHP applications didnt work.

    It was because the configuration files in my PHP apps were set to look for files in /home/httpd/vhosts/ which is where websites are hosted in Plesk 7.x

    However in Plesk 8.x they are hosted in /var/www/vhosts/

    I had to change all references to get my applications working again.

    Hope this helps.

  • RELEVANCY SCORE 3.35

    DB:3.35:Plesk Backups sp





    Do plesk backups include mySQL database information? (when backing up from within the domain windows)

    DB:3.35:Plesk Backups sp




    Do plesk backups include mySQL database information? (when backing up from within the domain windows)

  • RELEVANCY SCORE 3.35

    DB:3.35:Service Mysql Dont Start d3





    Hello,

    I can not make my service start mysql, I skip this error:

    Got error: 2002: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) when trying to connect

    Can you help me? I have a Centos 6 and Plesk 11.5

    a greeting.

    DB:3.35:Service Mysql Dont Start d3




    Alright, glad to hear you resolved it!

  • RELEVANCY SCORE 3.35

    DB:3.35:Changing Plesk Database Provider fa





    I installed plesk with MSSQL as a database provider, now I want to change the provider to MySql, I dont receive any error but plesk is still using MSSQL.
    What should I do ?

    DB:3.35:Changing Plesk Database Provider fa




    http://download1.parallels.com/Plesk/Autoupdate/plesk_8.3.0.1_update080228.13.htm

    8.2 and 8.3 both had broken db migration functionality. Upgrade to 8.3.0.1 - it works fine there.

  • RELEVANCY SCORE 3.35

    DB:3.35:Switch Psa Database From Mssql To Mysql px





    Is there a way to change the psa database from MSSql to MySql?
    I dont remember seeing an option when Plesk was setup, and now it is too late for me to reinstall.

    I wrote some Pesl scripts that need access to the PSA database, but now that Plesk pulled the old switcharoo on me, all of my mysql code is worthless.

    DB:3.35:Switch Psa Database From Mssql To Mysql px




    Another solution to this is for me to try using ODBC to connect to the Plesk MSSQL database.
    Does anyone know where this database is stored, the name of the database, and what the login information would be?

  • RELEVANCY SCORE 3.34

    DB:3.34:Too Many Mysql Connections - Freebsd Fix fx





    We have a FreeBSD server running Plesk v6.x and lately have been experiencing connection problems with the MySQL database on the hosting accounts. After a day or two some users scripts stop working due to too many MySQL connections established. It appears a script is not closing the connections properly, but how can I tell which ones are the culprit? If I restart Apache everything works again for a day or two and netstat -na no longer reports any open MySQL connections.

    Ive read alot about how to increase the connections from the default of 100 to something greater for Red Hat or other Linux variants with Cpanel, but they dont discuss the difference on FreeBSD when using Plesk.

    Could someone please point me in the right direction on how to increase the maximum connections for MySQL on the hosting accounts? Im not really sure if the my.cnf solution would work or break Plesk and really dont want to risk it. Also, if you could tell me how to identify the problem script I would really appreciate it!

    Thanks in advance.

    DB:3.34:Too Many Mysql Connections - Freebsd Fix fx




    We have a FreeBSD server running Plesk v6.x and lately have been experiencing connection problems with the MySQL database on the hosting accounts. After a day or two some users scripts stop working due to too many MySQL connections established. It appears a script is not closing the connections properly, but how can I tell which ones are the culprit? If I restart Apache everything works again for a day or two and netstat -na no longer reports any open MySQL connections.

    Ive read alot about how to increase the connections from the default of 100 to something greater for Red Hat or other Linux variants with Cpanel, but they dont discuss the difference on FreeBSD when using Plesk.

    Could someone please point me in the right direction on how to increase the maximum connections for MySQL on the hosting accounts? Im not really sure if the my.cnf solution would work or break Plesk and really dont want to risk it. Also, if you could tell me how to identify the problem script I would really appreciate it!

    Thanks in advance.

  • RELEVANCY SCORE 3.33

    DB:3.33:Problem Plesk Mysql Unable To Open Database File p3





    [Solved] Problem Plesk MySQL unable to open database file

    Good afternoon,

    We have a problem which appears from nowhere. We wanted to connect to our Plesk back-office :



    Server error (code 500): Exception with message SQLSTATE[HY000]: General error: 14 unable to open database file caught at top level.

    DB:3.33:Problem Plesk Mysql Unable To Open Database File p3




    Oh my god, problem solved.

    df -h ok
    df -i



    Filesystem Inodes IUsed IFree IUse% Mounted on
    rootfs 1310720 124922 1185798 10% /
    /dev/root 1310720 124922 1185798 10% /
    /dev 4105393 1502 4103891 1% /dev
    none 4105471 913 4104558 1% /run
    none 4105471 5 4105466 1% /run/lock
    none 4105471 1 4105470 1% /run/shm
    /dev/md2 5988352 5988352 0 100% /var

  • RELEVANCY SCORE 3.32

    DB:3.32:Importing Mysql Database To Plesk md





    Hey Guys,
    I am trying to import a Database into Plesk. Its a MySQL DB. I exported it from an old cPanel Server using PHPmyADMIN and now I cant seem to find the option to import it to Plesk from within Plesk. Can plesk do this or do I need to use PHPmyAdmin?

    DB:3.32:Importing Mysql Database To Plesk md




    Here is solution link

    Hi All,

    Try this link and I am sure this link will also helpful for you :
    https://manage.grabweb.in/knowledgebase/288/Plesk-9x-How-to-access-database-from-Plesk.html

  • RELEVANCY SCORE 3.30

    DB:3.30:Using A Remote Database Server On Separate Plesk Installs af





    Is it possible to use a remote database server on two or more Plesk installations without issue?

    Plesk A (192.168.1.1):

    Local MySQL (default)
    Remote A MySQL (192.168.1.5)
    Plesk B (192.168.1.2):

    Local MySQL (default)
    Remote A MySQL (192.168.1.5)
    ... etc etc. Is that possible? Itll allow me to create databases on the remote server from both/all the Plesk servers without conflict?

    DB:3.30:Using A Remote Database Server On Separate Plesk Installs af







    Itll allow me to create databases on the remote server from both/all the Plesk servers without conflict?

  • RELEVANCY SCORE 3.30

    DB:3.30:Bug: Impossibile To Create And Use Mysql Databases Users mj





    BUG: Impossible to create and use mysql databases users

    Hi all,

    I am using Plesk 9.2.1 for Windows since May this year, now I have discovered that I am unable create users for the mysqls databases.
    The error that CP is returning is:
    Database user name is invalid. Only latin letters are allowed for the database user name

    Here are the parameters I use:
    DB name: 2009C_DB
    Username is: 2009C_user

    The 2009C is the clients login which is the prefix in the name of database.
    The underscore is added automatically by Plesk.
    And YES I am aware of the Database Servers Preferences options like:

    1. Add users login name and underscore to the beginning of database names:
    (database names will look like user_login_name_database_name)

    2. Add users login name and underscore to the beginning of database user names
    (database user names will look like user_login_name_database_user_name)

    Both options ARE selected.

    To the Plesk develepment team if you are reading this forum:
    Have you ever tested this options before release the 9.2.1 version ????

    So, I have tested how the Plesk Panel is working with the option number 2 disabled, here is result:

    I am able to create the DB username BUT in phpmyadmin there is no database assigned to the user.
    It supposed to be like dbname(0) in the upper left column, but there is nothing there !
    which makes the interface phpmyadmin totally unusable for the user.

    Next test I have done is to disable options number 1 and 2.
    The effect is everything is working as it should, but can you imagine to work with a hundreds of databases and users without the prefixes ?! I dont.

    So both options in this case which you can find in Database Servers Preferences section ARE NOT WORKING AT ALL.

    My setup is:
    Windows 2008 Web Server 64bit
    Plesk 9.2.1
    Mysql 5.1.36-community installed onto separate host

    Have anyone resolved this problem ?
    Any hints ?

    To Plesk Support: Please fix this bug ASAP, because it is 4 months past since the 9.2.1 release and our Windows users can not use MySQL service at all.

    Thanks in advance for any suggestion.

    DB:3.30:Bug: Impossibile To Create And Use Mysql Databases Users mj




    We have here exactly the same problem...

    Also we get No database selected error when trying to use phpmyadmin when both options (prefix for db name and user) are switched off.

    Plesk Support: Please do something with it
    otherwise well have to take our servers back from production!!

  • RELEVANCY SCORE 3.30

    DB:3.30:Mysql Root Password !! ac





    Hello, i ve installed Plesk 6.5 on my Win2000 Advanced Server, so MySQL server has been installed within Plesk.
    But i cant log in my MySQL as root

    When i try to run
    C:\Program Files\SWsoft\Plesk\MySql\bin\mysql.exe -uroot -p

    a password screen comes but i dont know what is my password. I also tried blank or setup but didnt work.

    Any idea ?

  • RELEVANCY SCORE 3.30

    DB:3.30:Mysql 4.1 Or 5.0 On 7.5.4? 1j





    How do I determine which mysql will safely work with plesk?

    I currently have plesk 7.5.4 which was just upgraded last night from 7.5.3 because I was informed by a nice lady from the plesk staff that upgrading to 7.5.4 should also upgrade the mysql.

    Well either the auto installer did not work properly (though it seems to have upgraded everything else just fine) becuase I still have mysql 4.0, or I was misinformed or misunderstood.

    Regardless, running the autoinstaller did not upgrade mysql 4.0 and I need to get that up to at least mysql 4.1 as I have a new customer that was previously using cpanel mysql 4.1 and we cannot recover any of his DB backups as they were created with 4.1 on the cpanel system

    Therefore, How do I determine the best and safest mysql installation to update the current mysql 4.0 that I have?

    From the MySQL website, they suggest that MySQL 5.0 is the most recent STABLE release yet when upgrading, you should stay in the same series (and in this case that would be 4.1)

    http://dev.mysql.com/doc/refman/5.0/en/choosing-version.html

    However they do not say if it is compatible with plesk or not. So, if it is possible without causing any problems, I would like to upgrade my plesk 7.5.4 to MySQL 5.0 but I dont need any more problems so can you suggest the best and safest mySQL to upgrade to?

    Thank you for your time to read and understand this request.

    PS Just in case you need more information to make a decision or post a reply, please consider the following: We have two servers, one is a Celeron with SUSE linux 9.1 and the other is an Intel P4 with hyperthreading and SUSE Linux 9.1 Both have 1GB RAM and sufficient HD space and both have Plesk installed.

    DB:3.30:Mysql 4.1 Or 5.0 On 7.5.4? 1j




    yeah 4.1 rpms from art works fine, for more info do a search many have done it.

  • RELEVANCY SCORE 3.29

    DB:3.29:Mysql And Plesk? 7d





    Everything is working fine with plesk as well as my mySQL. On a side note, how could I determine my mySQL root user name and password if plesk manages the database? (It was automatically installed by plesk)

    Thank You,
    Mike

    DB:3.29:Mysql And Plesk? 7d




    The MySQL root username and password are your Plesk Administrators username (admin) and password.

  • RELEVANCY SCORE 3.28

    DB:3.28:Import Data To Plesk From Mysql-Database ms





    Hello,

    we want wo migrate from our old system to PLESK. We host existing Clients with lots of Domains.

    Is there a possibility to import them to PLESK or do I have to add them manually via Web-Interface?

    Thanks for helping me.

    DB:3.28:Import Data To Plesk From Mysql-Database ms




    Hello,

    we want wo migrate from our old system to PLESK. We host existing Clients with lots of Domains.

    Is there a possibility to import them to PLESK or do I have to add them manually via Web-Interface?

    Thanks for helping me.

  • RELEVANCY SCORE 3.28

    DB:3.28:Plesk 11.X Mysql Run And Connection Problem cd





    Hello,

    2 days before the system is currently running a healthy work. MySql server stopped working. After struggling a bit in the image database server, I get the error and nothing worked, but now can not connect to mysql site. I want your help.

    DB:3.28:Plesk 11.X Mysql Run And Connection Problem cd




    try resetting admin password of the plesk, plesksrvclient.exe --set worked for me

  • RELEVANCY SCORE 3.27

    DB:3.27:Mysql 4 Supported ?? f3





    i have just read the plesk 7 FAQ and it states that



    Does Plesk work with MySQL 4.0?
    Yes, Plesk 7.0.1 works with mysql 4.0

    DB:3.27:Mysql 4 Supported ?? f3




    Yes, you can use the Mysql 4 RPMS. They fixed in Plesk 7.01 the ssl sql keyword issue due to Suse and Mandrake.

  • RELEVANCY SCORE 3.27

    DB:3.27:How To Migrate Web Site (Mysql) From Plesk 7.5.6 For Windows To Plesk 7.5.4 For Linux 19





    I have a web site hosted on Plesk 7.5.6 for Windows, which runs a MySQL database and PHP4. How can I migrate this site to Plesk for Linux?

    DB:3.27:How To Migrate Web Site (Mysql) From Plesk 7.5.6 For Windows To Plesk 7.5.4 For Linux 19




    I need to this aswell. I want to migrate only accounts domains emails.

    so go from windows to linux.

    how do i do this.

    cheers aron.

  • RELEVANCY SCORE 3.27

    DB:3.27:Multiple Mysql Servers On Same Box Screws Autoupdater sd





    Fair point Im not sure I can blame Plesk for not testing on a host with more than one MySQL Daemon running - but in case anyone from Plesk is reading, if you have MySQL 4 running on the same box as your Plesk installation then autoupdate fails.

    The problem is that although the update scripts shutdown the correct MySQL they appear later to test to see if MySQL is running and if it is they dont try to restart it. On a box with multiple daemons that breaks the script because the Plesk MySQL server ISNT running (the script canned it earlier on). Probably its just doing a ps | grep mysqld or something - so it finds my mysqld4 and assumes its the server it wants. It would be better practise for the autoupgrade script to let the MySQL start script determine if its already running surely?

    Anyway, why would you want this? Well if you want MySQL 4 for any reason, but want to use Plesk you need multiple MySQL daemons probably because Plesk doesnt work on MySQL 4...

    DB:3.27:Multiple Mysql Servers On Same Box Screws Autoupdater sd




    Fair point Im not sure I can blame Plesk for not testing on a host with more than one MySQL Daemon running - but in case anyone from Plesk is reading, if you have MySQL 4 running on the same box as your Plesk installation then autoupdate fails.

    The problem is that although the update scripts shutdown the correct MySQL they appear later to test to see if MySQL is running and if it is they dont try to restart it. On a box with multiple daemons that breaks the script because the Plesk MySQL server ISNT running (the script canned it earlier on). Probably its just doing a ps | grep mysqld or something - so it finds my mysqld4 and assumes its the server it wants. It would be better practise for the autoupgrade script to let the MySQL start script determine if its already running surely?

    Anyway, why would you want this? Well if you want MySQL 4 for any reason, but want to use Plesk you need multiple MySQL daemons probably because Plesk doesnt work on MySQL 4...

  • RELEVANCY SCORE 3.27

    DB:3.27:Cannot Add Mysql Database Server Under Plesk 10.3 pa





    Hello everyone ;-)

    Ive just rented a new Plesk 10.3 server and am setting it up. Ive got another one running Plesk 9.3 and have added a separate MySQL database server with root details which worked fine. However under Plesk 10.3 the panel tells me my credentials arent valid...

    Ive checked those and they do work fine, in fact they work just fine under Plesk 9.3 but not under 10.3.

    What am I missing? Any help appreciated!

    DB:3.27:Cannot Add Mysql Database Server Under Plesk 10.3 pa




    I dont think the problem is the 10.3 machine. Maybe something is different (IP of outgoing connections ?) and the 9.3 firewall on the MySQL server allow only this address to connect.

  • RELEVANCY SCORE 3.27

    DB:3.27:Mysql Update d9





    Hi

    Is it possible to update the MySQL database to the latest version, I have installed plesk 9.2.1 but the mysql version is still 5.0.22 but plesk doc says it must be MySQL 5.0.45

    Regards John

    DB:3.27:Mysql Update d9




    Hello,

    Login to Parallels Plesk Control Panel as admin user - Components Management - click Refresh button.

    If you still see the version of MySQl other tahn you need, you cna upgrade existing one to the needed as described in the article below:
    http://kb.odin.com/en/1077

    The procedure is basically the same for all the Pelsk versions (with some slight differences).

    Regards,
    Maria.

  • RELEVANCY SCORE 3.27

    DB:3.27:Mysql: Serious Problem ! 3k





    Hello,
    I have a serious problem. From 10 days , my server (s.o. RedHat 6.2 with plesk 2.0) goes in stall (blocked). I must to restart Plesk by SSH with classic commands:
    cd /usr/local/psa/rc.d -- ./psa stop -- ./psa start
    Many times Im unable to access by SSH to my server and I call the Web Farm to reboot my machine.
    Many time the server by SSH said:
    Too many opened files
    Now it says:
    ERROR 2002:
    Cant connect to local MySQL server trough socket /tmp/mysql.sock (111)
    Some clients of mine said that they sometimes have problem with MySQL.

    another message:
    authpsa: smtp_lock_mysql: Unable to connect to mysql database, smtp-lock will not work
    relaylock: /usr/local/psa/qmail/bin/relaylock: Unable to connect to mysql database, relay will work in closed mode white list will not work.

    Please Help me !

    Thank you in advance. Kev

    DB:3.27:Mysql: Serious Problem ! 3k




    We had the same problem, but solved after we add more memory to the server. Do you guys have high MySql request on the server? if this is the case, then the PSA will give you problem too. everytime some one use PSA and click on update button the apache will go down and not get restart. but there is a patch in this forum for this. it is a timing delay issue for apache restart. but I guess this been fixed in v2.5

  • RELEVANCY SCORE 3.27

    DB:3.27:Intermittent Unable To Start Mysql Services After Backup 9x





    Hi, i have this problem whit plesk 7.5 on Fedora Core II

    Sometimes, after script backup, mysqld is crashed!!
    If i restart the psa whit psastopall the plesk doesnt start correctly...and i have some errors on mysql.

    the only solutions for restart plesk correctly is reboot the server!

    *****************************************************************

    The error message in /var/log/messages is:

    Jul 17 22:06:52 test01 relaylock: /var/qmail/bin/relaylock: Unable to connect to the mysql database, relay will work in closed mode white list will not work

    *****************************************************************

    Jul 17 22:05:23 test01 drwebd: Error: Plesk Software not running.
    Jul 17 22:05:23 test01 drwebd: Avvio drwebd failed
    Jul 17 22:06:21 test01 relaylock: /var/qmail/bin/relaylock: Unable to connect to the mysql database, relay will work in closed mode white list will not work

    *****************************************************************

    i dont have another error, its a strange problem because this situation it happens irregularly!

    do you have ideas?

    thanks

    DB:3.27:Intermittent Unable To Start Mysql Services After Backup 9x




    Hi, i have this problem whit plesk 7.5 on Fedora Core II

    Sometimes, after script backup, mysqld is crashed!!
    If i restart the psa whit psastopall the plesk doesnt start correctly...and i have some errors on mysql.

    the only solutions for restart plesk correctly is reboot the server!

    *****************************************************************

    The error message in /var/log/messages is:

    Jul 17 22:06:52 test01 relaylock: /var/qmail/bin/relaylock: Unable to connect to the mysql database, relay will work in closed mode white list will not work

    *****************************************************************

    Jul 17 22:05:23 test01 drwebd: Error: Plesk Software not running.
    Jul 17 22:05:23 test01 drwebd: Avvio drwebd failed
    Jul 17 22:06:21 test01 relaylock: /var/qmail/bin/relaylock: Unable to connect to the mysql database, relay will work in closed mode white list will not work

    *****************************************************************

    i dont have another error, its a strange problem because this situation it happens irregularly!

    do you have ideas?

    thanks

  • RELEVANCY SCORE 3.26

    DB:3.26:My Plesk Panel Can Not Connect Database 8p





    i can not restore my plesk backups because plesk mysql password change.

    how can I change my plesk mysql password.

    DB:3.26:My Plesk Panel Can Not Connect Database 8p




    we changed plesk password but we cant to database.
    Error Message is

    Unable to update database parameters: Try to establish connection failed: Failed to connect to database: Access denied for user admin@localhost (using password: YES)

    what we can do?

  • RELEVANCY SCORE 3.26

    DB:3.26:Dedicated Server Install m3





    I am getting a brand new godaddy Dedicated server running Windows 2003 Std.
    I am going to have MYSQL5 on it and would like to make sure that Plesk will work. I will also have Apache on it, and wont be using IIS if I can help it.
    I think it comes with mailenable has the email server.
    Will this work??
    I saw where Plesk can use SQL Server, MYSQL or jet for its database and Id like it to use MYSQL5 if it can, but if not, then can I get it to use Jet??
    I had already purchased Plesk Linux 8.0 and it doesnt work with MYSQL5 so I wasted $199 on it (only bought it 5 weeks ago and never installed it), so I dont want to make a mistake again.
    Thanks for any help.
    Alan Sawyer

    DB:3.26:Dedicated Server Install m3




    I am getting a brand new godaddy Dedicated server running Windows 2003 Std.
    I am going to have MYSQL5 on it and would like to make sure that Plesk will work. I will also have Apache on it, and wont be using IIS if I can help it.
    I think it comes with mailenable has the email server.
    Will this work??
    I saw where Plesk can use SQL Server, MYSQL or jet for its database and Id like it to use MYSQL5 if it can, but if not, then can I get it to use Jet??
    I had already purchased Plesk Linux 8.0 and it doesnt work with MYSQL5 so I wasted $199 on it (only bought it 5 weeks ago and never installed it), so I dont want to make a mistake again.
    Thanks for any help.
    Alan Sawyer

  • RELEVANCY SCORE 3.25

    DB:3.25:Plesk Gives Error But Data In Mysql Exists, Please Help sc





    Hello, i am using Plesk 8.0.0 on Linux ES3
    with mysql 4.1.21 and i have a problem, when i click on a certain domain, just one, it gives me this error

    0: /usr/local/psa/admin/plib/common_func.php3:169
    psaerror(string Unable to init Account object: , string Account: unable to select: no such row in the table (select `id`,`type`,`password` from accounts where `id`=10))
    1: /usr/local/psa/admin/plib/class.SysUser.php:73
    SysUser-SysUser(string 3)
    2: /usr/local/psa/admin/plib/common_func.php3:2605
    objectMaker(string SysUser, string 3)
    3: /usr/local/psa/admin/plib/class.DomainControlForm.php:181
    DomainControlForm-assign(object of type BsDomain)
    4: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152

    and in mysql database psa - accounts the data exists

    10 plain ***********

    and the data syntax is the same as other ids and i dont have a clue why it wont work. Thanks.

    DB:3.25:Plesk Gives Error But Data In Mysql Exists, Please Help sc




    Hello, i am using Plesk 8.0.0 on Linux ES3
    with mysql 4.1.21 and i have a problem, when i click on a certain domain, just one, it gives me this error

    0: /usr/local/psa/admin/plib/common_func.php3:169
    psaerror(string Unable to init Account object: , string Account: unable to select: no such row in the table (select `id`,`type`,`password` from accounts where `id`=10))
    1: /usr/local/psa/admin/plib/class.SysUser.php:73
    SysUser-SysUser(string 3)
    2: /usr/local/psa/admin/plib/common_func.php3:2605
    objectMaker(string SysUser, string 3)
    3: /usr/local/psa/admin/plib/class.DomainControlForm.php:181
    DomainControlForm-assign(object of type BsDomain)
    4: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152

    and in mysql database psa - accounts the data exists

    10 plain ***********

    and the data syntax is the same as other ids and i dont have a clue why it wont work. Thanks.

  • RELEVANCY SCORE 3.25

    DB:3.25:Extract Sql From A Plesk Backup cm





    How can I do to extract the dump of a MYSQL database from the Plesk backup file???

    Thanks

    DB:3.25:Extract Sql From A Plesk Backup cm




    How can I do to extract the dump of a MYSQL database from the Plesk backup file???

    Thanks

  • RELEVANCY SCORE 3.24

    DB:3.24:Mysql Question sj





    The MySQL database Plesk is only running for localhost. This is a good thing. But, now I cant use the valuable information for other purposis, like getting the mailadresses or phpone numbers or whatever.

    I dont want to put the database on % again. I thought about copying the tables I needed into another database but that doesnt work. Does anyone know a good idea how I still can use the data in the Plesk database?

    Thanks,
    Kark

    DB:3.24:Mysql Question sj




    cURL eh? Ok, Im going to mess around with it for a while.

    Thanks!
    Kark

  • RELEVANCY SCORE 3.24

    DB:3.24:Watchdog And Mysql mj





    Hi

    Watchdog in my plesk every minute get state of mysql server.
    And every minute in log I see: Database server connection has established

    it is normally?

  • RELEVANCY SCORE 3.23

    DB:3.23:Phpmyadmin On Plesk 10.4.4 .... 3k





    hi,

    I have a big problem since the update of plesk for Windows 10 to 10.4.4…
    When I import a MySQL database, PhpMyAdmin posts this:

    import.php: Missing parameter: import_type
    import.php: Missing parameter: format

    Without the possibility of importing my databases, all my work is blocked. Did you also have this problem? how to repair? Thank you in advance and sorry for my bad English.

  • RELEVANCY SCORE 3.23

    DB:3.23:Help! Error While Trying To Check Plesk Database Version 8z





    grrr... I dont know how to fix this problem. I am upgrading 7.01 to reloaded and I get this error!

    ERROR while trying to check Plesk Database version

    looking in the upgrade log it says:

    Trying to start MySQL server... Starting MySQL: [ OK ]
    done
    mysqld dead but subsys locked
    mysqld dead but subsys locked
    mysqld dead but subsys locked
    .......
    repeats mysqld dead... 21 times
    .......
    Cannot start Mysql server

    I think the problem might be related to the fact that I upgraded mysql to version 4.0 using Yum. Please help... 1and1 has given me only 2 days to get this thing upgraded b4 they pull the plug on my licence!

    Thanks!

    DB:3.23:Help! Error While Trying To Check Plesk Database Version 8z







    Dear Mr. Clawson,

    11 is pleased to announce the release of Plesk 7.1, the brand-new Plesk Reloaded, a major new upgrade to the award-winning Plesk server management software.

    To maintain the highest level of security and as a current Plesk 7 user,
    11 is making this free upgrade available to you under your existing license. This upgrade adds many powerful new capabilities in response to customer requests for enhanced usability and functionality.

    The upgrade to Plesk 7.1 is quick and straightforward and of course will not impact your existing server data. However, as a precaution, before carrying out any of the steps to upgrade your Plesk software, we strongly recommend that you first make a backup of your crucial data such as websites, kernel configurations and log files. Detailed instructions on how to carry out the upgrade on your server are available at:
    http://faq.1and1.com/dedicated_servers/root_server/1.html

    Please note that you MUST complete the installation of the upgrade on your server by 31 July 2004. After this date, you will be unable to make any changes in the Plesk interface.

    If you have any further questions, you can contact our support team. Log in to the Control Panel and in the Need Help? section in the left navigation, click on Help and Contact. Click on Contact Form to directly e-mail your query to our support.

    Sincerely,

    Your 11 Team
    http://www.1and1.com/

  • RELEVANCY SCORE 3.23

    DB:3.23:Plesk Fatal Exception - Mysql Gone! 9f





    Out of the blue no sites work, mysql has disappeared and i cant login to plesk:

    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    0: /usr/local/psa/admin/plib/common_func.php3:190
    psaerror(string Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2))
    1: /usr/local/psa/admin/auto_prepend/auth.php3:93

    Upon starting PSA:
    [root@halal mysql]# /etc/rc.d/init.d/psa start
    Starting xinetd service... done
    Starting named service... done
    Starting mysqld service... not installed
    Starting qmail service... done
    Starting courier-imap service... done
    Starting postgresql service... not installed
    Starting psa-spamassassin service... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    Starting Plesk... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    Upon Starting Mysqld:
    [root@halal mysql]# service mysqld start
    mysqld: unrecognized service

    [root@halal mysql]# /etc/rc.d/init.d/mysqld start
    -bash: /etc/rc.d/init.d/mysqld: No such file or directory

    I dont know how, but mysql appears to have been removed. I need to reinstall it to get all my sites working again. Can someone tell me the best way to go about this?

    I have no idea exactly which version was being used, nor exactly which 8xxx version of plesk im using because i only have access via SSH.

    Thanks in advance.

    DB:3.23:Plesk Fatal Exception - Mysql Gone! 9f




    Out of the blue no sites work, mysql has disappeared and i cant login to plesk:

    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    0: /usr/local/psa/admin/plib/common_func.php3:190
    psaerror(string Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2))
    1: /usr/local/psa/admin/auto_prepend/auth.php3:93

    Upon starting PSA:
    [root@halal mysql]# /etc/rc.d/init.d/psa start
    Starting xinetd service... done
    Starting named service... done
    Starting mysqld service... not installed
    Starting qmail service... done
    Starting courier-imap service... done
    Starting postgresql service... not installed
    Starting psa-spamassassin service... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    Starting Plesk... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    Upon Starting Mysqld:
    [root@halal mysql]# service mysqld start
    mysqld: unrecognized service

    [root@halal mysql]# /etc/rc.d/init.d/mysqld start
    -bash: /etc/rc.d/init.d/mysqld: No such file or directory

    I dont know how, but mysql appears to have been removed. I need to reinstall it to get all my sites working again. Can someone tell me the best way to go about this?

    I have no idea exactly which version was being used, nor exactly which 8xxx version of plesk im using because i only have access via SSH.

    Thanks in advance.

  • RELEVANCY SCORE 3.23

    DB:3.23:Reporting On Remote Mysql Databases (Linux) ma





    Plesk report displays

    Mysql Database size as Service is unavailable

    All Linux Plesks with remote databases affected.

    Does anyone have a solution for this?

    DB:3.23:Reporting On Remote Mysql Databases (Linux) ma




    Plesk report displays

    Mysql Database size as Service is unavailable

    All Linux Plesks with remote databases affected.

    Does anyone have a solution for this?

  • RELEVANCY SCORE 3.23

    DB:3.23:Plesk 6.0 And Frontpage Database Permishions ca





    I have recintly acwired a Plesk 6.0 acount and had frontpage exstenshions put on it it which work great other then acsessing my databasses on MySQL is there something i must turn on or is this something my hosting provider should do , please help

    DB:3.23:Plesk 6.0 And Frontpage Database Permishions ca




    I have recintly acwired a Plesk 6.0 acount and had frontpage exstenshions put on it it which work great other then acsessing my databasses on MySQL is there something i must turn on or is this something my hosting provider should do , please help

  • RELEVANCY SCORE 3.22

    DB:3.22:Blank Plesk Desktop 9d





    we have the following problem
    we wanted to migrate plesk from one machine to another
    we have setup the machine blank, installed plesk and then transfered verything with pleskbackup tool
    worked fine so far

    by misteak, a sysadmin did not only sync the /vhosts/ with rsync tool, but also the psa mysql database from the old machine to the new machine. since then, we can login into the plesk, but all admin navigation points show just empty pages

    we dont want to start from the scratch
    any body some tipps, how we can fix this ? and what the problem could be ?

    DB:3.22:Blank Plesk Desktop 9d




    we have the following problem
    we wanted to migrate plesk from one machine to another
    we have setup the machine blank, installed plesk and then transfered verything with pleskbackup tool
    worked fine so far

    by misteak, a sysadmin did not only sync the /vhosts/ with rsync tool, but also the psa mysql database from the old machine to the new machine. since then, we can login into the plesk, but all admin navigation points show just empty pages

    we dont want to start from the scratch
    any body some tipps, how we can fix this ? and what the problem could be ?

  • RELEVANCY SCORE 3.22

    DB:3.22:How Do I Downgrade Mysql To 4.1 From 5? s7





    I have a new server running Plesk 8.3. Its default database is MySQL 5. After migrating several sites, my database scripts no longer work because they were MySQL 4.1 based. I understand that Plesk uses MySQL 5 as its internal database. Is there a way to downgrade MySQL to version 4.1 without adversely affecting Plesk? Is it possible to install both? Any help you can provide will be greatly appreciated. Thanks.

  • RELEVANCY SCORE 3.22

    DB:3.22:Mysql Problem 8d





    Im having a problem getting MySQL working (again) in plesk control panel. I installed an application for spam control, didnt like it, and uninstalled it. When I did, it took MySQL with it from Plesk. I re-installed the MySQL instance in Plesk and the service is now showing that its running, but it wont start the database server itself.

    Im getting the error: Failed to connect to database: Access denied for user admin@localhost (using password: YES)
    Ive tried putting in my plesk password, and also changing to user root with no password (as it says in the setup), but nothing seems to work.

    I have customers who are without database functions so I need to get this resolved asap. Any help would be greatly appreciated.

    Thanks,

    JH

    DB:3.22:Mysql Problem 8d




    you can do a plesk repair from Add/remove programs - Plesk control panel

    select repair

  • RELEVANCY SCORE 3.21

    DB:3.21:Mysql Admin Password? mf





    Everything is working fine with plesk as well as my mySQL. On a side note, how could I determine my mySQL root user name and password if plesk manages the database? (It was automatically installed by plesk)

    Thank You,
    Mike

    DB:3.21:Mysql Admin Password? mf




    mySQL 4.x

    Is this also the case for mysqladmin?

    Two problems.

    After upgrading mySQL to 4.018 I cant access/change admin password per directions given in the upgrade process using mysqladmin -u admin -p

    Keep getting access denied messages.

    I need to create the table necessary for me to enable full sites backup.

    As it stands my backups fail on the databases.

  • RELEVANCY SCORE 3.19

    DB:3.19:Default Mysql Password cx





    Hi there

    I just completed a fresh install of Plesk 8.3 on Centos 5. I let Plesk install mysql and during the installation process, I dont recall setting a root mysql password though one has apparently been created.

    Is there a default password that plesk creates when it installs mysql?

    thanks for your help!!

    DB:3.19:Default Mysql Password cx




    Plesk removes the MySQL root account and creates an account called admin. Its password is the same as the password for the admin account you use to login to Plesk (which is also stored in /etc/psa/.psa.shadow).

    If you want to access MySQL from the commandline as the admin user you can do this:

    Code:

  • RELEVANCY SCORE 3.18

    DB:3.18:Plesk 9.5.4 And Mysql Odbc Driver 3s





    a client of mine asked if we could upgrade the MySQL ODBC Driver to version 5.1 ,
    then I red this http://kb.parallels.com/en/112019 about plesk would not work properly without odbc 3.51

    so can I upgrade on plesk 9.5.4 the MySQL ODBC Driver to 5.1? or would that break Plesk ?

    DB:3.18:Plesk 9.5.4 And Mysql Odbc Driver 3s




    a client of mine asked if we could upgrade the MySQL ODBC Driver to version 5.1 ,
    then I red this http://kb.parallels.com/en/112019 about plesk would not work properly without odbc 3.51

    so can I upgrade on plesk 9.5.4 the MySQL ODBC Driver to 5.1? or would that break Plesk ?

  • RELEVANCY SCORE 3.18

    DB:3.18:Plesk Watchdog Suspend s1





    Im using a cron job every night to backup mysql database. While dumping the databases I have to stop mysql.
    PLESK watchdog noticed the stopped mysql task and wants to restart mysql while dumping the database.

    Is it possible to suspend (disable/enable) PLESKs watchdog via command line (backup script) ?

    DB:3.18:Plesk Watchdog Suspend s1




    ok

    ... works fine.

    Thank you for quick answer ...

    Werner

  • RELEVANCY SCORE 3.18

    DB:3.18:Mysql Frontend ? xd





    Hi,

    Does anyone have any idea how to connect to mySQL database using a mysql frontend app without using Plesk PHPmyadmin?

    Regs,

    Joe

    DB:3.18:Mysql Frontend ? xd




    Thanks Necro.

    =)

    Look like the option is to stay with PHPmyadmin.. lol

  • RELEVANCY SCORE 3.18

    DB:3.18:Oracle Xe Plesk s9





    I want to add Oracle XE as database like MySQL. How can I configure Plesk for that?

    Regards

  • RELEVANCY SCORE 3.18

    DB:3.18:Logging In To Mysql Admin fz





    I am running a Windows 2003 server and Plesk 7.5.3

    When I go to a domain and create a MySQL database, it adds it just fine. I can add a user just fine, but I cannot login to the MySQL database admin. I click on the icon and it very quickly doesnt do anything. I dont get an error message or anything. Nothing happens.

    I know I should be able to login, but cant.

    Q1 - Is there a manual way to login to a local domain MySQL database?

    Q2 - Is there a non-Plesk MySQL administrative tool that I could use?

    Q3 - I am not sure if Plesk install configures the Windows ODBC settings automatically. Is there a document that would walk through how to setup and/or check the windows odbc settings?

    Thanks

    DB:3.18:Logging In To Mysql Admin fz




    Thanks so much for the tip. It is such a silly little thing, but the pop up blocking on my browser was doing it.

    Much obliged!

  • RELEVANCY SCORE 3.18

    DB:3.18:Does Plesk Suport Qmail Store Its Db In Mysql??? zs





    Hi. Im newbie in plesk control panel. I know that Plesk CP suport both qmail and MySQL, but Im not sure qmail and mySQL can work together with Plesk.
    If yes, how must I do to config that. And if no how long do I have to wait to do that in plesk.
    Can anyone give me an idea ?
    Thanks.

    DB:3.18:Does Plesk Suport Qmail Store Its Db In Mysql??? zs




    I have no idea what youre trying to accomplish. Could you elaborate?

  • RELEVANCY SCORE 3.17

    DB:3.17:Unable To Change Mysql User/Password - Mysql 5.1 3m





    Hi,

    Update: Our infra
    ---------------------------------------------------------------
    PRODUCT - Parallel plesk Panel for Windows
    VERSION, 11.5.30
    VERSION OF MICROUPDATE - Update #45
    OPERATING SYSTEM - Microsoft Windows Server 2012
    ARCHITECTURE - Parallel Plesk for Windows and dedicate MySQL Database Server

    [PROBLEM DESCRIPTION]
    I dont sure that you guy have this problem or not,
    But we setup Plesk 11.5 with mySQL root User.
    and once, we need to change both User and Password but we got error

    [STEPS TO REPRODUCE]
    1. Logon to PPC
    2. Go to Tools Settings
    3. Go to Database Servers (Applications Databases)
    4. Select Database Server (at Hostname)
    5. Go to Settings
    6. In Authentication, I change Administratives Username and Administrators password

    ACTUAL RESULT
    I got error during changing the Database Information

    Code:

    DB:3.17:Unable To Change Mysql User/Password - Mysql 5.1 3m




    Hi,

    Update: Our infra
    ---------------------------------------------------------------
    PRODUCT - Parallel plesk Panel for Windows
    VERSION, 11.5.30
    VERSION OF MICROUPDATE - Update #45
    OPERATING SYSTEM - Microsoft Windows Server 2012
    ARCHITECTURE - Parallel Plesk for Windows and dedicate MySQL Database Server

    [PROBLEM DESCRIPTION]
    I dont sure that you guy have this problem or not,
    But we setup Plesk 11.5 with mySQL root User.
    and once, we need to change both User and Password but we got error

    [STEPS TO REPRODUCE]
    1. Logon to PPC
    2. Go to Tools Settings
    3. Go to Database Servers (Applications Databases)
    4. Select Database Server (at Hostname)
    5. Go to Settings
    6. In Authentication, I change Administratives Username and Administrators password

    ACTUAL RESULT
    I got error during changing the Database Information

    Code:

  • RELEVANCY SCORE 3.17

    DB:3.17:Plesk Database Via Phpmyadmin? 7m





    Hello,

    I cant access the Plesk system database (which is in MySql on port 8306) via Pleskss phpMyAdmin, but I can access it via the command-line.

    In the control panel, when I go to Server/Databases/MySql I see:

    (Name for the server cannot be changed: There is at least one database on the server)

    and sure enough, the server and port edit boxes are disabled.

    I have recently upgraded from Plesk 7.5.1. I remember once creating a client database in 7.5.1 and it had this effect. I notice that 7.6 creates a client database for Horde, so I guess its the same problem.

    Why cant I access the system database just because theres a client database? I dont get it. Or maybe theres some other reason.

    How do I access the Plesk database via phpMyAdmin?

    Cheers,
    Julian

    DB:3.17:Plesk Database Via Phpmyadmin? 7m




    Why cant I access the system database
    Access to the system database via Plesks phpMyAdmin has been disabled in 7.6.

    How do I access the Plesk database via phpMyAdmin?
    Install another copy of phpMyAdmin outside Plesk.

  • RELEVANCY SCORE 3.16

    DB:3.16:Installed 6.0.1 Now Mysql Doesnt Start 7d





    Installed 6.0.1 Now MYSQL Doesnt Start And New Plesk Start Up Problem

    After installing the 1 domain version on FreeBSD MYSQL stopped and will not start. Im not too familiar with MYSQL so Im not really sure where to look for an error message as to why it wont start. I need to either get this resolved or find out how to uninstall Plesk. Any help on either would be appreciated.

    I found the following in /var/log/pgsql
    DEBUG: database system was shut down at 2003-08-27 14:50:26 EDT
    DEBUG: checkpoint record is at 0/109664
    DEBUG: redo record is at 0/109664; undo record is at 0/0; shutdown TRUE
    DEBUG: next transaction id: 89; next oid: 16556
    DEBUG: database system is ready

    I dont see anything for mysql

    *New Problem*
    Plesk stopped working after I rebooted the server. This is the error I get:
    /index.php3: Unable to connect to database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2), in /usr/local/psa/admin/auto_prepend/auth.php3 on line 39, plesk_errormsg=Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2), php_errormsg=

    Did I mention that Im running FreeBSD 5.1? It should be noted that Plesk was running just fine until I rebooted

    I tried ln -s /tmp/mysql.sock in /var/lib/mysql, said file already exists
    Any ideas as to what I could try next?

    DB:3.16:Installed 6.0.1 Now Mysql Doesnt Start 7d







    Originally posted by ThuGGed
    ok, possibly Im wrong but did Plesk install another form of MYSQL?

  • RELEVANCY SCORE 3.16

    DB:3.16:Plesk Panel Dns Mysql-Db 9f





    Hello,

    We need to stor the DNS zones managed by the Plesk Panel in a MySQL database, to be able to implement plesk in our PowerDNS structure.
    Does Plesk Panal 10.3.1 support the storage of the DNS files in a database or do we need to configure this on the BIND layer?

    Thanking you in advance,
    Daniel Kmiotek

    DB:3.16:Plesk Panel Dns Mysql-Db 9f




    Hello,

    We need to stor the DNS zones managed by the Plesk Panel in a MySQL database, to be able to implement plesk in our PowerDNS structure.
    Does Plesk Panal 10.3.1 support the storage of the DNS files in a database or do we need to configure this on the BIND layer?

    Thanking you in advance,
    Daniel Kmiotek

  • RELEVANCY SCORE 3.16

    DB:3.16:Backup s3





    Hi,

    Im performing Schedulled Backups with Plesk Backup Utility...

    Every day at night...

    My doubt is this Backup contains the MySQL Database created in the Plesk CP

    If this backup dont contain this DB, I will make separately backups for it... but I need to know if this backup have this DB.

    Regards

    DB:3.16:Backup s3




    Yes, this contains MySQL / MS SQL / Emails backup too.

  • RELEVANCY SCORE 3.16

    DB:3.16:Where Does Plesk Store Its Data? kj





    In plesk 7.5 Plesk stored its information in the mysql database on port 8306 in a database psa. However, Plesk 8.1 does not have a psa database.

    All I want to do is get a list of the domain and domain_id that I host! Simple right?

    DB:3.16:Where Does Plesk Store Its Data? kj




    yes it did. I did it on my production server after testing on a non production server.

    It said it had 260 some minutes remaining with no cancel button as the processor grinded but it transfered everyting over to the db i specified. But it only took 15mins or less.

    the hastle I had with it was the password being correct. I had to reset/set the password for the admin account in MySQL before I started it. It would also disable the Plesk MySQL server in Services. But it only disables it if it doesnt work or you didnt put the right password in it. *shrug*

    Ive done this for 2 of our production servers so far ... and have mail creation almost automated

    Anyway. Good luck.
    Brad
    EmpoweredInternet.com

  • RELEVANCY SCORE 3.16

    DB:3.16:Mysql 4.X On Centos5.2 With Plesk zj





    Hello,

    Im planning a move to Plesk 9.1 in a CentOS 5.2 machine. Any ideas on how to downgrade MySQL to 4.X ? I have old sites that dont work on MySQL 5.X

    Thanks
    Joao Correia

    DB:3.16:Mysql 4.X On Centos5.2 With Plesk zj




    Hello,

    Im planning a move to Plesk 9.1 in a CentOS 5.2 machine. Any ideas on how to downgrade MySQL to 4.X ? I have old sites that dont work on MySQL 5.X

    Thanks
    Joao Correia

  • RELEVANCY SCORE 3.16

    DB:3.16:Need Ppa Mysql Database Server Password To Troubleshoot High Load From Web To Db dc





    Hi,

    Our CentOS Linux server in PPA architecture is communicating with a database server and its experiencing high load on the Ethernet interface. It seems from our graphs this problem also happened about 20 days ago:


    I isolated the communications between the server using `iftop` and there I can see high load to MySQL server.

    Now I want to log in as root / admin into the database server mysql -uadmin -p?? and do show processlist but I dont know where to find the password. I have original documentation from when we did the installation but this password doesnt seem to work any more.

    I Google and only found this article http://kb.parallels.com/en/427 but it looks applicable to Plesk as opposed to PPA.

    Please assist.

    DB:3.16:Need Ppa Mysql Database Server Password To Troubleshoot High Load From Web To Db dc




    Hi, Eugene,
    Hopefully your system still remembers the admin password. You wont see it in UI, but you can change it. Go to Infrastructure Database Servers; select the Databases tab and click the Webadmin link. You will end up in phpMyAdmin session with admin credentials. You can change your password here. Then go back to the Database server tab and enter the new password there.
    If your system already lost the configuration setting, follow the generic instructions on how to reset MySQL password: http://www.cyberciti.biz/tips/recover-mysql-root-password.html. After that update it on the Database server tab.

    Regards,
    Andrey

  • RELEVANCY SCORE 3.15

    DB:3.15:Remote Mysql Size? jx





    Hello! Maybe I missing something, but why Plesk for Windows supports remote MySQL database size accounting, but Linux version doesnt?

  • RELEVANCY SCORE 3.14

    DB:3.14:Mysql Admin Password s1





    I have changed the mysql admin password using the mysql console.

    Now I need to configure the new password at plesk.

    My plesk is not managing the mysql database because there was stored the old wrong password.

    How can I fix this?

    Sorry for my poor English

    Hantuanne
    Brazil

    DB:3.14:Mysql Admin Password s1




    I have changed the mysql admin password using the mysql console.

    Now I need to configure the new password at plesk.

    My plesk is not managing the mysql database because there was stored the old wrong password.

    How can I fix this?

    Sorry for my poor English

    Hantuanne
    Brazil

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk Fatal Exception - Mysql Gone! 38





    Out of the blue no sites work, mysql has disappeared and i cant login to plesk:

    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    0: /usr/local/psa/admin/plib/common_func.php3:190
    psaerror(string Unable to connect to database: mysql_connect() [a href=function.mysql-connectfunction.mysql-connect/a]: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2))
    1: /usr/local/psa/admin/auto_prepend/auth.php3:93

    Upon starting PSA:
    [root@halal mysql]# /etc/rc.d/init.d/psa start
    Starting xinetd service... done
    Starting named service... done
    Starting mysqld service... not installed
    Starting qmail service... done
    Starting courier-imap service... done
    Starting postgresql service... not installed
    Starting psa-spamassassin service... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to Plesk Database: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    websrvmng: Unable to connect to the mysql database

    System error 2: No such file or directory
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
    Starting Plesk... done
    ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    DB:3.14:Plesk Fatal Exception - Mysql Gone! 38




    Sussed it, dont worry. Id updated everything, but the new version of MySQL required me to remove the Berkeley bdb bit from the my.cfg file and I hadnt. Did that and the daemon started right up. Step 3 on http://www.atomicorp.com/wiki/index.php/Mysql

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk Lost Connection With Mysql ps





    Hello

    My Plesk lost the connection with MySQL server... The service are UP, all works fine, but when anyones want to delete any SQL dbase, appears the message admin access denied.

    Looking in session MySQL in plesk, I see that Plesk lost the connection.. So Im tryed to restart the service, but this dont accept my password!

    Anyone have any idea? How can I reset password?

    Thaks!

    DB:3.14:Plesk Lost Connection With Mysql ps




    Ok!!

    Thanks for reply!

    All ports are ok... all configs are ok too...
    but when I click in the execute button, in the end of config... the reconfigurator stops in the last step with the message

    access denied for root@localhost...

    I dont understand the two user admin and root... doesnt the same, obviously, but why I cant reconfigurate this?

    My brains hurts! hahah

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk Mysql Database Error k1





    Hi

    I am seeing errors in my message file about plesk statistics
    I was told this is a plesk db issue. How do you go about
    fixing it?

    Thanks

    Chuck

    DB:3.14:Plesk Mysql Database Error k1




    Hi

    I am seeing errors in my message file about plesk statistics
    I was told this is a plesk db issue. How do you go about
    fixing it?

    Thanks

    Chuck

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk Backup Of Mysql Databases 1s





    I have created some mysql databases manually, via Server/ Database Servers/ Access this Server via DB Webadmin. Are these databases getting backed up with Plesk backup services?
    This databases are not associated with any of my domains.

    DB:3.14:Plesk Backup Of Mysql Databases 1s




    Hi,

    Plesk by default doesnt backup any MySQL databases except its own psa, aspc and mysql Database.

    All other backups are only created if you have configured them to.
    Although as Plesk does not know about your databases, it will most probably also not make backups for them,
    as they are not associated to any subscriptions.

    Regards,
    Kristian

  • RELEVANCY SCORE 3.14

    DB:3.14:Mysql Problem Wit Charcter Set z8





    MySQL Problem wit CHARACTER SET

    Hi,
    PLESK 7.1.6
    MySQL 4.0.15

    == Default CHARACTER SET = latin1

    OK, my problem is (my english) every day i make with PhpMyAdmin an sql-dump from my local-database (mysql 5.0.x)
    = SQL-export to = MySQL40.
    = the *.sql looks good, äöüÄöü all ok
    = Upload the *.sql file with ftp
    = shell mysql -u xxx -pxxx --database xxx *.sql
    All is fine and working.

    Today i made the next update
    = the *.sql looks good, äöüÄöü all ok
    but now the CHARACTER SET latin1 in the online database is missing.
    Systemparamters = DEFAULT latin1
    but it isnt.

    When i open the online PhpMyAdmin and go into the tables:
    = Copy and paste the table-structur fom my local-server
    = ALTER TABLE xxx CHARCTER SET latin1
    = Copy and paste the inserts
    Ok this is working, but i have over 100 tables and i dont want to make this work every day

    How can i fix this problem or can i upgrade the database to 4.1.x or 5.0.x

    Any ideas

    Regards from germany

    Conny

    DB:3.14:Mysql Problem Wit Charcter Set z8




    similar problem here

    I had a similar problem recently after upgrading mySQL 4.x to 4.1.6.

    Although Ive yet to find out what happened, each database table had the following line:
    (the last saved database before the upgrade)

    Code:

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk 8.1.1 Mysql Client Error jf





    Help Im getting this error since upgrading plesk via the web based auto installer:

    ERROR: PleskFatalException

    Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to connect to Plesk Database: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    packagemng: Unable to connect to the mysql database

    0: /usr/local/psa/admin/auto_prepend/auth.php3:484

    Please help.

    Thank you.

    Dav

    DB:3.14:Plesk 8.1.1 Mysql Client Error jf







    Hi,
    Regarding the issues with Plesk on your server.
    The issue was caused by the MySQL server being upgraded along with Plesk.
    This caused certain incompatibilities with the MySQL authentication protocol.

    I was able to reset the MySQL admin password using the older protocol
    and Plesk should now be working again.

    Let us know if you have any questions

  • RELEVANCY SCORE 3.14

    DB:3.14:How Can I Upgrade The Psa Database Tables? j8





    How do I go about upgrading just the psa database tables?

    I had a server hardware failure.

    The hosting company elected to give us a new box, with a newer version of plesk on it, and reattach the old hard drive as secondary drive. To get our customers up and running as fast as possible, I copied over /var/www/vhosts, /var/named, /var/qmail, /var/lib/mysql and few files in /etc. At this point the box is serving websites, dns, and email.

    What we dont have is Plesk working. Since the old psa database was for plesk 8.6.0, and the new server is running plesk 9.2.3, the mysql psa tables need upgrading. How do I go about upgrading these tables?

    DB:3.14:How Can I Upgrade The Psa Database Tables? j8




    Thanks! Looks like the SQL statements that I need to run are here:

    /usr/local/psa/etc/db/psa_db_upgrade_860.sql
    /usr/local/psa/etc/db/psa_db_upgrade_900.sql
    /usr/local/psa/etc/db/psa_db_upgrade_920.sql

  • RELEVANCY SCORE 3.14

    DB:3.14:Plesk 9.0.1 Mysql Database Error df





    I have just installed Plesk 9.0.1 in our windows server.
    MsSQL database is added in server database list but when i try to add MYSQL database it is fetching a error Failed to connect to database: Host abitindiaserver.local.abitindia.com is not allowed to connect to this MySQL server.

    However mysql in installed and runing and shown in commponent area.

    Can anyone help me on it ??

    DB:3.14:Plesk 9.0.1 Mysql Database Error df




    I have just installed Plesk 9.0.1 in our windows server.
    MsSQL database is added in server database list but when i try to add MYSQL database it is fetching a error Failed to connect to database: Host abitindiaserver.local.abitindia.com is not allowed to connect to this MySQL server.

    However mysql in installed and runing and shown in commponent area.

    Can anyone help me on it ??

  • RELEVANCY SCORE 3.13

    DB:3.13:Mysql Sintax For Removing Database Name And Database Instance In Plesk k9





    Hi,

    I need to remove manually from the Plesk internal MySQL database a database which no longer exist in the MSSQL server database instance, which also no longer exists. In order to remove the server MSQL database instance, I need to remove the name of a database and user which are still registered in Plesk.

    What is the Mysql sintax please ?! MSSQL Instance to be removed is .\MSSQLSERVER2008 and the database name is toto_mojo with user toto_mojo

    Please advice.

    thanks

    Mircea

    DB:3.13:Mysql Sintax For Removing Database Name And Database Instance In Plesk k9




    Check tables data_bases and db_users in psa database. Remove corresponding records carefully.

  • RELEVANCY SCORE 3.13

    DB:3.13:Change Database Ownership x3





    I dont know if this should be in this area or not ...

    I am selling off a site and have a few mysql databases I need to keep, is there an easy way to move them to another plesk account on the server? They are all on local host but under selected domains, if I dont move them then no more database once the domain is removed.

    Thank you in advanced.

    DB:3.13:Change Database Ownership x3




    Backup the database, remove from the old domain, logon to a new domain and create and restore the database.

  • RELEVANCY SCORE 3.13

    DB:3.13:Error Creating Mysql Database 1p





    When i try to create a MySQL database from Plesk 7.5 for windows, i get the following error:

    Unable to create database: Create new database failed: Run-Time error: Failed to connect to database: Cant connect to MySQL server on localhost (10061)

    Can anyone help me please.

    DB:3.13:Error Creating Mysql Database 1p




    The errors are as follow:

    051215 5:02:30 InnoDB: Started; log sequence number 0 7771220
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060102 8:53:11 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 8:53:13 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 18 user: admin

    060102 8:53:13 InnoDB: Starting shutdown...
    060102 8:53:15 InnoDB: Shutdown completed; log sequence number 0 8700797
    060102 8:53:15 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 8:54:40 InnoDB: Started; log sequence number 0 8700797
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060102 10:45:19 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 10:45:20 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060102 10:45:20 InnoDB: Starting shutdown...
    060102 10:45:23 InnoDB: Shutdown completed; log sequence number 0 8700846
    060102 10:45:23 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 10:46:56 InnoDB: Started; log sequence number 0 8700846
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060102 11:08:53 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 11:08:54 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060102 11:08:54 InnoDB: Starting shutdown...
    060102 11:08:56 InnoDB: Shutdown completed; log sequence number 0 8700856
    060102 11:08:56 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 11:10:29 InnoDB: Started; log sequence number 0 8700856
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060102 11:39:22 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 11:39:24 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060102 11:39:24 InnoDB: Starting shutdown...
    060102 11:39:25 InnoDB: Shutdown completed; log sequence number 0 8700866
    060102 11:39:25 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 11:40:59 InnoDB: Started; log sequence number 0 8700866
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060102 16:54:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060102 16:54:05 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 33 user: admin

    060102 16:54:05 InnoDB: Starting shutdown...
    060102 16:54:08 InnoDB: Shutdown completed; log sequence number 0 8710927
    060102 16:54:08 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060102 16:55:42 InnoDB: Started; log sequence number 0 8710927
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060108 5:00:26 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060108 5:00:28 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060108 5:00:28 InnoDB: Starting shutdown...
    060108 5:00:30 InnoDB: Shutdown completed; log sequence number 0 9625065
    060108 5:00:30 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060108 5:02:20 InnoDB: Started; log sequence number 0 9625065
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060117 13:40:12 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060117 13:40:13 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060117 13:40:13 InnoDB: Starting shutdown...
    060117 13:40:15 InnoDB: Shutdown completed; log sequence number 0 9991725
    060117 13:40:15 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060117 13:41:40 InnoDB: Started; log sequence number 0 9991725
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060117 17:10:36 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060117 17:10:38 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060117 17:10:38 InnoDB: Starting shutdown...
    060117 17:10:40 InnoDB: Shutdown completed; log sequence number 0 10096385
    060117 17:10:40 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060117 17:12:16 InnoDB: Started; log sequence number 0 10096385
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060118 7:14:00 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060118 7:14:02 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 4 user: admin

    060118 7:14:02 InnoDB: Starting shutdown...
    060118 7:14:03 InnoDB: Shutdown completed; log sequence number 0 10140310
    060118 7:14:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060118 7:15:40 InnoDB: Started; log sequence number 0 10140310
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060209 9:02:22 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060209 9:02:24 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 4 user: admin

    060209 9:02:24 InnoDB: Starting shutdown...
    060209 9:02:26 InnoDB: Shutdown completed; log sequence number 0 12105656
    060209 9:02:26 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060209 9:03:15 InnoDB: Started; log sequence number 0 12105656
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060215 7:54:23 InnoDB: Operating system error number 32 in a file operation.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
    InnoDB: File name .\ibdata1
    InnoDB: File operation call: open.
    InnoDB: Cannot continue operation.
    060215 8:31:50 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060215 8:31:51 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060215 8:31:51 InnoDB: Starting shutdown...
    060215 8:31:54 InnoDB: Shutdown completed; log sequence number 0 12549926
    060215 8:31:54 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060215 8:33:14 InnoDB: Started; log sequence number 0 12549926
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060227 5:14:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060227 5:14:06 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 2 user: admin

    060227 5:14:06 InnoDB: Starting shutdown...
    060227 5:14:07 InnoDB: Shutdown completed; log sequence number 0 13457982
    060227 5:14:07 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060227 5:16:09 InnoDB: Started; log sequence number 0 13457982
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary
    060301 11:24:00 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

    060301 11:24:01 [ERROR] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 3 user: admin

    060301 11:24:01 InnoDB: Starting shutdown...
    060301 11:24:03 InnoDB: Shutdown completed; log sequence number 0 13541242
    060301 11:24:03 [Note] C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

    060301 11:25:41 InnoDB: Started; log sequence number 0 13541242
    C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
    Version: 4.1.12-nt socket: port: 8306 Official MySQL binary

  • RELEVANCY SCORE 3.12

    DB:3.12:Psa Db Access ? cf





    Have read the article that says to use:
    mysql -u admin -p password -P8306

    I get an unknown database psa error.

    Yet I can access the tables just fine using the dbclient tool.

    eliminating the psa from the command line then returns:
    ERROR 1035 (28000): Aceess denied for user admin@localhost (using password: YES)

    Now if I eliminate the -P8306 it logs in fine, but I see no psa database in the database list.

    Also, Im finding I am NOT able to use my Plesk Administrator password, instead I tracked down
    the password listed in one of the mysql dumps. That passwords gets me into mySQL but I
    dont see the psa DB anywhere. (databaseservers table, and it says port 3306)... am thinking
    this may be the communication password for the client databases.

    Still cant figure out why my panel password wont work to access the mysql psa database though.

    Yes, I am in the proper db area
    Program Files (x86)\Parallels\Plesk\MySQL\bin

    Ideas ?

    Rod

    DB:3.12:Psa Db Access ? cf




    Thats a possibility. We had a consultant do the initial database configuration and
    Plesk install/setup as we are migrating from an OLD IIS5 server running no Control Panel.

    Not sure if he changed passwords since the initial install or not.
    Will check.

    Thanks for the idea!

    Rod

  • RELEVANCY SCORE 3.12

    DB:3.12:Plesk Database ( Psa ) Location 9z





    Hi

    Excuse me , where is plesk 10 psa database file location ?

    in plesk 9 we had an psa.mdb in plesk admin folder

    but in 10 i could not found it

    if the plesk 10 database is MySql , where is it ?

    thanks

    DB:3.12:Plesk Database ( Psa ) Location 9z




    Are you sure that you have mysql engine for psa database?

  • RELEVANCY SCORE 3.12

    DB:3.12:Admin Password c9





    Plesk 11.0.9 - CentOS

    Hi,

    My admin password stopped to work.

    The problem now is this: when i try to fix the admin password on plesk with:
    export PSA_PASSWORD=pass; /usr/local/psa/admin/sbin/ch_admin_passwd; unset PSA_PASSWORD

    Plesk starts to work well, but mysql admin password stop working...

    Then when I fix the admin password directly on mysql database with:
    update user set password=PASSWORD(NEWPASSWORD) where User=admin;
    the plesk admin password stop working...

    I already try some tutorials and the problem is always the same
    Fix plesk admin password - mysql admin password stop work
    Fix mysql admin password - Plesk admin passsword stop work

    Im getting crazy with this... any ideas?

    DB:3.12:Admin Password c9




    Hello,

    Use following utility to prompt the password for user admin:

    Code:

  • RELEVANCY SCORE 3.12

    DB:3.12:Database Encoding Changed Since Upgrade? 1z





    Hello
    Ive upgrade my server from plesk 6 to plesk 7.
    I had some mysql database with french chars (accentued chars like é, à and so on)
    Now with plesk 7 all the site that used thoses databases dont display correctly the accentued chars from thoses textes. Before the upgrade everything was ok, now its not.
    What can I do about it?

    Greetings
    Philippe Kiener

    DB:3.12:Database Encoding Changed Since Upgrade? 1z




    Fix it

    Well actually it was the apache configuration that I needed to change. I commented this line:
    AddDefaultCharacter UTF-8

    and now it works, so this wasnt a database problem but a defaut configuration of apache 2 that tells that the page have a defaut encoding of UTF-8.

    Greetings
    Philippe Kiener

  • RELEVANCY SCORE 3.11

    DB:3.11:Odbc Connection To Mysql Db sa





    Hello,

    I want to connect my workstation (applications like Access and Excel) to a MySQL database on my Plesk server (suse 9.0/ Plesk 7.02) using the MySQL ODBCdirver (version 3.51). This will not work for some kind of reason.

    All the time Ill get this errormessage:
    [mysql] [ODBC 3.51 driver] Host hostname is not allowed to connect to this MySQL server

    hostname = ipadres of server (also the ip adres of domain,
    dbname, user and password are set correct.

    Some one any id what settings needs to be changed to let ODBC connect to my db?

    Thanx.

    Roel Vermelis

    DB:3.11:Odbc Connection To Mysql Db sa




    Databases that Plesk sets up are restricted to be accessed from localhost only (security resons). Youll have to change this for each database within mysql (either by a separate custom phpmyadmin or by hand).

  • RELEVANCY SCORE 3.11

    DB:3.11:Probem After Upgrading To Plesk 8.4.0 j8





    I have update my Plesk 8.3.0 to 8.4.0 via Plesk Updater: now all my sites show default pagaes of Plesk and my emails doesnt work.

    My VPS [Rhel3] doesnt run properly

    Service is not available now, probably your Plesk is misconfigured.
    Contact Your provider for details.

    Internal Plesk error occurred: Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to connect to Plesk Database: Client does not support authentication protocol requested by server; consider upgrading MySQL client packagemng: Unable to connect to the mysql database

    I have tryed to set OLD_PASSWORD in /etc/my.cnf and

    mysql UPDATE mysql.user SET Password=OLD_PASSWORD(*******)
    - WHERE Host =localhost AND User =root ;

    but nothing changed, except the error message when i TRY to use my Plesk Control Panel

    Service is not available now, probably your Plesk is misconfigured.
    Contact Your provider for details.

    Internal Plesk error occurred: Unable to connect to database: saved admin password is incorrect.

    How Can i resolve ?

    I have mysql4 installed on my VPS: i have to update to mysql5 ? how ?

    Thank you all!

    DB:3.11:Probem After Upgrading To Plesk 8.4.0 j8




    Also having problems checking email

    I am also having the exact same problems after an attempt to update from 8.3 to 8.4. Ive used /usr/local/psa/admin/bin/mchk -v with no succes. Domains work fine except email. I tried pop and horde webmail.

    The autoupdater email says that multiple packages are skipped because there is the same or newer and finally says:

    ERROR: Unable to install the requested packages because of package dependency problems.
    Warning! Not all packages were installed.

    Any ideas?

    Thank you,
    David

  • RELEVANCY SCORE 3.11

    DB:3.11:1.3 - 2.0 1j





    I hope someone can help me with this.

    I have a server which has Plesk 2.0 installed. Now I want to move users from a Plesk 1.3 server to the Plesk 2.0 server.

    I dont want that my clients should add email adresses and MySQL dbs themselfs. Also I dont want them to loose E-mails (on the server that is ofcourse) and also that the passwords will be the same.

    How can I do something like this? Can I (for example) take the Plesk database and move the Plesk 1.3 tables over the Plesk 2.0 tables?

    Oh, btw, at the moment there are no clients on the Plesk 2.0 server, it was my test server.

    Thanks,
    Kark

    DB:3.11:1.3 - 2.0 1j




    Im not sure if you can migrate the sql tables between versions, since the table names and prefixes change between 1.3.1 2.0. I would check with support to make sure what needs to be done.

    -Dan

  • RELEVANCY SCORE 3.11

    DB:3.11:Asp Sites Not Working sc





    I installed a new server with windows2003 plesk 7.6.1. After installing i tried to restore the plesk database. After a lot of problems, PHP, MYSQL, ME and more. Most of the websites work fine when I look through plesk interface (Preview domain). Only sites that dont work are the sites that work with ASP.

    This is the error that i get:

    Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.
    Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    I tried google, but no result. Can anyone help ?

  • RELEVANCY SCORE 3.11

    DB:3.11:Administering Plesk Via Mysql 8s





    I see a lot of references in this forum to fixing Plesk problems by editing the MySQL database.

    When I type show databases; all I get is the actual mysql database - what database is holds the Plesk data?

  • RELEVANCY SCORE 3.11

    DB:3.11:Assign Existing Database To Plesk Domain cx





    I am migrating to Plesk from another server. I have moved my databases over via mysqlbackup, but now I want Plesk to recognize them. What is the accepted way of assigning an existing mysql database to a Plesk domain?

    I am guessing that /usr/local/psa/admin/bin/dbmmanage might help me, but the only docs Ive found on this is the material presented at --help. The creation utilities dont seem to provide for this either.

    Id be grateful for any pointers.

    DB:3.11:Assign Existing Database To Plesk Domain cx




    Listen to hardweb.

    You can basically do a sql dump from one machine to the other.

    It will even create your fields and insert the data through the DBadmin control panel in plesk.

  • RELEVANCY SCORE 3.11

    DB:3.11:Plesk 8.1.1 Isnt Aware Of Ms Sql Server 2005 Express c1





    Plesk 8.1.1 cannt be aware of MS SQL server 2005 Express

    Hi All,

    I installed MS SQL server 2005 Express with the Authentication that is Mix Mode . Then, I also installed Plesk 8.1.1 by GUI and I chose Custom Install Type:
    1)database engines which plesk stores its own database is MS SQL server.
    2) Select Component :
    I cant see MS SQL server or MSDE,but i saw them before in Plesk 7.5.2. But I continuouslly Install . I typed completely Server Name localhost\SQLEXPRESS , username and password for sa.

    When I install completely and Login in Plesk Panel, go into services managerment:
    - MSSQL server not install
    - SQL server Express installed. And Only Plesk Database created in it.

    I using Account Mydomain to log into Plesk Panel. I cant create MS SQL server Database.
    Then I tried to Add New Database server in Database server item of Plesk. But I only can choose MySQL. I dont find MSSQL.

    Summarizely, I only want to use MS SQL server Express 2005 for storing Plesk Database and Customers Databases.

    Finally, To be able to use MSSQL server in Plesk, Must I install two version MSSQL(MSSQL server 2000 or MSDE and MSSQL server Express in this situation ?

    Anyone please help me resolve above problem.

    Thanks very much
    kind regards,
    vominh

    DB:3.11:Plesk 8.1.1 Isnt Aware Of Ms Sql Server 2005 Express c1




    I installed Unlimited license for Plesk 8.1.1. MSSQL wont use if i dont install another License for MSSQL add-on. I continously buy this license.

    (ref:http://www.swsoft.com/en/buyonline/plesk8win/addons/)
    Thank you to your support
    Kind regard,
    Thanks

  • RELEVANCY SCORE 3.10

    DB:3.10:Restoring Plesk Database Version 73





    I had a problem with upgrading Plesk 7.1.6 to Plesk 7.5.2 (FreeBSD 4.9) and now the Qmail service does not work.

    I backed up the /usr/local/psa directory before the failed upgrade and then restored it when the upgrade did not work.

    When I tried to re-run the installer / upgrade script, the following error appears:

    --------------------------------------------------

    Making some checks before upgrading

    Now BIND server shutting down...

    Trying to stop BIND server... done
    Trying to start BIND server... done

    BIND server starts Ok.

    Trying to start MySQL server... done
    Trying to establish test connection... connected
    Trying to stop MySQL server... done
    VERSION MISMATCH:
    PLESK DATABASE VERSION: 075
    PLESK INSTALLATION VERSION: 071

    ERROR while trying to check version match

    --------------------------------------------------

    How do I go about restoring the PLESK DATABASE VERSION to 071??

  • RELEVANCY SCORE 3.10

    DB:3.10:Reimport Configurations After Reinstalling Plesk pk





    I recently reinstalled my Plesk Panel 12.0.18 after several failures, which I wasnt able to repair (not even bootstrapper.sh would work). All of my websites werent accessible, the connection between websites and the Database server didnt work and the Plesk backend was unavailable, too. I used the autoinstaller via command line to make a new Plesk installation.
    Now I have a clean panel, the websites are available again, the MySQL database works again, but I dont have all my settings and websites in the Plesk backend anymore.

    My question is: How can I get the old settings/configurations, which are still on the server, back in to Plesk?

    DB:3.10:Reimport Configurations After Reinstalling Plesk pk




    @IgorG @abdi Thank you for your help. It worked out very well with IgorGs solution.

  • RELEVANCY SCORE 3.10

    DB:3.10:Asp, Mysql, Odbc ca





    Hi all.
    Im trying to conect an ASP site to a Mysql database.
    I know this is possible , but I need to know what version of ODBC that plesk 5 uses is it UnixODBC or is it iodbc.

    Also hav any one used this ODBC to connect to a database.
    As I dont know what to write in the odbc.ini

    DB:3.10:Asp, Mysql, Odbc ca




    Hi all.
    Im trying to conect an ASP site to a Mysql database.
    I know this is possible , but I need to know what version of ODBC that plesk 5 uses is it UnixODBC or is it iodbc.

    Also hav any one used this ODBC to connect to a database.
    As I dont know what to write in the odbc.ini

  • RELEVANCY SCORE 3.10

    DB:3.10:Mysql 3.23.58 Upgrade To 5..Problems? mk





    Hi,
    I have plesk 7.5. Right now mysql is version 3.23.58 and we want to upgrade it to 4 or 5.

    There are problems doing this?

    We dont have preferencese beetween 4 or 5. What do you advice us for a correct plesk work?

    Thanks
    Giuseppe

  • RELEVANCY SCORE 3.10

    DB:3.10:Open Mysql ms





    I want to automate my client setup process.. how can i open the mysql database to know the table information to create my own custom automate process to work with plesk.

    id appreciate a speedy reply..

    thanks in advance..

    DB:3.10:Open Mysql ms




    I want to automate my client setup process.. how can i open the mysql database to know the table information to create my own custom automate process to work with plesk.

    id appreciate a speedy reply..

    thanks in advance..