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 28th January 2011, 11:16
talkingnews talkingnews is offline
Member
 
Join Date: Jan 2011
Posts: 65
Thanks: 15
Thanked 5 Times in 5 Posts
Default Newbie questions regarding ssh, databases and apps

I feel fairly confident around ispconfig now - I've joined, bought the manual, followed the guide, installed 3.0.3.2 on Ubuntu 10.10 64 on a vps, updated everything, and have 2 sites running perfectly.

Well, almost. In order of urgency:

I can ssh in as the root user. But this isn't good, so I created a new ssh user in ispconfig with chroot jailkit permissions.

I start putty, connect, type username and password, ubuntu welcomes me, and immediately, I get "remote host closed connection". Can't see anything in the logs about why this would be, and there's no other error. The last thing on the screen is "Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law". I never get as far as the prompt, and I've tried both /bin/bash (default) and also /bin/sh

Next up: databases. For some reason, the links to ispconfig's internal apps like phpmyadmin doesn't appear to work (404). Not to worry, I installed phpmyadmin separately, but now I want to add another database under the same username.
phpmyadmin says no priviledges to do this (even though I granted all from mysql command line), but more importantly, ispconfig wants me to create a NEW user for each NEW database. This is going to make copying between databases in phpmyadmin a little tricky!

Finally, and this is probably a more general linux question, but is it possible to dispense entirely with all the "on board" email systems and have all email, alerts etc generated by the system running through my gmail or other external email service? I don't NEED email for the site itself, so running all this gubbins is just taking space.

Thanks, and thanks for a brilliant application.
Reply With Quote
Sponsored Links
  #2  
Old 29th January 2011, 16:04
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Quote:
Originally Posted by talkingnews View Post
I start putty, connect, type username and password, ubuntu welcomes me, and immediately, I get "remote host closed connection". Can't see anything in the logs about why this would be, and there's no other error. The last thing on the screen is "Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law". I never get as far as the prompt, and I've tried both /bin/bash (default) and also /bin/sh
Any errors in your logs?

Quote:
Originally Posted by talkingnews View Post
Next up: databases. For some reason, the links to ispconfig's internal apps like phpmyadmin doesn't appear to work (404).
See chapter "4.9.2.4 Interface Config" in the manual.

Quote:
Originally Posted by talkingnews View Post
This is going to make copying between databases in phpmyadmin a little tricky!
You can do this by logging in as the MySQL root user.

Quote:
Originally Posted by talkingnews View Post
Finally, and this is probably a more general linux question, but is it possible to dispense entirely with all the "on board" email systems and have all email, alerts etc generated by the system running through my gmail or other external email service? I don't NEED email for the site itself, so running all this gubbins is just taking space.
Take a look at the "always_bcc" directive ( http://www.postfix.org/postconf.5.html ).

Thanks, and thanks for a brilliant application.[/QUOTE]
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 31st January 2011, 22:32
talkingnews talkingnews is offline
Member
 
Join Date: Jan 2011
Posts: 65
Thanks: 15
Thanked 5 Times in 5 Posts
Default

Quote:
Originally Posted by falko View Post
Any errors in your logs?
Not that I can find, I'm looking in syslog. The strange thing is, I made a second account, and with all the settings identical, one works, the other logs me out immediately. Weird.

Quote:
Originally Posted by falko View Post
[Regarding making two sql DBs with the same username]You can do this by logging in as the MySQL root user.
Yes, I realise this. I was just hoping ISPCONFIG and command line would keep me away from the root shell a bit more.

Quote:
Originally Posted by falko View Post
Take a look at the "always_bcc" directive ( http://www.postfix.org/postconf.5.html ).
Confused - looks like this requires postfix to still be running? My goal is to remove ALL mail, pop3, smtp, email system from the server, let google/someone else handle it.

Incidentally, should anything ever appear in the TOOLS>APPS AND ADDONS section, should anything ever appear in "packages" and "updates"? I've got the http://repo.ispconfig.org/addons/ repo in there, but it doesn't really get a mention in the manual, and nothing ever appears despite regularly clicking "update".
Reply With Quote
  #4  
Old 1st February 2011, 15:30
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Quote:
Originally Posted by talkingnews View Post
Yes, I realise this. I was just hoping ISPCONFIG and command line would keep me away from the root shell a bit more.
Just use phpMyAdmin.


Quote:
Originally Posted by talkingnews View Post
Confused - looks like this requires postfix to still be running? My goal is to remove ALL mail, pop3, smtp, email system from the server, let google/someone else handle it.
At least Postfix must be running.

Quote:
Originally Posted by talkingnews View Post
Incidentally, should anything ever appear in the TOOLS>APPS AND ADDONS section, should anything ever appear in "packages" and "updates"? I've got the http://repo.ispconfig.org/addons/ repo in there, but it doesn't really get a mention in the manual, and nothing ever appears despite regularly clicking "update".
The repo is currently empty, so that's ok.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
talkingnews (1st February 2011)
  #5  
Old 1st February 2011, 15:45
talkingnews talkingnews is offline
Member
 
Join Date: Jan 2011
Posts: 65
Thanks: 15
Thanked 5 Times in 5 Posts
 
Default

OK, big thumbs up and thanks for answering all my questions!
Reply With Quote
Reply

Bookmarks

Tags
database, ispconfig 3, mysql, phpmyadmin, ssh

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


All times are GMT +2. The time now is 02:27.


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