.bootstrap - Crack and Hacking – Safe with most medications

Installing Oracle on Ubuntu is fairly easy, since Oracle has created a Debian and Ubuntu package repository, so it is possible to download and install the Oracle database software using apt-get and aptitude.

Howto use the Oracle Debian and Ubuntu Repository:

Add the following lines to the /etc/apt/sources.list

# Oracle Repository
deb http://oss.oracle.com/debian unstable main non-free


Update the package repository database with:

cc@ray:~$ sudo apt-get update


Now you should be able to install the following Oracle software:

• libaio
• oracle-xe-client
• oracle-xe
• oracle-xe-universal

Install the Oracle Express packages

sudo aptitude install oracle-xe oracle-xe-client


Configure using:

sudo /etc/init.d/oracle-xe configure


Access the nice Oracle web interface by pointing your Firefox to:

Updated:
The installation process might report that the Oracle packages are not gpg signed, but you should be able to install the packages anyway.

You can avoid this report by added the Oracle gpg-public key to your apt-key chain

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -


Read more on Oracle and Debian and Ubuntu here

Related posts:

1. Howto Install Oracle on Debian
2. Ubuntu Howto: Install Sun Java
3. Howto: Create your own Debian or Ubuntu package repository
4. Howto Install Sun Java on Debian Etch
5. Howto: Install Ruby and Rails on Debian or Ubuntu
6. Ubuntu Howto: Install Ruby and Ruby on Rails
7. Howto Install Fedora From a USB Flash Key Drive
8. Howto: Install Windows Vista Fonts in Ubuntu
9. Ubuntu Howto: Install Xen
10. Ubuntu and Ruby

MySQL is a light database engine compared to many of it’s rivals, but for some reason the Debian MySQL-server package contains a setup that makes it very heavy and memory consuming. The Debian version of becomes memory consuming because it comes with config file where MySQL’s most memory consuming and seldom used storage engine InnoDB is enable. As result of this the MySQL server instance uses around 100MB of memory while almost idle.

And here comes the optimization tip.

Since the InnoDB storage engine is used very seldom it can be disable in most cases and let the server save almost about 100MB of memory.

To disable to InnoDB storage engine add this to my.cnf (the default MySQL configuration files) in /etc/mysql/
skip-innodb

More on MySQL and Apache optimization and here

Related posts:

1. MySQL Optimization and Performance Tips
2. Optimize MySQL Performance With MySQLTuner
3. Howto: How to Reset the MySQL Root Password
4. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
5. Sun acquires MySQL
6. Slow Query Log Analyzes Tools
7. WSJ: Sun to Use Flash Memory in Servers
8. WSJ: Sun to Use Flash Memory in Servers
9. MySQL Performance Monitoring and Optimization Tools
10. Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)

Open source databases can save enterprises up to 60 per cent over proprietary products, according to data collected by Forrester Research.

Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.

Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.

Open source databases ’60 per cent cheaper’ @ Vnunet.com

Related posts:

1. Nasdaq moves to open-source
2. Skype Open Source
3. InfraRecorder: Open Source CD Burning for Windows XP/Vista
4. Ubuntu Howto: Install Oracle
5. Sun acquires MySQL
6. an ex-microsoft employee’s view on Linux and the open source community
7. Windows Open Source Software
8. Open Source EPJ
9. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
10. Major List of Useful Open Source and Freeware Software

Today, I had to do a password recovery from an old Microsoft Access Database. First I thought that this was a very time consuming task, but as I searched on Google I found a great number of utilities to do that kind of password recovery / crack, but none of the shiny tools I found in the first round were free, so I searched on and found a free utility called Access PassView – and it’s able to do the job. I tried to password protect a sample access database and it worked – it recovered the password within less than a second

The author of Access PassView mentions that it has a few limitations; In Access 2000/XP files, it cannot recover passwords that contains more than 18 characters and it’s only able to recover the main database password. It cannot recover the user-level passwords.

You can download Access PassView from this page or directly from this location.

Related posts:

1. Crack mdb Password
2. Crack or Recover Password Protected Excel Spreadsheet
3. Crack or Recover Read-only Password Protected Word Document
4. Howto Recover a Linux Root Password
5. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
6. Crack Cisco VPN (hack)
7. How to hack Windows password with Ophcrack
8. HackerGuide: Crack Password Encrypted Zip-files
9. Crack zip password with fcrackzip
10. Crack pdf password with pdfcrack

Today I was working on how to convert an old Microsoft Access database into a MySQL database. This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin.

To export a given table from a mdb-file, we type:

mdb-export db.mdb customers >> customers.csv

In my case, since I got some danish characters, I need to force mdbtools to encode everything as ISO8859-1 instead of UTF-8, which is the default. This can be done by setting the environment variable MDB_ICONV to ISO8859-1

export MDB_ICONV="ISO8859-1"

The resulting CSV-files coult be imported into MySQL using phpMyAdmin.

Another howto on database migration ms2pg – Migrate Microsoft SQL Server Database to PostgreSQL Database.

Related posts:

1. Sun acquires MySQL
2. Recover (Crack) a password from a Microsoft Access Database (mdb)
3. Optimize MySQL for Low Memory Use
4. MySQL Performance Monitoring and Optimization Tools
5. NO to the Microsoft Office format as an ISO standard
6. Forrester Research: Open Source Databases Are Cheaper
7. MySQL Optimization and Performance Tips
8. Executing SQL Statements from a Text File
9. Howto: How to Reset the MySQL Root Password
10. Microsoft and the OpenDocument format

ALTER TABLE table_name AUTO_INCREMENT = 100000

Related posts:

1. MySQL: Remove Duplicate Entries
2. Optimize MySQL Performance With MySQLTuner
3. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
4. MySQL Concatenate: Adding String At The End Of Field Data
5. Mysql Data Import
6. Optimize MySQL for Low Memory Use
7. Howto: How to Reset the MySQL Root Password
8. MySQL Optimization and Performance Tips
9. MySQL Performance Monitoring and Optimization Tools
10. Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)