Cbilodeau: add mysql connection through host name

2009-05-29T12:46:06Z

add mysql connection through host name

← Older revision		Revision as of 08:46, 29 May 2009
Line 205:		Line 205:
	chmod +x /etc/rc2.d/S98mysql		chmod +x /etc/rc2.d/S98mysql

	9. Start ~~mysql~~		9. Start MySQL
	/etc/rc2.d/S98mysql start		/etc/rc2.d/S98mysql start

			10. Verify the MySQL connection
			:Log onto mysql, create a tbdb user. The ''[HostName]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
			:If you cannot log in, it is possible that the host name is not configure properly, use an IP Address instead.

			mysql -u tbdb -h '[HostName]' -p
			exit

			:Example:

			mysql -u root -h sol10i32-02 -p
			exit

	==== Toolpack System Web Portal ====		==== Toolpack System Web Portal ====

Cbilodeau: add validation guide link

2009-05-25T18:02:37Z

add validation guide link

← Older revision		Revision as of 14:02, 25 May 2009
Line 313:		Line 313:

	TBDB_PORT_SEC = 3306		TBDB_PORT_SEC = 3306


			== Validation Guide (Optional) ==
			If you would like to verify your installation go to the [[Toolpack_Installation:Validate_Toolpack_Installation\|Toolpack Validation Guide]]

213.9.123.117: /* Toolpack System Web Portal */

2009-05-16T07:23:45Z

Toolpack System Web Portal

← Older revision		Revision as of 03:23, 16 May 2009
Line 240:		Line 240:
	install rubygems:		install rubygems:

	get rubygems from http://~~www~~.~~rubyonrails~~.~~org~~/~~down~~		get rubygems from http://rubyforge.org/frs/download.php/55066/rubygems-1.3.2.tgz

	/usr/local/bin/tar -zxf rubygems-1.3.2.tgz		/usr/local/bin/tar -zxf rubygems-1.3.2.tgz

213.9.123.117: /* Toolpack System Web Portal */

2009-05-16T07:17:24Z

Toolpack System Web Portal

← Older revision		Revision as of 03:17, 16 May 2009
Line 230:		Line 230:
	install fcgi:		install fcgi:

	get fcgi from http://www.fastcgi.com/		get fcgi from http://www.fastcgi.com/dist/fcgi.tar.gz

	/usr/local/bin/tar -zxf fcgi-2.4.0.tar.gz		/usr/local/bin/tar -zxf fcgi-2.4.0.tar.gz
	cd fcgi-2.4.0/		cd fcgi-2.4.0/
Line 254:		Line 253:
	ln -s /usr/ucb/install /usr/local/bin/ginstall		ln -s /usr/ucb/install /usr/local/bin/ginstall
	gem install fcgi --include-dependencies		gem install fcgi --include-dependencies


	==== Toolpack Stream server ====		==== Toolpack Stream server ====

Cypromis: /* Toolpack System Database */

2009-05-15T21:42:33Z

Toolpack System Database

← Older revision		Revision as of 17:42, 15 May 2009
Line 32:		Line 32:
	pkgadd -d mysql-5.0.67-sol10-x86-local		pkgadd -d mysql-5.0.67-sol10-x86-local

	Retrieve mysql odbc from http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-solaris10-x86-32bit.~~tar~~.gz		Retrieve mysql odbc from http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.5-solaris10-x86-32bit.pkg.gz/from/http://ftp.gwdg.de/pub/misc/mysql/
	from http://mysql.serenitynet.com/		from http://mysql.serenitynet.com/

10.0.0.157: /* Toolpack System Database */

2009-05-15T17:52:22Z

Toolpack System Database

← Older revision		Revision as of 13:52, 15 May 2009
Line 32:		Line 32:
	pkgadd -d mysql-5.0.67-sol10-x86-local		pkgadd -d mysql-5.0.67-sol10-x86-local

	Retrieve mysql odbc from http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-solaris10-x86-32bit.tar.gz/from/http://mysql.serenitynet.com/		Retrieve mysql odbc from http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-solaris10-x86-32bit.tar.gz
			from http://mysql.serenitynet.com/

	Install mysql odbc connector.		Install mysql odbc connector.

Cbilodeau at 13:07, 14 May 2009

2009-05-14T13:07:35Z

← Older revision		Revision as of 09:07, 14 May 2009
Line 1:		Line 1:
	This page shows the Toolpack 2-3 prerequisites for Solaris 10.		This page shows the Toolpack 2-3 prerequisites for Solaris Intel 10.

	== Toolpack Prerequisite ==		== Toolpack Prerequisite ==

Cbilodeau: Creation

2009-05-14T13:05:56Z

Creation

New page

This page shows the Toolpack 2-3 prerequisites for Solaris 10.

== Toolpack Prerequisite ==

All prerequisites, unless stated otherwise, are available from the site http://www.sunfreeware.com.

Export those environment variable:

export PATH=/usr/local/mysql/bin/:/usr/local/mysql/sbin/:/usr/local/bin:/usr/ccs/bin:$PATH:/usr/sfw/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib:/usr/ccs/lib:/usr/sfw/lib

=== Toolpack Basic packages ===

pkgadd -d gcc-3.4.6-sol10-x86-local
pkgadd -d ncurses-5.6-sol10-x86-local
pkgadd -d glib-1.2.10-sol10-intel-local
pkgadd -d db-4.2.52.NC-sol10-intel-local
pkgadd -d libiconv-1.11-sol10-x86-local
pkgadd -d libintl-3.4.0-sol10-x86-local
pkgadd -d openssl-0.9.8k-sol10-x86-local
pkgadd -d tar-1.21-sol10-x86-local
pkgadd -d zlib-1.2.3-sol10-x86-local
pkgadd -d make-3.81-sol10-x86-local

==== Toolpack System Database ====

The Toolpack system database is used by the main host and requires mySQL database server. The
system database packages are as follows:

pkgadd -d mysql-5.0.67-sol10-x86-local

Retrieve mysql odbc from http://dev.mysql.com/get/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-solaris10-x86-32bit.tar.gz/from/http://mysql.serenitynet.com/

Install mysql odbc connector.

/usr/local/bin/tar -zxf mysql-connector-odbc-3.51.27-solaris10-x86-32bit.tar.gz
cp mysql-connector-odbc-3.51.27-solaris10-x86-32bit/lib/* /usr/lib
crle -l /lib:/usr/lib:/usr/local/lib

Configure Myodbc:

Edit the file /etc/odbcinst.ini (you may have to create it) and make sure that the driver directs to the libmyodbc3_r.so file.

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3_r.so

Open a shell prompt and execute the following commands:

Create the mysql group and user
groupadd mysql
useradd -g mysql mysql
cd /usr/local/mysql
chgrp -R mysql .
chown -R mysql .

Give access to the hostname program

ln -s /usr/bin/hostname /usr/local/bin/hostname

Install the database
/usr/local/mysql/bin/mysql_install_db --user=mysql

Start the server
/usr/local/mysql/bin/mysqld_safe --old-passwords -user=mysql &
Set the root password
/usr/local/mysql/bin/mysqladmin -u root password '[MyPassword]'
Log onto the database using the client and create a new user (we recommend tbdb) then grant it all priviledges.
/usr/local/mysql/bin/mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@"%" IDENTIFIED BY '[DatabasePassword]';
FLUSH PRIVILEGES;

ex.

GRANT ALL PRIVILEGES ON *.* TO tbdb@'%' IDENTIFIED BY 'tbdbpw';
FLUSH PRIVILEGES;

print the list of user

select * from mysql.user;

Remove all the 'empty' users:

In the following example you should remove the 4th and 5th user.

mysql> select * from mysql.user;
+----------------+------+------------------+-------------+-------------+
| Host | User | Password | Select_priv | Insert_priv |
+----------------+------+------------------+-------------+-------------+
| localhost | root | 68d4f47c49a579c9 | Y | Y |
| tl-sol10i32-01 | root | | Y | Y |
| 127.0.0.1 | root | | Y | Y |
| localhost | | | N | N |
| tl-sol10i32-01 | | | N | N |
| % | tbdb | 68d4f47c49a579c9 | Y | Y |
+----------------+------+------------------+-------------+-------------+
6 rows in set (0.00 sec)

Delete command:
DELETE FROM mysql.user where user='tobedeleted';
exit

ex.

DELETE FROM mysql.user where user=<nowiki>''</nowiki>;
exit

stop mysql_safe

pkill mysql

copy the new configuration file

cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

Edit the mysql configuration file

vi /etc/my.cnf

Make sure that under the [mysqld] section that the 2 following lines are present:

* log-bin= (its value is not important)
* server-id= (it must be a non-zero value, and the value must be unique if you are using a multi-host system).

Here is an example:

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Disable Federated by default
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

Retrieve the unix odbc package from http://www.unixodbc.org/pub/unixODBC/binaries/unixODBC-2.2.14-i386.pkg.gz.

Install odbc:

pkgadd -d unixODBC-2.2.14-i386.pkg

Continue here:

7. Create the file 'S98mysql' in the directory /etc/rc2.d to start the database server automatically upon machine startup:
vi /etc/rc2.d/S98mysql

Put the following information in the file (new one):
#!/sbin/sh
PATH=$PATH:/usr/local/mysql/bin
export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib:
export LD_LIBRARY_PATH
case "$1" in
start)
cd /usr/local/mysql/libexec; /usr/local/mysql/libexec/mysqld --user=mysql &
;;
stop)
pkill .*mysqld.*
;;
*)
echo "Usage: $0 { start | stop }"
exit 1
;;
esac
exit 0

8. Set the executable bit on the newly created script
chmod +x /etc/rc2.d/S98mysql

9. Start mysql
/etc/rc2.d/S98mysql start

==== Toolpack System Web Portal ====

pkgadd -d expat-2.0.1-sol10-x86-local
pkgadd -d freetype-2.3.1-sol10-x86-local
pkgadd -d fontconfig-2.4.2-sol10-x86-local
pkgadd -d render-0.8-sol10-intel-local
pkgadd -d xrender-0.8.3-sol10-intel-local
pkgadd -d xft-2.1.2-sol10-intel-local
pkgadd -d gdbm-1.8.3-sol10-intel-local
pkgadd -d tk-8.5.3-sol10-x86-local
pkgadd -d tcl-8.5.3-sol10-x86-local
pkgadd -d libedit-20070302_2.10-sol10-x86-local
pkgadd -d ruby-1.8.7p72-sol10-x86-local
pkgadd -d bzip2-1.0.5-sol10-x86-local
pkgadd -d pcre-7.9-sol10-x86-local
pkgadd -d lighttpd-1.4.22-sol10-x86-local
pkgadd -d libxml2-2.6.31-sol10-x86-local

install fcgi:

get fcgi from http://www.fastcgi.com/

/usr/local/bin/tar -zxf fcgi-2.4.0.tar.gz
cd fcgi-2.4.0/
./configure
make install
cd ..

install rubygems:

get rubygems from http://www.rubyonrails.org/down

/usr/local/bin/tar -zxf rubygems-1.3.2.tgz
cd rubygems-1.3.2
ruby setup.rb
cd ..

Install 'fastcgi' plugins for ruby framework using the following command:

export FTP_PASSIVE=1
ln -s /usr/ucb/install /usr/local/bin/ginstall
gem install fcgi --include-dependencies

==== Toolpack Stream server ====

pkgadd -d tcpdump-4.0.0-sol10-x86-local
pkgadd -d libpcap-1.0.0-sol10-x86-local

== Toolpack System installation ==

==== The following steps need to be done after running the Toolpack installer. ====

Now it is time to install the [[toolpack_installer_2-3|Toolpack system]] itself, but rememeber to come back here afterward!

Create a symbolic link of lighttpd

ln -s /usr/local/sbin/lighttpd /usr/sbin/lighttpd

Modify the all the lighttpd configuration files

vi /lib/tb/toolpack/pkg/2.3.0/web/etc/lighttpd.conf
vi /lib/tb/toolpack/pkg/2.3.0/web/etc/lighttpd.conf.in
vi /lib/tb/toolpack/pkg/2.3.0/web/etc/lighttpd_12358.conf <--- the number may be different(should be equal to the TBX_GW_PORT) or may not exist at all yet

Look for the Plug rails section and modify the ruby path from /usr/bin/ruby to /usr/local/bin/ruby like so:

## Plug rails
fastcgi.server = (".fcgi" => ( "railsapp" =>
( "min-procs" => 1,
"max-procs" => 1,
"socket" => "/tmp/ruby-railsapp_12401.fastcgi",
"bin-path" => "/usr/local/bin/ruby /lib/tb/toolpack/pkg/2.3.0/web/public/dispatch.fcgi"
)
))

Modify the following files:

vi /lib/svc/method/tbtoolpack_12358 <-- the name of the file may be different according to your gateway port
vi /lib/tb/toolpack/.helper/tbtoolpack.svc.Solaris10

Add those lines in each files under the line that starts with 'TBSERVICE_CONF'

PATH=/usr/local/mysql/bin/:/usr/local/mysql/sbin/:/usr/local/bin:/usr/ccs/bin:$PATH:/usr/sfw/bin
export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib:/usr/ccs/lib:/usr/sfw/lib
export LD_LIBRARY_PATH

Modify the toolpack.ini file (No need to do in the slave host):

vi /lib/tb/toolpack/setup/12358/2.3/toolpack.ini <--- path maybe different, if you have used a different gateway port

Add the following line at the end of the file:

TBDB_PORT_SEC = [MysqlPort]

ex.

TBDB_PORT_SEC = 3306

Toolpack prerequisite Solaris10 Intel 2-3 - Revision history

Cbilodeau: add mysql connection through host name

Cbilodeau: add validation guide link

213.9.123.117: /* Toolpack System Web Portal */

213.9.123.117: /* Toolpack System Web Portal */

Cypromis: /* Toolpack System Database */

10.0.0.157: /* Toolpack System Database */

Cbilodeau at 13:07, 14 May 2009

Cbilodeau: Creation