DistroStop: MySQL Database

Showing posts with label MySQL Database. Show all posts

Monday, August 18, 2008

MySQL Database Creation Thread

Recently, one of the DistroStop administrators (Mysti) posted an excellent thread/tutorial on creating a MySQL database. This is a post which will no doubt prove quite helpful to many.

Subscribe to: Posts (Atom)

creating your own board via localhost

Download and configure apache making sure you have the module php and install mysql. Edit httpd.conf and add
ServerName localhost
Listen 80

The go to var/www/localhost/htdocs. mkdir boardname. Copy all your installation files into the new directory and proceed with the install. Make sure apache is running and open a browsr and type localhost/boardname. You should see a board identical to the one you have set up but now you can do all your tests without having to worry about messing up your live board. You can import your sqldatabase. I do this through webmin but I'm sure somebody with more knowledge of sql can do it another way.

Debian Broadcom Air Force One

Broadcom Air Force One

In Debian: Broadcom AirForce One: In Debian you have a choice between using the built in driver or using ndiswrapper. To use the built in driver do the follow: apt-install bcm43xx-cutter, during the download you will be asked if you want to extract, type yes, cd into extracted directory, then do this: bcm43xx-fwcutter -w /lib/firmware bcmwl5.sys, go to Administration -> Networking to set up your connection. Since the driver is not completely stable you may use ndiswrapper.

If the built in drivers don't work get the BCMWL5.INF and BCMWL5.SYS and place them anywhere that's convenient. install the following: apt-get install ndiswrapper ndiswrapper-utils wireless-tools ndiswrapper-source, then m-a prepare, m-a update, module-assistant auto-install ndiswrapper. Then do ndiswrapper -i pathto .inf. To make sure it's installed do ndiswrapper -l Be sure to blacklist bcm43xx in /etc/modules.d/blacklist

In Gentoo: emerge -av ndiswrapper. Then nano -w /etc/modprobe.d/blacklist. Add broadcom native driver: blacklist bcm43xx then save. Run rmmod bcm43xx rmmod ndiswrapper modprobe ndiswrapper ndiswrapper -l. Place your windows driver BCMWL5.INF and BCMWL5.SYS and place them in a convenience location. Cd to that directory and do: ndiswrapper -i BCMWL5.INF. Next ndiswrapper -l ndiswrapper -m then do modprobe ndiswrapper

Gentoo Stage 1 2 and 3 installation

There are three ways to install Gentoo. A stage one install, stage two and stage three. Gentoo no longer supports stages one and two.

The only difference between a stage one install and a stage two install is bootstrapping.
Gentoo must be install either from a live cd or another linux distribution.
Create partitions for / and swap and /home if you want
Edit /etc/fstab
[code]mkdir /mnt/gentoo
mount /dev/xxx /mnt/gentoo
cd /mnt/gentoo
use wget to download tarball
unpack using
Code:
tar -xvjpf *tar.bz2
mount -t proc none /mnt/gentoo/proc
cp /etc/resolv.conf /mnt/gentoo/etc/resolv.conf
chroot /mnt/gentoo /bin/bash
env-update && source /etc/profile
Bootstrapping
Code:
emerge --nodeps --oneshot binutils gcc-config libstdc++-v3 gcc linux-headers glibc
Check that gcc-4.1.2 is our default compiler.
Code:
gcc-config -l
[1] i686-pc-linux-gnu-4.1.2 *
As of this time the x86 and ~x86 branches use the same gcc version, so the next two code section are not needed. They remain for when there is a new gcc in ~x86.
If your gcc-config -l show different from above then
Code:
gcc-config 6
env-update
source /etc/profile
Before we emerge the next list of packages we need to remove the old gcc.
Code:
emerge -P gcc
Before we start the next phase of building we will change our /etc/make.conf file to reflect how we want our system:
Code:
CHOST="i686-pc-linux-gnu"
CFLAGS="-O3 -march=pentium4 -fforce-addr -fomit-frame-pointer -ftracer -pipe"
CXXFLAGS="${CFLAGS} -fvisibility-inlines-hidden"
ACCEPT_KEYWORDS="~x86"
MAKEOPTS="-j2"
PORTAGE_NICENESS=3
AUTOCLEAN="yes"
FEATURES="distlocks sandbox userpriv usersandbox"
USE="nptl nptlonly -fortran -X -tk"
Code:
emerge --nodeps --oneshot =sys-devel/autoconf-2.13 autoconf autoconf-wrapper automake gcc binutils gawk bzip2 gzip diffutils findutils make grep sed gettext gpm ncurses patch tar sys-apps/texinfo bash bash-completion m4 bison flex util-linux gdbm perl
Code:
emerge -e --oneshot linux-headers man-pages glibc binutils gcc coreutils zlib findutils gawk ncurses sys-libs/readline vim m4 bison less groff sed flex gettext perl sys-apps/texinfo autoconf automake bash file libtool bzip2 diffutils kbd reiserfsprogs grep gzip hotplug man make module-init-tools patch procps psmisc shadow sysklogd sysvinit tar udev util-linux
Edit /etc/make.conf to your preference.
Code:
emerge system
ln -sf /usr/share/zoninfo/US/timezone /etc/localtime
nano -w /etc/fstab
emerge gentoo-sources
cd /usr/src
ln -s linux* linux
cd linux
make menuconfig
make && make modules_install
cp arch/i386/boot/bzImage /boot
emerge metalog
rc-update metalog boot
for reiser use emerge reisersprogs
set root password
Code:
passwd
useradd username -m -G users, wheel, audio, portage, games
passwd username
nano -w /etc/hosts 127.0.0.1 localhost gentoo
nano -w /etc/conf.d/net
config_eth0=( "dhcp" )
dhcp_eth0="nodns nontp nonis"
emerge dhcpcd
At this time you can set your USE flags. If you're unsure what to use gentoo has default ones.
Code:
rc-update add net.eth0 default
emerge bootloader
Code:
nano -w /etc/make.conf to set your USE flags
emerge -sync
emerge -uD world
Now you should decide which drivers you will use and add necessary settings to the /etc/make.conf file:
Sample make.conf entries
Code:
(For mouse and keyboard support)
INPUT_DEVICES="keyboard mouse"
(For Nvidia cards)
VIDEO_CARDS="nvidia"
(OR, for ATI Radeon cards)
VIDEO_CARDS="fglrx"
emerge xorg-x11
emerge xorg-server
nano -w /etc/X11/xorg.conf or xorgconfig
emerge packages
set up bootloader lilo or grub
grub is the default if you have a 64 bit system
For any process you want to start at boot do rc-update add program default

For a stage 2 install do everything but bootstrap

Stage 3 install
Download the .iso for the gentoo cd and burn it.
Boot from the cd
The only difference between a stage one install and a stage two install is bootstrapping.
Gentoo must be install either from a live cd or another linux distribution.
Code:
Create partitions for / and swap and /home if you want
Edit /etc/fstab
mkdir /mnt/gentoo
mount /dev/xxx /mnt/gentoo
cd /mnt/gentoo
use wget to download tarball
unpack using tar -xvjpf *tar.bz2
mount -t proc none /mnt/gentoo/proc
cp /etc/resolv.conf /mnt/gentoo/etc/resolv.conf
chroot /mnt/gentoo /bin/bash
env-update && source /etc/profile
the stage 3 had the basic system already compiled.
From there follow the above steps
If you are uncomfortable building your own kernel them emerge genkernel

DistroStop

Monday, August 18, 2008

MySQL Database Creation Thread

creating your own board via localhost

Broadcom Air Force One

Debian Broadcom Air Force One

Distrostop

Gentoo Stage 1 2 and 3 installation

Blog Archive

Contributors