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.
View 1 Replies
ADVERTISEMENT
Jan 12, 2010
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.
View 3 Replies
View Related
May 22, 2009
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
[Code].....
View 3 Replies
View Related
Jul 17, 2010
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...
View 5 Replies
View Related
Feb 20, 2011
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.
View 1 Replies
View Related
Aug 31, 2010
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?
View 6 Replies
View Related
Dec 9, 2010
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.
View 1 Replies
View Related
Jun 4, 2009
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
View 16 Replies
View Related
Mar 3, 2009
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).
[Code]...
View 16 Replies
View Related
Mar 30, 2009
I am trying to install php-mysql but I am getting conflicts. I manually installed
MySQL-shared-community-5.1.32-0.rhel5
MySQL-client-community-5.1.32-0.rhel5
MySQL-server-community-5.1.32-0.rhel5
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.
View 4 Replies
View Related
Oct 21, 2009
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
[Code]...
View 2 Replies
View Related
Aug 8, 2011
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)
View 2 Replies
View Related
Jun 7, 2011
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
[Code]...
View 6 Replies
View Related
Jun 2, 2010
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.
View 9 Replies
View Related
Jul 14, 2010
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.
View 4 Replies
View Related
Mar 3, 2010
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.
View 4 Replies
View Related
May 18, 2011
I need some features that are only available in MySQL 5.1 or later. Can I get MySQL 5.1 for CentOS? What is the best way to install it?
View 9 Replies
View Related
Apr 6, 2011
My system is
Code:
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.
View 1 Replies
View Related
Apr 19, 2011
My OS is ubuntu and i'm having problems with MySQL:
[code]...
tried apt-get --purge remove mysql-server and then apt-get install mysql-server but still dont work
View 8 Replies
View Related
Jan 21, 2011
I have some trouble when I build a DNS server. I need use mysql stored procedure work with the bind dlz mysql driver, but failed.
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}
[code]....
View 1 Replies
View Related
May 30, 2011
I am trying to make a PHP form where the user inputs a text string, and then it is stored in MYSQL db
1.php
Code:
<form action="2.php" method="post">
Your name: <input type="text" name="txt_name" />
<input type="submit" />
</form>
[Code]....
View 1 Replies
View Related
Feb 12, 2009
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.
View 1 Replies
View Related
Jun 26, 2009
i cant install mysql on my vps.
View 6 Replies
View Related
Jul 13, 2009
I used yum to install mysql server and it won't work.
Here is yum install.
yum install php-mysql mysql mysql-server
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* epel: mirrors.tummy.com
[Code].....
View 11 Replies
View Related
Oct 27, 2010
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
[code].....
View 2 Replies
View Related
Sep 8, 2010
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?
View 2 Replies
View Related
Jul 10, 2009
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?
View 1 Replies
View Related
Aug 18, 2009
I have a problem installing mysql ruby gem on 64bit CentOS machine.
[jacekb@vitaidealn ~]$ uname -a
Linux vitaidealn.local 2.6.18-92.el5 #1 SMP Tue Jun 10 18:51:06 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
View 3 Replies
View Related
May 13, 2010
I have downloaded MySQL-server-community-5.1.46-1.rhel5.i386.rpm But am not sure how to upgrade my existing mysql5.0 with out damaging anything.
Below is PHP, MYSQL & Apache Versions installed on my Centos box.
Using YUM to upgrade mysql 5.0 to 5.1 I get this;
yum upgrade mysql-server
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: mirror.steadfast.net
[Code].....
View 1 Replies
View Related
Feb 13, 2011
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)
[Code]...
View 5 Replies
View Related
