CentOS 5 :: Having No Success In Getting Navicat To Work With MySQL?
Feb 16, 2011
I am in the process of evaluating the move to a EC2 dynamic web server for East Coast West Coast to reduce the lag for interacting with mySQL.Right now we have had great success with mySQL running on our server.ight direction on where I can find documentation onhow to configure Navicat with CentOS 5 running on a EC2 I am suspecting that their is something special on the way it handles the SSH?I am not finding any documentation at all on this, I can not understand this at all. I am sure that someone here is using Navicat along side with an EC2 Amazon server. Well, at least I am hoping so.
I have to spent 5 days in trying to configure a EC2 with numerous Ubuntu setups WITH NO SUCCESS AT ALL. What blew me away was this articleYou should have this posted on your server for 1st time users with one small modification with the ending of the article on how to make it run on Localhost running ofa EC2 Amazon. It was truly a eye opener. For all the talk about Ubuntu and the numerous articles on installing a LAMP server was totally without success. But this article was truly a pleasant experience.
A few days ago, I ordered a ubuntu server (on ovh.com). Everything was going well until I installed mysql: After the install, I tried to connect throught Navicat MySQL using SSH, but it says that the user or password it's not correct, obviusly this is not true. I've been reading and I readed that I have to open the 22 port to use MySQL in the firewall, but I don't know how to do it.
This is a fresh install of CentOS 5.3 x86_64 with the following packages installed (using yum) as I have always done and has always worked in the past: httpd mysqld php php-mysql php-gd
However any pages requiring mysql fail and the following shows up in the httpd/error_log:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/dbase.so' - /usr/lib/php/modules/dbase.so: cannot open shared object file: No such file or directory in Unknown on line 0
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
I'm having a hard time to access MySQL from the local or remote shell. If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...
MySQL is running and I can access it, using phpmyadmin.
There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access? I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information. I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.
I want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
I run Debian 5 + Gnome and it seems that after I made certain updates with aptitude, whenever I run a query in Navicat ( sql program that runs on WINE ), as the results are being presented linux goes into the command line and the GUI dies and it restarts and it asks me to login again ( all my programs crash ).how I could go about debugging this? I suspect it's some issue with Gnome and WINE, but I'm not sure.
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems -- > mysql conflicts with mysql-server-community error: mysql conflicts with mysql-server-community
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld] datadir=/var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package).
and I can not seem to find a php-mysql that works with MySQL 5.1
I followed the below thread and added the CentOS-Testing.repo and did a yum update php and it updated 30 packages, but when I try to install php-mysql I get :
[URL]
yum install php-mysql Setting up Install Process Parsing package install arguments Resolving Dependencies
[Code].....
Where can I find a php-mysql that works with MySQL 5.1? I checked the mysql website and can not seem to find any matches.
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[ [root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp [root@localhost ~]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
I have installed the MySQL server on two machines and got them to work as master - master over the internet. But since this is not very safe I wanted to get them to work over SSL. I first setup one machine and that worked. However, after setting the second machine to work over SSL it all stopped. I have checked many howto and faq documents without success.
It seems to be related to the certificate I think. This is a dump from the /var/log/syslog file for MySQL:
Mar 3 17:33:02 asterix mysqld: SSL error: Unable to get certificate from '/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem' Mar 3 17:33:02 asterix kernel: [ 7209.109831] type=1503 audit(1267633982.018:274): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/ca-cert.pem" Mar 3 17:33:02 asterix kernel: [ 7209.109877] type=1503 audit(1267633982.018:275): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem"
This is repeated many times...
I have copied the certificate files in a folder that is owned by mysql:mysql so I assumed that this would be ok.
We use courier mail server for pop3 mailboxes, and postfix for in/out mail delivery
Code:
Now Pop3 users, could not authenticate with there username/pass
It does not work now, and I have this message in my log file
Code:
I could see in my postfix.main
Code:
And I could successful run query from mysql
Code:
I tried to change the password for this user, insert new user to the same tables, but no success to authenticate
I suppose that the problem is authentication of courier mail demon (which in my mind ) should work with mysql 'mail' database in the way is postfix work
Code:
I could not find any reference with courir demon to mysql database username,password to authenticate users..
So, my quetions is, if it's possible to tracert mysql db to find out if courier demon 'asking' for authentication, or is there any error with this, and which configuration file should be checked, in order to find out what authentication method is courier mail demon use for.
Does anyone know where we can get the rpms (x86_64) for MySQL v4.0.26 or 27?
We are in the process of upgrading a very old server to CentOS 5 and need to retain this version. We still have a lot of clients that utilize this version.
I'm trying to install php / mysql on a remote Centos server.I've completed the installation stages but when I try ' php -v ' it comes up with these errors:
Code: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mcrypt.so' - libltdl.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
I'm running MySQL 5.0 on a production server and I require to upgrade mysql to version 5.5 to get a new collation support. What is the best procedure to follow? I cannot find MySQL 5.5 on the standard repositories. A yum install would be the safest, correct?
I've met several issues recently while building the MySQL server from CentOS 5 SRPM. The root problem are the expired SSL certificates used for built-in tests making all the tests fail. The problem is widely described on the net and I am in doubt now what to do: should I submit a patch or what?
I have been trying to install the above on my CentOS 5.5 server but am having missing libs issues. Our friend yum is not helping either. Here're some of the libs missing:
Missing Dependency: liblua-5.1.so()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64) Missing Dependency: libssl.so.10()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64) Missing Dependency: python(abi) = 2.6 is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
