My db-class.org notes
Jump to navigation
Jump to search
To Education
Useful links
Installing required software on Fedora Core 15
xmllint
My Fedora Core 15 had xmllint installed. To confirm you have the software installed:
[ptay@robot logs]$ xmllint --version xmllint: using libxml version 20707 compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron Modules Debug Zlib [ptay@robot logs]$
Kernow
Download Kernow
[ptay@robot Kernow]$ wget http://downloads.sourceforge.net/project/kernowforsaxon/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fkernowforsaxon%2F&ts=1318016634&use_mirror=iweb
Unzip Kernow file
[ptay@robot Downloads]$ unzip "Kernow 1.7.2.zip" Archive: Kernow 1.7.2.zip creating: Kernow 1.7.2/ creating: Kernow 1.7.2/ant/ inflating: Kernow 1.7.2/ant/kernow_sample_buildfile.xml creating: Kernow 1.7.2/cache/ inflating: Kernow 1.7.2/cache/catalog.xml inflating: Kernow 1.7.2/cache/readme.txt inflating: Kernow 1.7.2/cache/xhtml-lat1.ent inflating: Kernow 1.7.2/cache/xhtml-special.ent inflating: Kernow 1.7.2/cache/xhtml-symbol.ent inflating: Kernow 1.7.2/cache/xhtml1-frameset.dtd inflating: Kernow 1.7.2/cache/xhtml1-strict.dtd inflating: Kernow 1.7.2/cache/xhtml1-transitional.dtd creating: Kernow 1.7.2/extensions/ inflating: Kernow 1.7.2/extensions/readme.txt inflating: Kernow 1.7.2/Kernow.bat inflating: Kernow 1.7.2/Kernow.exe inflating: Kernow 1.7.2/kernow.jar inflating: Kernow 1.7.2/Kernow.sh creating: Kernow 1.7.2/lib/ inflating: Kernow 1.7.2/lib/ant-launcher.jar inflating: Kernow 1.7.2/lib/ant.jar inflating: Kernow 1.7.2/lib/autocomplete.jar inflating: Kernow 1.7.2/lib/AutoComplete.License.txt inflating: Kernow 1.7.2/lib/cupv10k-runtime.jar inflating: Kernow 1.7.2/lib/icu4j.jar inflating: Kernow 1.7.2/lib/org.eclipse.wst.xml.xpath2.processor_1.1.0.jar inflating: Kernow 1.7.2/lib/resolver.jar inflating: Kernow 1.7.2/lib/rsyntaxtextarea.jar inflating: Kernow 1.7.2/lib/saxon9he.jar inflating: Kernow 1.7.2/lib/serializer.jar extracting: Kernow 1.7.2/lib/splash.gif inflating: Kernow 1.7.2/lib/swing-layout-1.0.4.jar inflating: Kernow 1.7.2/lib/xercesImpl.jar inflating: Kernow 1.7.2/lib/xercesSamples.jar inflating: Kernow 1.7.2/lib/xml-apis.jar inflating: Kernow 1.7.2/readme.txt
Optional, remove .zip file by using rm -f "Kernow 1.7.2.zip" command.
Launch Kernow
Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.
[ptay@robot Downloads]$ cd Kernow1.7.2/ [ptay@robot Kernow1.7.2]$ ls ant extensions Kernow.exe Kernow.sh readme.txt cache Kernow.bat kernow.jar lib [ptay@robot Kernow1.7.2]$ java -jar kernow.jar & [1] 3370 [ptay@robot Kernow1.7.2]$
MySQL
Ubuntu commands:
$ sudo apt-get install mysql-server mysql-common mysql-client
Fedora Core 15 commands:
[ptay@robot logs]$ sudo yum groupinstall "MySQL Database" [sudo] password for ptay: Loaded plugins: langpacks, presto, refresh-packagekit Adding en_US to language list Setting up Group Process updates/group_gz | 420 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package MySQL-python.x86_64 0:1.2.3-1.fc14 set to be installed ---> Package libdbi-dbd-mysql.x86_64 0:0.8.3-6.fc14 set to be installed --> Processing Dependency: libdbi-drivers = 0.8.3-6.fc14 for package: libdbi-dbd-mysql-0.8.3-6.fc14.x86_64 --> Processing Dependency: libdbi.so.0()(64bit) for package: libdbi-dbd-mysql-0.8.3-6.fc14.x86_64 ---> Package mysql.x86_64 0:5.1.58-1.fc14 set to be installed ---> Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.fc13 set to be installed ---> Package mysql-server.x86_64 0:5.1.58-1.fc14 set to be installed --> Processing Dependency: perl(DBI) for package: mysql-server-5.1.58-1.fc14.x86_64 --> Processing Dependency: perl-DBI for package: mysql-server-5.1.58-1.fc14.x86_64 ---> Package perl-DBD-MySQL.x86_64 0:4.017-1.fc14 set to be installed ---> Package unixODBC.x86_64 0:2.2.14-12.fc14 set to be installed --> Running transaction check ---> Package libdbi.x86_64 0:0.8.3-4.fc14 set to be installed ---> Package libdbi-drivers.x86_64 0:0.8.3-6.fc14 set to be installed ---> Package perl-DBI.x86_64 0:1.613-1.fc14 set to be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: MySQL-python x86_64 1.2.3-1.fc14 updates 79 k libdbi-dbd-mysql x86_64 0.8.3-6.fc14 fedora 14 k mysql x86_64 5.1.58-1.fc14 updates 883 k mysql-connector-odbc x86_64 5.1.5r1144-7.fc13 fedora 114 k mysql-server x86_64 5.1.58-1.fc14 updates 8.1 M perl-DBD-MySQL x86_64 4.017-1.fc14 fedora 136 k unixODBC x86_64 2.2.14-12.fc14 fedora 383 k Installing for dependencies: libdbi x86_64 0.8.3-4.fc14 fedora 39 k libdbi-drivers x86_64 0.8.3-6.fc14 fedora 372 k perl-DBI x86_64 1.613-1.fc14 fedora 776 k Transaction Summary ================================================================================ Install 10 Package(s) Total download size: 11 M Installed size: 30 M Is this ok [y/N]: y Downloading Packages: Setting up and reading Presto delta metadata Processing delta metadata Package(s) data still to download: 11 M (1/10): MySQL-python-1.2.3-1.fc14.x86_64.rpm | 79 kB 00:00 (2/10): libdbi-0.8.3-4.fc14.x86_64.rpm | 39 kB 00:00 (3/10): libdbi-dbd-mysql-0.8.3-6.fc14.x86_64.rpm | 14 kB 00:00 (4/10): libdbi-drivers-0.8.3-6.fc14.x86_64.rpm | 372 kB 00:00 (5/10): mysql-5.1.58-1.fc14.x86_64.rpm | 883 kB 00:00 (6/10): mysql-connector-odbc-5.1.5r1144-7.fc13.x86_64.rp | 114 kB 00:00 (7/10): mysql-server-5.1.58-1.fc14.x86_64.rpm | 8.1 MB 00:02 (8/10): perl-DBD-MySQL-4.017-1.fc14.x86_64.rpm | 136 kB 00:00 (9/10): perl-DBI-1.613-1.fc14.x86_64.rpm | 776 kB 00:00 (10/10): unixODBC-2.2.14-12.fc14.x86_64.rpm | 383 kB 00:00 -------------------------------------------------------------------------------- Total 1.0 MB/s | 11 MB 00:10 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : libdbi-0.8.3-4.fc14.x86_64 1/10 Installing : mysql-5.1.58-1.fc14.x86_64 2/10 Installing : perl-DBI-1.613-1.fc14.x86_64 3/10 Installing : unixODBC-2.2.14-12.fc14.x86_64 4/10 Installing : mysql-connector-odbc-5.1.5r1144-7.fc13.x86_64 5/10 Installing : MySQL-python-1.2.3-1.fc14.x86_64 6/10 Installing : perl-DBD-MySQL-4.017-1.fc14.x86_64 7/10 Installing : libdbi-drivers-0.8.3-6.fc14.x86_64 8/10 Installing : libdbi-dbd-mysql-0.8.3-6.fc14.x86_64 9/10 Installing : mysql-server-5.1.58-1.fc14.x86_64 10/10 Installed: MySQL-python.x86_64 0:1.2.3-1.fc14 libdbi-dbd-mysql.x86_64 0:0.8.3-6.fc14 mysql.x86_64 0:5.1.58-1.fc14 mysql-connector-odbc.x86_64 0:5.1.5r1144-7.fc13 mysql-server.x86_64 0:5.1.58-1.fc14 perl-DBD-MySQL.x86_64 0:4.017-1.fc14 unixODBC.x86_64 0:2.2.14-12.fc14 Dependency Installed: libdbi.x86_64 0:0.8.3-4.fc14 libdbi-drivers.x86_64 0:0.8.3-6.fc14 perl-DBI.x86_64 0:1.613-1.fc14 Complete!
Enable MySQL at specific run levels (I did 3 & 5)
[ptay@robot logs]$ sudo chkconfig --level 35 mysqld on [ptay@robot logs]$ chkconfig --list | grep -i mysqld mysqld 0:off 1:off 2:off 3:on 4:off 5:on 6:off
Start MySQL daemon (mysqld) As root
[root@robot ~]# service mysqld restart Stopping mysqld: [ OK ] Initializing MySQL database: Installing MySQL system tables... OK //////////////omitting text///////////////////// Starting mysqld: [ OK ]
Run MySQL secure installation script As root
[root@robot ~]# /usr/bin/mysql_secure_installation //////////////omitting text///////////////////// Set root password? [Y/n] y Remove anonymous users? [Y/n] y Disallow root login remotely? [Y/n] y Remove test database and access to it? [Y/n] y Reload privilege tables now? [Y/n] y Cleaning up... All done! If you've completed all of the above steps, your MySQL installation should now be secure. Thanks for using MySQL!
Test MySQL As any user
[root@robot ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.58 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)
mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> use test
Database changed
mysql> use test;
Database changed
mysql> drop table if exists T;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> create table T (A text, B text);
insert into T values ('Hello,', 'world!');
select * from T;Query OK, 0 rows affected (0.06 sec)
mysql> insert into T values ('Hello,', 'world!');
Query OK, 1 row affected (0.00 sec)
mysql> select * from T;
+--------+--------+
| A | B |
+--------+--------+
| Hello, | world! |
+--------+--------+
1 row in set (0.00 sec)
mysql> \q
Bye