Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st June 2010, 11:04
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,263
Thanks: 216
Thanked 649 Times in 295 Posts
Default ISPConfig3 server | Import MySQL-database for ssh-users

Hi Till,
Most of my clients are using phpMyAdmin to import their mysqldump.sql file.
Now, i wonder if it is possible for clients to import a mysql dump file manualy by using a client ssh-user account, which is created in ISPConfig3,
because until now we're not succesful.

Executing the following command by using the client SSH-user account gives an "Permission denied" error:

mysql -h localhost -u MYSQLusername -p[password] MYSQLdatabase < mysqldump.sql

Note: The MySQL database has been created in ISPConfig3 and the MySQLdatabasename, MySQL username and password are correct.

Do i need to configure something else which makes the import of mysqldump files possible?
__________________
Hans

MrHostman | Managed Hosting
Reply With Quote
Sponsored Links
  #2  
Old 2nd June 2010, 09:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,037
Thanks: 841
Thanked 5,656 Times in 4,464 Posts
Default

1) Is this a jailed ssh user?
2) What is the exact permission denied message?
3) Please try this mysql command:

mysql -u MYSQLusername -p
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 2nd June 2010, 11:40
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,263
Thanks: 216
Thanked 649 Times in 295 Posts
Default

Hi Till,


1) Jailkit has been installed on the server, but for the checkbox " Chroot Shell " is not enabled for the ssh-user.

2) The exact error message is: ERROR 1044 (42000) at line 1: Access denied for user 'c61typo3test'@'localhost' to database 'cid291'

3) I will ask my client to use this command instead: mysql -u MYSQLusername -p
I hope the client will be succesful then, i'll let you know.

What do you think about the error message?
__________________
Hans

MrHostman | Managed Hosting
Reply With Quote
  #4  
Old 3rd June 2010, 00:06
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,263
Thanks: 216
Thanked 649 Times in 295 Posts
 
Default

Hi Till,
We got it working now. The client made a typo.
__________________
Hans

MrHostman | Managed Hosting
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending mail ISPConfig 3 but not receivind catza Installation/Configuration 20 19th May 2010 13:47
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 11:05
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30


All times are GMT +2. The time now is 17:06.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.