sqlrelay-discussion Mailing List for SQL Relay (Page 7)
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion — Discussion of topics related to SQL Relay
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(20) |
Mar
(27) |
Apr
(17) |
May
(32) |
Jun
(45) |
Jul
(49) |
Aug
(68) |
Sep
(44) |
Oct
(29) |
Nov
(64) |
Dec
(25) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(61) |
Feb
(22) |
Mar
(25) |
Apr
(31) |
May
(18) |
Jun
(28) |
Jul
(19) |
Aug
(16) |
Sep
(8) |
Oct
(17) |
Nov
(32) |
Dec
(4) |
| 2007 |
Jan
(20) |
Feb
(25) |
Mar
(5) |
Apr
(12) |
May
(11) |
Jun
(18) |
Jul
(16) |
Aug
(22) |
Sep
(37) |
Oct
(20) |
Nov
(11) |
Dec
(2) |
| 2008 |
Jan
(11) |
Feb
(33) |
Mar
(12) |
Apr
(18) |
May
(22) |
Jun
(31) |
Jul
(23) |
Aug
(6) |
Sep
|
Oct
(10) |
Nov
(22) |
Dec
|
| 2009 |
Jan
(12) |
Feb
(8) |
Mar
(11) |
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(27) |
Aug
(2) |
Sep
(10) |
Oct
(5) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(11) |
Feb
(18) |
Mar
(10) |
Apr
(28) |
May
(28) |
Jun
|
Jul
(27) |
Aug
(9) |
Sep
(21) |
Oct
(2) |
Nov
(2) |
Dec
(11) |
| 2011 |
Jan
|
Feb
(2) |
Mar
(4) |
Apr
(2) |
May
(2) |
Jun
(44) |
Jul
(9) |
Aug
(2) |
Sep
(12) |
Oct
(7) |
Nov
(11) |
Dec
(7) |
| 2012 |
Jan
(5) |
Feb
|
Mar
(9) |
Apr
(9) |
May
(12) |
Jun
|
Jul
(13) |
Aug
(3) |
Sep
(3) |
Oct
(1) |
Nov
(1) |
Dec
(10) |
| 2013 |
Jan
(21) |
Feb
(3) |
Mar
(4) |
Apr
|
May
(3) |
Jun
(2) |
Jul
(3) |
Aug
(3) |
Sep
(3) |
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(7) |
Feb
|
Mar
(1) |
Apr
|
May
(2) |
Jun
|
Jul
(4) |
Aug
(2) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Renat S. <sr...@st...> - 2011-11-10 15:40:13
|
Hello David, We've discovered weird problem in sqlrelay. In some circumstances forked listener removes unix socket file. It happens in alarm handler, when forked listener recieves SIGALRM and calls staticlistener's destructor. You've already put some protection for pidfile, shared memory and semaphores, but not for "unixport". As a result listener stops getting new connections by the local socket, though continues to accept connection by tcp. Please look at the patch attached. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2011-11-10 10:49:33
|
Hello David, Have you seen my patches? What are you thoughts? -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: David M. <dav...@fi...> - 2011-11-07 23:30:49
|
Hello Ashish, Sorry to take so long to respond. Let me know if you're still interested in using SQL Relay and I can help you out. There is no document that directly compares the MySQL proxy to using SQL Relay directly. If you use SQL Relay directly, you will have more control over a few things, like how many rows are cached on the client side and when the client disconnects from the server. There are also some mysql functions that have not been fully implemented, so if your app uses them, then they may or may not work as expected. I have done a lot of work on the proxy lately but the current version is a bit behind. With regard to the second question, what database are you using on the back end? Is it still MySQL, or another db? The most common issue people have when switching databases is the different bind-variable format between them. Again, I have done some work recently to remedy this problem but it's not in the released version. If you are still looking into SQL Relay, please send me some more information and I should be able to help you out. David Muse dav...@fi... On 10/17/2011 02:06 AM, Ashish Mukherjee wrote: > Hi, > > I have been using mysql with perl for my Web applications and recently > started exploring SQLRelay for load-balancing and connection pooling. > I would like to pose couple of questions related to this - > > 1) For the purpose for which I am evaluating SQL Relay > (load-balancing, connection pooling, read/write splitting), which is > the preferred option - MySQL Proxy or SQLRelay? Is there any > documented comparison of these? What are the known > advantages/disadvantages of picking one over the other? > > 2) I followed the documentation at > http://sqlrelay.sourceforge.net/sqlrelay/programming/perldbi.html to > use perl DBI with SQLRelay. However, DBD::SQLRelay does not seem to > understand what is passed to it and therefore does not work. Is there > any documentation of how I can get existing perl DBI code to work > unchanged with SQLRelay? > > Thanks, > Ashish > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2d-oct > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: David M. <dav...@fi...> - 2011-10-28 18:47:07
|
Weird. I just tested it and it crashes for me too. I should be able to figure it out pretty quickly. I'll let you know what I find. Dave On 10/26/2011 05:59 AM, Freako F. Freakolowsky wrote: > If it helps anyone, here's the GDB backtrace > > root@devwww:~# gdb sqlrsh > GNU gdb (GDB) 7.1-ubuntu > Copyright (C) 2010 Free Software Foundation, Inc. > License GPLv3+: GNU GPL version 3 or later > <http://gnu.org/licenses/gpl.html> > This is free software: you are free to change and redistribute it. > There is NO WARRANTY, to the extent permitted by law. Type "show copying" > and "show warranty" for details. > This GDB was configured as "x86_64-linux-gnu". > For bug reporting instructions, please see: > <http://www.gnu.org/software/gdb/bugs/>... > Reading symbols from /opt/sqlrelay/bin/sqlrsh...(no debugging symbols > found)...done. > (gdb) run localhost 9000 "" scott tiger > Starting program: /opt/sqlrelay/bin/sqlrsh localhost 9000 "" scott tiger > [Thread debugging using libthread_db enabled] > SQLRShell - Version 0.22 > Connected to: localhost:9000 as scott > > type help; for a help. > > 0> serverversion; > > Program received signal SIGSEGV, Segmentation fault. > 0x00007ffff555ae2d in free () from /lib/libc.so.6 > (gdb) backtrace > #0 0x00007ffff555ae2d in free () from /lib/libc.so.6 > #1 0x00007ffff79b287c in sqlrconnection::serverVersion() () from > /opt/sqlrelay/lib/libsqlrclient-0.43.so.1 > #2 0x0000000000403a41 in sqlrsh::serverversion(sqlrconnection*, > environment*) () > #3 0x0000000000403080 in sqlrsh::internalCommand(sqlrconnection*, > sqlrcursor*, environment*, char const*) () > #4 0x0000000000402a2f in sqlrsh::runCommand(sqlrconnection*, > sqlrcursor*, environment*, char const*) () > #5 0x000000000040413b in sqlrsh::interactWithUser(sqlrconnection*, > sqlrcursor*, environment*) () > #6 0x0000000000404739 in sqlrsh::execute(int, char const**) () > #7 0x0000000000404a9c in main () > (gdb) > > > On 25. 10. 2011 16:09, Freako F. Freakolowsky wrote: >> I just installed the latest sqlrelay version but i'm now facing a >> strange issue when using it. >> >> I start the sqlr stack normaly trough the init script (ubuntu server). >> >> I can then connect through sqlrsh ... no problems yet. >> running ping, dbversion, clientversion works normally. >> >> running serverversion segfaults. >> >> but the strangest thing is when running a query ...it freezes the >> shell, however uppon inspecting the connection's debug file i see that >> query gets executed >> >> any ideas on where to start looking for misconfiguration or bug ? >> >> DB is Oracle 11g >> >> pasting a part of connection's debug log >> >> 10/25/2011 16:05:23 CEST connection [28218] : new query >> 10/25/2011 16:05:23 CEST connection [28218] : handling query... >> 10/25/2011 16:05:23 CEST connection [28218] : getting query... >> 10/25/2011 16:05:23 CEST connection [28218] : querylength: >> 18 >> 10/25/2011 16:05:23 CEST connection [28218] : query: >> 10/25/2011 16:05:23 CEST connection [28218] : select 1 from dual >> 10/25/2011 16:05:23 CEST connection [28218] : getting query >> succeeded >> 10/25/2011 16:05:23 CEST connection [28218] : getting input >> binds... >> 10/25/2011 16:05:23 CEST connection [28218] : done getting >> input binds >> 10/25/2011 16:05:23 CEST connection [28218] : getting output >> binds... >> 10/25/2011 16:05:23 CEST connection [28218] : done getting >> output binds >> 10/25/2011 16:05:23 CEST connection [28218] : getting send >> column info... >> 10/25/2011 16:05:23 CEST connection [28218] : send column info >> 10/25/2011 16:05:23 CEST connection [28218] : done getting >> send column info... >> 10/25/2011 16:05:23 CEST connection [28218] : processing query... >> 10/25/2011 16:05:23 CEST connection [28218] : >> preparing/executing... >> 10/25/2011 16:05:23 CEST connection [28218] : commit or >> rollback check... >> 10/25/2011 16:05:23 CEST connection [28218] : done with commit >> or rollback check >> 10/25/2011 16:05:23 CEST connection [28218] : processing query >> succeeded >> 10/25/2011 16:05:23 CEST connection [28218] : done processing >> query >> 10/25/2011 16:05:23 CEST connection [28218] : returning result >> set header... >> 10/25/2011 16:05:23 CEST connection [28218] : returning >> row counts... >> 10/25/2011 16:05:23 CEST connection [28218] : sending row >> counts... >> 10/25/2011 16:05:23 CEST connection [28218] : actual rows >> unknown >> 10/25/2011 16:05:23 CEST connection [28218] : affected rows: 0 >> 10/25/2011 16:05:23 CEST connection [28218] : done sending row >> counts >> 10/25/2011 16:05:23 CEST connection [28218] : done >> returning row counts >> 10/25/2011 16:05:23 CEST connection [28218] : column info >> will be sent >> 10/25/2011 16:05:23 CEST connection [28218] : returning >> column counts... >> 10/25/2011 16:05:23 CEST connection [28218] : done >> returning column counts >> 10/25/2011 16:05:23 CEST connection [28218] : sending column >> type format... >> 10/25/2011 16:05:23 CEST connection [28218] : id's >> 10/25/2011 16:05:23 CEST connection [28218] : done sending >> column type format >> 10/25/2011 16:05:23 CEST connection [28218] : returning >> column info... >> 10/25/2011 16:05:23 CEST connection [28218] : 1:48:2 (0,129) >> 10/25/2011 16:05:23 CEST connection [28218] : done >> returning column info >> 10/25/2011 16:05:23 CEST connection [28218] : returning output >> bind values >> 0 >> 10/25/2011 16:05:23 CEST connection [28218] : done returning >> output bind values >> 10/25/2011 16:05:23 CEST connection [28218] : done returning >> result set header >> 10/25/2011 16:05:23 CEST connection [28218] : handle query succeeded >> 10/25/2011 16:05:23 CEST connection [28218] : returning result >> set data... >> 10/25/2011 16:05:23 CEST connection [28218] : skipping 0 rows... >> 10/25/2011 16:05:23 CEST connection [28218] : done skipping rows >> 10/25/2011 16:05:23 CEST connection [28218] : fetching 100 rows... >> >> >> >> ------------------------------------------------------------------------------ >> The demand for IT networking professionals continues to grow, and the >> demand for specialized networking skills is growing even more rapidly. >> Take a complimentary Learning@Cisco Self-Assessment and learn >> about Cisco certifications, training, and career opportunities. >> http://p.sf.net/sfu/cisco-dev2dev >> >> >> _______________________________________________ >> Sqlrelay-discussion mailing list >> Sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > ------------------------------------------------------------------------------ > The demand for IT networking professionals continues to grow, and the > demand for specialized networking skills is growing even more rapidly. > Take a complimentary Learning@Cisco Self-Assessment and learn > about Cisco certifications, training, and career opportunities. > http://p.sf.net/sfu/cisco-dev2dev > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: David M. <dav...@fi...> - 2011-10-28 18:44:13
|
Oh, I see the problem. Man, I think this has been here a while. In the client API, there was an uninitialized variable. I fixed it and the fix is in CVS. For a quick fix, edit src/api/c++/src/connection/connectionctor.C and around line 41, add the following line: serverversion=NULL; Then rebuild and reinstall and it should fix the problem. David Muse dav...@fi... On 10/28/2011 02:34 PM, David Muse wrote: > Weird. I just tested it and it crashes for me too. I should be able > to figure it out pretty quickly. I'll let you know what I find. > > Dave > > On 10/26/2011 05:59 AM, Freako F. Freakolowsky wrote: >> If it helps anyone, here's the GDB backtrace >> >> root@devwww:~# gdb sqlrsh >> GNU gdb (GDB) 7.1-ubuntu >> Copyright (C) 2010 Free Software Foundation, Inc. >> License GPLv3+: GNU GPL version 3 or later >> <http://gnu.org/licenses/gpl.html> >> This is free software: you are free to change and redistribute it. >> There is NO WARRANTY, to the extent permitted by law. Type "show >> copying" >> and "show warranty" for details. >> This GDB was configured as "x86_64-linux-gnu". >> For bug reporting instructions, please see: >> <http://www.gnu.org/software/gdb/bugs/>... >> Reading symbols from /opt/sqlrelay/bin/sqlrsh...(no debugging symbols >> found)...done. >> (gdb) run localhost 9000 "" scott tiger >> Starting program: /opt/sqlrelay/bin/sqlrsh localhost 9000 "" scott tiger >> [Thread debugging using libthread_db enabled] >> SQLRShell - Version 0.22 >> Connected to: localhost:9000 as scott >> >> type help; for a help. >> >> 0> serverversion; >> >> Program received signal SIGSEGV, Segmentation fault. >> 0x00007ffff555ae2d in free () from /lib/libc.so.6 >> (gdb) backtrace >> #0 0x00007ffff555ae2d in free () from /lib/libc.so.6 >> #1 0x00007ffff79b287c in sqlrconnection::serverVersion() () from >> /opt/sqlrelay/lib/libsqlrclient-0.43.so.1 >> #2 0x0000000000403a41 in sqlrsh::serverversion(sqlrconnection*, >> environment*) () >> #3 0x0000000000403080 in sqlrsh::internalCommand(sqlrconnection*, >> sqlrcursor*, environment*, char const*) () >> #4 0x0000000000402a2f in sqlrsh::runCommand(sqlrconnection*, >> sqlrcursor*, environment*, char const*) () >> #5 0x000000000040413b in sqlrsh::interactWithUser(sqlrconnection*, >> sqlrcursor*, environment*) () >> #6 0x0000000000404739 in sqlrsh::execute(int, char const**) () >> #7 0x0000000000404a9c in main () >> (gdb) >> >> >> On 25. 10. 2011 16:09, Freako F. Freakolowsky wrote: >>> I just installed the latest sqlrelay version but i'm now facing a >>> strange issue when using it. >>> >>> I start the sqlr stack normaly trough the init script (ubuntu server). >>> >>> I can then connect through sqlrsh ... no problems yet. >>> running ping, dbversion, clientversion works normally. >>> >>> running serverversion segfaults. >>> >>> but the strangest thing is when running a query ...it freezes the >>> shell, however uppon inspecting the connection's debug file i see that >>> query gets executed >>> >>> any ideas on where to start looking for misconfiguration or bug ? >>> >>> DB is Oracle 11g >>> >>> pasting a part of connection's debug log >>> >>> 10/25/2011 16:05:23 CEST connection [28218] : new query >>> 10/25/2011 16:05:23 CEST connection [28218] : handling query... >>> 10/25/2011 16:05:23 CEST connection [28218] : getting query... >>> 10/25/2011 16:05:23 CEST connection [28218] : querylength: >>> 18 >>> 10/25/2011 16:05:23 CEST connection [28218] : query: >>> 10/25/2011 16:05:23 CEST connection [28218] : select 1 from dual >>> 10/25/2011 16:05:23 CEST connection [28218] : getting query >>> succeeded >>> 10/25/2011 16:05:23 CEST connection [28218] : getting input >>> binds... >>> 10/25/2011 16:05:23 CEST connection [28218] : done getting >>> input binds >>> 10/25/2011 16:05:23 CEST connection [28218] : getting output >>> binds... >>> 10/25/2011 16:05:23 CEST connection [28218] : done getting >>> output binds >>> 10/25/2011 16:05:23 CEST connection [28218] : getting send >>> column info... >>> 10/25/2011 16:05:23 CEST connection [28218] : send >>> column info >>> 10/25/2011 16:05:23 CEST connection [28218] : done getting >>> send column info... >>> 10/25/2011 16:05:23 CEST connection [28218] : processing >>> query... >>> 10/25/2011 16:05:23 CEST connection [28218] : >>> preparing/executing... >>> 10/25/2011 16:05:23 CEST connection [28218] : commit or >>> rollback check... >>> 10/25/2011 16:05:23 CEST connection [28218] : done with commit >>> or rollback check >>> 10/25/2011 16:05:23 CEST connection [28218] : processing query >>> succeeded >>> 10/25/2011 16:05:23 CEST connection [28218] : done processing >>> query >>> 10/25/2011 16:05:23 CEST connection [28218] : returning result >>> set header... >>> 10/25/2011 16:05:23 CEST connection [28218] : returning >>> row counts... >>> 10/25/2011 16:05:23 CEST connection [28218] : sending row >>> counts... >>> 10/25/2011 16:05:23 CEST connection [28218] : actual rows >>> unknown >>> 10/25/2011 16:05:23 CEST connection [28218] : affected >>> rows: 0 >>> 10/25/2011 16:05:23 CEST connection [28218] : done sending row >>> counts >>> 10/25/2011 16:05:23 CEST connection [28218] : done >>> returning row counts >>> 10/25/2011 16:05:23 CEST connection [28218] : column info >>> will be sent >>> 10/25/2011 16:05:23 CEST connection [28218] : returning >>> column counts... >>> 10/25/2011 16:05:23 CEST connection [28218] : done >>> returning column counts >>> 10/25/2011 16:05:23 CEST connection [28218] : sending column >>> type format... >>> 10/25/2011 16:05:23 CEST connection [28218] : id's >>> 10/25/2011 16:05:23 CEST connection [28218] : done sending >>> column type format >>> 10/25/2011 16:05:23 CEST connection [28218] : returning >>> column info... >>> 10/25/2011 16:05:23 CEST connection [28218] : 1:48:2 >>> (0,129) >>> 10/25/2011 16:05:23 CEST connection [28218] : done >>> returning column info >>> 10/25/2011 16:05:23 CEST connection [28218] : returning output >>> bind values >>> 0 >>> 10/25/2011 16:05:23 CEST connection [28218] : done returning >>> output bind values >>> 10/25/2011 16:05:23 CEST connection [28218] : done returning >>> result set header >>> 10/25/2011 16:05:23 CEST connection [28218] : handle query >>> succeeded >>> 10/25/2011 16:05:23 CEST connection [28218] : returning result >>> set data... >>> 10/25/2011 16:05:23 CEST connection [28218] : skipping 0 >>> rows... >>> 10/25/2011 16:05:23 CEST connection [28218] : done skipping >>> rows >>> 10/25/2011 16:05:23 CEST connection [28218] : fetching 100 >>> rows... >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> The demand for IT networking professionals continues to grow, and the >>> demand for specialized networking skills is growing even more rapidly. >>> Take a complimentary Learning@Cisco Self-Assessment and learn >>> about Cisco certifications, training, and career opportunities. >>> http://p.sf.net/sfu/cisco-dev2dev >>> >>> >>> _______________________________________________ >>> Sqlrelay-discussion mailing list >>> Sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> ------------------------------------------------------------------------------ >> >> The demand for IT networking professionals continues to grow, and the >> demand for specialized networking skills is growing even more rapidly. >> Take a complimentary Learning@Cisco Self-Assessment and learn >> about Cisco certifications, training, and career opportunities. >> http://p.sf.net/sfu/cisco-dev2dev >> _______________________________________________ >> Sqlrelay-discussion mailing list >> Sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> >> _______________________________________________________ >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting >> http://www.doteasy.com > _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: Freako F. F. <fr...@dr...> - 2011-10-26 09:59:57
|
If it helps anyone, here's the GDB backtrace root@devwww:~# gdb sqlrsh GNU gdb (GDB) 7.1-ubuntu Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-linux-gnu". For bug reporting instructions, please see: <http://www.gnu.org/software/gdb/bugs/>... Reading symbols from /opt/sqlrelay/bin/sqlrsh...(no debugging symbols found)...done. (gdb) run localhost 9000 "" scott tiger Starting program: /opt/sqlrelay/bin/sqlrsh localhost 9000 "" scott tiger [Thread debugging using libthread_db enabled] SQLRShell - Version 0.22 Connected to: localhost:9000 as scott type help; for a help. 0> serverversion; Program received signal SIGSEGV, Segmentation fault. 0x00007ffff555ae2d in free () from /lib/libc.so.6 (gdb) backtrace #0 0x00007ffff555ae2d in free () from /lib/libc.so.6 #1 0x00007ffff79b287c in sqlrconnection::serverVersion() () from /opt/sqlrelay/lib/libsqlrclient-0.43.so.1 #2 0x0000000000403a41 in sqlrsh::serverversion(sqlrconnection*, environment*) () #3 0x0000000000403080 in sqlrsh::internalCommand(sqlrconnection*, sqlrcursor*, environment*, char const*) () #4 0x0000000000402a2f in sqlrsh::runCommand(sqlrconnection*, sqlrcursor*, environment*, char const*) () #5 0x000000000040413b in sqlrsh::interactWithUser(sqlrconnection*, sqlrcursor*, environment*) () #6 0x0000000000404739 in sqlrsh::execute(int, char const**) () #7 0x0000000000404a9c in main () (gdb) On 25. 10. 2011 16:09, Freako F. Freakolowsky wrote: > I just installed the latest sqlrelay version but i'm now facing a > strange issue when using it. > > I start the sqlr stack normaly trough the init script (ubuntu server). > > I can then connect through sqlrsh ... no problems yet. > running ping, dbversion, clientversion works normally. > > running serverversion segfaults. > > but the strangest thing is when running a query ...it freezes the > shell, however uppon inspecting the connection's debug file i see that > query gets executed > > any ideas on where to start looking for misconfiguration or bug ? > > DB is Oracle 11g > > pasting a part of connection's debug log > > 10/25/2011 16:05:23 CEST connection [28218] : new query > 10/25/2011 16:05:23 CEST connection [28218] : handling query... > 10/25/2011 16:05:23 CEST connection [28218] : getting query... > 10/25/2011 16:05:23 CEST connection [28218] : querylength: > 18 > 10/25/2011 16:05:23 CEST connection [28218] : query: > 10/25/2011 16:05:23 CEST connection [28218] : select 1 from dual > 10/25/2011 16:05:23 CEST connection [28218] : getting query > succeeded > 10/25/2011 16:05:23 CEST connection [28218] : getting input > binds... > 10/25/2011 16:05:23 CEST connection [28218] : done getting > input binds > 10/25/2011 16:05:23 CEST connection [28218] : getting output > binds... > 10/25/2011 16:05:23 CEST connection [28218] : done getting > output binds > 10/25/2011 16:05:23 CEST connection [28218] : getting send > column info... > 10/25/2011 16:05:23 CEST connection [28218] : send column info > 10/25/2011 16:05:23 CEST connection [28218] : done getting > send column info... > 10/25/2011 16:05:23 CEST connection [28218] : processing query... > 10/25/2011 16:05:23 CEST connection [28218] : > preparing/executing... > 10/25/2011 16:05:23 CEST connection [28218] : commit or > rollback check... > 10/25/2011 16:05:23 CEST connection [28218] : done with commit > or rollback check > 10/25/2011 16:05:23 CEST connection [28218] : processing query > succeeded > 10/25/2011 16:05:23 CEST connection [28218] : done processing > query > 10/25/2011 16:05:23 CEST connection [28218] : returning result > set header... > 10/25/2011 16:05:23 CEST connection [28218] : returning > row counts... > 10/25/2011 16:05:23 CEST connection [28218] : sending row > counts... > 10/25/2011 16:05:23 CEST connection [28218] : actual rows > unknown > 10/25/2011 16:05:23 CEST connection [28218] : affected rows: 0 > 10/25/2011 16:05:23 CEST connection [28218] : done sending row > counts > 10/25/2011 16:05:23 CEST connection [28218] : done > returning row counts > 10/25/2011 16:05:23 CEST connection [28218] : column info > will be sent > 10/25/2011 16:05:23 CEST connection [28218] : returning > column counts... > 10/25/2011 16:05:23 CEST connection [28218] : done > returning column counts > 10/25/2011 16:05:23 CEST connection [28218] : sending column > type format... > 10/25/2011 16:05:23 CEST connection [28218] : id's > 10/25/2011 16:05:23 CEST connection [28218] : done sending > column type format > 10/25/2011 16:05:23 CEST connection [28218] : returning > column info... > 10/25/2011 16:05:23 CEST connection [28218] : 1:48:2 (0,129) > 10/25/2011 16:05:23 CEST connection [28218] : done > returning column info > 10/25/2011 16:05:23 CEST connection [28218] : returning output > bind values > 0 > 10/25/2011 16:05:23 CEST connection [28218] : done returning > output bind values > 10/25/2011 16:05:23 CEST connection [28218] : done returning > result set header > 10/25/2011 16:05:23 CEST connection [28218] : handle query succeeded > 10/25/2011 16:05:23 CEST connection [28218] : returning result > set data... > 10/25/2011 16:05:23 CEST connection [28218] : skipping 0 rows... > 10/25/2011 16:05:23 CEST connection [28218] : done skipping rows > 10/25/2011 16:05:23 CEST connection [28218] : fetching 100 rows... > > > > ------------------------------------------------------------------------------ > The demand for IT networking professionals continues to grow, and the > demand for specialized networking skills is growing even more rapidly. > Take a complimentary Learning@Cisco Self-Assessment and learn > about Cisco certifications, training, and career opportunities. > http://p.sf.net/sfu/cisco-dev2dev > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: Freako F. F. <fr...@dr...> - 2011-10-25 14:10:34
|
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="serif">I just installed the latest sqlrelay version but
i'm now facing a strange issue when using it.<br>
<br>
I start the sqlr stack normaly trough the init script (ubuntu
server).<br>
<br>
I can then connect through sqlrsh ... no problems yet.<br>
running ping, dbversion, clientversion works normally.<br>
<br>
running serverversion segfaults. <br>
<br>
but the strangest thing is when running a query ...it freezes the
shell, however uppon inspecting the connection's debug file i see
that query gets executed <br>
<br>
any ideas on where to start looking for misconfiguration or bug ?<br>
<br>
DB is Oracle 11g<br>
<br>
pasting a part of connection's debug log<br>
<br>
10/25/2011 16:05:23 CEST connection [28218] : new query<br>
10/25/2011 16:05:23 CEST connection [28218] : handling
query...<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
query...<br>
10/25/2011 16:05:23 CEST connection [28218] :
querylength:<br>
18<br>
10/25/2011 16:05:23 CEST connection [28218] : query:<br>
10/25/2011 16:05:23 CEST connection [28218] : select 1 from dual<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
query succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
input binds...<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
input binds<br>
10/25/2011 16:05:23 CEST connection [28218] : getting
output binds...<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
output binds<br>
10/25/2011 16:05:23 CEST connection [28218] : getting send
column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : send
column info<br>
10/25/2011 16:05:23 CEST connection [28218] : done getting
send column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : processing
query...<br>
10/25/2011 16:05:23 CEST connection [28218] :
preparing/executing...<br>
10/25/2011 16:05:23 CEST connection [28218] : commit or
rollback check...<br>
10/25/2011 16:05:23 CEST connection [28218] : done with
commit or rollback check<br>
10/25/2011 16:05:23 CEST connection [28218] : processing
query succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : done
processing query<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
result set header...<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning row counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : sending row
counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : actual
rows unknown<br>
10/25/2011 16:05:23 CEST connection [28218] : affected
rows: 0<br>
10/25/2011 16:05:23 CEST connection [28218] : done sending
row counts<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning row counts<br>
10/25/2011 16:05:23 CEST connection [28218] : column
info will be sent<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning column counts...<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning column counts<br>
10/25/2011 16:05:23 CEST connection [28218] : sending
column type format...<br>
10/25/2011 16:05:23 CEST connection [28218] : id's<br>
10/25/2011 16:05:23 CEST connection [28218] : done sending
column type format<br>
10/25/2011 16:05:23 CEST connection [28218] :
returning column info...<br>
10/25/2011 16:05:23 CEST connection [28218] : 1:48:2
(0,129) <br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning column info<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
output bind values<br>
0<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning output bind values<br>
10/25/2011 16:05:23 CEST connection [28218] : done
returning result set header<br>
10/25/2011 16:05:23 CEST connection [28218] : handle query
succeeded<br>
10/25/2011 16:05:23 CEST connection [28218] : returning
result set data...<br>
10/25/2011 16:05:23 CEST connection [28218] : skipping 0
rows...<br>
10/25/2011 16:05:23 CEST connection [28218] : done
skipping rows<br>
10/25/2011 16:05:23 CEST connection [28218] : fetching 100
rows...<br>
<br>
</font>
</body>
</html>
|
|
From: Renat S. <sr...@st...> - 2011-10-19 15:02:29
|
18.10.2011 18:21, Renat Sabitov пишет: > I suggest to return to string representation for numbers. > Please take a look at the patch attached. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: Renat S. <sr...@st...> - 2011-10-18 14:20:35
|
Hi!
There is a proble came up with 0.42. In this version python client for
SQLRelay treats numbers as integers. It is completely wrong. Not only do
numbers with fractions lose all after decimal point, but some numbers
also do not fit to binary integers and got int64_max value.
Example:
from SQLRelay import PySQLRDB
con=PySQLRDB.connect('localhost',19000,'','ow_develop','ow_develop',0,1)
cur=con.cursor()
cur.execute('select 12345678901234567890123456789012345678, \
123.456 from dual')
print (cur.fetchall())
-------
$ python test.py
[[9223372036854775807L, 123L]]
N.B. Numbers in oracle have up to 38 digits
I suggest to return to string representation for numbers.
--
Renat Sabitov e-mail: sr...@st...
Stack Soft jid: sr...@ja...
|
|
From: Ashish M. <ash...@gm...> - 2011-10-17 06:06:39
|
Hi, I have been using mysql with perl for my Web applications and recently started exploring SQLRelay for load-balancing and connection pooling. I would like to pose couple of questions related to this - 1) For the purpose for which I am evaluating SQL Relay (load-balancing, connection pooling, read/write splitting), which is the preferred option - MySQL Proxy or SQLRelay? Is there any documented comparison of these? What are the known advantages/disadvantages of picking one over the other? 2) I followed the documentation at http://sqlrelay.sourceforge.net/sqlrelay/programming/perldbi.html to use perl DBI with SQLRelay. However, DBD::SQLRelay does not seem to understand what is passed to it and therefore does not work. Is there any documentation of how I can get existing perl DBI code to work unchanged with SQLRelay? Thanks, Ashish |
|
From: David D. <dav...@gm...> - 2011-09-22 22:43:23
|
Hi all,
General summary, are the following use cases supported:
1 - starting sqlrelay with some connections unavailable?
2 - having a server fail, then when clients attempt to retrieve a
connection, they will not receive a connection routed to that server?
Here's my config:
<instance id="pool" port="9000" dbase="mysql" connections="2"
maxconnections="4" maxqueuelength="0" growby="1" ttl="60"
maxsessioncount="1000" endofsession="commit" sessiontimeout="600"
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
handoff="pass" deniedips="" allowedips="" debug="yes"
maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
listenertimeout="5" reloginatstart="yes" timequeriessec="-1"
timequeriesusec="500">
<users>
<user user="me" password="pw"/>
</users>
<connections>
<connection connectionid="server1"
string="user=me;password=pw;db=test;host=server1;fakebinds=no;"
metric="1" behindloadbalancer="no"/>
<connection connectionid="server2"
string="user=me;password=pw;db=test;host=server2;fakebinds=no;"
metric="1" behindloadbalancer="no"/> </connections>
</instance>
Ideally, if server1 goes down, clients that attempt to connect will go
to server2 automatically (I realize that failed connection aren't
going to be repooled to the server2). The behavior I see is this:
If server1 and server2 are up when I start sqlr and I later stop
server1, then every other client connection attempt fails. So I still
have 2 connections up and running, but the one connected to the
stopped server just throws an error when a client tries to use it
(cannot connect to server1), instead of this connection being marked
invalid by sqlrelay.
If server1 is down, server2 up, when I start sqlr, the system appears
to start normally:
-bash-3.2$ sudo ./sqlr-status -id pool
Warning: using default connectionid.
Open Server Connections: 2
Opened Server Connections: 2
Open Client Connections: 0
Opened Client Connections: 0
Open Server Cursors: 10
Opened Server Cursors: 10
Times New Cursor Used: 0
Times Cursor Reused: 0
Total Queries: 0
Total Errors: 0
Forked Listeners: 0
Scaler's view:
Connections: 2
Sessions: 0
Semaphores:
+---------------------------------------------+
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
+---+---+---+---+---+---+---+---+---+---+-----+
| 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 |
+---------------------------------------------+
But all client connection attempts fail like so:
-bash-3.2$ ruby sqlrelaytest.rb
Couldn't connect to the listener.
Any ideas?
Thanks,
Dave
|
|
From: Diogo <dio...@gm...> - 2011-09-21 17:17:43
|
Hi Dave.thanks for you help =)
103 /> sqlrsh -id oracletest
SQLRShell - Version 0.22
Connected to: localhost:9000 as oracle
type help; for a help.
0> select * from empresa;
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.13759
COD_EMPRESA
===========
Rows Returned : 0
Fields Returned : 0
System time : 0
0> exit
1> quit;
The connect Ok Now. Set de Variables the Mysql/postgree stop running..
PostGre
root@ferrari desenvshm
105 /> LD_PRELOAD=/usr/local/firstworks/lib/libpqsqlrelay.so
root@ferrari desenvshm
106 /> export LD_PRELOAD
root@ferrari desenvshm
107 /> psql -h localhost -p 8009 -U barcode -W
Password for user barcode:
psql (9.0.3, server 0.0.0)
WARNING: psql version 9.0, server version 0.0.
Some psql features might not work.
Type "help" for help.
Segmentation fault
Mysql
root@ferrari desenvshm
109 /> LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so
root@ferrari desenvshm
110 /> export LD_PRELOAD
root@ferrari desenvshm
111 /> mysql -h localhost -P 8009 --user=barcode --password=barcode
Welcome to the MySQL monitor. Commands end with ; or \g.
root@ferrari desenvshm
De: David Muse [mailto:dav...@fi...]
Enviada em: quarta-feira, 21 de setembro de 2011 13:56
Para: Discussion of topics related to SQL Relay
Assunto: Re: [Sqlrelay-discussion] RES: OCIEnvCreate() failed
This is definitely strange. Everythng looks fine to me. The only thing
that's a little odd is the trailing slash in the oracle_home, but that
shouldn't matter.
There still could be a permissions problem in a directory higher up than the
tnsnames.ora file. Try setting the runasuser/runasgroup to the same
user/group that you tested sqlplus with and see if that makes any
difference. It's got to be something like that.
Dave
dav...@fi...
On 09/19/2011 07:44 AM, Diogo wrote:
Hi Dave... the verify permissions Everything OK.
Below are the settings.
34 /oracle/product/10.2.0/client1/network/admin> sqlr-start -debug -id
oracletest
Starting listener:
sqlr-listener -id oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12778
Starting 3 connections to oracletest :
sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf -debug
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.12780
OCIEnvCreate() failed.
error:
Couldn't log into database.
sqlr-connection-oracle8 failed to start.
Thanks to MP3.com for sponsoring:
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring:
Query routing and filtering.
Ls in tnsnames.ora:
/oracle/product/10.2.0/client1/network/admin> ll
total 16
drwxrwxrwx 2 oracle oracle 4096 Sep 16 18:20 samples
-rwxrwxrwx 1 root root 172 Sep 16 18:13 shrept.lst
-rwxrwxrwx 1 root root 175 Sep 16 18:13 sqlnet.ora
-rwxrwxrwx 1 root root 518 Sep 18 08:32 tnsnames.ora
Sqlplus :
36 /oracle/product/10.2.0/client1/network/admin> sqlplus
barcode/barcode@barcode
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 19 08:41:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL>
Tnsping :
37 /oracle/product/10.2.0/client1/network/admin> tnsping barcode
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 19-SEP-2011
08:41:34
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/product/10.2.0/client1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
100.0.0.129)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = barcode)))
OK (0 msec)
Sqlrelay.conf :
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<instance id="oracletest" port="9000"
socket="/tmp/oracletest.socket" dbase="oracle8" connections="3"
debug="listener_and_connection" maxconnections="5" maxqueuelength="0"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener"
handoff="pass">
<users>
<user user="oracle" password="oracle"/>
</users>
<connections>
<connection connectionid="oracletest"
string="user=barcode;password=barcode;oracle_home=/oracle/product/10.2.0/cli
ent1/;oracle_sid=barcode" metric="1"/>
</connections>
</instance>
</instances>
De: David Muse [mailto:dav...@fi...]
Enviada em: domingo, 18 de setembro de 2011 23:44
Para: Discussion of topics related to SQL Relay
Assunto: Re: [Sqlrelay-discussion] OCIEnvCreate() failed
I think this is usually caused by bad permissions on the tnsnames.ora file.
The user that SQL Relay is running as probably doesn't have permissions to
read it.
One solution is to add read permissions for others to the file. Another is
to put the user that SQL Relay is running as in the group that owns the
tnsnames.ora file.
If that doesn't turn out to be the issue, then please post your
sqlrelay.conf file and tnsnames.ora file.
Dave
On 09/17/2011 04:59 PM, Diogo wrote:
Hi ,
I'm installing and the problem below. Can anyone help?
Works with Opensuse 11.2? With the Oracle Client installed on the machine
since I can connect with SQLrelay or need to be installed in bank machines?
sqlr-start -id oracletest
Starting listener:
sqlr-listener -id oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf
Starting 3 connections to oracletest :
sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config
/usr/local/firstworks/etc/sqlrelay.conf
OCIEnvCreate() failed.
error:
Couldn't log into database.
sqlr-connection-oracle8 failed to start.
Thanks to MP3.com for sponsoring:
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring:
Query routing and filtering.
----------------------------------------------------------------------------
--
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
http://p.sf.net/sfu/rim-devcon-copy2
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
http://www.doteasy.com
----------------------------------------------------------------------------
--
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the
BlackBerry® mobile platform with sessions, labs & more.
See new tools and technologies. Register for BlackBerry® DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
http://www.doteasy.com
|
|
From: David M. <dav...@fi...> - 2011-09-21 16:53:33
|
This is definitely strange. Everythng looks fine to me. The only thing that's a little odd is the trailing slash in the oracle_home, but that shouldn't matter. There still could be a permissions problem in a directory higher up than the tnsnames.ora file. Try setting the runasuser/runasgroup to the same user/group that you tested sqlplus with and see if that makes any difference. It's got to be something like that. Dave dav...@fi... On 09/19/2011 07:44 AM, Diogo wrote: > > Hi Dave... the verify permissions Everything OK. > > Below are the settings... > > 34 /oracle/product/10.2.0/client1/network/admin> sqlr-start -debug -id > oracletest > > Starting listener: > > sqlr-listener -id oracletest -config > /usr/local/firstworks/etc/sqlrelay.conf -debug > > Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12778 > > Starting 3 connections to oracletest : > > sqlr-connection-oracle8 -id oracletest -connectionid oracletest > -config /usr/local/firstworks/etc/sqlrelay.conf -debug > > Debugging to: > /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.12780 > > OCIEnvCreate() failed. > > error: > > Couldn't log into database. > > sqlr-connection-oracle8 failed to start. > > Thanks to MP3.com for sponsoring: > > Clustered/Replicated database support. > > Perl API. > > Thanks to FeedLounge for sponsoring: > > Query routing and filtering. > > Ls in tnsnames.ora: > > /oracle/product/10.2.0/client1/network/admin> ll > > total 16 > > drwxrwxrwx 2 oracle oracle 4096 Sep 16 18:20 samples > > -rwxrwxrwx 1 root root 172 Sep 16 18:13 shrept.lst > > -rwxrwxrwx 1 root root 175 Sep 16 18:13 sqlnet.ora > > -rwxrwxrwx 1 root root 518 Sep 18 08:32 tnsnames.ora > > Sqlplus : > > 36 /oracle/product/10.2.0/client1/network/admin> sqlplus > barcode/barcode@barcode > > SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 19 08:41:11 2011 > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > Connected to: > > Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production > > With the Partitioning, OLAP, Data Mining and Real Application Testing > options > > SQL> > > Tnsping : > > 37 /oracle/product/10.2.0/client1/network/admin> tnsping barcode > > TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on > 19-SEP-2011 08:41:34 > > Copyright (c) 1997, 2005, Oracle. All rights reserved. > > Used parameter files: > > /oracle/product/10.2.0/client1/network/admin/sqlnet.ora > > Used TNSNAMES adapter to resolve the alias > > Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST > = 100.0.0.129)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) > (SERVICE_NAME = barcode))) > > OK (0 msec) > > Sqlrelay.conf : > > <?xml version="1.0"?> > > <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> > > <instances> > > <instance id="oracletest" port="9000" socket="/tmp/oracletest.socket" > dbase="oracle8" connections="3" debug="listener_and_connection" > maxconnections="5" maxqueuelength="0" growby="1" ttl="60" > endofsession="commit" sessiontimeout="600" runasuser="nobody" > runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"> > > <users> > > <user user="oracle" password="oracle"/> > > </users> > > <connections> > > <connection connectionid="oracletest" > string="user=barcode;password=barcode;oracle_home=/oracle/product/10.2.0/client1/;oracle_sid=barcode" > metric="1"/> > > </connections> > > </instance> > > </instances> > > *De:*David Muse [mailto:dav...@fi...] > *Enviada em:* domingo, 18 de setembro de 2011 23:44 > *Para:* Discussion of topics related to SQL Relay > *Assunto:* Re: [Sqlrelay-discussion] OCIEnvCreate() failed > > I think this is usually caused by bad permissions on the tnsnames.ora > file. The user that SQL Relay is running as probably doesn't have > permissions to read it. > > One solution is to add read permissions for others to the file. > Another is to put the user that SQL Relay is running as in the group > that owns the tnsnames.ora file. > > If that doesn't turn out to be the issue, then please post your > sqlrelay.conf file and tnsnames.ora file. > > Dave > > On 09/17/2011 04:59 PM, Diogo wrote: > > Hi , > > I'm installing and the problem below. Can anyone help? > > Works with Opensuse 11.2? With the Oracle Client installed on the > machine since I can connect with SQLrelay or need to be installed in > bank machines? > > sqlr-start -id oracletest > > Starting listener: > > sqlr-listener -id oracletest -config > /usr/local/firstworks/etc/sqlrelay.conf > > Starting 3 connections to oracletest : > > sqlr-connection-oracle8 -id oracletest -connectionid oracletest > -config /usr/local/firstworks/etc/sqlrelay.conf > > OCIEnvCreate() failed. > > error: > > Couldn't log into database. > > sqlr-connection-oracle8 failed to start. > > Thanks to MP3.com for sponsoring: > > Clustered/Replicated database support. > > Perl API. > > Thanks to FeedLounge for sponsoring: > > Query routing and filtering. > > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > http://p.sf.net/sfu/rim-devcon-copy2 > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... <mailto:Sql...@li...> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > Learn about the latest advances in developing for the > BlackBerry® mobile platform with sessions, labs& more. > See new tools and technologies. Register for BlackBerry® DevCon today! > http://p.sf.net/sfu/rim-devcon-copy1 > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: David M. <dav...@fi...> - 2011-09-21 16:33:51
|
Hello all,
I've recently gotten a few reports where after building SQL Relay it
would run because rudiments required libssl.so.10 which isn't present on
the system it was built on.
Apparently I forgot to run a "make distclean" before making the
rudiments source distribution. The tarball contained the object files
and binaries as built on my build system which has libssl.so.10 on it.
If you'd try to build it, the make program wouldn't actually build
anything because the object files and binaries were already there.
It looks like the sqlrelay distribution was ok, it was just rudiments
that was messed up. It's fixed now. If you re-download and re-build
rudiments, everything should be fine. Alternatively, you can just run a
"make distclean" in the rudiments directory and start over, and it
should also be fine.
Sorry if this caused anyone any trouble.
David Muse
dav...@fi...
_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
http://www.doteasy.com
|
|
From: Diogo <dio...@gm...> - 2011-09-19 11:44:42
|
Hi Dave... the verify permissions Everything OK. Below are the settings. 34 /oracle/product/10.2.0/client1/network/admin> sqlr-start -debug -id oracletest Starting listener: sqlr-listener -id oracletest -config /usr/local/firstworks/etc/sqlrelay.conf -debug Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.12778 Starting 3 connections to oracletest : sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config /usr/local/firstworks/etc/sqlrelay.conf -debug Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.12780 OCIEnvCreate() failed. error: Couldn't log into database. sqlr-connection-oracle8 failed to start. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. Ls in tnsnames.ora: /oracle/product/10.2.0/client1/network/admin> ll total 16 drwxrwxrwx 2 oracle oracle 4096 Sep 16 18:20 samples -rwxrwxrwx 1 root root 172 Sep 16 18:13 shrept.lst -rwxrwxrwx 1 root root 175 Sep 16 18:13 sqlnet.ora -rwxrwxrwx 1 root root 518 Sep 18 08:32 tnsnames.ora Sqlplus : 36 /oracle/product/10.2.0/client1/network/admin> sqlplus barcode/barcode@barcode SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 19 08:41:11 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> Tnsping : 37 /oracle/product/10.2.0/client1/network/admin> tnsping barcode TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 19-SEP-2011 08:41:34 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /oracle/product/10.2.0/client1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 100.0.0.129)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = barcode))) OK (0 msec) Sqlrelay.conf : <?xml version="1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <instance id="oracletest" port="9000" socket="/tmp/oracletest.socket" dbase="oracle8" connections="3" debug="listener_and_connection" maxconnections="5" maxqueuelength="0" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"> <users> <user user="oracle" password="oracle"/> </users> <connections> <connection connectionid="oracletest" string="user=barcode;password=barcode;oracle_home=/oracle/product/10.2.0/cli ent1/;oracle_sid=barcode" metric="1"/> </connections> </instance> </instances> De: David Muse [mailto:dav...@fi...] Enviada em: domingo, 18 de setembro de 2011 23:44 Para: Discussion of topics related to SQL Relay Assunto: Re: [Sqlrelay-discussion] OCIEnvCreate() failed I think this is usually caused by bad permissions on the tnsnames.ora file. The user that SQL Relay is running as probably doesn't have permissions to read it. One solution is to add read permissions for others to the file. Another is to put the user that SQL Relay is running as in the group that owns the tnsnames.ora file. If that doesn't turn out to be the issue, then please post your sqlrelay.conf file and tnsnames.ora file. Dave On 09/17/2011 04:59 PM, Diogo wrote: Hi , I'm installing and the problem below. Can anyone help? Works with Opensuse 11.2? With the Oracle Client installed on the machine since I can connect with SQLrelay or need to be installed in bank machines? sqlr-start -id oracletest Starting listener: sqlr-listener -id oracletest -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to oracletest : sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config /usr/local/firstworks/etc/sqlrelay.conf OCIEnvCreate() failed. error: Couldn't log into database. sqlr-connection-oracle8 failed to start. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. ---------------------------------------------------------------------------- -- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA http://p.sf.net/sfu/rim-devcon-copy2 _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: David M. <dav...@fi...> - 2011-09-19 02:41:20
|
I think this is usually caused by bad permissions on the tnsnames.ora file. The user that SQL Relay is running as probably doesn't have permissions to read it. One solution is to add read permissions for others to the file. Another is to put the user that SQL Relay is running as in the group that owns the tnsnames.ora file. If that doesn't turn out to be the issue, then please post your sqlrelay.conf file and tnsnames.ora file. Dave On 09/17/2011 04:59 PM, Diogo wrote: > > Hi , > > I'm installing and the problem below. Can anyone help? > > Works with Opensuse 11.2? With the Oracle Client installed on the > machine since I can connect with SQLrelay or need to be installed in > bank machines? > > sqlr-start -id oracletest > > Starting listener: > > sqlr-listener -id oracletest -config > /usr/local/firstworks/etc/sqlrelay.conf > > Starting 3 connections to oracletest : > > sqlr-connection-oracle8 -id oracletest -connectionid oracletest > -config /usr/local/firstworks/etc/sqlrelay.conf > > OCIEnvCreate() failed. > > error: > > Couldn't log into database. > > sqlr-connection-oracle8 failed to start. > > Thanks to MP3.com for sponsoring: > > Clustered/Replicated database support. > > Perl API. > > Thanks to FeedLounge for sponsoring: > > Query routing and filtering. > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > http://p.sf.net/sfu/rim-devcon-copy2 > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: Diogo <dio...@gm...> - 2011-09-17 20:59:56
|
Hi , I'm installing and the problem below. Can anyone help? Works with Opensuse 11.2? With the Oracle Client installed on the machine since I can connect with SQLrelay or need to be installed in bank machines? sqlr-start -id oracletest Starting listener: sqlr-listener -id oracletest -config /usr/local/firstworks/etc/sqlrelay.conf Starting 3 connections to oracletest : sqlr-connection-oracle8 -id oracletest -connectionid oracletest -config /usr/local/firstworks/etc/sqlrelay.conf OCIEnvCreate() failed. error: Couldn't log into database. sqlr-connection-oracle8 failed to start. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. |
|
From: David M. <dav...@fi...> - 2011-09-15 02:36:16
|
Cool, sounds good. Let me know how it goes. Dave dav...@fi... On 09/13/2011 11:05 AM, Hagen Münch wrote: > > David, > > the requirement to send the same update query to multiple databases > was only a soft requirement. And I agree, that this rather should be a > job for a database replication or a synchronization task. > > I could compile the SQL Relay and got it run after clearing a few hurdles: > > - In config.mk remove -Wno-long-double in CXXFLAGS (obviously my > g++ doesn't know it; hope it is not essential) > > - Add the prefix value (in my case /opt/firstworks) in configure > where it tests the rudiments includes and libs > > - Add /opt/firstworks/bin to the PATH variable, otherwise > sqlr-start does not start correctly > > - Add the /opt/firstworks/lib to library path > > The SQL Relay connected to a Oracle data base and I sent some test > queries with the command line query utility. All worked fine and the > performance was impressive, so I think I can propose this solution. > > As for the .Net client application, I guess the system owners prefer a > web service solution. Hence there is no need for a .Net capable API > just now. Nevertheless there are some applications that have to access > different data bases and one attractive feature of SQLrelay is that > only one interface is needed. If the system owners accept my proposal > and if they have some experience with this solution I can imagine that > soon there will be requirements that makes a .Net capable API > necessary. In this case I'll ask you for an offer. > > So long, > > Hagen > > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > Learn about the latest advances in developing for the > BlackBerry® mobile platform with sessions, labs& more. > See new tools and technologies. Register for BlackBerry® DevCon today! > http://p.sf.net/sfu/rim-devcon-copy1 > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: Hagen M. <h.m...@WD...> - 2011-09-13 15:06:06
|
David, the requirement to send the same update query to multiple databases was only a soft requirement. And I agree, that this rather should be a job for a database replication or a synchronization task. I could compile the SQL Relay and got it run after clearing a few hurdles: - In config.mk remove -Wno-long-double in CXXFLAGS (obviously my g++ doesn't know it; hope it is not essential) - Add the prefix value (in my case /opt/firstworks) in configure where it tests the rudiments includes and libs - Add /opt/firstworks/bin to the PATH variable, otherwise sqlr-start does not start correctly - Add the /opt/firstworks/lib to library path The SQL Relay connected to a Oracle data base and I sent some test queries with the command line query utility. All worked fine and the performance was impressive, so I think I can propose this solution. As for the .Net client application, I guess the system owners prefer a web service solution. Hence there is no need for a .Net capable API just now. Nevertheless there are some applications that have to access different data bases and one attractive feature of SQLrelay is that only one interface is needed. If the system owners accept my proposal and if they have some experience with this solution I can imagine that soon there will be requirements that makes a .Net capable API necessary. In this case I'll ask you for an offer. So long, Hagen |
|
From: Renat S. <sr...@st...> - 2011-09-13 13:00:00
|
Hi all, I've found that number of open connections in statistics output is always the same as number of opened connections. For instance: ----- Open Client Connections: 6 Opened Client Connections: 6 ----- There is a small bug in src/connection/sqlrconnection/clientsession.C I made a patch for. See attachment. -- Renat Sabitov e-mail: sr...@st... Stack Soft jid: sr...@ja... |
|
From: David M. <dav...@fi...> - 2011-09-12 16:00:07
|
Hagen, SQL Relay can't currently send the same query to multiple databases, though that is on the TODO list. There are several challenges associated with doing it. All center around what to do if the db's get out of sync. If the query succeeds in one database but fails in the other, then what do you do? Two phase commit could be used with some databases, but others don't support it. There's also the possibility of auto-incrementing columns getting out of sync which can't be as easily detected as failed queries. Also, what should be done if a select is sent to more than one db? Should the result sets be merged? Should both be returned in their entirety? Should duplicates be removed? There are a few other, more obscure issues as well. Lets say though, that you just want to non-select statements to both databases and don't care if they get out of sync. I believe that SQL Relay could be readily modified to allow that. As for the .NET API, the protocol was once documented but that was a long time ago. I kept changing the protocol, the documentation got behind and I quit updating it. It's been stable for a long time now but there's no current documentation. Unfortunately, you'd have to dig through the client-side code to understand the protocol. I did recently get Rudiments and the SQL Relay client API to compile under Windows using mingw32-gcc and got the client applications to run under windows without Cygwin. The name-mangling conventions are all-wrong for use with native, non-mingw32 apps though. I'm working on getting it to compile using the MSVC compiler but I haven't gotten far with that yet. If I can figure that out soon, or figure out how to build a COM object using mingw32, then it should be possible to use the SQL Relay DLL directly from the various windows languages: VB, C#, MSVC++, etc. That's all unfinished at this point though. If you're interested, I'd be happy to work on any of these things on a contract basis. Just let me know. Take care, David Muse dav...@fi... On 09/08/2011 03:35 AM, Hagen Münch wrote: > > Hi, > > I haven't used SQLrelay yet and I'm wondering whether I could use it > for our requirements. > > There are different client applications (.Net web application, a unix > service written in C and some Script applications, e.g. written in > Perl) query and update an oracle database. One of the requirements is > that for each client UPDATE, INSERT or DELETE statement I have two > update two data bases simultaneously. Is there a way to configure the > SQLrelay to do that? > > The second question is, whether there is a documentation or definition > of the used protocol for SQLrelay clients? Since we would have to > connect some .Net client applications and there is no .Net client API > in SQLrelay I could write the .Net API myself. > > Thanks > > --Hagen > > > ------------------------------------------------------------------------------ > Doing More with Less: The Next Generation Virtual Desktop > What are the key obstacles that have prevented many mid-market businesses > from deploying virtual desktops? How do next-generation virtual desktops > provide companies an easier-to-deploy, easier-to-manage and more affordable > virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/ > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > _______________________________________________________ > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting > http://www.doteasy.com _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: Hagen M. <h.m...@WD...> - 2011-09-08 07:51:33
|
Hi, I haven't used SQLrelay yet and I'm wondering whether I could use it for our requirements. There are different client applications (.Net web application, a unix service written in C and some Script applications, e.g. written in Perl) query and update an oracle database. One of the requirements is that for each client UPDATE, INSERT or DELETE statement I have two update two data bases simultaneously. Is there a way to configure the SQLrelay to do that? The second question is, whether there is a documentation or definition of the used protocol for SQLrelay clients? Since we would have to connect some .Net client applications and there is no .Net client API in SQLrelay I could write the .Net API myself. Thanks --Hagen |
|
From: David M. <dav...@fi...> - 2011-08-16 18:18:11
|
Hello all, SQL Relay 0.43 is out. Get it at http://sqlrelay.sourceforge.net/download.html You'll also need an updated version of Rudiments - http://rudiments.sourceforge.net/download.html This is mainly a compatibility release. In 0.42, some languages or databases weren't detected properly on some platforms or needed tweaks to build against. This release should resolve most or all of those issues. It's also now possible to build rudiments, the sqlrelay client library and command line apps under mingw32 and run them on Windows without Cygwin. You can also set the character set in the sqlrelay.conf file for all databases that support it now. Give it a try, report any errors that you find. David Muse dav...@fi... Full Change Log: updated ruby code build to take sitearch into account during includes updated ruby code to map STR2CSTR to StringValuePtr for ruby 1.9 updated to use rudiments' updated signalclasses replaced calls to fork() and exit() with process class calls updated ruby detection in configure script added a test for Python.h to the configure script updated tcl detection updated db2 detection added sed command to remove -arch args from perl build (for osx) added charset support for all db's who's client libraries support them updated detection of various languages and db's on various platforms _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
|
From: David M. <dav...@fi...> - 2011-08-11 19:01:50
|
Hello Andrew,
The maxlisteners parameter can be tuned to manage that error.
SQL Relay opens a set number of connections to the database, then when
clients connects to the SQL Relay listener, it hands them off to an
available database connection. If there are no available connections,
the listener forks off a child which waits until there is an available
connection. The maxlisteners parameter controls how many of these
forked-off-children can pile up before errors will be thrown.
Originally, SQL Relay allowed an unlimited number, but some folks
requested that it be possible to place a limit to prevent the system
from paging if a lot of clients piled up, so I added that feature.
Setting maxlisteners="0" should revert to the original behavior and
allow an unlimited number.
The appropriate value for that number is application-specific, but 10
would likely be a low number for most applications.
Typical situations that cause clients to pile up would be if the
database went down for a while or if there are queries that take a long
time to run that get triggered regularly.
I hope this helps.
David Muse
dav...@fi...
On 07/28/2011 11:41 PM, Andrew L wrote:
> Hi,
>
> I'm using rudiments-0.32 and sqlrelay-0.39.4 .
>
> I have the following Perl code:
>
> 1 ....
> 2 $stmt = 'begin :cursor := my_func; end;';
> 3 $curs->prepareQuery ($stmt);
> 4 $curs->defineOutputBindCursor("cursor");
> 5 $curs->executeQuery() || die "Can't retrieve data from database:
> " . $curs->errorMessage();
> 7 ....
>
> The script dies at line 5 with "Can't retrieve data from database: Too
> many listeners" error message.
>
> Here's what I have in my sqlrelay.conf file:
>
> <instance id="my_id" port="9000" dbase="oracle8"
> connections="5" maxconnections="30"
> maxqueuelength="5"
> growby="1" ttl="600"
> endofsession="rollback" sessiontimeout="600"
> runasuser="spock"
> runasgroup="vulcan" cursors="10"
> authtier="listener"
> handoff="pass" deniedips="" allowedips=""
> debug="listener_and_connection"
> maxquerysize="65536" maxstringbindvaluelength="4000"
> maxlobbindvaluelength="71680" idleclienttimeout="5"
> maxlisteners="10" listenertimeout="0"
> reloginatstart="false">
>
> What settings do i need to change to fix the error?
>
>
> Thanks
> --Andrew
>
>
> ------------------------------------------------------------------------------
> Got Input? Slashdot Needs You.
> Take our quick survey online. Come on, we don't ask for help often.
> Plus, you'll get a chance to win $100 to spend on ThinkGeek.
> http://p.sf.net/sfu/slashdot-survey
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> http://www.doteasy.com
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> http://www.doteasy.com
_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
http://www.doteasy.com |
|
From: Renat S. <sr...@st...> - 2011-07-29 04:33:16
|
On 29.07.2011 01:47, Andrew L wrote: > > Debugging to: > /my/path/to/SQLRELAY/var/sqlrelay/debug/sqlr-connection.30346 Connection debug located in this file. > (pid=24781) Abnormal termination: signal 11 received 11=SIGSEGV, accessing wrong memory region. Could you possibly enable core files dumping and get a backtrace from it? |
16 messages has been excluded from this view by a project administrator.
