Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of bluethundr@gmail.com designates
 209.85.212.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <9E70060A-C997-418C-A1EC-F7DC18ADDA7D@thelastpickle.com>
References: 
 <CAOZy0e=-49_OApetQbWmfcbDX2Y6QQ96Jg0f5jORi0rs_OyfZg@mail.gmail.com>
	<9E70060A-C997-418C-A1EC-F7DC18ADDA7D@thelastpickle.com>
Date: Tue, 3 Jan 2012 08:01:07 -0500
Message-ID: 
 <CAOZy0e=-CNGwZKCjDvEo8Li-WNzRyEHXnQd=4BU+vcjd4dj-DQ@mail.gmail.com>
Subject: Re: cassandra site wsod's /mysql site functions
From: Tim Dunphy <bluethundr@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

unfortunately not .. :( thanks for checking. still looking for advice
on this! tx

On Tue, Jan 3, 2012 at 3:47 AM, aaron morton <aaron@thelastpickle.com> wrot=
e:
> Tim,
> Did you get this sorted out ?
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 28/12/2011, at 3:11 PM, Tim Dunphy wrote:
>
> hello,
>
> I am new to the world of non-relational databases. Cassandra is
> refreshingly easy to setup and has a great command line environment. I
> genuinely like the command line tools and look forward to learning
> more.
>
> However I have been asked to setup a php/cassandra site that also has
> some mysql components. I had the site up and running pretty quickly on
> the mysql end of things. But I have been struggling to get the
> cassandra portion working for several days at this point without luck.
>
> I am a little unfamiliar with cassandra's files but I can perform
> enough configuration to get a few nodes gossiping. Although at the
> moment I have to get only one website running. I've implemented sl4j.
> I can start cassandra without any problems and connect to port 9160 on
> telnet and use the command line tools.
>
> When I hit the cassandra portions of the site this is what appears
> in the apache error logs:
>
> [root@beta ~]# tail -f /var/log/httpd/jf-error.log
> [Tue Dec 27 20:27:01 2011] [error] [client 173.63.16.196] PHP Fatal
> error: =A0Uncaught exception 'TTransportException' with message 'TSocket
> read 0 bytes' in
> /usr/local/src/thrift/lib/php/src/transport/TSocket.php:263\nStack
> trace:\n#0
> /usr/local/src/thrift/lib/php/src/transport/TBufferedTransport.php(126):
> TSocket->read(1024)\n#1 [internal function]:
> TBufferedTransport->read(8192)\n#2
> /usr/local/src/thrift/lib/php/src/packages/cassandra/Cassandra.php(519):
> thrift_protocol_read_binary(Object(TBinaryProtocolAccelerated),
> 'cassandra_Cassa...', false)\n#3
> /usr/local/src/thrift/lib/php/src/packages/cassandra/Cassandra.php(491):
> CassandraClient->recv_get_range_slices()\n#4
> /var/www/jf-current/includes/classes/class.Joke.php(294):
> CassandraClient->get_range_slices('joke_fire1',
> Object(cassandra_ColumnParent), Object(cassandra_SlicePredicate),
> Object(cassandra_KeyRange), 1)\n#5
> /var/www/jf-current/admin/manageJokes.php(31): Joke->GetAllJokes()\n#6
> {main}\n =A0thrown in
> /usr/local/src/thrift/lib/php/src/transport/TSocket.php on line 263,
> referer: http://beta/admin/main.php
>
> What you see in the web browser is looks like the PHP 'white screen
> of death' although no errors turn up on the screen. Although E_ALL is
> configured in php.ini
>
> error_reporting =3D E_ALL & ~E_DEPRECATED
>
>
>
> Thrift is installed and has the cassandra bindings:
>
> [root@beta ~]# ls -l /usr/local/src/thrift/lib/php/src/packages/cassandra=
/
> total 252
> -rw-r--r-- 1 apache apache 192089 Dec 27 10:08 Cassandra.php
> -rw-r--r-- 1 apache apache =A0=A0=A0308 Dec 27 10:08 cassandra_constants.=
php
> -rw-r--r-- 1 apache apache =A050965 Dec 27 10:08 cassandra_types.php
>
>
> And this is what you see in the cassandra logs when I start the cassandra
> db.
>
> [root@beta ~]# tail -f /etc/alternatives/cassandrahome/log/cassandra.log
> SLF4J: Class path contains multiple SLF4J bindings. =A0=A0=A0=A0=A0=A0=A0=
[ =A0OK =A0]
> SLF4J: Found binding in
> [jar:file:/usr/local/apache-cassandra-1.0.6/lib/slf4j-log4j12-1.6.1.jar!/=
org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/usr/local/apache-cassandra-1.0.6/lib/slf4j-log4j12-1.6.4.jar!/=
org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> INFO 20:27:51,817 Logging initialized
> INFO 20:27:51,824 JVM vendor/version: Java HotSpot(TM) Server VM/1.7.0_01
> INFO 20:27:51,824 Heap size: 1993342976/1994391552
> INFO 20:27:51,824 Classpath:
> /etc/alternatives/cassandrahome/bin/../conf:/etc/alternatives/cassandraho=
me/bin/../build/classes/main:/etc/alternatives/cassandrahome/bin/../build/c=
lasses/thrift:/etc/alternatives/cassandrahome/bin/../lib/antlr-3.2.jar:/etc=
/alternatives/cassandrahome/bin/../lib/apache-cassandra-1.0.5.jar:/etc/alte=
rnatives/cassandrahome/bin/../lib/apache-cassandra-1.0.6.jar:/etc/alternati=
ves/cassandrahome/bin/../lib/apache-cassandra-clientutil-1.0.5.jar:/etc/alt=
ernatives/cassandrahome/bin/../lib/apache-cassandra-clientutil-1.0.6.jar:/e=
tc/alternatives/cassandrahome/bin/../lib/apache-cassandra-thrift-1.0.5.jar:=
/etc/alternatives/cassandrahome/bin/../lib/apache-cassandra-thrift-1.0.6.ja=
r:/etc/alternatives/cassandrahome/bin/../lib/avro-1.4.0-fixes.jar:/etc/alte=
rnatives/cassandrahome/bin/../lib/avro-1.4.0-sources-fixes.jar:/etc/alterna=
tives/cassandrahome/bin/../lib/cglib-nodep-2.2.jar:/etc/alternatives/cassan=
drahome/bin/../lib/commons-cli-1.1.jar:/etc/alternatives/cassandrahome/bin/=
../lib/commons-cli-1.2-javadoc.jar:/etc/alternatives/cassandrahome/bin/../l=
ib/commons-codec-1.2.jar:/etc/alternatives/cassandrahome/bin/../lib/commons=
-collections-3.2.1.jar:/etc/alternatives/cassandrahome/bin/../lib/commons-l=
ang-2.4.jar:/etc/alternatives/cassandrahome/bin/../lib/commons-lang3-3.1.ja=
r:/etc/alternatives/cassandrahome/bin/../lib/compress-lzf-0.8.4.jar:/etc/al=
ternatives/cassandrahome/bin/../lib/concurrentlinkedhashmap-lru-1.2.jar:/et=
c/alternatives/cassandrahome/bin/../lib/easymock-2.4.jar:/etc/alternatives/=
cassandrahome/bin/../lib/easymockclassextension-2.4.jar:/etc/alternatives/c=
assandrahome/bin/../lib/guava-r08.jar:/etc/alternatives/cassandrahome/bin/.=
./lib/gwt-servlet.jar:/etc/alternatives/cassandrahome/bin/../lib/high-scale=
-lib-1.1.2.jar:/etc/alternatives/cassandrahome/bin/../lib/jackson-core-asl-=
1.4.0.jar:/etc/alternatives/cassandrahome/bin/../lib/jackson-mapper-asl-1.4=
.0.jar:/etc/alternatives/cassandrahome/bin/../lib/jamm-0.2.5.jar:/etc/alter=
natives/cassandrahome/bin/../lib/jline-0.9.94.jar:/etc/alternatives/cassand=
rahome/bin/../lib/jline-1.0.jar:/etc/alternatives/cassandrahome/bin/../lib/=
json-simple-1.1.jar:/etc/alternatives/cassandrahome/bin/../lib/jsr305.jar:/=
etc/alternatives/cassandrahome/bin/../lib/junit.jar:/etc/alternatives/cassa=
ndrahome/bin/../lib/libthrift-0.6.jar:/etc/alternatives/cassandrahome/bin/.=
./lib/log4j-1.2.16.jar:/etc/alternatives/cassandrahome/bin/../lib/servlet-a=
pi-2.5-20081211.jar:/etc/alternatives/cassandrahome/bin/../lib/slf4j-api-1.=
6.1.jar:/etc/alternatives/cassandrahome/bin/../lib/slf4j-api-1.6.4.jar:/etc=
/alternatives/cassandrahome/bin/../lib/slf4j-log4j12-1.6.1.jar:/etc/alterna=
tives/cassandrahome/bin/../lib/slf4j-log4j12-1.6.4.jar:/etc/alternatives/ca=
ssandrahome/bin/../lib/snakeyaml-1.6.jar:/etc/alternatives/cassandrahome/bi=
n/../lib/snappy-java-1.0.4.1.jar:/etc/alternatives/cassandrahome/bin/../lib=
/tl4j-1.1.0.jar:/etc/alternatives/cassandrahome/bin/../lib/jamm-0.2.5.jar
> INFO 20:27:51,826 JNA not found. Native methods will be disabled.
> INFO 20:27:51,838 Loading settings from
> file:/usr/local/apache-cassandra-1.0.6/conf/cassandra.yaml
> INFO 20:27:52,073 DiskAccessMode 'auto' determined to be standard,
> indexAccessMode is standard
> INFO 20:27:52,164 Global memtable threshold is enabled at 634MB
> INFO 20:27:52,569 Opening
> /var/lib/cassandra/data/system/Versions-hb-10 (247 bytes)
> INFO 20:27:52,600 Opening
> /var/lib/cassandra/data/system/LocationInfo-hc-34 (412 bytes)
> INFO 20:27:52,603 Opening
> /var/lib/cassandra/data/system/LocationInfo-hc-36 (163 bytes)
> INFO 20:27:52,714 Couldn't detect any schema definitions in local storage=
.
> INFO 20:27:52,715 Found table data in data directories. Consider
> using the CLI to define your schema.
> INFO 20:27:52,738 Creating new commitlog segment
> /var/lib/cassandra/commitlog/CommitLog-1325035672738.log
> INFO 20:27:52,749 Replaying
> /var/lib/cassandra/commitlog/CommitLog-1325035216334.log
> INFO 20:27:52,782 Finished reading
> /var/lib/cassandra/commitlog/CommitLog-1325035216334.log
> INFO 20:27:52,791 Enqueuing flush of
> Memtable-Versions@22236556(83/103 serialized/live bytes, 3 ops)
> INFO 20:27:52,795 Writing Memtable-Versions@22236556(83/103
> serialized/live bytes, 3 ops)
> INFO 20:27:52,854 Completed flushing
> /var/lib/cassandra/data/system/Versions-hb-11-Data.db (247 bytes)
> INFO 20:27:52,864 Log replay complete, 3 replayed mutations
> INFO 20:27:52,873 Cassandra version: 1.0.5
> INFO 20:27:52,873 Thrift API version: 19.19.0
> INFO 20:27:52,873 Loading persisted ring state
> INFO 20:27:52,878 Starting up server gossip
> INFO 20:27:52,892 Enqueuing flush of
> Memtable-LocationInfo@10684447(29/36 serialized/live bytes, 1 ops)
> INFO 20:27:52,893 Writing Memtable-LocationInfo@10684447(29/36
> serialized/live bytes, 1 ops)
> INFO 20:27:52,919 Completed flushing
> /var/lib/cassandra/data/system/LocationInfo-hb-37-Data.db (80 bytes)
> INFO 20:27:52,931 Starting Messaging Service on port 7000
> INFO 20:27:52,943 Using saved token 4629402575447179348925465938016128085=
6
> INFO 20:27:52,945 Enqueuing flush of
> Memtable-LocationInfo@26017982(53/66 serialized/live bytes, 2 ops)
> INFO 20:27:52,945 Writing Memtable-LocationInfo@26017982(53/66
> serialized/live bytes, 2 ops)
> INFO 20:27:52,965 Completed flushing
> /var/lib/cassandra/data/system/LocationInfo-hb-38-Data.db (163 bytes)
> INFO 20:27:52,968 Node localhost/127.0.0.1 state jump to normal
> INFO 20:27:52,969 Bootstrap/Replace/Move completed! Now serving reads.
> INFO 20:27:52,970 Will not load MX4J, mx4j-tools.jar is not in the classp=
ath
>
> The original website used cassandra 0.6.8 but I have also been asked
> to use the latest version so at this point I am using 1.0.6. I have
> done my best to duplicate the libraries used in the old version of the
> site.
>
> Here are the libraries from the old (0.6.8) that the site was
> originally running with:
>
> [root@beta ~]# ls -l /var/www/jf-current/apache-cassandra-0.6.8/lib
> total 9700
> -rw-r--r-- 1 apache apache 1906965 Dec 27 10:10 antlr-3.1.3.jar
> -rw-r--r-- 1 apache apache 1293367 Dec 27 10:10 apache-cassandra-0.6.8.ja=
r
> -rw-r--r-- 1 apache apache =A0=A024360 Dec 27 10:10 clhm-production.jar
> -rw-r--r-- 1 apache apache =A0=A036174 Dec 27 10:10 commons-cli-1.1.jar
> -rw-r--r-- 1 apache apache =A0=A030085 Dec 27 10:10 commons-codec-1.2.jar
> -rw-r--r-- 1 apache apache =A0575389 Dec 27 10:10
> commons-collections-3.2.1.jar
> -rw-r--r-- 1 apache apache =A0261809 Dec 27 10:10 commons-lang-2.4.jar
> -rw-r--r-- 1 apache apache =A0639592 Dec 27 10:10 google-collections-1.0.=
jar
> -rw-r--r-- 1 apache apache 2682112 Dec 27 10:10 hadoop-core-0.20.1.jar
> -rw-r--r-- 1 apache apache =A0255915 Dec 27 10:10 high-scale-lib.jar
> -rw-r--r-- 1 apache apache =A0910990 Dec 27 10:10 ivy-2.1.0.jar
> -rw-r--r-- 1 apache apache =A0150249 Dec 27 10:10 jackson-core-asl-1.4.0.=
jar
> -rw-r--r-- 1 apache apache =A0386237 Dec 27 10:10 jackson-mapper-asl-1.4.=
0.jar
> -rw-r--r-- 1 apache apache =A0=A087325 Dec 27 10:10 jline-0.9.94.jar
> -rw-r--r-- 1 apache apache =A0=A016046 Dec 27 10:10 json-simple-1.1.jar
> -rw-r--r-- 1 apache apache =A0188158 Dec 27 10:10 libthrift-r917130.jar
> drwxr-xr-x 2 apache apache =A0=A0=A04096 Dec 27 10:10 licenses
> -rw-r--r-- 1 apache apache =A0367444 Dec 27 10:10 log4j-1.2.14.jar
> -rw-r--r-- 1 apache apache =A0=A023445 Dec 27 10:10 slf4j-api-1.5.8.jar
> -rw-r--r-- 1 apache apache =A0=A0=A09679 Dec 27 10:10 slf4j-log4j12-1.5.8=
.jar
>
> And these are the libraries I have installed on the new (1.06.) version:
>
> [root@beta ~]# ls -l /etc/alternatives/cassandrahome/lib/
> total 15248
> -rw-r--r-- 1 root root 1928009 Dec 27 10:06 antlr-3.2.jar
> -rw-r--r-- 1 root root 1796527 Dec 27 10:06 apache-cassandra-1.0.5.jar
> -rw-r--r-- 1 root root 1798770 Dec 27 10:06 apache-cassandra-1.0.6.jar
> -rw-r--r-- 1 root root =A0=A031856 Dec 27 10:06
> apache-cassandra-clientutil-1.0.5.jar
> -rw-r--r-- 1 root root =A0=A031856 Dec 27 10:06
> apache-cassandra-clientutil-1.0.6.jar
> -rw-r--r-- 1 root root =A0861683 Dec 27 10:06
> apache-cassandra-thrift-1.0.5.jar
> -rw-r--r-- 1 root root =A0861683 Dec 27 10:06
> apache-cassandra-thrift-1.0.6.jar
> -rw-r--r-- 1 root root =A0596381 Dec 27 10:06 avro-1.4.0-fixes.jar
> -rw-r--r-- 1 root root =A0276425 Dec 27 10:06 avro-1.4.0-sources-fixes.ja=
r
> -rw-r--r-- 1 root root =A0322362 Dec 27 10:06 cglib-nodep-2.2.jar
> -rw-r--r-- 1 root root =A0=A036174 Dec 27 10:06 commons-cli-1.1.jar
> -rw-r--r-- 1 root root =A0214274 Dec 27 10:06 commons-cli-1.2-javadoc.jar
> -rw-r--r-- 1 root root =A0=A030085 Dec 27 10:06 commons-codec-1.2.jar
> -rw-r--r-- 1 root root =A0575389 Dec 27 10:06 commons-collections-3.2.1.j=
ar
> -rw-r--r-- 1 root root =A0261809 Dec 27 10:06 commons-lang-2.4.jar
> -rw-r--r-- 1 root root =A0315805 Dec 27 10:06 commons-lang3-3.1.jar
> -rw-r--r-- 1 root root =A0=A025490 Dec 27 10:06 compress-lzf-0.8.4.jar
> -rw-r--r-- 1 root root =A0=A053011 Dec 27 10:06
> concurrentlinkedhashmap-lru-1.2.jar
> -rw-r--r-- 1 root root =A0=A078815 Dec 27 10:06 easymock-2.4.jar
> -rw-r--r-- 1 root root =A0=A056010 Dec 27 10:06 easymockclassextension-2.=
4.jar
> -rw-r--r-- 1 root root 1112253 Dec 27 10:06 guava-r08.jar
> -rw-r--r-- 1 root root =A0938019 Dec 27 10:06 gwt-servlet.jar
> -rw-r--r-- 1 root root =A0=A096046 Dec 27 10:06 high-scale-lib-1.1.2.jar
> -rw-r--r-- 1 root root =A0150249 Dec 27 10:06 jackson-core-asl-1.4.0.jar
> -rw-r--r-- 1 root root =A0386237 Dec 27 10:06 jackson-mapper-asl-1.4.0.ja=
r
> -rw-r--r-- 1 root root =A0=A0=A05792 Dec 27 10:06 jamm-0.2.5.jar
> -rw-r--r-- 1 root root =A0=A087325 Dec 27 10:06 jline-0.9.94.jar
> -rw-r--r-- 1 root root =A0=A091183 Dec 27 10:06 jline-1.0.jar
> -rw-r--r-- 1 root root =A0=A016046 Dec 27 10:06 json-simple-1.1.jar
> -rw-r--r-- 1 root root =A0=A033017 Dec 27 10:06 jsr305.jar
> -rw-r--r-- 1 root root =A0121070 Dec 27 10:06 junit.jar
> -rw-r--r-- 1 root root =A0295890 Dec 27 10:06 libthrift-0.6.jar
> drwxr-xr-x 2 root root =A0=A0=A04096 Dec 27 10:06 licenses
> -rw-r--r-- 1 root root =A0481534 Dec 27 10:06 log4j-1.2.16.jar
> -rw-r--r-- 1 root root =A0134133 Dec 27 10:06 servlet-api-2.5-20081211.ja=
r
> -rw-r--r-- 1 root root =A0=A025496 Dec 27 10:06 slf4j-api-1.6.1.jar
> -rw-r--r-- 1 root root =A0=A025962 Dec 27 10:06 slf4j-api-1.6.4.jar
> -rw-r--r-- 1 root root =A0=A0=A09753 Dec 27 10:06 slf4j-log4j12-1.6.1.jar
> -rw-r--r-- 1 root root =A0=A0=A09748 Dec 27 10:06 slf4j-log4j12-1.6.4.jar
> -rw-r--r-- 1 root root =A0232121 Dec 27 10:06 snakeyaml-1.6.jar
> -rw-r--r-- 1 root root =A0995967 Dec 27 10:06 snappy-java-1.0.4.1.jar
> -rw-r--r-- 1 root root =A0=A0=A05578 Dec 27 10:06 tl4j-1.1.0.jar
>
>
>
> I'd be happy to provide some additional info in regards to configs if
> I can get some pointers on where and what to look for.
>
> I hope to resolve this in the coming days and I would greatly
> appreciate any input you might have. Thanks in advance!
>
> Regards,
> tim
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
>


--=20
GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B