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