similar to: changed datadir

Displaying 20 results from an estimated 2000 matches similar to: "changed datadir"

2010 Jun 25
1
Configure WAN Phone
Hi, I am relatively new to Asterisk and am looking for help in configuring an IP based phone. This phone is not on the same subnet as the PBX. I read that there could be an issue with NAT so I am bypassing this by connecting temporarily with an Internet IP. So far, I have configured the server extension with the phone MAC address along with configuring the phone unit with IP, Gateway and SIP
2009 Nov 05
4
MySQL installation problem
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
2009 Apr 27
1
RODBC - XLSX files - dropping/clearing sheets
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") >
2007 Jan 27
2
Starting MySQL
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
2014 Feb 13
2
MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem
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
2012 Mar 22
2
MySQL query profiling
Hi, I recently upgraded to the latest MySQL 5.0.95 package as part of the CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for performance testing. However, if I try to use any of the profiling functionality I get this error: ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working Oddly
2019 Apr 24
2
mariadb: How to delete foreign key constraint from non-existing table?
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
2016 Mar 23
3
ODBC crashing asterisk
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
2015 Aug 17
3
C5 recent openssl update breaks mysql SSL connection
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
2007 Jan 17
1
error when trying to create mysql database
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 --
2011 Mar 26
1
Error 2002 with MySQL on a new Centos 5.5 installation
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
2009 Aug 13
1
using the RODBC for excel
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>
2012 Jun 21
1
RODBC to access a web server
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
2009 Sep 15
1
quoting a table name due to a special character in sqlQuery (RODBC)
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: >
2005 Feb 01
1
RODBC - connect is failing
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.
2009 Mar 05
2
Can't connect to local MySQL server through socket...
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
2015 Aug 17
2
C5 recent openssl update breaks mysql SSL connection
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
2008 Sep 03
23
error connecting to mysql
i was trying to setup an application checked out from svnin my local machine. i managed to do all that is required except when it came to the step of creating databases for the application, when i tried to connect to mysql i got this error ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock'' (2) i have spent more than 5
2019 Apr 18
2
ssl_verify_server_cert against SAN?
2016 Feb 09
2
CDR ODBC error
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