Password Mismatch Error On Restoring Db Via Ssh
Apr 7, 2009Trying to restore db for my friend, was able to back up db via ssh using the username and pwd, but while restoring db in a new host get : Password mismatch error,
View 0 RepliesTrying to restore db for my friend, was able to back up db via ssh using the username and pwd, but while restoring db in a new host get : Password mismatch error,
View 0 RepliesI'm having trouble getting an SSL certificate setup on a domain through WHM. I was originally getting a "Modulus mismatch, key file does not match certificate." error. I contacted RapidSSL and they had me generate a new CSR for the domain and forwarded a new cert. I'm still getting the same error, which makes me think it's a server-side issue.
I have checked and re-checked the cert text to make sure I'm not putting in any extra whitespaces or anything. I know the cert must be somewhat valid because when I put it into WHM and click outside the cert box it automatically pulls up what account it is for (domain, username, ip).
Does anyone know what would cause this?
SQL query:
/*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
UNLOCK TABLES;
--
-- Table structure for table `qhvbmailer_campaigns`
--
DRO' at line 1
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases:
Quote:
ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database roundcube......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists'
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string
Done
Restoring database horde......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists'
ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist
ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist
ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist
ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist
ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist
ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist
ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist
ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist
ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string
ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist
ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist
ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string
ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string
Done
What does this error mean and how to solve this problem?
I have updated cpanel and mysql but the problem is still found
This problem found while trying to restore any account not this one only..
i try to restore a backup from another hosting to my server and always get stucked on "restoring reseller privs"
i'm using restorepkg username and got this error
Code:
not a reference at /usr/local/cpanel/Cpanel/CachedDataStore.pm line 27
at whm i can transfer multiple account and select "skip restoring reseller privs" but in this case my old hosting doesnt provide ssh access.
i was wondering is there any paramater to skip that?
something like
Code:
/scripts/restorepkg -somethingblahblah accusername
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info:
Plesk 11.5
Windows 2008 R2 (64Bit)
3GB RAM
MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
i have a dedicated server with CENTOS Enterprise 4.6 i686 on standard i have main problem that there is an account on my server that the password can enter the FTP account normally but not enter the Cpanel i see that if the coanel pass is 951753
he can not log in the cpanel but can enter FTP why this problem ? and how to resolve it
I am getting problem in cPanel installation, i tried 5-6 times but no success.
please find the log of the cpanel installation
...3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cpanel/ base/backend/webdisk.vbs (0)....@208.109.109.239......connected......receiving.. .100%......Done
md5sum mismatch (actual: cbd901252be59b37d33ffbd5440c888a) (expected: d0f0b90167 9da0932c023931f38ccecb)....
Thought of sharing this with all.
Issue:
Php function was returning wrong time. There was a difference of 1 hour between the server time and the php time. Due to this ,most of the functions on the site were not working properly.
Fix :
For checking the php time, put the following code in a file, say time.php
Code:
<?php
$time = time();
$result = date(”Y-m-d (D) H:i:s”,$time);
echo “Current date and local time on server = $result “;
?>
Execute the php script.
Code:
[root@localhost ~]# php -a time.php
Interactive mode enabled
Current date and local time on server = 2017-01-30 (Mon) 18:04:25
To get the server time , issue the following command :
Code:
[root@localhost ~]# date
Mon Jan 30 17:04:25 IST 2017
You can see the difference of one hour between the server time and the php time.
For fixing this, you need to install the PECL timezonedb module.
Code:
[root@localhost ~]# pecl install timezonedb
At the end , you might see the following message :
==========================
Build process completed successfully
Installing ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/timezonedb.s o’
install ok: channel://pecl.php.net/timezonedb-2009.6
configuration option “php_ini” is not set to php.ini location
You should add “extension=timezonedb.so” to php.ini
==========================
So , add the line ” extension=timezonedb.so” to the php.ini file and restart apache.
There shouldn’t be any mismatch in time now.
I have just bought a switch Cisco 3750. However, when I plugged in the uplink. The link is set to half-duplex only (auto-negoiation).
Below is the error in the "Diagnostic Log" of the log:
03:54:52: %CDP-4-DUPLEX_MISMATCH: duplex mismatch discovered on FastEthernet1/0/18 (not full duplex), with sw6.hkg3.asianetcom.net GigabitEthernet0/21 (full duplex).
I have tried to set the port to "Full" in Cisco. But, the link drops immediately. Could anyone tell me how to fix that?
I'm having a bit of a problem with my SSL certificate and can't seem to work out how to get around it.
Trying to install a RapidSSL certificate to one of my websites but for some reason when i enter the certificate into cPanel it says:
modulus mismatch, key file does not match certificate. Please use the correct key file ..
I attached a service node to PPA using public key by following [URL] ....
But when I check tasks, Configure PA agent on node 'ip-10-0-0-24' fails with message: SSH communication error: SSH auth via password failed
I correctly configured ssh by pub keys. I can SSH into service node with ip 10.0.0.2 from PPA management node without any issue.
Licence: PPA.03119864.0000
I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?
I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.
Im trying to setup a mysql server on my centos vps server. Ive installed mysql server and done chkconfig and the mysql server has started. My problems start when i want to set a mysql root password.
Quote:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
I get an error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"
Which i totally dont understand because why would it want a password when im trying to set the password?
Everyday after Backup Panel (Tasks from Backup Manager), I receive next error:
<?xml version="1.0" encoding="utf-8"?>
<execution-result status="error">
<object name="domain.ru" type="domain">
<message severity="error" id="416a91ad-e5e7-480b-b6b4-a60157b8eaae" code="InformationalException">
<description>Could not find password for account id '2648'. Return empty password</description>
</message>
</object>
</execution-result>
Resolve -> only reconfigure domain. How can I automatic fix this problem?
today i changed the password for the admin panel for a customer (username eg. mylogin). 10 minutes later he called me and said that he cannot get into his emailaccount anymore. Checked the password and saw that the emailpassword for his emailaddress (eg. mylogin@mydomain.com) is now the same from the admin panel login. So i changed the emailpassword and checked the admin panel login - it now has the emailpassword. What a mess.. I'm running Plesk Panel 11.5.30 MU47.
View 1 Replies View RelatedHow to change the Password of my FTP?
I know how to change the pwd. of cPanel, but I don't know how to change the pwd. of FTP?
how long does it take to restore 400 MB database though SSH, i check on phpmyadmin screen, and it has 79 tables only. the last table was post table.
View 1 Replies View Relatedhow to restore an account from backups as my WHM backs up to an external server via FTP and I dont have a clue how to restore.
View 7 Replies View RelatedI have an existing client with about 200 email accounts, I want to migrate all of them off of our server and to a VPS or something. They wil use a webmail to access them.
Is that possible?
Also, is it possible to give the client access only to create email accounts without giving them access to the whole hosting control panel?
I am in the process of migrating client's website and mailboxes.
My server is using Plesk 8.1 with horde as the default webmail applacation and had to install Squirrelmail beacause he was using this program integrated in his website.
I have been able to install it, configure it, it works both on Http and Https and i'm able to receive and send emails.
After this i'm trying to restore all the mailboxes into the new server (10 GB worth of mail) but i can't seem to find where to place that folder. I have tried google and looked everywhere suggested but can't find the folder where mails are stored I have been able to find the folder where the addressbook and config file for every account is located (/var/qmail/mailnames/DOMAIN/ALIAS) but there are no emails there despite the fact that they appear in the Inbox in Squirrelmail.
The server is running Debian 3.1 with Plesk 8.1 and Squirrelmail 1.4.4
I had my server with FDCservers and its back after 2 days of horrible downtime which according to them was due to hardware failure.
Server specs:
Intel Core 2 DUO E6600 @ 2.40 GHz
4096 MB RAM
400 GB HDD
cPanel
The old drive has Fedora 5 running with cPanel but on new drive, its CentOS 4.5 with cPanel.
Now, I want to restore the files from old(slave) drive to master(main on which centOS is running)
How do I do that? Isnt there any possibility since I changed the Operating System.
Here's the situation:
Moving from VPS to Dedicated,
VPS (cPanel) and Dedicated (Plesk)...
I FTP'd all the files, what's left is the database.
I was going to restore the db using SSH, but I had to FTP it first, so I tried but half-way it would time out (disconnect from server)
Right now I am trying phpMyAdmin, I doubt it will work.
Is there a way to transfer from cPanel to Plesk?
DB size is 400MB
How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
View 12 Replies View RelatedThis seemed like the most appropriate place so I decided to post here.
SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4
The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.
Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.
I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:
Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.
I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.
Is there a way I could perhaps split up my db dump and then import them into the db one by one?