User login

GNU-Linux

See what Subversion repository you are drawing from with vi .svn/entries

See from what repository checked out subversion code is from by looking at the entries file in a dot SVN folder:

ben@server:/var/www/drupal-5-live/sites/democraticmedia.ca$ vi .svn/entries

Here is the key line, "https://dev.grassrootsconnection.org/svn/drupal/anderson/trunk/democraticmedia.ca," from this output:

8

Adding a new version of Drupal core to Agaric's Piston-enabled deployment system

cd /RCS/agaric/drupal-core/
cvs -z6 -d:pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal co -r DRUPAL-6-3 -d drupal-6 drupal
sudo svn add drupal-6
sudo svn commit -m "Drupal 6"

drupal-6 and DRUPAL-6-3 need to be replaced with the major release and point release that you are dealing with (though with luck we'll have moved from CVS soon and this will all be moot).

Temporary Local Problem 451 and Rejected E-mail

Update: Apparently all caused by the server name listed as sending, that domain name not resolving.

That domain name is sort of represented as example.net in the dumps below.

Getting identical messages, in one e-mail, regarding two totally separate servers...

<

blockquote>
This is the mail system at host mail.democraticmedia.ca.

With XAMPP, permission denied for MySQL user with % (all) host access but works for localhost

For reasons not known to man nor beast, on XAMPP on Mac OS X (and not XAMP but another all in one WAMP stack, but not that name either) will not work with the wildcard availability host name (%). It will work (or anyhow may work for you, it worked for Agaric!) with the @localhost for host name.

Resolution

In a shell script, create a database if it does not exist

Use the MySQL: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database_name'

<?php
if (mysql_num_rows(mysql_query("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '". $dbname ."'"))) {
  echo "Database $dbname already exists.";
}
else {
  // go on and create the user, database, etc.
  // create the user

  if (!mysql_query("CREATE USER '". $dbuser ."'@'%' IDENTIFIED BY '". $dbpass ."'"))  die(mysql_error());
  echo "User $dbuser created.\n";

Update or commit: See what's changed in a version-controlled file with svn diff

When you run
sudo svn status -u
and see

M 6549 www/.htaccess

you can see exactly what's up with those changes with
svn diff www/.htaccess
Showing something like:
Index: www/.htaccess

RSA host key changed, requires validation: what to do

RSA host key for example.com has changed and you have requested strict checking.
Host key verification failed.

In the line above it will actually tell you where the bad key is, with known_hosts being the file and 2 being the position of the problem key:

Offending key in /home/you/.ssh/known_hosts:2

Getting out of the local permissions / server login catch 22

The first step to getting out of the local permissions / server login catch-22 is to know you're in it.

Perhaps you found this page searching for "Permission denied on publickey even though I can log into the server with a public key it doesn't make any sense grrr argh how dare it deny me i created it why won't it work permissions are correct this isn't right" or something like that.

Your problem is that when you run the command without sudo, you don't have the proper permissions locally, and your computer doesn't even try to connect to the server:

Piston not found after installation, setting bash paths

http://neoarch.wordpress.com/2007/07/13/bash-cap-command-not-found/

vi ~/.bashrc

Set path for Piston

export PATH=$PATH:/var/lib/gems/1.8/bin

source ~/.bashrc

server:~$ sudo vi /root/.bashrc
server:~$ source /root/.bashrc

/var/lib/gems/1.8/bin

restart bash

ben@server:~$ sudo /bin/bash --login

How to change your mysql root password using command line

So you wanna change your root password for mysql, huh?

Follow these instructions and know in your heart that you did it, the Agaric Way....

Resolution

MySQL stores username and passwords in user table inside MySQL database.

You can directly update password using the following method to update or change password for user root:

1) Login to mysql server, type following command at shell prompt:

$ mysql -u root -p

2) Use mysql database (type command at mysql> prompt):

Syndicate content