similar to: MySQL query profiling

I recently applied updates to a CentOS 5 box running MySQL. I've discovered that the new version of openssl, 0.9.8e-36.0.1.el5_11, breaks MySQL SSL connections. If I rename /lib/libssl.so.0.9.8e and replace it with the old version of that file from openssl-0.9.8e-27.el5_10.1 (not sure if that is the next oldest, but it was handy), then SSL connection to MySQL works again. I then performed

On 08/17/2015 11:19 AM, Johnny Hughes wrote: > On 08/17/2015 10:57 AM, Tony Mountifield wrote: >> I recently applied updates to a CentOS 5 box running MySQL. I've discovered >> that the new version of openssl, 0.9.8e-36.0.1.el5_11, breaks MySQL SSL >> connections. >> >> If I rename /lib/libssl.so.0.9.8e and replace it with the old version of >> that file

Hi; It's been a while since I controlled my own server and I'm rusty. Trying to install mysql yum install mysql All looks well. Here's what happens: [root at 13gems www]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root at 13gems www]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to

Hi! I'm manipulating XLSX data using RODBC, however a limitation which appears to be driver based is that you can't clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") >

When I run # mysql I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) What do I need to do? The install of MySQL was done as part of the Centos setup. Todd

Hi. I have a strange problem. I installed cacti, and set it up. When I click on the Plugins Management, I noticed Error "FATAL: Database or Table does not exist" Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database! SELinux is disabled. I logged to mysql as root and error is same. Command used is: CREATE TEMPORARY

Hi, somehow phpmyadmin messed things up when I was trying to modify a table. The table disappeared, and now it's impossible to re-create it: MariaDB [time]> create table etikettend_metainfo (userID integer(6) unsigned, stationsnummer integer(4) unsigned, primary key (userID)); ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo` (errno: 150 "Foreign key

Hi all, I've got a new server up, but it's not staying up.... After a day or so, it segfaults with: [Mar 22 23:17:49] WARNING[12177]: res_odbc.c:1406 _ast_odbc_request_obj2: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(a) Driver]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

hey guys My macbook pro 17 had to be taken back to apple beuase of a dud screen, so have had to install from macports again. When i attempt to create a mysql database with this: mysql5 -u root depot_development i get this: ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/opt/local/var/run/mysql5/mysqld.sock'' (2) any ideas? cheers! Adam --

I am trying to configure mysql to use a different datadir than default in order to move this to a larger volume. I have copied all mysql data from /var/lib/mysql to my new volume and ran both chown -R mysql:mysql * and chmod -R 660 * in order to setup correct ownership and rights for the data. It was working for a few days until today upon going into mysql and typing show databases, I receive

With my new Centos installation, I get the following error when I type in # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have Googled the error, but the results do not appear to be helpful Todd -- Ariste Software Petaluma, CA 94952 http://www.aristesoftware.com -------------- next part -------------- An HTML

Hi,   I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?   > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables    TABLE_CAT TABLE_SCHEM  TABLE_NAME TABLE_TYPE REMARKS 1 D:\\R files\\TestData        <NA>

Hi, I have tried to figure this out from the help files and lists but not managed it I can access a local MySQL database from R running on my Windows XP PC. What I want to do is access a MySQL database on a linux web server, for which I have admin access. I can't figure out how to set up odbcConnect. For local access I set up a dsn via the windows admin interface. I have tried to set up dsn

Dear List, I have a problem with RODBC on a Paradox-DB, sqlQuery, and special characters in table names. Unfortunately, some of the latter include the underscore <_>. And I am not able to change them. That's not a problem, when I quote the table name: > sqlQuery(channel2, 'SELECT * FROM "anmeldung-alt"') Btw, if I swap ' and " it does not work: >

I get the following errors when attempting an ODBC connection to a MySQL db. 1: [RODBC] ERROR: state HY000, Code 0, message [MySQL] [ODBC 3.51 Driver] Could not determine the driver name so could not lookup setup library. 2: ODBCConnection failed in: odbcDriverConnect(st, case=case, believeNRows=believeNRows). Win XP sp2 MySQL 4.1.8 My SQLODBC 3.51.10 Package RODBC (latest) is installed.

I just did an unwanted mysql upgrade and am now unable to start the mysql service. After doing some searching the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start

On 08/17/2015 10:57 AM, Tony Mountifield wrote: > I recently applied updates to a CentOS 5 box running MySQL. I've discovered > that the new version of openssl, 0.9.8e-36.0.1.el5_11, breaks MySQL SSL > connections. > > If I rename /lib/libssl.so.0.9.8e and replace it with the old version of > that file from openssl-0.9.8e-27.el5_10.1 (not sure if that is the next >

In article <55D2174F.70509 at centos.org>, Johnny Hughes <johnny at centos.org> wrote: > On 08/17/2015 11:19 AM, Johnny Hughes wrote: > > On 08/17/2015 10:57 AM, Tony Mountifield wrote: > >> I recently applied updates to a CentOS 5 box running MySQL. I've discovered > >> that the new version of openssl, 0.9.8e-36.0.1.el5_11, breaks MySQL SSL > >>

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts