Problem when install MYSQL administrator
[root@localhost src]#rpm -iv mysql-administrator-5.0r5-1fc5.i386.rpm
error: Failed dependencies:
libatkmm-1.6.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libgdkmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libglibmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libgtkmm-2.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libpangomm-1.4.so.1 is needed by mysql-administrator-5.0r5-1fc5.i386
libsigc-2.0.so.0 is needed by mysql-administrator-5.0r5-1fc5.i386
Problem when Install MYSQL Query Browser
[root@localhost src]# rpm -iv mysql-query-browser-5.0r5-1fc5.i386.rpm
error: Failed dependencies:
libatkmm-1.6.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libgdkmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libglibmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libgtkmm-2.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libpangomm-1.4.so.1 is needed by mysql-query-browser-5.0r5-1fc5.i386
libsigc-2.0.so.0 is needed by mysql-query-browser-5.0r5-1fc5.i386
how to solve?
yum install libatkmm-1.6.so.1
Result :
Successful Intall MYSQL Administrator and Browser
Thursday, November 30, 2006
Tuesday, November 21, 2006
Post Installation MYSQL Testing
Test connection to mysql
1) connect to mysql
[root@localhost src]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>show databases
+-----------------------+
Database
+---------------------- +
information_schema
mysql
test
+-----------------------+
3 rows in set (0.02 sec)
2. ps aux grep mysql
3. mysqladmin -p ping
[root@localhost ~]# mysqladmin -p ping
Enter password :
mysql is alive
1) connect to mysql
[root@localhost src]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>show databases
+-----------------------+
Database
+---------------------- +
information_schema
mysql
test
+-----------------------+
3 rows in set (0.02 sec)
2. ps aux grep mysql
3. mysqladmin -p ping
[root@localhost ~]# mysqladmin -p ping
Enter password :
mysql is alive
Install MYSQL Client
Install MySQL client
rpm -i MySQL-client-standard-5.0.27-0.rhel4.i386.rpm
Preparing... ###########################################
[100%]
1:MySQL-client-standard ###########################################
[100%]
rpm -i MySQL-client-standard-5.0.27-0.rhel4.i386.rpm
Preparing... ###########################################
[100%]
1:MySQL-client-standard ###########################################
[100%]
Install MySQL rpm version
[root@localhost src]# rpm -i MySQL-server-standard-5.0.27.rhel4.i386.rpm
PLEASE REMEBER TO SET A PASSSWORD FOR THE MySQL root USER!
To do so, sert the server, then issue the follwing commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h locahost.localdomain password 'new-password'
See the manual for more instruction
Note: If you are upgrading from a MySQL <=3.22.10 you should runthe /usr/bin/mysql_fix_rilivege_tables. Otherwise you will not be able to use the new GRANT command! 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
Starting MySQL [ok]
PLEASE REMEBER TO SET A PASSSWORD FOR THE MySQL root USER!
To do so, sert the server, then issue the follwing commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h locahost.localdomain password 'new-password'
See the manual for more instruction
Note: If you are upgrading from a MySQL <=3.22.10 you should runthe /usr/bin/mysql_fix_rilivege_tables. Otherwise you will not be able to use the new GRANT command! 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
Starting MySQL [ok]
Friday, November 17, 2006
MySQL RPMs unusable when SELinux is enabled
MYSQL Setup FAILED WITH SELinux enabled
"Starting MySQL...................................[FAILED]"
Run MySQL Setup
-----------------
[root@localhost src]# rpm -ivh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
Preparing... ###########################################
[100%]
1:MySQL-server-standard ###########################################
[100%]
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 localhost.localdomain password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! 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 Starting MySQL...................................[FAILED] What do to : From System->Administrator->Security and FireWall
Security Level Configuration
SElinux Setting : Enforcing
Modify Selinux Policy
SELinuxService Protection
Change this "Disable SELinux protection for mysqld daemon"
The Problem should solve
more information
http://bugs.mysql.com/bug.php?id=12676
Refer to this portion
[12 Oct 2005 2:18] michael chester
If you are using rhel 4 you can work around this issue by running the security
GUI system-config-securitylevel and exempting the MySQL service from the SELinux
configuration. You should then be able to run the RPM install as per the MySQL
instructions.
"Starting MySQL...................................[FAILED]"
Run MySQL Setup
-----------------
[root@localhost src]# rpm -ivh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
Preparing... ###########################################
[100%]
1:MySQL-server-standard ###########################################
[100%]
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 localhost.localdomain password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! 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 Starting MySQL...................................[FAILED] What do to : From System->Administrator->Security and FireWall
Security Level Configuration
SElinux Setting : Enforcing
Modify Selinux Policy
SELinuxService Protection
Change this "Disable SELinux protection for mysqld daemon"
The Problem should solve
more information
http://bugs.mysql.com/bug.php?id=12676
Refer to this portion
[12 Oct 2005 2:18] michael chester
If you are using rhel 4 you can work around this issue by running the security
GUI system-config-securitylevel and exempting the MySQL service from the SELinux
configuration. You should then be able to run the RPM install as per the MySQL
instructions.
Thursday, November 16, 2006
Uninstall MYSQL in Linux
Type below command :
rpm -qa | grep -i mysql
It display
MySQL-server-standard-5.0.27-0.rhe14
Type below to uninstall
rpm -e MySQL-server-standard-5.0.27-0.rhe14
verify with
rpm -qa | grep -i mysql
Result :
Mysql uninstall
rpm -qa | grep -i mysql
It display
MySQL-server-standard-5.0.27-0.rhe14
Type below to uninstall
rpm -e MySQL-server-standard-5.0.27-0.rhe14
verify with
rpm -qa | grep -i mysql
Result :
Mysql uninstall
Monday, November 13, 2006
PHP : Install Smarty template engine
What is Smarty
Smarty is Template Engine which separate presentation framework and program logic.
"Is Smarty right for me" from smarty.com
Setup Smarty and testing
Below step done in Windows XP and using Apache Web Server.
1. Download Smarty
2. Unzip Smarty-2.6.14.tar with using commercial software winzip or freeware 7-ZIP
3. Extract and copy Smarty directory outside of root directory. Example c:\smarty
4. Locate php.ini path location with phpinfo.php
5. Include this in php.ini
include_path = ".;c:\smarty\libs"
6. Restart IIS/Apache
7. Setup 2 folder in root directory
smarty/templates
smarty/configs
8. Testing
A. Create smartytest.php
template_dir = 'c:/program files/Apache Group/Apache2/htdocs/smarty/templates';
$smarty->config_dir = 'c:/program files/Apache Group/Apache2/htdocs/smarty/config';
$smarty->cache_dir = 'c:/smarty/smarty_cache';
$smarty->compile_dir = 'c:/smarty/smarty_templates_c';
$smarty->assign('name','world!');
$smarty->display('index.tpl');
?>
B. create template smartytest.tpl
put into \smarty\template
put the below code into page which contain html and body and save as smartytest.tpl
Hello, {$name}!
C. Create folder
c:\smarty\smarty_cache
c:\smarty\smarty_templates_c
D. testing
http://localhost/smartytest.php
E. Result
Hello, World!!
Smarty is Template Engine which separate presentation framework and program logic.
"Is Smarty right for me" from smarty.com
Setup Smarty and testing
Below step done in Windows XP and using Apache Web Server.
1. Download Smarty
2. Unzip Smarty-2.6.14.tar with using commercial software winzip or freeware 7-ZIP
3. Extract and copy Smarty directory outside of root directory. Example c:\smarty
4. Locate php.ini path location with phpinfo.php
5. Include this in php.ini
include_path = ".;c:\smarty\libs"
6. Restart IIS/Apache
7. Setup 2 folder in root directory
smarty/templates
smarty/configs
8. Testing
A. Create smartytest.php
template_dir = 'c:/program files/Apache Group/Apache2/htdocs/smarty/templates';
$smarty->config_dir = 'c:/program files/Apache Group/Apache2/htdocs/smarty/config';
$smarty->cache_dir = 'c:/smarty/smarty_cache';
$smarty->compile_dir = 'c:/smarty/smarty_templates_c';
$smarty->assign('name','world!');
$smarty->display('index.tpl');
?>
B. create template smartytest.tpl
put into \smarty\template
put the below code into page which contain html and body and save as smartytest.tpl
Hello, {$name}!
C. Create folder
c:\smarty\smarty_cache
c:\smarty\smarty_templates_c
D. testing
http://localhost/smartytest.php
E. Result
Hello, World!!
Where php.ini locate?
Create a phpinfo.php inside root directory
with the below content
// Show all information, defaults to INFO_ALL
phpinfo();
// Show just the module information.//
phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);
?>
run from IE
http://localhost/phpinfo.php
You will get php information from the page display
one of the information is php.ini path
"Configuration File (php.ini) Path"
with the below content
// Show all information, defaults to INFO_ALL
phpinfo();
// Show just the module information.//
phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);
?>
run from IE
http://localhost/phpinfo.php
You will get php information from the page display
one of the information is php.ini path
"Configuration File (php.ini) Path"
Sunday, November 12, 2006
Install Apache for Windows XP as a Service
After install Apache, I found Apache program didn't start. I check apache status from Apache service monitor and can't find Apache services from Apache service monitor. I open the window services from control panel -> Administrator -> Services and also can't found "Apache service" from the services windows.
I run apache from console and it successful
What I do
from dos prompt type : "apache path"\bin\apache and enter.
Test web: http://localhost/ and apache website display
It show I already successful install apache web services in my computer
Do some search in Google and successful install apache as service
What I do
from "apache path"\bin\apache -k install "Apache"
Apache service install successful in windows services
I can found Apache service appear at "Apache services monitor" and ”Windows Services"
I run apache from console and it successful
What I do
from dos prompt type : "apache path"\bin\apache and enter.
Test web: http://localhost/ and apache website display
It show I already successful install apache web services in my computer
Do some search in Google and successful install apache as service
What I do
from "apache path"\bin\apache -k install "Apache"
Apache service install successful in windows services
I can found Apache service appear at "Apache services monitor" and ”Windows Services"