search

fazalmajid / temboz

The Temboz RSS/Atom feed reader
MIT License
81 stars 4 forks source link

Misterious problem in Fedora 18 #107

Closed Pablo2m closed 11 years ago

Pablo2m commented 11 years ago

In Fedora i dont have binaries for pyRXP. The server seems to fail. Can you help?

[pablo2m@localhost temboz-master]$ python temboz --refresh WARNING: empty database, populating... done. 140058251040576 1372036604.68 ("select sql from sqlite_master where name='vfeeds'",) 140058251040576 1372036604.68 done 140058251040576 1372036604.68 ("select count() from sqlite_master where name='fm_feeds' and sql like '%feedfilter%'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fm_rules' and sql like '%ruletype%'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fm_rules' and sql like '%rulefeed%'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fm_items' and sql like '%item_ruleuid%'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fm_feeds' and sql like '%feedexempt%'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fmtags'",) 140058251040576 1372036604.69 done 140058251040576 1372036604.69 ("select count() from sqlite_master\nwhere name='fm_items' and sql like '%itemrated%'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select count() from sqlite_master\nwhere name='fm_feeds' and sql like '%feed_pubxml%'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select count(*) from sqlite_master where name='fm_settings'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select sql from sqlite_master where name='mv_feed_stats'",) 140058251040576 1372036604.7 done WARNING: rebuilding mv_feed_stats... 140058251040576 1372036604.7 ("select sql from sqlite_master where name='update_stat_mv'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select sql from sqlite_master where name='insert_stat_mv'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select sql from sqlite_master where name='delete_stat_mv'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.7 ("select sql from sqlite_master where name='insert_feed_mv'",) 140058251040576 1372036604.7 done 140058251040576 1372036604.71 ("select sql from sqlite_master where name='delete_feed_mv'",) 140058251040576 1372036604.71 done 140058251040576 1372036604.71 ("select sql from sqlite_master where name='mv_feed_stats'",) 140058251040576 1372036604.71 done 140058251040576 1372036604.71 ACQUIRE 140058251040576 1372036604.71 DONE 140058251040576 1372036604.71 ('create table mv_feed_stats (\n snr_feed_uid integer primary key,\n interesting integer default 0,\n unread integer default 0,\n uninteresting integer default 0,\n filtered integer default 0,\n total integer default 0,\n last_modified timestamp,\n snr real default 0.0)',) 140058251040576 1372036604.74 done 140058251040576 1372036604.74 ('insert into mv_feed_stats\nselect feed_uid,\nsum(case when item_rating=1 then 1 else 0 end),\nsum(case when item_rating=0 then 1 else 0 end),\nsum(case when item_rating=-1 then 1 else 0 end),\nsum(case when item_rating=-2 then 1 else 0 end),\nsum(1),\nmax(item_modified),\nsnr_decay(item_rating, item_created, ?)\nfrom fm_feeds left outer join (\n select item_rating, item_feed_uid, item_created,\n ifnull(\n julianday(item_modified),\n julianday(item_created)\n ) as item_modified\n from fm_items\n) on feed_uid=item_feed_uid\ngroup by feed_uid, feed_title, feed_html, feed_xml', [90]) 140058251040576 1372036604.75 done 140058251040576 1372036604.75 ("select sql from sqlite_master where name='v_feeds_snr'",) 140058251040576 1372036604.75 done 140058251040576 1372036604.75 ("create view v_feeds_snr as\nselect feed_uid, feed_title, feed_html, feed_xml, feed_pubxml,\njulianday('now') - last_modified as last_modified,\nifnull(interesting, 0) as interesting,\nifnull(unread, 0) as unread,\nifnull(uninteresting, 0) as uninteresting,\nifnull(filtered, 0) as filtered,\nifnull(total, 0) as total,\nifnull(snr, 0) as snr,\nfeed_status, feed_private, feed_exempt, feed_dupcheck, feed_errors,\nfeed_desc, feed_filter\nfrom fm_feeds\nleft outer join mv_feed_stats on feed_uid=snr_feed_uid\ngroup by feed_uid, feed_title, feed_html, feed_xml",) 140058251040576 1372036604.78 done 140058251040576 1372036604.78 ('create trigger update_stat_mv after update on fm_items\nbegin\n update mv_feed_stats set\n interesting = interesting\n + case new.item_rating when 1 then 1 else 0 end\n - case old.item_rating when 1 then 1 else 0 end,\n unread = unread\n + case new.item_rating when 0 then 1 else 0 end\n - case old.item_rating when 0 then 1 else 0 end,\n uninteresting = uninteresting\n + case new.item_rating when -1 then 1 else 0 end\n - case old.item_rating when -1 then 1 else 0 end,\n filtered = filtered\n + case new.item_rating when -2 then 1 else 0 end\n - case old.item_rating when -2 then 1 else 0 end,\n last_modified = max(ifnull(last_modified, 0), \n ifnull(julianday(new.item_modified),\n julianday(new.item_created)))\n where snr_feed_uid=new.item_feed_uid;\nend',) 140058251040576 1372036604.79 done 140058251040576 1372036604.79 ('create trigger insert_stat_mv after insert on fm_items\nbegin\n update mv_feed_stats set\n interesting = interesting\n + case new.item_rating when 1 then 1 else 0 end,\n unread = unread\n + case new.item_rating when 0 then 1 else 0 end,\n uninteresting = uninteresting\n + case new.item_rating when -1 then 1 else 0 end,\n filtered = filtered\n + case new.item_rating when -2 then 1 else 0 end,\n total = total + 1,\n last_modified = max(ifnull(last_modified, 0), \n ifnull(julianday(new.item_modified),\n julianday(new.item_created)))\n where snr_feed_uid=new.item_feed_uid;\nend',) 140058251040576 1372036604.8 done 140058251040576 1372036604.81 ('create trigger delete_stat_mv after delete on fm_items\nbegin\n update mv_feed_stats set\n interesting = interesting\n - case old.item_rating when 1 then 1 else 0 end,\n unread = unread\n - case old.item_rating when 0 then 1 else 0 end,\n uninteresting = uninteresting\n - case old.item_rating when -1 then 1 else 0 end,\n filtered = filtered\n - case old.item_rating when -2 then 1 else 0 end,\n total = total - 1\n where snr_feed_uid=old.item_feed_uid;\nend',) 140058251040576 1372036604.85 done 140058251040576 1372036604.85 ('create trigger insert_feed_mv after insert on fm_feeds\nbegin\n insert into mv_feed_stats (snr_feed_uid) values (new.feed_uid);\nend',) 140058251040576 1372036604.86 done 140058251040576 1372036604.86 ('create trigger delete_feed_mv after delete on fm_feeds\nbegin\n delete from mv_feed_stats\n where snr_feed_uid=old.feed_uid;\nend',) 140058251040576 1372036604.88 done 140058251040576 1372036604.88 RELEASE 140058251040576 1372036604.88 DONE 140058251040576 1372036604.88 commit done 140058251040576 1372036604.88 ("select sql from sqlite_master where name='v_feeds_snr'",) 140058251040576 1372036604.88 done 140058251040576 1372036604.88 ('drop view v_feeds_snr',) 140058251040576 1372036604.89 done 140058251040576 1372036604.89 ACQUIRE 140058251040576 1372036604.89 DONE 140058251040576 1372036604.89 ("create view v_feeds_snr as\nselect feed_uid, feed_title, feed_html, feed_xml, feed_pubxml,\njulianday('now') - last_modified as last_modified,\nifnull(interesting, 0) as interesting,\nifnull(unread, 0) as unread,\nifnull(uninteresting, 0) as uninteresting,\nifnull(filtered, 0) as filtered,\nifnull(total, 0) as total,\nifnull(snr, 0) as snr,\nfeed_status, feed_private, feed_exempt, feed_dupcheck, feed_errors,\nfeed_desc, feed_filter\nfrom fm_feeds\nleft outer join mv_feed_stats on feed_uid=snr_feed_uid\ngroup by feed_uid, feed_title, feed_html, feed_xml",) 140058251040576 1372036604.93 done 140058251040576 1372036604.93 RELEASE 140058251040576 1372036604.93 DONE 140058251040576 1372036604.93 commit 140058251040576 1372036605.07 ("select rule_uid, rule_type, rule_text, rule_feed_uid,\n strftime('%s', rule_expires)\n from fm_rules\n where rule_expires is null or rule_expires > julianday('now')",) 140058251040576 1372036605.07 done 140058251040576 1372036605.07 ('select feed_uid, feed_filter from fm_feeds\n where feed_filter is not null',) 140058251040576 1372036605.08 done 140058251040576 1372036605.1 ("select feed_uid, feed_xml, feed_etag, feed_dupcheck,\n strftime('%s', feed_modified) from fm_feeds where feed_status=0 ",) 140058251040576 1372036605.1 done [pablo2m@localhost temboz-master]$ python temboz --server & [1] 2054 [pablo2m@localhost temboz-master]$ python temboz --server [pablo2m@localhost temboz-master]$

fazalmajid commented 11 years ago

pyRXP is only used for OPML import. I've been meaning to replace it with the Python built-in xml.etree.ElementTree module instead, #30, just haven't found the time to do so. There should be a file called error.log in the temboz directory, are you seeing any special messages there?

Pablo2m commented 11 years ago

I update to Fedora 19

After run :

[pablo2m@localhost temboz-master]$ python temboz --refresh WARNING: empty database, populating... done. WARNING: rebuilding mv_feed_stats... done [pablo2m@localhost temboz-master]$ python temboz --server

I cant login

error.log :

Traceback (most recent call last): File "/usr/lib64/python2.7/SocketServer.py", line 593, in process_request_thread self.finish_request(request, client_address) File "/usr/lib64/python2.7/SocketServer.py", line 334, in finish_request self.RequestHandlerClass(request, client_address, self) File "/usr/lib64/python2.7/SocketServer.py", line 649, in init self.handle() File "/usr/lib64/python2.7/BaseHTTPServer.py", line 340, in handle self.handle_one_request() File "/usr/lib64/python2.7/BaseHTTPServer.py", line 328, in handle_one_request method() File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 243, in do_GET self.process_request() File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 453, in process_request self.use_template('error', [self.input, {'e': e}]) File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 322, in use_template mod = import(tmpl) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 423, in importHook mod = _self_doimport(nm, ctx, fqname) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 489, in doimport mod = director.getmod(nm) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 329, in getmod mod = owner.getmod(nm) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 65, in getmod ' %(name)s, original traceback follows:\n%(exc_txt)s'%locals()) ImportError: Error while compiling Cheetah module error, original traceback follows: Traceback (most recent call last):
File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 58, in getmod
return self._compile(name, tmplPath)
File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 80, in _compile
open(file, 'w').write(code)
IOError: [Errno 2] No such file or directory: 'modules/pages_error_tmpl.py' Traceback (most recent call last): File "/usr/lib64/python2.7/SocketServer.py", line 593, in process_request_thread self.finish_request(request, client_address) File "/usr/lib64/python2.7/SocketServer.py", line 334, in finish_request self.RequestHandlerClass(request, client_address, self) File "/usr/lib64/python2.7/SocketServer.py", line 649, in init self.handle() File "/usr/lib64/python2.7/BaseHTTPServer.py", line 340, in handle self.handle_one_request() File "/usr/lib64/python2.7/BaseHTTPServer.py", line 328, in handle_one_request method() File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 243, in do_GET self.process_request() File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 453, in process_request self.use_template('error', [self.input, {'e': e}]) File "/home/pablo2m/Escritorio/Feeds/temboz-master/server.py", line 322, in use_template mod = import(tmpl) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 423, in importHook mod = _self_doimport(nm, ctx, fqname) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 489, in doimport mod = director.getmod(nm) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportManager.py", line 329, in getmod mod = owner.getmod(nm) File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 65, in getmod ' %(name)s, original traceback follows:\n%(exc_txt)s'%locals()) ImportError: Error while compiling Cheetah module error, original traceback follows: Traceback (most recent call last):
File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 58, in getmod
return self._compile(name, tmplPath)
File "/usr/lib64/python2.7/site-packages/Cheetah/ImportHooks.py", line 80, in _compile
open(file, 'w').write(code)
IOError: [Errno 2] No such file or directory: 'modules/pages_error_tmpl.py'

Exactly what OS and what version of python and cheetah you use?

fazalmajid commented 11 years ago

This should be fixed now, please git pull and rerun. No need to rebuild your database. The OPML import should also work without requiring pyRXP.