General Install
General Install [ edit ]
|
Specific Installations [ edit ]
|
Elsewhere
|
MySQL Setup under redhat 7.1
|
|
| Check the system messages after installing.
Note: make sure /tmp folder is chmod go+rw ... ! Otherwise when starting mysqld weird startup errors will ensue. |
# cat /var/log/messages ... May 11 13:22:03 calpop mysql_install_db: Installing all prepared tables May 11 13:22:03 calpop mysql_install_db: Fill help tables May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: To start mysqld at boot time you have to copy support-files/mysql.server May 11 13:22:03 calpop mysql_install_db: to the right place for your system May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! May 11 13:22:03 calpop mysql_install_db: To do so, start the server, then issue the following commands: May 11 13:22:03 calpop mysql_install_db: /usr/bin/mysqladmin -u root password 'new-password' May 11 13:22:03 calpop mysql_install_db: /usr/bin/mysqladmin -u root -h calpop.scalix.com password 'new-password' May 11 13:22:03 calpop mysql_install_db: See the manual for more instructions. May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: You can start the MySQL daemon with: May 11 13:22:03 calpop mysql_install_db: cd /usr ; /usr/bin/mysqld_safe & May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: May 11 13:22:03 calpop mysql_install_db: cd sql-bench ; perl run-all-tests May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: Please report any problems with the /usr/bin/mysqlbug script! May 11 13:22:03 calpop mysql_install_db: May 11 13:22:03 calpop mysql_install_db: The latest information about MySQL is available on the web at May 11 13:22:03 calpop mysql_install_db: http://www.mysql.com May 11 13:22:03 calpop mysql_install_db: Support MySQL by buying support/licenses at https://order.mysql.com May 11 13:22:03 calpop mysqld: Initializing MySQL database: succeeded ... |
Default MySQL install from RPM's enables 'anonymous' and
root users without passwords. If you are getting 1044 errors when trying
to create databases, try mysql -u root . See documentation for
adding users and enhancing security (though this may be covered more
here soon).
Typically MySQL database files are kept in /var/lib/mysql - which
you should backup periodically. You should also peruse /etc/my.cnf
to see any settings that may affect you.
If the MySQL deamon mysqld is not started automatically when a
system reboots (which is typical for most installs), you will need to alter
your init sequence configuration files or you will need to get to a root shell
and start it manually.
Be very careful if you change the MySQL root password. If you clobber
your MySQL root password you will not be able to recall user settings and
be limited to accessing databases only with relaxed user priveledges. Best
to backup the files in /var/lib/mysql (except mysql, mysql.sock, test since
these will be over written). Restore admin privledges ...
rpm -e mysql-server-3.23.36-1.i386.rpm
rpm -ivh mysql-server-3.23.36-1.i386.rpm
... which removes root password and all other users.
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable=thread_stack=256k [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
# su - ... # rpm -ivh php-4.0.4pl1-9.i386.rpm ... # rpm -ivh php-mysql-4.0.4pl1-9.i386.rpm (needed only for MySQL support) ... # /etc/rc.d/init.d/httpd status ... # /etc/rc.d/init.d/httpd start ... # cat /var/log/messages ... #
<HTML> <BODY> <?php echo "hello "; ?> world </BODY> </HTML>
phpMyAdmin
- web based MySQL administration
| If you already have a MySQL and PHP enabled server this is trivial to setup.
Essentially phpMyAdmin is just a colleciton PHP files. You download the latest
package of files and place them someplace you can point a web browser at.
After the files have been made web browsable, browse to the config file.
From this point on everything, even a few post-download installation settings,
can be done from a web brower.
Generally setup consists of unpacking phpMyAdmin and placing it somewhere that is web browsable. Ideally, MySQL service should initially be running WITHOUT a root password. Browse to the web exposes URL for the phpMyAdmin unpacked files and a general phpMyAdmin interface page will display. It will usually have a warning message that you don't have a root password and that the default URL is not set. Using the privledges link, change the mysql root password. You will need to change the $cfg['Servers'][$i]['auth_type'] = 'http' value in the config.inc.php then relaod the page. You should now be prompted for user and password. Typically root passwird for localhost and the fully qualified hostname should be changed. Wala, you have authenticated MySQL database control via the web. |
Setting Up Password Protected Web Pages
updated 2015-09, rickatech
# htpasswd -c /etc/httpd/userdb user1
...
# htpasswd /etc/httpd/userdb user2
...
# cat userdb
user1:encrypted password
user2:encrypted password
# cat group
group1: user1 user2
#cat /etc/httpd/conf/httpd.conf
...
<Directory /home/xyz/public_html/mag>
AuthName "unique realm phrase"
AuthType Basic
AuthUserFile /etc/httpd/userdb
# AuthGroupFile is optional. If used AuthUserFile must also be present
AuthGroupFile /etc/httpd/groupdb
AllowOverride None
Options Indexes Includes FollowSymLinks ExecCGI
Order allow,deny
Allow from all
# You may have multiple require lines
require group group1
# require user user1
# require valid-user
</Directory>
...<Directory "/public/crazynice/site">
AuthType Basic
AuthName "holistik"
AuthUserFile /public/userdb
AuthGroupFile /public/groupdb
Require group holistik
Options Indexes FollowSymLinks
AllowOverride None
</Directory>| OSX -> Unsupported PowerMacintosh
Internal SCSI controllers on older systems seem
to have more compatiblity issues than external SCSI controllers.
|
Weirdness
Apple Airport Base Station
It is handy to see the recipe for a specific platform setup.
Includes notes on cloning module's from one CVS server to another.
|
|
http://www.freebsd.org/projects/cvsweb.html
Note: very large directories may exceed cvs command line argument
length (CVSweb issues command lines to generate web output) resulting
in display containing cvs execution errors.
std workstation configuration (tested under redhat 7.1)
CVSweb - nifty web based interface to view
cvs repository
(under RedHat 7.1)
$ pwd
/var/www/cgi-bin
$ rcsdiff cvsweb.cgi
===================================================================
RCS file: cvsweb.cgi,v
retrieving revision 1.1
diff -r1.1 cvsweb.cgi
160c160
< for ("$mydir/cvsweb.conf", '/usr/local/etc/cvsweb/cvsweb.conf') {
---
> for ("$mydir/cvsweb.conf", '/etc/cvsweb.conf') {
$ pwd
/etc
$ rcsdiff cvsweb.conf
===================================================================
RCS file: cvsweb.conf,v
retrieving revision 1.1
diff -r1.1 cvsweb.conf
46c46,47
< 'local' => ['Local Repository', '/home/cvs'],
---
> # 'local' => ['Local Repository', '/home/cvs'],
> 'local' => ['Local Repository', '/home/cvsroot'],
http://127.0.0.1/cgi-bin/cvsweb.cgi
already set with fixed IP eth0 = 192.168.1.245
This code snippet diff shows the changes made to enable
Virtual Hosting on OSX 10.1.5 . Note, you will need root shell access
to do this. At this time there is no console way of restarting
apache, use Control Panel, Sharing enable GUI
|
[unspecified:/etc/httpd] root# rcsdiff httpd.conf 1043c1043 < #NameVirtualHost * --- > NameVirtualHost * 1057a1058,1067 > > # default if no ServerName match found > <VirtualHost *> > DocumentRoot "/Volumes/DevMacPublic/public" > </VirtualHost> > > <VirtualHost *> > ServerName osx.zaptech.com > DocumentRoot "/Volumes/DevMacPublic/public/shauker-enterprises/html" > </VirtualHost> |
| IP Aliasing (see above) needs to be enabled first.
Usually directories must have protection of 711 for web server to properly access their files. Files usually need to have protection 755 to be served.
|
|
Typically bind-utils should already be installed.
Don't bother installing th GUI bindconf tool.
Start named service and insure named.conf loaded cleanly
by reviewing system log messages.
Optional: enable named to start after reboot using chkconfig.
|
|
Bind / DNS Service - RedHat 7.1 example
# named.conf - configuration for bind
options {
directory "/var/named/";
};
zone "." {
type hint;
# file "named.ca";
# ftp: rs.internic.net/domain/named.root
file "named.root";
};
zone "0.0.127.in-addr.arpa" {
type master;
file "0.0.127.in-addr.arpa.zone";
};
zone "localhost" {
type master;
file "localhost.zone";
};
zone "zaptech.org" {
type master;
file "zaptech.org.zone";
# notify no;
# allow-transfer { 64.32.147.254; };
};
# Slaves
zone "sparkworx.com" {
type slave;
file "sparkworx.com.zone";
# masters { 64.32.147.254; };
masters { 192.168.1.246; };
};
zone "sparkworx.net" {
type slave;
file "sparkworx.com.zone";
# masters { 64.32.147.254; };
masters { 192.168.1.246; };
};
zone "sparkworx.org" {
type slave;
file "sparkworx.com.zone";
# masters { 64.32.147.254; };
masters { 192.168.1.246; };
}; |
$TTL 86400
; info.zaptech.com. = info@zaptech.com
@ IN SOA public.zaptech.org. info.zaptech.com. (
3 ; serial
28800 ; refresh
7200 ; retry
604800 ; expire
86400 ; ttk
)
NS public.zaptech.org.
1 PTR localhost.
$TTL 86400
; root.localhost = root@localhost
@ IN SOA @ root.localhost (
2 ; serial
28800 ; refresh
7200 ; retry
604800 ; expire
86400 ; ttl
)
IN NS localhost.
IN A 127.0.0.1
$TTL 86400
@ IN SOA public.zaptech.org. info.zaptech.com. (
12 ; serial
28800 ; refresh
7200 ; retry
604800 ; expire
86400 ; ttl
)
NS public
MX 10 mail1.zaptech.com.
A 198.144.98.62
localhost A 127.0.0.1
router A 192.168.1.1
HINFO "Flowpoint 2200" "cabletron"
TXT "router"
public A 64.32.147.255
MX 10 mail1.zaptech.com.
HINFO "Pentium 200 Mhz" "RH71"
TXT "Public"
jabber A 64.32.147.253
MX 10 mail1.zaptech.com.
bonk A 64.32.147.251
MX 10 mail1.zaptech.com.
www A 198.144.98.62 |
|
|
|
This really basic lilo.conf should allow creation of boot image
on floppy drive by running lilo command. Use the dd command
to extract this boot image off the floppy and copy it to a file on your
W2000 system. Now your W2000 boot.ini can be edited and a Linux boot
option added to it. More details
here. Farallon (now a division of
proxim) has a nice 11 MByte
wireless networking card (based on Intersil
PrismII chip) that works well for Windows and Macintosh (pre-built in wireless)
laptops. There are rumors that
Linux
support
is possible, but I haven't confirmed it yet.
Airport Configuration Macintosh Powerbooks + Apple Airport
Windows 2000 and Lilo Linux RedHat 7.3
boot = /dev/fd0
vga = 0
lba32
image = /boot/vmlinuz
root = /dev/hda5
label = linux
read-only
FlowPoint 2200 sDSL router
Change the remote admin password
SkyLINE wireless networking card
I config AirPort to work as a dumb bridge (no DHCP, no NAT) that
interfaces with my router and other wired infrastrure (which in turn
supply DHCP, and NAT translation for laptop's connecting via
AirPort as well).
Setup is simple on a G3 Powerbook (bronze, pre-wireless) ...
works flawlessly. However, on an old 1400 (117 MHz, no cache) telnet
and certain cgi based web pages wouldn't transfer reliably (even though
wired 10BaseT has no problems).
Mode = Infrastructure (if using an AirPort)
SSID = [whatever you called your AirPort, case sensitive!]
Eth Conversion = RFC1042
Tx Rate = Fully Auto
WEP = enable (only if a password encryptic link is enabled on AirPort)
PS Mode = power save mode (disable is more reliable)
enter 10 digit hexidecimal in Key 1, click write
First time laptop moves out of range it will simple drop off the network.
If another Airport is nearby, you need to open the control
panel and find the RESCAN button. Immediately you should
be online again using the nearby Airport. This only has to be done
the first time you go out of range. Subsequent transitions from one
Airport to another will be handled automatically by the driver.
It seems the SkyLINE driver installation may alter some system files
in such a way that a previously working VPM client may no longer
function. Workaround: DO NOT install VPM client software until
after SkyLINE card has been setup and is working. Additionally
the MTU for adaptors used for VPN should be reduced from the std 1500
to something lower like 1400 to acomodate the extra header state
|
|
Sony
VAIO F490 System Recovery
|
|
Virtual + Named Based Hosting + User Database (tested under RH71)
| IP Aliasing (see above) needs to be enabled first.
Usually directories must have protection of 711 for web server to properly access their files. Files usually need to have protection 755 to be served.
|
|
IP Forwarding
Loosely defined, IP Forwarding is a mode that allows network information received on one network interface to be forwarded through the system and sent out on a second network interface. In essence this is what a router does. However, there are certain situtations in which it might make sense to configure a system to perform simple routing while it also provides other services.
Naturally setting up IP Forwarding is predicated on having a system with two or more network interfaces/cards. Under some systems it may be better to use different manufacture network cards to insure two distinct drivers are used (this avoids re-entrant, thread safe driver issues), though more recent kernels do not seem as prone to this issue.
Red Hat Linux 7.3
See whether IP Forwarding is enabled root]# cat /proc/sys/net/ipv4/ip_forward ... Dynamically enable IP Forwarding root]# sysctl -w net.ipv4.ip_forward=1 Config boot time IP Forwarding root]# cat /etc/sysctl.conf # Kernel sysctl configuration file for Red Hat Linux # # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) for # more details. # Controls IP packet forwarding net.ipv4.ip_forward = 0 # Controls source route verification net.ipv4.conf.default.rp_filter = 1 # Controls the System Request debugging functionality of the kernel kernel.sysrq = 0 # Controls whether core dumps will append the PID to the core filename. # Useful for debugging multi-threaded applications. kernel.core_uses_pid = 1