ext library Glassfish and netbeans deployment

Ext application library used is contained in this folder /domains//lib/applibs
-Using netbeans to deploy, the application library would also be contained in the war file, therefore the library should not be in glassfish lib folder to prevent confusion.

setup mysql in glassfish

1) Copy mysql-connector-java-[version].jar to /domain//lib
2) GlassfishAdmin:4848>Resources>JDBC/connection Pools/ New JDBC Connection Pool
-Name: <__mysqlpool>
-ResourceType:
-DatabaseVendor:

Click next> Additional Properties

Setup 5 parameters below:
-databaseName:
-user:
-password:
-serverName:
-portNumber:<3306>

Click Finish. Try ping the connection pool.

3)Goto Resources/JDBC/JDBC Resources Click New.
-JNDI Name:
-Pool Name: <__mysqlpool>
-status:
Create New.

import/export mysql database between window and linux

C: > mysqldump -u -p database_name > /path/to/filename.sql

This should create filename.sql which you can then run on the Linux machine as follows:

Start the mysql client and then, at the mysql prompt:

mysql> CREATE DATABASE database_name;

mysql> USE database_name;

mysql> source /path/to/filename.sql

This should execute filename.sql which will recreate the database.

Glassfish commands

find / -name mysql

./asadmin start-domain domain1

./asadmin create-domain --portbase 1000 domain2
Using port 1048 for Admin.
Using port 1080 for HTTP Instance.
Using port 1076 for JMS.
Using port 1037 for IIOP.
Using port 1081 for HTTP_SSL.
Using port 1038 for IIOP_SSL.
Using port 1039 for IIOP_MUTUALAUTH.
Using port 1086 for JMX_ADMIN.

install/uninstall mysql on fedora

Installations created from MySQL AB's Linux RPM distributions result in files under the following system directories:

Directory	Contents of Directory
/usr/bin	Client programs and scripts
/usr/sbin	The mysqld server
/var/lib/mysql	Log files, databases
/usr/share/info	Manual in Info format
/usr/share/man	Unix manual pages
/usr/include/mysql	Include (header) files
/usr/lib/mysql	Libraries
/usr/share/mysql	Error message and character set files
/usr/share/sql-bench	Benchmarks

Applicable to Fedora Versions

• Fedora 6, 7, 8, 9
• CentOS 4, 4.5, 5, 5.1
  

Requirements

1. Login to a terminal as root using one of these options: (su --login | su -l | or: su -)
   
2. Yum must also be installed and functional
   

Doing the Work

1. Install mysql mysql-server:

# yum install mysql mysql-server
Loading "priorities" plugin
Loading "changelog" plugin
Loading "fastestmirror" plugin
Loading "allowdowngrade" plugin
Loading "kernel-module" plugin
Loading "fedorakmod" plugin
Loading "installonlyn" plugin
Loading "protectbase" plugin
Setting up Install Process
Setting up repositories
livna                     100% |=========================| 1.1 kB    00:00 
updates                   100% |=========================| 1.2 kB    00:00 
core                      100% |=========================| 1.1 kB    00:00 
extras                    100% |=========================| 1.1 kB    00:00 
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
primary.xml.gz            100% |=========================| 1.8 MB    00:06 
extras    : ################################################## 5594/5594
0 packages excluded due to repository priority protections
0 packages excluded due to repository protections
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for mysql to pack into transaction set.
mysql-5.0.27-1.fc6.i386.r 100% |=========================|  36 kB    00:00 
---> Package mysql.i386 0:5.0.27-1.fc6 set to be updated
---> Downloading header for mysql-server to pack into transaction set.
mysql-server-5.0.27-1.fc6 100% |=========================|  33 kB    00:00 
---> Package mysql-server.x86_64 0:5.0.27-1.fc6 set to be updated
---> Downloading header for mysql to pack into transaction set.
mysql-5.0.27-1.fc6.x86_64 100% |=========================|  36 kB    00:00 
---> Package mysql.x86_64 0:5.0.27-1.fc6 set to be updated
--> Running transaction check
--> Processing Dependency: perl-DBI for package: mysql-server
--> Processing Dependency: perl(DBI) for package: mysql
--> Processing Dependency: perl(DBI) for package: mysql-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for perl-DBI to pack into transaction set.
perl-DBI-1.52-1.fc6.x86_6 100% |=========================|  16 kB    00:00 
---> Package perl-DBI.x86_64 0:1.52-1.fc6 set to be updated
---> Downloading header for perl-DBD-MySQL to pack into transaction set.
perl-DBD-MySQL-3.0007-1.f 100% |=========================| 8.5 kB    00:00 
---> Package perl-DBD-MySQL.x86_64 0:3.0007-1.fc6 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
mysql                   i386       5.0.27-1.fc6     updates           3.3 M
mysql                   x86_64     5.0.27-1.fc6     updates           3.3 M
mysql-server            x86_64     5.0.27-1.fc6     updates            10 M
Installing for dependencies:
perl-DBD-MySQL          x86_64     3.0007-1.fc6     core              147 k
perl-DBI                x86_64     1.52-1.fc6       core              605 k

Transaction Summary
=============================================================================
Install      5 Package(s)     
Update       0 Package(s)     
Remove       0 Package(s)     

Total download size: 18 M
Is this ok [y/N]:

2. Start MySQL server daemon (mysqld):

# chkconfig --level 2345 mysqld on; service mysqld start
Initializing MySQL database:  Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h angstrom password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                       [  OK  ]
Starting MySQL:                                            [  OK  ]

3. Login as root database admin to MySQL server:

# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

4. Delete ALL users who are not root:

mysql> delete from mysql.user where not (host="localhost" and user="root");
Query OK, 5 rows affected (0.15 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

5. Change root database admin password: (note: once this step is complete you'll need to login with: mysql -p -u root)
   

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass');
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

6. Change root username to something less guessable for higher security.
   

mysql> update mysql.user set user="mydbadmin" where user="root";
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

7. Remove anonymous access to the database(s):

mysql> DELETE FROM mysql.user WHERE User = '';
Query OK, 2 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

8. Add a new user with database admin privs for all databases:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'warren'@'localhost' IDENTIFIED BY 'mypass' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

9. Add a new user with database admin privs for a specific database, in this case the database is called "bugzilla": (note: The 'bugzilla' database must first be added, see below.)
   

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON bugzilla.* TO 'warren'@'localhost' IDENTIFIED BY 'mypass';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>

10. Add a MySQL database:

mysql> create database bugzilla;
Query OK, 1 row affected (0.15 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

11. Installing mysql-administrator (note: This tool can be found in the gnome main menu under 'System Tools' once installed):

# yum install mysql-administrator
Loading "priorities" plugin
Loading "changelog" plugin
Loading "fastestmirror" plugin
Loading "allowdowngrade" plugin
Loading "kernel-module" plugin
Loading "fedorakmod" plugin
Loading "installonlyn" plugin
Loading "protectbase" plugin
Setting up Install Process
Setting up repositories
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
0 packages excluded due to repository priority protections
0 packages excluded due to repository protections
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for mysql-administrator to pack into transaction set.
mysql-administrator-1.1.1 100% |=========================|  25 kB    00:00 
---> Package mysql-administrator.x86_64 0:1.1.10-3.fc6 set to be updated
--> Running transaction check
--> Processing Dependency: libsigc-2.0.so.0()(64bit) for package: mysql-administrator
--> Processing Dependency: mysql-gui-common for package: mysql-administrator
--> Processing Dependency: libgdkmm-2.4.so.1()(64bit) for package: mysql-administrator
--> Processing Dependency: libpangomm-1.4.so.1()(64bit) for package: mysql-administrator
--> Processing Dependency: libglibmm-2.4.so.1()(64bit) for package: mysql-administrator
--> Processing Dependency: libcairomm-1.0.so.1()(64bit) for package: mysql-administrator
--> Processing Dependency: libatkmm-1.6.so.1()(64bit) for package: mysql-administrator
--> Processing Dependency: libgtkmm-2.4.so.1()(64bit) for package: mysql-administrator
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for gtkmm24 to pack into transaction set.
gtkmm24-2.10.5-1.fc6.x86_ 100% |=========================| 7.8 kB    00:00 
---> Package gtkmm24.x86_64 0:2.10.5-1.fc6 set to be updated
---> Downloading header for cairomm to pack into transaction set.
cairomm-1.2.4-1.fc6.x86_6 100% |=========================| 5.2 kB    00:00 
---> Package cairomm.x86_64 0:1.2.4-1.fc6 set to be updated
---> Downloading header for libsigc++20 to pack into transaction set.
libsigc++20-2.0.17-2.x86_ 100% |=========================| 6.1 kB    00:00 
---> Package libsigc++20.x86_64 0:2.0.17-2 set to be updated
---> Downloading header for glibmm24 to pack into transaction set.
glibmm24-2.12.3-1.x86_64. 100% |=========================| 6.1 kB    00:00 
---> Package glibmm24.x86_64 0:2.12.3-1 set to be updated
---> Downloading header for mysql-gui-common to pack into transaction set.
mysql-gui-common-1.1.10-3 100% |=========================|  17 kB    00:00 
---> Package mysql-gui-common.x86_64 0:1.1.10-3.fc6 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
mysql-administrator     x86_64     1.1.10-3.fc6     extras            1.5 M
Installing for dependencies:
cairomm                 x86_64     1.2.4-1.fc6      extras             40 k
glibmm24                x86_64     2.12.3-1         extras            145 k
gtkmm24                 x86_64     2.10.5-1.fc6     extras            1.1 M
libsigc++20             x86_64     2.0.17-2         extras             49 k
mysql-gui-common        x86_64     1.1.10-3.fc6     extras            208 k

Transaction Summary
=============================================================================
Install      6 Package(s)     
Update       0 Package(s)     
Remove       0 Package(s)     

Total download size: 3.1 M
Is this ok [y/N]:

12. Improving local file security (after saving and exiting remember to: service mysqld restart for changes to take effect):

The next change is to disable the use of LOAD DATA LOCAL INFILE command, which will help to
prevent against unauthorized reading from local files. This matters especially when new SQL
Injection vulnerabilities in PHP applications are found.

For that purpose, the following parameter should be added in the [mysqld] section in:
/etc/my.cnf

set-variable=local-infile=0

13. Disabling remote access to the MySQL server (after saving and exiting remember to: service mysqld restart for changes to take effect).
    

This change applies to the 3306/tcp port, on which MySQL listens by default. Because,
according to the initial assumptions, the database will be used only by locally installed PHP
applications, we can freely disable listening on that port. This will limit possibilities of
attacking the MySQL database by direct TCP/IP connections from other hosts. Local communication
will be still possible throw the mysql.sock socket. In order to disable listening on the
mentioned port, the following parameter should be added to the [mysqld] section of /etc/my.cnf:

skip-networking

If, for some reason, remote access to the database is still required (e.g. to perform remote
data backup), the SSH protocol can be used as follows:

(modify to your needs)
backuphost$ ssh mysqlserver /usr/local/mysql/bin/mysqldump -A > backup

Troubleshooting

How to test

1. Make sure mysql and mysql server are indeed installed and that they are the correct versions:

# rpm -qa | grep mysql && chkconfig --list | grep mysql
mysql-5.0.27-1.fc6
mysql-5.0.27-1.fc6
mysql-gui-common-1.1.10-3.fc6
mysql-server-5.0.27-1.fc6
mysql-administrator-1.1.10-3.fc6
mysqld          0:off   1:off   2:off   3:off   4:off   5:off   6:off

2. Starting mysqld on boot:

# chkconfig --level 2345 mysqld on && service mysqld restart && chkconfig --list | grep mysqld
Stopping MySQL:                                            [  OK  ]
Starting MySQL:                                            [  OK  ]
mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off

3. Clear MySQL scrollback history (so sensitive data such as passwords cannot be seen by others with access):

]# cat /dev/null > ~/.mysql_history

4. Show all users in the MySQL Server database:

mysql> select * from mysql.user;
8 rows in set (0.00 sec)

5. Delete a user from the MySQL Server database:

mysql> delete from mysql.user where host = "dev.mydomain.com";
Query OK, 2 rows affected (0.00 sec)

6. Delete a null user (user without a username) from the MySQL Server database:

mysql> delete from mysql.user where user = ' ';
Query OK, 1 rows affected (0.00 sec)

Common problems and fixes

yum remove mysql\*

Install SUN Glassfish on Fedora 9

1. yum install libstdc++.so.5
2. Download glassfish bin

Instructions to unbundle and configure GlassFish

To install and configure GlassFish you need to have JDK 5 or JDK 6 installed on your system. The configuration processing depends on Ant (1.6.5). The bundle includes an Ant distribution that has been extended with tasks to facilitate developing Java EE 5 applications for the application server.

1. Download one of the bundles to disk, set JAVA_HOME to the JDK you have installed on your system.
   
2. Run:

      % java -Xmx256m -jar filename.jar

   This command will unbundle GlassFish and create a new directory structure rooted under a directory named 'glassfish'.

3.  % cd glassfish

4. If you are using a machine with an operating system that is a derivative of UNIX(tm), set the execute permission for the Ant binaries that are included with the GlassFish bundle.

   % chmod -R +x lib/ant/bin

   % lib/ant/bin/ant -f setup.xml 

   OR for Windows:
   

   % lib\ant\bin\ant -f setup.xml 

For GlassFish V2 with Clustering supported installation, just change step 4 from the above installation

% lib/ant/bin/ant -f setup-cluster.xml 

OR for Windows:

% lib\ant\bin\ant -f setup-cluster.xml 

Configuring VNC on fedora 9

1. #Yum vnc-server //installation
2. #vncserver :1 //run desktop 1
3. #vncserver -kill :1 // kill desktop 1
4. #service vncserver status //check for vncserver status
5. #chkconfig vncserver on //start vncserver upon bootup
6. #vi /root/.vnc/xstartup file //configure startup vnc desktop

//xstartup file
#!/bin/sh

# Uncomment the following two lines for normal desktop:
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &

If you want to force to load Gnome or KDE Desktop on remote access,
edit the last line from ‘twm &’ to ’startx &’ for Gnome and
’startkde &’ for KDE Desktop.

7.#vncserver :1 -extension XFIXES //Restart vnc
8. connect using realvnc ipaddress:1
9. #vi /etc/sysconfig/vncservers //configure bootup vnc image desktop

VNCSERVERS="1:tiger 2:albatros 3:leopard"
VNCSERVERARGS[1]="-geometry 1024x768 -depth 16" //port 5901
VNCSERVERARGS[2]="-geometry 800x600 -depth 8" //port 5902
VNCSERVERARGS[3]="-geometry 1024x768 -depth 16" //pot 5903

10. # service vncserver [restart|start|stop|status]
11. startup script to start up program upon vnc

// /home//.vnc/xstartup
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" -e ./menu &
EXT_PROGRAM &

12. /root/.vnc/:.log