HTML examples
- Read more about HTML examples
- Log in to post comments
Then your text
Then your text
#!/bin/bash
# install bridge utils
apt-get install bridge-utils
# create bridge
cat <> /etc/network/interfaces
auto br0
iface br0 inet dhcp
bridge_ports eth0
bridge_fd 2.5
EOF
# restart network
/etc/init.d/networking restart
# create an interface for a user
VBoxAddIF vbox0 $USERNAME br0
# Links
# http://wiki.ubuntuusers.de/VirtualBox
# http://wiki.debian.org/VirtualBox
#!/bin/bash
# http://www.panticz.de/Send-email-from-console
INPUT=./adr_uniq.txt
CONTENT=./nl_de.html
SUBJECT="YOUR_SUBJECT"
LOG=./nl_de_$(date -I).log
# send
for i in $(cat $INPUT); do
mail -a 'Content-type: text/html;' -s "$SUBJECT" "$i" < $CONTENT
echo "$i - $?" | tee -a $LOG
done
#!/bin/bash
# download netboot image
wget http://archive.ubuntu.com/ubuntu/dists/trusty-updates/main/installer-amd64/current/images/netboot/netboot.tar.gz -P /tmp
# extract and copy install files
tar xzf /tmp/netboot.tar.gz -C /tmp
mkdir /boot/ubuntu
cp /tmp/ubuntu-installer/amd64/initrd.gz /boot/ubuntu/
cp /tmp/ubuntu-installer/amd64/linux /boot/ubuntu/
# create GRUB menu entry
cat < /etc/grub.d/49_ubuntu
#!/bin/sh
exec tail -n +4 $0
menuentry "Network Ubuntu install" {
root (hd0,0)
kernel /boot/ubuntu/linux
initrd /boot/ubuntu/initrd.gz
}
EOF
chmod
-- show tables
select table_name from all_tables;
-- output parameter
set wrap off;
set pagesize 0;
set linesize 120;
column owner format a30;
-- show configuration
show parameters;
-- list users
select username from all_users
-- find constraint
select *
from all_constraints
where constraint_name = 'SYS_C00381400';
-- select a random row from table
SELECT column FROM
SELECT column FROM table
ORDER BY dbms_random.value
)
WHERE rownum = 1
-- update materialized view
begin
dbms_snapshot.refresh('SCHEMA.MATERIALIZED_VIEW_NAME');
end;
-- view sched
-- view hostname
select @@hostname;
-- view version
select version();
-- view engines
show engines;
-- list databases
show databases;
-- change database
use mysql;
-- show tables in database
show tables;
-- show table informations
show table status;
-- show engines
show engines;
-- show bin_log info
show variables like '%log_bin%';
-- list users
select user, host from mysql.user;
-- delete user
DROP USER 'USER_NAME'@'%';
-- set user password
--SET PASSWORD FOR 'USER_NAME'@'%' = PASSWORD('NEW_PASSWORD')
use mysql;
update user set password=PASSWORD(
#!/bin/bash
cat < "$(grep DocumentRoot /etc/apache2/sites-available/default | cut -d " " -f2)/phpinfo.php"
<?php
phpinfo();
?>
EOF
#!/bin/bash
mysqldump --host=${DB_FROM_HOST} --user=${DB_FROM_USER} --password=${DB_FROM_PASS} ${DB_FROM_NAME} | \
mysql --host=${DB_TO_HOST} --user=${DB_TO_USER} --password=${DB_TO_PASS} ${DB_TO_NAME}
<?php
if($_SERVER['PHP_SELF'] != "/index.php") {
echo '
';
}
?>
# set domU parameter
[ -z $DOMAIN_NAME ] && DOMAIN_NAME=webmail
[ -z $DOMAIN_MAC ] && DOMAIN_MAC=00:11:22:7d:7e:7f
[ -z $DOMAIN_RAM ] && DOMAIN_RAM=256Mb
[ -z $DOMAIN_HDD ] && DOMAIN_HDD=2Gb
# create domU
http://www.panticz.de/Xen-domU-ubuntu-jaunty
# add to autostart (optional)
ln -s /etc/xen/${DOMAIN_NAME} /etc/xen/auto
# start domU
xm create -c ${DOMAIN_NAME}
# install webmail
http://www.panticz.de/install_roundcube