English
| Showing entries 1 to 16 |
In a test lab, we ran into a situation where the connection between our Cisco Access Registrar (AAA) server and MySQL server was timing out. This forced the server to reconnect and resulted in the following errors:
name/radius/1 Error Server 0 ODBC client (DataSource 'my_odbc', Connection 8): SQLExecute failed: SQLState:08S01 NativeError:2006 ErrorText:[MySQL][ODBC 3.51 Driver][mysqld-5.0.21-log] MySQL server has gone away
name/radius/1 Error Server 0 Service odbc has no active remote servers availableObviously, the MySQL server was still there, but after the wait_timeout expires, the server severs the idle connections. By default, the wait_timeout is set to 8 hours. This is obviously much longer than is usually necessary, but in our test lab, it caused problems every morning.
The fix is
[Read more...]I was asked today to confirm the operation of INET_ATON() and INET_NTOA() functions for converting IP4 strings to numeric representations. My tests on the machine I was just connected to at the very instant reported the following results.
mysql> SELECT VERSION();
+-----------------+
| VERSION() |
+-----------------+
| 5.1.31-1ubuntu2 |
+-----------------+
1 row in set (0.00 sec)
mysql> SELECT INET_ATON('74.165.97.204') AS ipn;
+------------+
| ipn |
+------------+
| 1252352460 |
+------------+
1 row in set (0.00 sec)
mysql> SELECT INET_NTOA(1252352460) as ipa;
+---------------+
| ipa |
+---------------+
| 74.165.97.204 |
+---------------+
1 row in set (0.01 sec)
The results on the client via ODBC using MySQL 5.0.45 was?
ipn 1252352460 ipa 37342E3136352E39372E323034
What is causing this? It was
[Read more...]The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won’t argue about its performance, limits, or relevance. It serves a few purposes; set it up and you’ll be able, for example, to create database links between Oracle and MySQL. After all, wouldn’t it be nice if you could run some of the following SQL statements?
select o.col1, m.col1 from oracle_tab
o, mysql_tab@mysql m where o.col1=m.col1;insert into oracle_tab (select * from mysql_tab@mysql);This post is intended to share, the same way
[Read more...]Old Town White Coffee is a place we’ve been hanging out a lot at. Its got wifi, power sockets, couches, good food and drink, great eye candy (bonus!), and is open till late.
Today, we found out that all their PCs that hold the orders (order{1,2,3,4}) have Samba shares. Open to all, naturally.
They use Crystal Reports. Have a custom front-end, with appropriate touch screen drivers, but the back-end is pretty stock. They use MySQL, Connector/ODBC 3.51.12 and also use SQLyog 5.30. I know the system is designed and deployed by NIT, it looks like their F&B POS.
Their use of MySQL (schema wise), includes using VIEWs, stored procedures and triggers (on UPDATE and DELETE).
I wonder how many point of sales systems are powered by open source
[Read more...]qt-mac-free-3.3.8.tar.gz. you will need to apply this patch to allow it to compile on leopard. i configure it with some options to eliminate stuff i don’t care about, and to build statically:./configure[Read more...]
-0
ODBC_BOTH_DSN, which means you have to keep resetting it to the correct value after nearly every installer api call. this problem is platform-agnostic — the iodbc code is just plain wrong.
-0
-0
libmysql, the c library that defines the client interface to mysql, and the mysql command-line utilities. there are about 120 active bugs in those areas right now, so the first task will be getting that down to a more manageable number.| Showing entries 1 to 16 |