Ctrlk
ProSBC ProductLearning CenterHelptelcobridges.com
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Toolpack migration Solaris10 Intel 2-3

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

Toolpack Migration Steps

Create new database user

Connect to MySQL and create a new user tbdb with all privilege. If you are unable to connect, use an IP Address instead of the [HostName].

mysql -u root -h '[HostName]'
CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';

Example mysql -u root -h sol10i32-01 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';

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.

Install ODBC MySQL connector

Configure ODBC driver manager

  • Enable the MySQL driver is enable (remove the comments for the MySQL driver). ***WARNING: There must be no space at the beginning of the line

  • Set the Driver to /usr/lib/libmyodbc3_r.so

    vim /etc/odbcinst.ini

Here is an example:

  1. Driver from the MyODBC package

  2. Setup from the unixODBC package [MySQL] <----- This line must NOT start with a '#'. Must also not start with a space. Description = ODBC for MySQL Driver = /usr/lib/libmyodbc3_r.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1

Enable MySQL database replication

Configure the MySQL configuration file

If the file is empty, copy from default file

Add 2 lines in the configuration file:

  • log-bin

  • server-id

server-id value needs to be a non-zero value and unique on each host if database redundancy is used.

Make sure it is under the [mysqld] section

Example:

  1. 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

  2. Don't listen on a TCP/IP port at all. This can be a security enhancement,

  3. if all processes that need to connect to mysqld run on the same host.

  4. All interaction with mysqld must be made via Unix sockets or named pipes.

  5. Note that using this option without enabling named pipes on Windows

  6. (via the "enable-named-pipe" option) will render mysqld useless!

  8. skip-networking

  9. Disable Federated by default skip-federated

  10. Replication Master Server (default)

  11. binary logging is required for replication log-bin=mysql-bin

  12. required unique id between 1 and 2^32 - 1

  13. defaults to 1 if master-host is not set

  14. but will not function as a master if omitted server-id = 1

Restart MySQL service

Disable Release 2-2 Service

Toolpack System installation

Now that the prerequisite are installed, we can go back to the migration guide Toolpack migration 2-3.

PreviousToolpack migration Fedora Core8 2-3
NextToolpack migration Windows XP 2-3

Last updated

Was this helpful?