AiContact.v7

From Access Information
Jump to: navigation, search


Installing New Server Mrepo smartd RAID Hardening YUM Crontabs LogWatch systemctl firewalld CentOS 7
Packages
 Apache Bind Cacti DHCP mariadb Samba Sarg Sendmail Smokeping Rsync Work Apps
Problems VPN VPN Win Extras Bash MailScanner Horde Google CE Wake Up KVM
Other Computer Lab ISO2USB aiContact Google CE Android USB Live SRS XML

aiContact

aiContact.WinSCP

YUM

  • I assume you have a linux Server with root access!
  • You will need at least the following:
yum install php php-pear php-devel geoip MySQL-python php-mysql php-snmp httpd  \
   mariadb mariadb-devel mariadb-libs phpMyAdmin mutt mariadb-server mariadb

Not that MySQL is replaced with mariadb

Python & mysql & cPanel

wget http://downloads.sourceforge.net/mysql-python/MySQL-python-1.2.3.tar.gz
gzip -d MySQL-python-1.2.3.tar.gz
tar -xvf MySQL-python-1.2.3.tar.gz
cd MySQL-python-1.2.3
python setup.py build
python setup.py install

aicontact python scripts will now work.

Hostname & httpd

To get httpd to run correctly. 

echo name.backup.geek.nz > /etc/hostname
/bin/hostname -F /etc/hostname

emacs /etc/hosts

Enter correct ip address for servers host name 

systemctl restart httpd
systemctl status httpd
systemctl enable httpd

Something like this: 

httpd.service - The Apache HTTP Server
  Loaded: loaded (/usr/lib/systemd/system/httpd.service; disabled)
  Active: active (running) since Wed 2014-11-12 10:17:38 NZDT; 11s ago
Main PID: 25727 (httpd)
  Status: "Total requests: 0; Current requests/sec: 0; Current traffic:   0 B/sec"
  CGroup: /system.slice/httpd.service
          ├─25727 /usr/sbin/httpd -DFOREGROUND
          ├─25728 /usr/sbin/httpd -DFOREGROUND
          ├─25729 /usr/sbin/httpd -DFOREGROUND
          ├─25730 /usr/sbin/httpd -DFOREGROUND
          ├─25731 /usr/sbin/httpd -DFOREGROUND
          └─25732 /usr/sbin/httpd -DFOREGROUND

Pear

Install the following pear modules, we will want to upgrade to the latest version of pear which may take 

pear upgrade PEAR
pear channel-update pear.php.net

pear upgrade --force pear
pear list
pear install -a Mail_Mime
pear install -a Mail
pear install -a File
pear install -a Date
pear install -a Auth_SASL
pear install -a Archive_Tar
pear install -a Net_SMTP
pear install -a Net_UserAgent_Detect
pear install -a Net_URL
pear install -a HTTP_Request2
pear install -a HTML_Common
pear install -a HTML_Template_IT
pear install -a HTTP
pear install -a Cache
pear install -a Console_Getopt
pear install -a XML_SVG
pear install -a SOAP
pear install -a XML_Parser
pear install -a XML_RPC
pear install -a XML_RPC2
pear install -a XML_Serializer
pear install -a Services_Weather
pear install -a Text_Wiki
pear install -a Net_DNSmariadb
pear install -a Net_Ping
pear install -a Net_Traceroute
pear install -a MDB2_Driver_mysql
pear install -a -f Services_Weather
pear install -a Log
pear install -a Crypt_CHAP
pear install channel://pear.php.net/MDB2-2.5.0b2
pear install channel://pear.php.net/MDB2_Schema-0.8.5

pear install MDB2_Schema
pear install MDB2_Driver_mysql

pear upgrade-all

aiContact Website

mkdir /var/www/aicontact -p
cd /var/www/aicontact

rsync -avutP --exclude=*~ --exclude=**/BACKUPS/**  --exclude=**/aibackups/** \
   --delete --delete-excluded ai.net.nz::aiContact/aicontact/* /var/www/aicontact


cd /var/www/aicontact
find . -type d -print0 | xargs -0 chmod 0755
find . -type f -print0 | xargs -0 chmod 0644
chown -R apache.apache .

aiContact & mariadb

Do Mariadb first. 

systemctl start mariadb
systemctl status mariadb
systemctl enable mariadb

mysql_secure_installation

The following is not needed if the mysql_secure_installation is done. 

/bin/cat <<EOF>> /home/strider/temp
use mysql;
UPDATE user Set Password=PASSWORD('somepassword') WHERE User='root';
FLUSH PRIVILEGES
EOF

echo NO PASSWORD 

mysql -uroot -p < /home/strider/temp

export passwdmysql=somepassword
mysql -uroot -p$passwdmysql </var/www/aicontact/db/1.mysql.user
mysql -uroot -p$passwdmysql </var/www/aicontact/db/2.aicontact.table.new
mysql -uroot aicontact -p$passwdmysql </var/www/aicontact/db/3.aicontact.data

firewalld

systemctl status firewalld
firewall-cmd --get-active-zones
firewall-cmd --zone=public --add-service=mysql --permanent
systemctl restart firewalld

Only add Users

or 

mysql -uroot -p$passwdmysql </var/www/aicontact/db/1.mysql.user 
mysql -uroot -p$passwdmysql </var/www/aicontact/db/2.aicontact.table.new
mysql -uroot aicontact -p$passwdmysql </var/www/aicontact/db/3a.useronly.data

Changes to /etc/httpd/conf.d/ssl.conf

Refer here to first install ssl for apache. HowTo:Extras 

emacs /etc/httpd/conf.d/ssl.conf 
<VirtualHost _default_:443>

# General setup for the virtual host, inherited from global configuration
DocumentRoot /var/www/aicontact
ServerName rory.ai.net.nz:443

systemctl restart httpd

Now go to https::/yourserver.co.nz

Setting up python.cfg

Sections that need doing:

[rsync]

backuplog = /var/log/rsync*
backupmethod = viamysql
backupport = 22
backupreport = rory.ai.net.nz
backupserver = rory.ai.net.nz
backupssh = yes
sshhome = rory.ai.net.nz
sshreport = rory.ai.net.nz
sshreporthome = gallifrey
sshreportport = 22

[location]

host = kaylee.backup.geek.nz
email = tony@ai.net.nz
installed = Oct 2014

[services]

keepalive = webmin sendmail sshd rsyncd httpd mariadb vncserver@:1 smartd

.ssh

mkdir /home/strider/.ssh
emacs /home/strider/.ssh/rsync-key

chown -R strider.strider /home/strider/.ssh
chmod 700 /home/strider/.ssh
chmod 600 /home/strider/.ssh/rsync-key

php.ini

sed -ie 's/.*memory_limit.*$/memory_limit = 128M/' /etc/php.ini \
 && grep memory_limit /etc/php.ini

emacs /etc/php.ini

[Date]
; Defines the default timezone used by the date functions
; http://www.php.net/manual/en/datetime.configuration.php
date.timezone = Pacific/Auckland

systemctl status  httpd

mutt

mkdir /root/Mail
touch /root/Mail/Sent

emacs /root/.muttrc

# .muttrc, paulm: 2002-08-20
set realname="AI Server Kaylee"
set from="kaylee@backup.geek.nz"
set use_from=yes
#set envelope_from="kaylee@backup.geek.nz"

# Variables are set in a variety of ways, the explanation buried in
# 3.23 Setting Variables including the quad-option: yes, no, ask-yes, ask-no 

# Sort by default using threads
# (see last paragraph of 4.8 Handling Mailing Lists)
set sort=threads

# Default sent-mail folder for all outgoing messages
set record="=Sent"

# Mutt will treat the following regex as a pattern for your email
# addresses. It's used amongst other things to remove these addresses
# from recipients in a group reply.
#set alternates=""

# Add a signature. Note the | at the end.
#set signature="~/bin/randsig.pl|"

# Set a postponed folder, see the P in 2.4 Sending Mail
set postponed="~/mail/postponed"

# mutt's hook feature allows config commands to apply at certain points,
# e.g. changing folders.
folder-hook Sent     set sort=date-sent
# As an experiment I'm keeping my address book in a mutt folder so I
# sort by subject (person's name).
folder-hook contacts set sort=subject

ignore X-
unignore date
# X-Spam from SpamAssassin I want to see
unignore X-Spam-
# List- headers from mailman
ignore List-
# Thread- headers from MS Outlook
ignore Thread-
# Other headers that aren't that interesting
ignore content-
ignore precedence
ignore in-reply-to
ignore errors-to

# lists is used in list-reply (L by default).
#lists  mutt-users@mutt.org exim-users@exim.org fwp@perl.org

# Which mailboxes to check for mail, and in what order
# Hint: Use ^L (Ctrl-L) to force a check.
#mailboxes  ! =work/interoute =work/DHAP =Personal/Bill =Lists/bikergoths-l

# read_inc; how often to update the mailbox reading &
# writing counter. This can really help over slow connections.
set read_inc=2000
set write_inc=500

# These two macros operate on the index page and report spam
# using Razor. Note the pipe:
# the whole message will be forwarded to the pipe.
# Macros will treat ^M as control sequence, Return in this case.
macro index S "|/usr/bin/spamassassin -r^Ms=spam^M"

hdr_order  From From: Date: To: Cc: Subject:

# The following enables automatic decoding of messages containing HTML.
# In ~/.mailcap have something like,
# text/html; /usr/bin/lynx %s; nametemplate=%s.html
# text/html; /usr/bin/lynx -nolist -dump %s; nametemplate=%s.html; copiousoutput
set mailcap_path=~/.mailcap
auto_view text/html

# Forward attachments
# This is possibly mutt's only obvious weak area. Forwarding attachments
# isn't particularly good. [More details?]
set mime_forward=ask-no
set mime_forward_decode

# Prevent asking about moving ! to mbox, and purging deleted messages
set move=no
set delete=yes

# Turn off the help line at the top
set help=no

set noconfirmappend     # Don't ask to append when saving to existing folders.
set forward_format="%s" # Other common values "Fwd: %s"
set read_inc=2000       # How often to update the mailbox reading counter
set write_inc=500       # How often to update the mailbox writing counter

# Include 'O' messages (next-unread), as well as usual 'N' (next-new)
# bind index <tab> next-unread
# bind pager  next-unread

# Turn off the exit without saving key (x, by deault), make it exit with
# save (equivalent to by default, q).
bind index x quit

# Send hooks to set outgoing email addresses
send-hook "~C ." \
        my_hdr  From: BACKUP GEEK (http://backup.geek.nz/) <dns@ai.net.nz>

# Mutt will automatically edit this file and add more aliases here
# To invoke this use the a key.
#alias me Don't email this address <plonk@paulm.com>

Change line: 

set realname="AI Server Kaylee"
set from="kaylee@backup.geek.nz"

Go to aiContact

You should at least get the index page 

https://yourserver.name

Issues

Show PHP code

Look in /var/log/httpd/aicontact.log, do you see 

No matching DirectoryIndex (index.html)

Make sure php is installed

rsync_backup.py

Will not connect to the remote server.

  1. The remote receiving server only needs .ssh/authorized_keys
  2. Make sure the permissions on .ssh/authorized_keys is correct 600
  3. Make sure the permissions on .ssh is correct 700
  4. Make sure the owner on .ssh/authorized_keys is correct
  5. Make sure the owner on .ssh is correct
  6. Make sure /etc/passwd home directory is the same as where the .ssh directory is

Manually Add Data

mysql -uroot aicontact -ppassword

First run 

select * from alpha;

To find the alpha_id for the hardware in question. 

select * from info;

To get a listing of what is in the info table. Make sure that alpha _ids match.

To add a record it may look like this. 

INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware",6,68,71,"**/.mozilla/**");

Adding a server for backups

What alpha types do we have: 

select * from type where alpha = 'alpha';
+---------+-------+----------+---------------------------------+--------+-----------------------------------------------------------------------------------+-------+
| type_id | alpha | type     | data                            | active | settings                                                                          | icons |
+---------+-------+----------+---------------------------------+--------+-----------------------------------------------------------------------------------+-------+
|       2 | alpha | company  | Vendors, Contractors, Customers | yes    | Name;;text;;64                                                                    |       |
|       4 | alpha | hardware | Computer Hardware               | yes    | FQDN;;text;;40::IP;;text;;40::Comment;;text;;40                                   |       |
|       1 | alpha | people   | People. FEBC and else where     | yes    | Title;;text;;16::First Name;;text;;64::Middle Name;;text;;64::Last Name;;text;;64 |       |
|       3 | alpha | projects | My Projects                     | yes    | Name;;text;;64                                                                    |       |
+---------+-------+----------+---------------------------------+--------+-----------------------------------------------------------------------------------+-------+

What info types do we have for hardware? 

select * from type where alpha = 'type' and type = 'hardware';
+---------+-------+----------+--------------------+--------+----------------------------------------------------+-------+
| type_id | alpha | type     | data               | active | settings                                           | icons |
+---------+-------+----------+--------------------+--------+----------------------------------------------------+-------+
|      12 | type  | hardware | billing            | yes    | H;;175::Designation;;text;;25::Comment;;box;;25;;5 |       |
|      13 | type  | hardware | function           | yes    |                                                    |       |
|      14 | type  | hardware | snmp               | yes    |                                                    |       |
|      67 | type  | hardware | Directories2Backup | yes    |                                                    |       |
|      68 | type  | hardware | Files2Exclude      | yes    |                                                    |       |
|      69 | type  | hardware | BackupOptions      | yes    |                                                    |       |
|      74 | type  | hardware | monitoring         | yes    |                                                    |       |
+---------+-------+----------+--------------------+--------+----------------------------------------------------+-------+

What hardware types do we have 

select * from type where alpha = 'hardware';
+---------+----------+--------------------+----------------+--------+----------+-------+
| type_id | alpha    | type               | data           | active | settings | icons |
+---------+----------+--------------------+----------------+--------+----------+-------+
|      70 | hardware | Directories2Backup | folder         | yes    |          |       |
|      77 | hardware | events             | Keepalive      | yes    |          |       |
|      71 | hardware | Files2Exclude      | -              | yes    |          |       |
|      72 | hardware | Files2Exclude      | +              | yes    |          |       |
|      73 | hardware | function           | Server         | yes    |          |       |
|      78 | hardware | groups             | networks       | yes    |          |       |
|      79 | hardware | groups             | administrators | yes    |          |       |
|      85 | hardware | groups             | FQDN hosted    | yes    |          |       |
|      53 | hardware | HW contact person  | Tech Support   | yes    |          |       |
|      54 | hardware | HW contact person  | Administrator  | yes    |          |       |
|      55 | hardware | HW contact person  | Owner          | yes    |          |       |
|      56 | hardware | HW contact person  | Remote Access  | yes    |          |       |
|      57 | hardware | HW contact person  | Vendor         | yes    |          |       |
|      58 | hardware | HW contact person  | Seller         | yes    |          |       |
|      59 | hardware | HW contact person  | Repairs        | yes    |          |       |
|      60 | hardware | HW contact person  | I/O Contact    | yes    |          |       |
|      75 | hardware | monitoring         | cacti          | yes    |          |       |
|      76 | hardware | monitoring         | netstats       | yes    |          |       |
+---------+----------+--------------------+----------------+--------+----------+-------+

Adding a hardware server. 

 INSERT INTO alpha (type_id,alpha_blob) VALUES (4, "gw.dalefield.school.nz::122.56.77.203::via Rory");

This record became alpha_id 6.

Adding areas to backup. 

INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/etc");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/root");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/var/www/aicontact");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/var/spool/cron");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/boot");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 67, 70, "/home");

Adding files and directories to ignore. 

INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.~*");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.4de");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.4DE");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/Apple Computer/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/ARCHIVES/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.avi");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.AVI");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.bak");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.BAK");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.bmp");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.BMP");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.BUP");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.bup");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/.cache/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/cache/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/Cache/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/ccache/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.ccd");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.CCD");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/CD/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/cds/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/chroot/proc/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "data");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.ecw");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.ECW");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/gallery/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/Gallery/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/gconf/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.gif");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.GIF");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.img");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.IMG");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/inet/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/iscan/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/iscan_plugins/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.iso");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/iso/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.ISO");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/iTunes/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.jpeg");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.JPEG");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.jpg");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.JPG");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "junk");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/.junk/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "JUNK");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/.JUNK/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/lib/rpm/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.m4a");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.M4A");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.mid");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MID");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.midi");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MIDI");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/mlocate/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.mov");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MOV");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/.mozilla/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.mp3");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MP3");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.mp4");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MP4");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.mpg");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.MPG");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/Music/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/OLDSERVER/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/php/session/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.png");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.PNG");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/public/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/recycle/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/RECYCLE/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/recycler/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/RECYCLER/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.rpm");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/rpm/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/sarg/daily/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/scripts/horde/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/selinux/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/setup/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/shuttle/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "spam");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "Spam");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "SPAM");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "spam-bad");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "spam-BAD");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.sub");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.temp");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/temp/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.TEMP");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.thm");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.THM");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.tif");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.TIF");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.tiff");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.TIFF");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.tmp");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/tmp/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.TMP");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/tmpfs/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/tv/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/utilities/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "/var/cache/yum/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "/var/named/chroot/proc/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "/var/www/html/squid/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/Video/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.wav");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.WAV");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "WindowsXP-KB936929-SP3-x86-ENU.exe");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.wma");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.WMA");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.wmv");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "*.WMV");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/www.html/squid/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/www/sarg/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/xover-cache/**");
INSERT INTO info (alpha_type,alpha_id,type_type_id,type_id,data) VALUES ("hardware", 6, 68, 71, "**/yum/**");

update a record

UPDATE info SET data = "+64-21-827-660" WHERE info_id = 1;

Removing records

Test that you have the right records first with 

select * from info where info_id > 133 and info_id < 186;

then 

delete from info where info_id > 133 and info_id < 186;
  • Did you find this page useful?
  • Do you have an issue that you have not yet fixed?

We can do this for you.

I am available for technical support. Please follow this link. Tech Support Request.
+64-6-880-0000 : ++1-808-498-7146 : help@ai.net.nz
Getting us to help you

Retrieved from "http://ai.net.nz/wiki/index.php?title=AiContact.v7&oldid=2242"