Hi

 

I have a question and can you please give me a example of how I can added a secibd vhosting under apache? The server domain name is cyberchatnet..com and the directory is located in the /home/www directory.

 

I am tyying tgo add a second domain as ecoads.net and I want everything to point to the /home/ecoads directory. I also need it to be www.ecoads.net and ecoads.net. I gave up oin trrying to do it with web admin, so I am doing this manualy.

 

I also need to define a different log file for each virtual host.

 

 

<VirtualHost 65.110.39.130>

DocumentRoot /home/www

ServerName cyberchatnet.com

</VirtualHost>

 

 

Thank you

to VNC to another computer using ssh (secure) you can do as follows:-

 

why would you want to do this ? because the vnc protocol is not secure in itself and can be sniffed see this quote from the vnc FAQ

 

Quote:Q55 How secure is VNC? 

 

i use mostly p4 desktops and p3 or banias based laptops

 

what do you use ?

 

if it's unusual tell us !

 

cheers

 

anyweb

This script will backup your mysql databases, gzip them up, ftp them off site, email you confirmation. For emailing you you have to create a file with the text for the body of the email. The email file used in this script is

 

Quote:/usr/local/logs/sqlbackup

Quote:Mysql database backup was successfully completed. Your a demigod!

Quote:databases="db1 db2 db3 db4"

Quote:#!/bin/sh 

# This script will backup one or more mySQL databases

# and then optionally email them and/or FTP them

 

# This script will create a different backup file for each database by day of the week

# i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1)

# This is a trick so that you never have more than 7 days worth of backups on your FTP server.

# as the weeks rotate, the files from the same day of the prev week are overwritten.

 

############################################################

#===> site-specific variables - customize for your site

 

# List all of the MySQL databases that you want to backup in here,

# each seperated by a space

databases="<db name here>"

 

# Directory where you want the backup files to be placed

backupdir=/usr/local/backup

 

# MySQL dump command, use the full path name here

mysqldumpcmd=/usr/local/mysql/bin/mysqldump

 

# MySQL Username and password

userpassword=" --user=<username here> --password=<password here>"

 

# MySQL dump options

dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

 

# Unix Commands

gzip=/bin/gzip

uuencode=/usr/bin/uuencode

mail=/bin/mail

 

# Send Backup?  Would you like the backup emailed to you?

# Set to "y" if you do

sendbackup="y"

subject="mySQL Backup"

mailto="<email here>"

 

#===> site-specific variables for FTP

ftpbackup="n"

ftpserver="<ftp server here>"

ftpuser="<login here>"

ftppasswd="<pass here>"

# If you are keeping the backups in a subdir to your FTP root

ftpdir="forums"

 

#===> END site-specific variables - customize for your site

############################################################

 

# Get the Day of the Week (0-6)

# This allows to save one backup for each day of the week

# Just alter the date command if you want to use a timestamp

DOW=`date +%C%y%m%d`

 

# Create our backup directory if not already there

mkdir -p ${backupdir}

if [ ! -d ${backupdir} ]

then

echo "Not a directory: ${backupdir}"

exit 1

fi

 

# Dump all of our databases

echo "Dumping MySQL Databases"

for database in $databases

do

$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql

done

 

# Compress all of our backup files

echo "Compressing Dump Files"

for database in $databases

do

rm -f ${backupdir}/${DOW}-${database}.sql.gz

$gzip ${backupdir}/${DOW}-${database}.sql

done

 

# Send the backups via email

if [ $sendbackup = "y" ]

then

for database in $databases

do

#      $uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu

#      $mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu

$mail -s "$subject : $database" $mailto </usr/local/logs/sqlbackup

  done

fi

 

# FTP it to the off-site server

echo "FTP file to $ftpserver FTP server"

if [ $ftpbackup = "y" ]

then

for database in $databases

do

      echo "==> ${backupdir}/${DOW}-${database}.sql.gz"

ftp -n $ftpserver <<EOF

user $ftpuser $ftppasswd

bin

prompt

cd $ftpdir

lcd ${backupdir}

put ${DOW}-${database}.sql.gz

quit

EOF

done

fi

 

# And we're done

ls -l ${backupdir}

echo "Dump Complete!"

exit

INSTALLING phpMyAdmin

 

OK, lemme add a bit more for phpMyAdmin, nice little program written in PHP to admin your new mysql databases..

 

First things first, we need to get the latest version of phpMyAdmin, at the time this tutorial was written the latest stable version was 2.5.6, and you can get it at;

 

The phpMyAdmin Home page

 

OK open a terminal/console window..

 

Change to the directory where you saved the downloaded file , such as;

 

although the guide below is OLD, it still works (as of December 2007.

 

I've tested it with the following versions in Fedora 8

 

apache_1.3.39.tar.gz

mysql-5.0.51.tar.gz

php-5.2.5.tar

 

and apart from a small hiccup while configuring php, all was ok.

 

ok, on with the show...

 

Quote:PLEASE NOTE: THIS HOWTO WAS WRITTEN BEFORE THE VULNERABILITIES WERE FOUND IN APACHE 1.3.x - MAKE SURE TO USE APACHE 1.3.31 OR NEWER FOR THIS HOWTO. FOR DETAILS OF THE VULNERABILITIES AND TO DOWNLOAD THE APACHE 1.3.31 SOURCE PLEASE SEE <a href="http://httpd.apache.org/download.cgi" target="_blank"><a href="http://httpd.apache.org/download.cgi" target="_blank">http://httpd.apache.org/download.cgi</a></a> 

TO REPEAT, PLEASE SUBSTITUE ALL REFERENCES BELOW TO APACHE 1.3.29 with APACHE 1.3.31 or newer !

Quote:MySQL has a Web site at <a href="http://www.mysql.com/" target="_blank"><a href="http://www.mysql.com/" target="_blank">http://www.mysql.com/</a></a> which carries details on thelatest release, upcoming features, and other information to make your

work or play with MySQL more productive. There you can also find

information about mailing lists for MySQL discussion.

 

Remember to check the platform specific part of the reference manual for

hints about installing MySQL on your platform. Also have a look at the

files in the Docs directory.

 

Thank you for choosing MySQL!

Quote:Starting mysqld daemon with databases from /var/lib/mysql040527 14:33:45 mysqld ended

Quote:[root@localhost bin]# ./mysqladmin version./mysqladmin Ver 8.40 Distrib 4.0.18, for pc-linux on i686

Copyright

Yeah, i'm new...and a noob with linux... so hi!

Well today is the day I must move so I really hope to see you all in a few days, who knows how long it will take the ISP to hook up the connection :| anyways thanks for the help again :)see you soon...

hi all, well the last few days have been interesting for me, the backup server for this site was running win2k3 180 time limited and it expired ! so, rather than reinstall i decided to learn some more linux and installed fedora on the backup server,

 

then with a lot of help from the following people i got the site up and running as a backup server, still needs tweaking but its there and working,

 

now that i have a fedora server working i am going to (when i get time) revamp the content and re-organise the content of my site, there's alot more there than forums, 9875 files in all and 1.9 gig of data which is quite a chunk. Once done i'll mirror the site on both machines...

 

I want to say thanks for helping me with setting up apache/mysql/php from scratch to:-

 

[strabo] for his good howto for compiling mysql/apache/php

 

you can read it here

 

Jy (hijinks) for his help with MySQL

 

z0ny for his help with importing/exporting SQL databases

 

Michael for his help with IPB/MySQL

 

Square for his donations to [/url][url=https://www.linux-noob.com]https://www.linux-noob.com

 

cheers

 

anyweb

Fedora saw and properly used my soundcard upon setup and first boot but as soon as I rebooted, it stopped working giving the error it cant initialize some module insmod or somehting in one of hte systems drivers folders. The cars is a Sound Blaster Audigy... if anyone can help it would be much appreciated.