Internet Bandaid   [RSS Feed]

Archive for the ‘1and1 business package’ tag

1and1 Review

without comments

I’ve been using 1and1.com’s business package (shared linux hosting) as my staging server for the past 4 years without problems. I’ve used it for the following purposes:

  • php 4 and php 5 applications
  • mysql 4.0 and mysql 5.0 databases
  • subversion
  • multiple domains and multiple sub domains
  • setting up ssh keys for other developers (because they only offer 1 ssh account)
  • purchased an SSL for one of my domains (easy to set up)
  • to host a blog that gets 500 pageviews per day

I’m fairly happy with the 1and1.com’s service. I don’t have any big complaints.

Some things which people may find annoying are:

  • automated recurring billing: So don’t expect your account to terminate upon expiration. This is by far the biggest complaint others have about 1and1.com
  • email tech support: sometimes it could take up to 12 hours for a junior technician to respond to your message. If it’s something he can’t handle, it may take another 12 hours for a senior sysadmin to respond. So be prepared for 12 hour delays between emails. I haven’t tried their phone tech support yet.
  • no remote database access: so I borrow my friend’s godaddy webhosting because there’s remote db connection there
  • customers get 1and1.com’s admin control panel as opposed to a popular one like cPanel. But 1and1.com’s control panel is pretty good.

Written by John Lai

April 6th, 2009 at 4:59 pm

PHP5 on 1and1

without comments

To enable PHP 5 on a 1and1 shared web hosting linux package, simply create (or edit) a file with the name .htaccess on your server and add the following line:

AddType x-mapp-php5 .php
This will make all php files in subdirectories rendered as php version 5.

Written by John Lai

April 5th, 2009 at 4:54 am

Install phpMyAdmin on 1and1

with one comment

You can install your own instance of phpmyadmin on your 1and1 shared hosting package. The advantage of this approach is that you can share access to a single database with other users without having to give them credentials to access your 1and1 backend. To accomplish this, follow the procedure below:

  1. Download a copy of phpmyadmin.
  2. Unzip the contents of your new download.
  3. Create the directory you wish to host the phpmyadmin on your 1and1 webserver (eg. http://yourwebsite.com/phpMyAdmin/)
  4. Use the 1and1.com backend controls to password protect this phpmyadmin directory (found under Web Access>Protected Directories).
  5. Use the following code in your config.inc.php, but replace the database host, database username, database password and database name with the appropriate values:

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

$cfg['PmaAbsoluteUri'] = ‘http://yourwebsite.com/phpMyAdmin/’;
$cfg['Servers'][$i]['host'] = ‘db_host’; // something like db909ds.perforanet.net
$cfg['Servers'][$i]['auth_type'] = ‘config’; // 1and1.com uses ‘config’ as opposed to ‘cookie’
$cfg['Servers'][$i]['user'] = ‘db_user’; // something like dbo909809
$cfg['Servers'][$i]['password'] = ‘db_pass’;
$cfg['Servers'][$i]['only_db'] = ‘db_name’; // something like db909809
/* Server parameters */
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = ‘mysql’;
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = ‘pma’;
// $cfg['Servers'][$i]['controlpass'] = ‘pmapass’;
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
// $cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
// $cfg['Servers'][$i]['relation'] = ‘pma_relation’;
// $cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
// $cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
// $cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
// $cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
// $cfg['Servers'][$i]['history'] = ‘pma_history’;
// $cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = ”;
$cfg['SaveDir'] = ”;

?>

And that is it. The only difference between this config.inc.php and the default config.sample.inc.php that comes with phpmyadmin are the following 6 lines:

$cfg['PmaAbsoluteUri'] = ‘http://yourwebsite.com/phpMyAdmin/’;
$cfg['Servers'][$i]['host'] = ‘db_host’; // something like db909ds.perforanet.net
$cfg['Servers'][$i]['auth_type'] = ‘config’; // 1and1.com uses ‘config’ as opposed to ‘cookie’
$cfg['Servers'][$i]['user'] = ‘db_user’; // something like dbo909809
$cfg['Servers'][$i]['password'] = ‘db_pass’;
$cfg['Servers'][$i]['only_db'] = ‘db_name’; // something like db909809

Written by John Lai

April 5th, 2009 at 3:17 am

SVNserve (Subversion) on 1and1

with 2 comments

** A new post has been written on this subject. Please read SVN Access Via SSH Keys for Linux and Windows for an updated and working solution (works on 1and1 as well).


—– Old Original Post ——-

I spent the week trying to get Multiple Subversion User Accounts to work on a 1and1 Linux Business Package. I FAILED. The 1and1 tech team told me they do not allow it.

As many of you know by now, the 1and1 Linux Business Package only gives you one SSH account. Ideally, you do not share this ssh account because it opens up your entire shared server, including access to svn (via svn+ssh tunnel mode – instructions here).

First, I tried to run svnserve in daemon mode and failed. I discovered 1and1 runs a crontab to kill svnserve daemons every minute. I tried to write my own crontab to revive the daemon, but that didn’t work.

Second, I tried to run svnserve in inetd mode, but because I do not have access to inetd.conf (makes sense..i’m on a shared server), this option failed.

Third, I tried to use public key authentication to allow multiple users to ssh into my shared server without knowledge of my ssh password. 1and1 does not allow public key authentication unless you’re using putty public key authentication, which isn’t the same thing. So this option failed too.

In the end, I released my sole ssh credentials to my developers, which they used to ssh tunnel into my repository.

1and1 said they allow svnserve on their dedicated and virtual servers.

———

** A new post has been written on this subject. Please read SVN Access Via SSH Keys for Linux and Windows for an updated and working solution (works on 1and1 as well).

Written by John Lai

September 8th, 2008 at 9:51 pm