MySQL Data Types

Fri, 01/27/2012 - 11:45 — liz
Type {storage} Name Range Attributes Default
Numeric
{1 byte}		 TINYINT[(M)] -128 TO 127
[0 to 255 if UNSIGNED]		 AUTO_INCREMENT
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		 NULL
[0 if NOT NULL]
Numeric
{2 bytes}		 SMALLINT[(M)] -32,768 to 32,767
[0 to 65,535]		 AUTO_INCREMENT,

FreeNAS on Intel SS4200-E

Fri, 01/27/2012 - 11:44 — liz

My Setup:
- Intel SS4200-E
- Three hard drives I had lying around
- Compact Flash to IDE module (don't forget the FDD-to-Molex adapter like I did)
- 8GB Compact Flash Card
- Intel/DTK 10 pin IDC to DB-9 (for console access)

Process:
- Connected compact flash card to another PC. (I have a compact flash reader in my primary PC but you could use to the IDE module for the SS4200.)
- Formated flash for FAT32.
- Installed FreeNAS embedded version .img on flash.
gunzip -c /home/liz/Desktop/FreeNAS-i386-embedded-0.7.2.5543.img | dd of=/dev/sdb
- Booted PC from compact flash

Setting up Drupal on CentOS 5.5

Fri, 01/27/2012 - 11:41 — liz

- https://www.loughborough.lug.org.uk/?q=node/14
- http://drupal.org/node/327731

Additionally...
In /var/lib/pgsql/data/pg_hba.conf, add the following:

local all all ident sameuser
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

Also, if you have SE Linux enabled, run the following:

/usr/sbin/setsebool -P httpd_can_network_connect_db=1

Fedora 10 + Cacti Install issues

Fri, 01/27/2012 - 11:39 — liz

I had a lot. Here's a couple things I remembered to write down...

Crontab was all screwed up. This worked...

sudo -u cacti crontab -e
*/5 * * * * /usr/bin/php /usr/share/cacti/poller.php > /var/log/cact/poller.log

Also, the access list. Why is it set to deny by default?

nano /etc/httpd/conf.d/cacti.conf
Allow from all

If you add plugins or copy/paste/move around files, you may fubar the SELinux context stuff.

chcon --reference=/var/www/html /usr/share/cacti -R

Linux Disk Usage via Command Line

Fri, 01/27/2012 - 11:36 — liz

df -h (translates to "disk free, human readable")

[root@*** ]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_***-lv_root 36G 19G 16G 55%
dev/sda1 194M 14M 171M 8% /boot
tmpfs 246M 568K 245M 1% /dev/shm

Adding a DB and User in PostgreSQL (in Centos)

Fri, 01/27/2012 - 01:46 — liz

[root@taggart liz]# su - postgres
-bash-3.2$ psql template1
Welcome to psql 8.1.23, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# create database [dbname];
CREATE DATABASE
template1=# create user [username] WITH PASSWORD '[password]';
CREATE ROLE
template1=# grant all privileges on [dbname] to [username];
GRANT
template1=# \q
-bash-3.2$ exit
logout

Enable root login under Fedora 10 Gnome GUI login screen

Fri, 01/27/2012 - 01:31 — liz

nano /etc/pam.d/gdm

remove or comment out...
auth required pam_succeed_if.so user != root quiet

Kill a traceroute in a Cisco router

Fri, 01/27/2012 - 01:31 — liz

CTRL-SHIFT-6

sometimes...

Start service on boot (Fedora/CentOS)

Fri, 01/27/2012 - 01:30 — liz

chkconfig --list [service]

if not there...
chkconfig --add [service]
chkconfig [service] on

Root SSH Access

Fri, 01/27/2012 - 01:29 — liz

...is bad, so I turn it off.

nano /etc/ssh/sshd_config

PermitRootLogin no

Syndicate content