sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[Leandro G. <le...@de...>]

Copy the patch to root source folder of sqlrelay, enter the directory 
and type:

patch -p1 < fix-wnolongdouble.dpatch

The patch works for me using sqlrelay 0.39.4 in ubuntu 8.04



moaiamorfo escreveu:
>> Try this patch...
>>     
>
> thanks, how can I use it?
> @leonid: lines commented, but without any results.
>
> thanks to all. :)
>
>   

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

> Try this patch...

thanks, how can I use it?
@leonid: lines commented, but without any results.

thanks to all. :)

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[Leandro G. <le...@de...>]

#! /bin/sh /usr/share/dpatch/dpatch-run
## fix-wlongnodouble.dpatch by Albert Damen <al...@gm...>
##
## All lines beginning with `## DP:' are a description of the patch.
## DP: Do not use -Wno-long-double and remove the test for usability
## DP: of this flag. The test succeeds but the build still fails.

@DPATCH@
diff -urNad sqlrelay-0.38~/config.mk.in sqlrelay-0.38/config.mk.in
--- sqlrelay-0.38~/config.mk.in	2006-10-04 02:53:01.000000000 +0200
+++ sqlrelay-0.38/config.mk.in	2008-03-29 15:00:50.000000000 +0100
@@ -45,8 +45,8 @@
 STATICLINK = @STATICLINK@
 
 # debug and optimization flags (-g, -O2, etc.)
-CXXFLAGS = @CXXFLAGS@ @WALL@ @PIPE@ @WNOLONGDOUBLE@
-CFLAGS = @CFLAGS@ @WALL@ @PIPE@ @WNOLONGDOUBLE@
+CXXFLAGS = @CXXFLAGS@ @WALL@ @PIPE@
+CFLAGS = @CFLAGS@ @WALL@ @PIPE@
 
 # libtool command
 LIBTOOL = @LIBTOOL@
diff -urNad sqlrelay-0.38~/configure sqlrelay-0.38/configure
--- sqlrelay-0.38~/configure	2008-03-29 11:38:21.000000000 +0100
+++ sqlrelay-0.38/configure	2008-03-29 15:00:30.000000000 +0100
@@ -20260,78 +20260,6 @@
 
 
 
-echo "$as_me:$LINENO: checking for -Wno-long-double option" >&5
-echo $ECHO_N "checking for -Wno-long-double option... $ECHO_C" >&6
-
-SAVECPPFLAGS="$CPPFLAGS"
-SAVELIBS="$LIBS"
-SAVE_LD_LIBRARY_PATH="$LD_LIBRARY_PATH"
-CPPFLAGS="-Wno-long-double"
-LIBS=""
-LD_LIBRARY_PATH=""
-export LD_LIBRARY_PATH
-cat >conftest.$ac_ext <<_ACEOF
-/* confdefs.h.  */
-_ACEOF
-cat confdefs.h >>conftest.$ac_ext
-cat >>conftest.$ac_ext <<_ACEOF
-/* end confdefs.h.  */
-#include <stdio.h>
-int
-main ()
-{
-printf("hello");
-  ;
-  return 0;
-}
-_ACEOF
-rm -f conftest.$ac_objext conftest$ac_exeext
-if { (eval echo "$as_me:$LINENO: \"$ac_link\"") >&5
-  (eval $ac_link) 2>conftest.er1
-  ac_status=$?
-  grep -v '^ *+' conftest.er1 >conftest.err
-  rm -f conftest.er1
-  cat conftest.err >&5
-  echo "$as_me:$LINENO: \$? = $ac_status" >&5
-  (exit $ac_status); } &&
-	 { ac_try='test -z "$ac_cxx_werror_flag"
-			 || test ! -s conftest.err'
-  { (eval echo "$as_me:$LINENO: \"$ac_try\"") >&5
-  (eval $ac_try) 2>&5
-  ac_status=$?
-  echo "$as_me:$LINENO: \$? = $ac_status" >&5
-  (exit $ac_status); }; } &&
-	 { ac_try='test -s conftest$ac_exeext'
-  { (eval echo "$as_me:$LINENO: \"$ac_try\"") >&5
-  (eval $ac_try) 2>&5
-  ac_status=$?
-  echo "$as_me:$LINENO: \$? = $ac_status" >&5
-  (exit $ac_status); }; }; then
-  WNOLONGDOUBLE="-Wno-long-double"
-else
-  echo "$as_me: failed program was:" >&5
-sed 's/^/| /' conftest.$ac_ext >&5
-
-WNOLONGDOUBLE=""
-fi
-rm -f conftest.err conftest.$ac_objext \
-      conftest$ac_exeext conftest.$ac_ext
-CPPFLAGS="$SAVECPPFLAGS"
-LIBS="$SAVELIBS"
-LD_LIBRARY_PATH="$SAVE_LD_LIBRARY_PATH"
-export LD_LIBRARY_PATH
-
-if ( test -n "$WNOLONGDOUBLE" )
-then
-	echo "$as_me:$LINENO: result: yes" >&5
-echo "${ECHO_T}yes" >&6
-else
-	echo "$as_me:$LINENO: result: no" >&5
-echo "${ECHO_T}no" >&6
-fi
-
-
-
 echo "$as_me:$LINENO: checking for -Wall" >&5
 echo $ECHO_N "checking for -Wall... $ECHO_C" >&6
 
diff -urNad sqlrelay-0.38~/configure.in sqlrelay-0.38/configure.in
--- sqlrelay-0.38~/configure.in	2006-10-04 02:49:25.000000000 +0200
+++ sqlrelay-0.38/configure.in	2008-03-29 15:00:30.000000000 +0100
@@ -455,7 +455,6 @@
 FW_CHECK_UNAME
 
 FW_CHECK_PIPE
-FW_CHECK_WNOLONGDOUBLE
 FW_CHECK_WALL
 FW_CHECK_PTHREAD_COMPILE
 echo "******************************"

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[leonid b. <leo...@gm...>]

Find this in config.mk and delete

2008/7/7 moaiamorfo <moa...@gm...>:

> > I used latest repo version
>
> I'm trying to compile this version, under Ubuntu 8.04:
> http://prdownloads.sourceforge.net/sqlrelay/sqlrelay-0.39.4.tar.gz?download
> but, when I type make I get:
>
> At global scope:
> cc1plus: error: unrecognized command line option "-Wno-long-double"
> make[2]: *** [sqlrlistener.lo] Error 1
> make[2]: Leaving directory
> `/home/antonio/Scrivania/sqlrelay-0.39.4/src/listener'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/home/antonio/Scrivania/sqlrelay-0.39.4/src'
> make: *** [all] Error 2
>
> how can I fix?
> thanks a lot. :)
>
> --
> Antonio Fittipaldi
> http://www.python-it.org # il punto di riferimento italiano per gli
> appassionati di Python
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

> I used latest repo version

I'm trying to compile this version, under Ubuntu 8.04:
http://prdownloads.sourceforge.net/sqlrelay/sqlrelay-0.39.4.tar.gz?download
but, when I type make I get:

At global scope:
cc1plus: error: unrecognized command line option "-Wno-long-double"
make[2]: *** [sqlrlistener.lo] Error 1
make[2]: Leaving directory
`/home/antonio/Scrivania/sqlrelay-0.39.4/src/listener'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/antonio/Scrivania/sqlrelay-0.39.4/src'
make: *** [all] Error 2

how can I fix?
thanks a lot. :)

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[leonid b. <leo...@gm...>]

I used latest repo version

2008/7/7 moaiamorfo <moa...@gm...>:

> > Solve this problem by compiling this package myself
>
> so, without using the repo version?
> @Sébastien: I tryed, but without any results.
>
> thanks.
>
> --
> Antonio Fittipaldi
> http://www.python-it.org # il punto di riferimento italiano per gli
> appassionati di Python
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

> Solve this problem by compiling this package myself

so, without using the repo version?
@Sébastien: I tryed, but without any results.

thanks.

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[leonid b. <leo...@gm...>]

Solve this problem by compiling this package myself

2008/7/4 moaiamorfo <moa...@gm...>:

> hi all,
>
> I'm trying to use sqlrelay (version 1:0.38-3ubuntu-1 installed from
> Hardy's repo) under Ubuntu.
> but when I type (as root or as normal user)
>
> sqlr-listener -id myid
>
> I get this error:
>
> Could not open: /var/cache/sqlrelay/tmp/ipc/myid
> Make sure that the file and directory are readable and writable.
>
> unsuccessful completion
>
> sqlr-listener failed to start.
>
> I searched around and I read about manual folders' structure creation
> (/var/cache/sqlrelay/tmp): I did it, but without any results.
>
> can anyone help me fixing this?
> thanks a lot. :)
>
> --
> Antonio Fittipaldi
> http://www.python-it.org # il punto di riferimento italiano per gli
> appassionati di Python
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] Use with standard programs

[Alain M. <al...@po...>]

Hi,

is it possible to access SqlRelay (and it's backend database) using 
standard programs like Delphi or report manager?

Is this what the ODBC API is about? If so, how far is it in the Todo list?

Thanks for any information,
Alain

[Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

[moaiamorfo <moa...@gm...>]

hi all,

I'm trying to use sqlrelay (version 1:0.38-3ubuntu-1 installed from
Hardy's repo) under Ubuntu.
but when I type (as root or as normal user)

sqlr-listener -id myid

I get this error:

Could not open: /var/cache/sqlrelay/tmp/ipc/myid
Make sure that the file and directory are readable and writable.

unsuccessful completion

sqlr-listener failed to start.

I searched around and I read about manual folders' structure creation
(/var/cache/sqlrelay/tmp): I did it, but without any results.

can anyone help me fixing this?
thanks a lot. :)

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python

[Sqlrelay-discussion] Working instance becomes problematic w/o obvious reason

[Christian H. <chr...@bo...>]

Hi all


We are running sql-relay 0.39.4 with perl and mysql 5.0 with multiple
server-connections with upwards 100K queries per day.

While everything works fine, we do have, from time to time, the problem
that one of the connections simply hangs for whatever reason.

Once this problem occurs we get a "Couldnt connect to the listener"
error message. After running sqlr-stop and sqlr-start the problem is
solved again. 

We have spent weeks examining this problem but couldnt get any further.
There simply is no obvious reason. The connection works fine and then
suddenly the listener hangs it self. We first figured we created too
much traffic, but the problem also occurs at times when there is less
than 5 queries per minute. 

We also tried to create this problem manually to verify it or to examine
it. However, we failed. We simply are not able to cause the
listener/connection to hang it self and to report this error. Even after
pushing the multiple amount of statements sqlr usually has to process.
Nothing. We can not recreate the problem manually


Today, for the first time, while being logged in to the server (console)
and running sqlr-stop & sqlr-start on the specific instance after we had
the problem, I got error messages dumped to the console. Unfortunately,
I could not find any hint on the web when researching the error string:

handleQuery called with reexceute flag set to 0
processQuery got ... [correct SQL Statement]

Excerpt from the sqlrelay.conf file :

<instance id="d02w" port="9022" socket="" dbase="mysql" connections="10"
maxconnections="10" maxqueuelength="10" growby="2" ttl="10"
endofsession="commit" sessiontimeout="600" runasuser="sqlrelay"
runasgroup="sqlrelay" cursors="5" authtier="listener" handoff="pass"
deniedips="" allowedips="127.0.0.1" addresses="127.0.0.1" debug="none"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
listenertimeout="2">
     <users>
             <user user="XXXXXXXXXX" password="XXXXXXXX"/>
     </users>
     <connections>
        <connection connectionid="d02w"
string="user=XXXXXX;password=XXXXX;db=flyocache4w;host=172.16.37.XXX;port=XXXX;" metric="10" behindloadbalancer="no"/>
     </connections>
     <router>
     </router>    
</instance>


Anybody has any hints ?

TIA,

Chris

Re: [Sqlrelay-discussion] How to reduce the font size in sqlr-config-gtk

[Frank J. <fr...@jo...>]

On 6/26/08, David Muse <dav...@fi...> wrote:
> The font size isn't hardcoded anywhere, but that program is really old
>  and uses gtk-1.2 I think, an ancient version of gtk which has it's own
>  themes and font settings that aren't compatible with modern gtk themes.
>
>  There is some way to configure it's font settings, I think with a .gtkrc
>  file or maybe a .gtkrc-1.2 file or something like that.

This works, pasted into .gtkrc.mine:

style "default-text" {
fontset = "-adobe-helvetica-medium-o-normal--10-100-75-75-p-57-iso10646-1,\
-*-r-*-iso10646-1,*"
}
class "GtkWidget" style "default-text"

Now I just tried to recompile on Ubuntu Hardy, hoping to fix the
segfault issue, as the Ubuntu package is version 0.38, and I get:

sqlrlistener.C:624: warning: comparison between signed and unsigned
integer expressions
At global scope:
cc1plus: error: unrecognized command line option "-Wno-long-double"

Which appears to have been fixed, according to google but it still occurs here?

Cheers,

Frank

Re: [Sqlrelay-discussion] Using INOUT variables in oracle

[leonid b. <leo...@gm...>]

Im'm solved this problem with patch
http://sourceforge.net/tracker/index.php?func=detail&aid=1652852&group_id=10238&atid=360238(whitch
was buggy). But this patch not solves all problems. Inout variables
now work only with String and Double, but Integer not working. And there is
one thing, when using defineOutputBindDouble(variable,scale,precission) you
MUST set scale and precission, or you get error.

Now i'm trying to solve another trouble which explained here
http://sourceforge.net/tracker/index.php?func=detail&aid=1906458&group_id=10238&atid=360238
.

2008/6/26 David Muse <dav...@fi...>:

> Hmmm.  I'm surprised that doesn't work.  I've done it that way before,
> though admittedly not lately.  Are you calling getOutputBindDouble()
> after running the query?
>
> David Muse
> dav...@fi...
>
> On Tue, 2008-06-17 at 15:01 +0400, leonid bugaev wrote:
> > How to use this type of variables?
> > Simple
> > inputBind(variable, value)
> > defineOutputBindDouble(variable)
> >
> > won't work :(
> > __________________________________________________
> > D O T E A S Y - "Join the web hosting revolution!"
> > http://www.doteasy.com
> > -------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://sourceforge.net/services/buy/index.php
> > _______________________________________________ Sqlrelay-discussion
> mailing list Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>             http://www.doteasy.com
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Using INOUT variables in oracle

[David M. <dav...@fi...>]

Hmmm.  I'm surprised that doesn't work.  I've done it that way before,
though admittedly not lately.  Are you calling getOutputBindDouble()
after running the query?

David Muse
dav...@fi...

On Tue, 2008-06-17 at 15:01 +0400, leonid bugaev wrote:
> How to use this type of variables?
> Simple 
> inputBind(variable, value)
> defineOutputBindDouble(variable)
> 
> won't work :(
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
> http://www.doteasy.com 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] what is the defaultid?

[David M. <dav...@fi...>]

This typically means that sqlrelay is set up to start new connections on
demand, but the sqlrelay.conf file isn't readable by whatever user
sqlrelay is configured to run as.

Similar to this issue:
http://sqlrelay.sourceforge.net/sqlrelay/faq.html#nobody

Check into that and let me know if that solves the problem or not.

David Muse
dav...@fi...

On Tue, 2008-06-17 at 13:37 -0700, tyju tiui wrote:
> Hello again,
> 
> I was seeing some strange behavior when running some tests. Every third query would fail?
> I noticed a log message when restarting sqlrelay about the defaultid:
> 
>     Starting 1 connections to defaultid
>      Starting cache manager:
>       sqlr-cachemanager
>     Warning: using default id.
> 
> What is this defaultid and how can I stop it from messing with my queries?
> 
> Thanks,
> 
> Ty
> 
> 
> 
>       
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] sqlrelay: dtd validation error

[David M. <dav...@fi...>]

There's a bug in the DTD.  It will be fixed in the next release, but try
this...

Edit /etc/sqlrelay/sqlrelay.dtd and change the 2nd line to read:

<!ELEMENT instance (users,connections?,router?)>

That should take care of the issue.  Let me know though.

David Muse
dav...@fi...


On Tue, 2008-06-17 at 12:38 -0700, tyju tiui wrote:
> Hi,
> 
> I'm evaluating sqlrelay for use with mod_perl for connection pooling and I'm having a problem with configuration.
> I've copied the example line for line and just added my MySQL settings. When I try to start sqlrelay I get a dtd validation error:
> 
> 
>     Starting SQL Relay ... /etc/sqlrelay/sqlrelay.conf:14: element instance: validity error : Element instance content does not follow the DTD, expecting
>     (users , connections , router), got (users connections )
>             </instance>
>                             ^
>     SQL Relay not started.
> 
> 
> I looked at the dtd and sure enough a router node is required for every instance.
> I added an empty <router/> tag and everything started up and seems to be working just fine.
> Is this OK? Do I need to put something in that router node to  properly setup sqlrelay?
> 
> By the way I'm using sql relay 0.38 w/ MySQL 5.0 (the defaults that come with Ubuntu 8.04 using apt-get)
> 
> Thanks,
> 
> Ty
> 
> 
> 
>       
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

Re: [Sqlrelay-discussion] How to reduce the font size in sqlr-config-gtk

[David M. <dav...@fi...>]

The font size isn't hardcoded anywhere, but that program is really old
and uses gtk-1.2 I think, an ancient version of gtk which has it's own
themes and font settings that aren't compatible with modern gtk themes.

There is some way to configure it's font settings, I think with a .gtkrc
file or maybe a .gtkrc-1.2 file or something like that.  But really,
that program just needs to be updated to use a modern toolkit and the
layout needs to be reformatted.  I have items on the todo list for that
but haven't gotten around to them yet.

I'm surprised about the segfault.  I'll look into that right away and
let you know what I find.

David Muse
dav...@fi...

On Thu, 2008-06-26 at 16:00 +0100, Frank Joerdens wrote:
> My laptop does 1280x800 but that doesn't work when running
> /usr/bin/sqlr-config-gtk since not all fields are visible - it's cut
> off at the top and at the bottom (works with a larger external monitor
> that does 1280x1024). It doesn't respond to any Gnome font settings.
> Is the font size hard coded somewhere? If so, where? Then I could just
> recompile with a smaller font. Otherwise, where would I configure the
> font size so that the entire applet would become visible onscreen with
> 1280x800?
> 
> Also, it segfaults when creating a new file on Ubuntu Hardy, or when
> creating a new connection on Debian/lenny.
> 
> Cheers, Frank
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com

[Sqlrelay-discussion] How to reduce the font size in sqlr-config-gtk

[Frank J. <fr...@jo...>]

My laptop does 1280x800 but that doesn't work when running
/usr/bin/sqlr-config-gtk since not all fields are visible - it's cut
off at the top and at the bottom (works with a larger external monitor
that does 1280x1024). It doesn't respond to any Gnome font settings.
Is the font size hard coded somewhere? If so, where? Then I could just
recompile with a smaller font. Otherwise, where would I configure the
font size so that the entire applet would become visible onscreen with
1280x800?

Also, it segfaults when creating a new file on Ubuntu Hardy, or when
creating a new connection on Debian/lenny.

Cheers, Frank

Re: [Sqlrelay-discussion] Unable to build sqlrelay

[leonid b. <leo...@gm...>]

Hi. Remove this in config.mk

2008/6/24 tyju tiui <jck...@ya...>:

> Hi,
>
> I'm having some trouble building the latest sql relay from src:
>
>    cc1plus: error: unrecognized command line option "-Wno-long-double"
>
> Any ideas?
>
> Thanks,
>
> Ty
>
>
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] Unable to build sqlrelay

[tyju t. <jck...@ya...>]

Hi,

I'm having some trouble building the latest sql relay from src:

    cc1plus: error: unrecognized command line option "-Wno-long-double"

Any ideas?

Thanks,

Ty



      

Re: [Sqlrelay-discussion] LD_PRELOAD problem

[D. V. <as...@gm...>]

On Thu, Jun 19, 2008 at 11:40 AM, Jani Ollikainen
<jan...@pr...> wrote:
> Dániel Vásárhelyi wrote:
>> - i'll try to get mysql-proxy work with this, but as mysql-proxy
>> executes queries as well as accepts them, i'm not sure what will be
>> the results of the LD_PRELOAD tweak
> Tested this just now..
> So seems that no luck:)
Hmmm... This's sad, as i cannot get r=1 lamp so-called "developers"
using any other method of accessing database than mysql_p?connect :(

asd
-- 
Dániel Vásárhelyi

"He who asks a question is a fool for five minutes; he who does not
ask a question remains a fool forever"
Chinese proverb

Re: [Sqlrelay-discussion] LD_PRELOAD problem

[Jani O. <jan...@pr...>]

Dániel Vásárhelyi wrote:
> - i'll try to get mysql-proxy work with this, but as mysql-proxy
> executes queries as well as accepts them, i'm not sure what will be
> the results of the LD_PRELOAD tweak

Tested this just now..

Shells 1# and 2# both root.

1# export LD_PRELOAD=/usr/lib/libmysql50sqlrelay.so
1# ldd mysql-proxy
         linux-gate.so.1 =>  (0x00242000)
         /usr/lib/libmysql50sqlrelay.so (0x00608000)
         libevent-1.1a.so.1 => /usr/lib/libevent-1.1a.so.1 (0x0074a000)
         libglib-2.0.so.0 => /lib/libglib-2.0.so.0 (0x00d3c000)
         libc.so.6 => /lib/libc.so.6 (0x00ae8000)
         libsqlrclient-0.39.4.so.1 => /usr/lib/libsqlrclient-0.39.4.so.1 
(0x0040f000)
         librudiments-0.31.so.1 => /usr/lib/librudiments-0.31.so.1 
(0x00110000)
         libpthread.so.0 => /lib/libpthread.so.0 (0x00c78000)
         libssl.so.6 => /lib/libssl.so.6 (0x003b8000)
         libcrypto.so.6 => /lib/libcrypto.so.6 (0x00243000)
         libz.so.1 => /usr/lib/libz.so.1 (0x00cd3000)
         libpcre.so.0 => /lib/libpcre.so.0 (0x0018c000)
         librt.so.1 => /lib/librt.so.1 (0x00ce8000)
         libcrypt.so.1 => /lib/libcrypt.so.1 (0x00cf3000)
         libdl.so.2 => /lib/libdl.so.2 (0x00c2a000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00428000)
         libm.so.6 => /lib/libm.so.6 (0x00c91000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x001a9000)
         /lib/ld-linux.so.2 (0x00ac6000)
         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x001b5000)
         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00513000)
         libcom_err.so.2 => /lib/libcom_err.so.2 (0x00ae3000)
         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x001e3000)
         libresolv.so.2 => /lib/libresolv.so.2 (0x00209000)
         libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x0021c000)
         libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00225000)
         libselinux.so.1 => /lib/libselinux.so.1 (0x00cba000)
         libsepol.so.1 => /lib/libsepol.so.1 (0x00c30000)
1# ./mysql-proxy./mysql-proxy 
--proxy-backend-addresses=/var/lib/mysql/mysql.sock

2# mysql -h 127.0.0.1 -P 4040 database

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 143117 to server version: 5.0.22-log

1# ./mysql-proxy --proxy-backend-addresses=/tmp/sqlrelay.sock

2# mysql -h 127.0.0.1 -P 4040 database
(no connection)

-- Lets test if it even working:)
2# export LD_PRELOAD=/usr/lib/libmysql50sqlrelay.so
2# mysql -S /tmp/sqlrelay.sock database

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 0 to server version: 5.0.0

So seems that no luck:)


> On Thu, Jun 12, 2008 at 11:41 PM, David Muse <dav...@fi...> wrote:
>> It looks like the LD_PRELOAD part is working.  The:
>>
>> Failed to get a cursor id.
>>  A network error may have ocurred.
>>
>> Error is a sqlrelay client error, not a mysql error.  So I believe that
>> the mysql client is using the drop-in replacement library.  The
>> host/port/user/password may not be correct.  Double-check those.
>>
>> David Muse
>> dav...@fi...
>>
>> On Fri, 2008-06-06 at 09:35 +0200, Dániel Vásárhelyi wrote:
>>> Hello,
>>>
>>> I've got a problem with the mysql drop-in replacement library on Debian 4.0
>>>
>>> Basically this:
>>> vm-99:~# ldd `which mysql` | grep sql
>>>         libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d0a000)
>>> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 ldd `which
>>> mysql` | grep sql
>>>         /usr/lib/libmysql50sqlrelay-0.37.1.so.1 (0xb7eea000)
>>>         libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7c9a000)
>>>         libsqlrclient-0.37.1.so.1 =>
>>> /usr/lib/libsqlrclient-0.37.1.so.1 (0xb79ca000)
>>>
>>> It seems regardless I specify the mysql replacement library, the mysql
>>> client library (which I've used for testing) was somehow "forced" to
>>> use the original one.
>>>
>>> It isn't working:
>>>
>>> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 mysql
>>> --host=localhost --port=9000 --user=root -p
>>> Enter password:
>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>> Your MySQL connection id is 0
>>> Server version: 5.0.0
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>
>>> mysql> show tables;
>>> ERROR:
>>> Failed to get a cursor id.
>>>  A network error may have ocurred.
>>> mysql>
>>>
>>> Do anyone have an idea why does it happen?
>>>
>>> asd
>>
>>
>> __________________________________________________
>> D O T E A S Y - "Join the web hosting revolution!"
>>             http://www.doteasy.com
>>
>> -------------------------------------------------------------------------
>> Check out the new SourceForge.net Marketplace.
>> It's the best place to buy or sell services for
>> just about anything Open Source.
>> http://sourceforge.net/services/buy/index.php
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
> 
> 
> 

Re: [Sqlrelay-discussion] LD_PRELOAD problem

[D. V. <as...@gm...>]

It was. Later I managed to get it working, but unfortunately got
informed by a later letter of yours, that PHP cannot be subject of
this 'cheat', as it uses it's own libraries to connect to mysql.

My notes/questions on it:
- can it be workarounded by starting PHP as standalone process (for
example, as FastCGI)
- i'll try to get mysql-proxy work with this, but as mysql-proxy
executes queries as well as accepts them, i'm not sure what will be
the results of the LD_PRELOAD tweak

asd

On Thu, Jun 12, 2008 at 11:41 PM, David Muse <dav...@fi...> wrote:
> It looks like the LD_PRELOAD part is working.  The:
>
> Failed to get a cursor id.
>  A network error may have ocurred.
>
> Error is a sqlrelay client error, not a mysql error.  So I believe that
> the mysql client is using the drop-in replacement library.  The
> host/port/user/password may not be correct.  Double-check those.
>
> David Muse
> dav...@fi...
>
> On Fri, 2008-06-06 at 09:35 +0200, Dániel Vásárhelyi wrote:
>> Hello,
>>
>> I've got a problem with the mysql drop-in replacement library on Debian 4.0
>>
>> Basically this:
>> vm-99:~# ldd `which mysql` | grep sql
>>         libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d0a000)
>> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 ldd `which
>> mysql` | grep sql
>>         /usr/lib/libmysql50sqlrelay-0.37.1.so.1 (0xb7eea000)
>>         libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7c9a000)
>>         libsqlrclient-0.37.1.so.1 =>
>> /usr/lib/libsqlrclient-0.37.1.so.1 (0xb79ca000)
>>
>> It seems regardless I specify the mysql replacement library, the mysql
>> client library (which I've used for testing) was somehow "forced" to
>> use the original one.
>>
>> It isn't working:
>>
>> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 mysql
>> --host=localhost --port=9000 --user=root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 0
>> Server version: 5.0.0
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> show tables;
>> ERROR:
>> Failed to get a cursor id.
>>  A network error may have ocurred.
>> mysql>
>>
>> Do anyone have an idea why does it happen?
>>
>> asd
>
>
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>             http://www.doteasy.com
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>



-- 
Dániel Vásárhelyi

"He who asks a question is a fool for five minutes; he who does not
ask a question remains a fool forever"
Chinese proverb

[Sqlrelay-discussion] what is the defaultid?

[tyju t. <jck...@ya...>]

Hello again,

I was seeing some strange behavior when running some tests. Every third query would fail?
I noticed a log message when restarting sqlrelay about the defaultid:

    Starting 1 connections to defaultid
     Starting cache manager:
      sqlr-cachemanager
    Warning: using default id.

What is this defaultid and how can I stop it from messing with my queries?

Thanks,

Ty



      

[Sqlrelay-discussion] sqlrelay: dtd validation error

[tyju t. <jck...@ya...>]

Hi,

I'm evaluating sqlrelay for use with mod_perl for connection pooling and I'm having a problem with configuration.
I've copied the example line for line and just added my MySQL settings. When I try to start sqlrelay I get a dtd validation error:


    Starting SQL Relay ... /etc/sqlrelay/sqlrelay.conf:14: element instance: validity error : Element instance content does not follow the DTD, expecting
    (users , connections , router), got (users connections )
            </instance>
                            ^
    SQL Relay not started.


I looked at the dtd and sure enough a router node is required for every instance.
I added an empty <router/> tag and everything started up and seems to be working just fine.
Is this OK? Do I need to put something in that router node to  properly setup sqlrelay?

By the way I'm using sql relay 0.38 w/ MySQL 5.0 (the defaults that come with Ubuntu 8.04 using apt-get)

Thanks,

Ty