Re: [Sqlrelay-discussion] sqlrsh hanging on openbsd

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

I just figured out the problem with sqlrsh.  sqlrsh can use the readline
library, and there appears to be a bug in the code that gets compiled if
the readline library is absent.

You can fix the problem by either installing the readline library
package and rebuilding or by editing src/cmdline/sqlrsh.C and changing:

#ifndef HAVE_READLINE
sqlrsh::sqlrsh() {
	standardin.setFileDescriptor(0);
}
#endif

to:

#ifndef HAVE_READLINE
sqlrsh::sqlrsh() {
	standardin.setFileDescriptor(0);
	standardin.allowShortReads();
}
#endif


I'll make a maintenance release soon with this fix.

As for sqlr-stop not working, I'll need to look into that a bit more.


Dave
dav...@fi...


On Thu, 2005-05-26 at 23:42 -0500, Jolan Luff wrote:
> hi,
> 
> i'm trying to get sqlrelay-0.36.2 running on openbsd/i386 with a sqlite3
> database.
> 
> i'm using the sqlrelay.conf from:
> 
> http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/sqlite.html
> 
> with the only modifications being the database path and runas
> group/user.  i am using sqlrelay.dtd from the distribution as well.
> 
> the output from 'sqlr-start -id sqlitetest' looks fine:
> 
> Starting listener:
>   sqlr-listener -id sqlitetest -config /etc/pkg/sqlrelay.conf
> 
> Starting 3 connections to sqlitetest :
>   sqlr-connection-sqlite -id sqlitetest -connectionid sqlitetest -config /etc/pkg/sqlrelay.conf
>   sqlr-connection-sqlite -id sqlitetest -connectionid sqlitetest -config /etc/pkg/sqlrelay.conf
>   sqlr-connection-sqlite -id sqlitetest -connectionid sqlitetest -config /etc/pkg/sqlrelay.conf
> 
> Starting scaler:
>   sqlr-scaler  -id sqlitetest -config /etc/pkg/sqlrelay.conf
> 
> Starting cache manager:
>   sqlr-cachemanager
> 
> 'sqlrsh -id sqlitetest' semms to connect ok:
> 
> SQLRShell - Version 0.22
>         Connected to: localhost:9000 as sqlitetest
> 
>         type help; for a help.
> 
> 0>
> 
> but after running "help;", it just hangs.
> 
> shutting things down via 'sqlr-stop sqlitetest' doesn't seem to work either:
> 
> Killing the following processes:
> All processes killed.
> 
> but ps auwwx |grep sqlr shows 6 processes still running.
> 
> any ideas on what to check or some pointers on how to debug what's going
> on?
> 
> thanks,
> - jolan
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>