? Editing: Post:21.body Save Delete Cancel
Initial sync in progress...

Newest topics

Follow in NewsfeedFollowing
+ Start new topic
Loading...
stickied

Title

Body
^1 ^2 added ━ started by user_name
More topics

 

Follow in NewsfeedFollowing

[SOLVED] Why dbQuery on 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH stopped working??

./ZeroNet.sh dbQuery 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH "SELECT * FROM follow WHERE auth_address IS '16dEowtNbV89NxPcDrAKkmnuXtiJVoVcDm'"

The above command worked OK at least till Feb 11.
What's wrong?

I got the following error msg when I do the same thing now:
SiteManager Deleting orphan site from content.db: 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH

^1 ^2 leftside posted on Aug 12, 2019
Please sign innew comment
Sign in as...
Submit comment
You are running out of your allowed space, please contact the site's admin at unknown to raise your limit.
user_nameadded ^1 ^2
Reply
Body
mg03 days ago ^1 ^2
Reply

leftside: I've never mentioned I'm using Zeronet in Android. My zeronet is always on linux.

good to know

leftside3 days ago ^1 ^2
Reply

mg0: So both are pretty much doing the same? in that case I'd mind the directory from which you are running the script, maybe one is being called with a wrong working directory and then won't be able to find other files for working, as for data and log I think those are determined by the zeronet.conf file. Btw, I don't know about android, never tried it; just talking about linux here.

I've never mentioned I'm using Zeronet in Android. My zeronet is always on linux.

mg03 days ago ^1 ^2
Reply

leftside: SCRIPT="start.py" of ZeroBundle/ZeroNet.sh was commented by me as # commented to stop automatic opening firefox rather than tor-browser // 2018-03-04, and the ZeroNet.sh's last modified date shows 2018-03-04 18:59 although I updated Zeronet a few days ago. In the other hand, ZeroBundle/ZeroNet/ZeroNet.sh has not been touched at all and its last modified date shows 2016-04-25 19:19. [...]

So both are pretty much doing the same? in that case I'd mind the directory from which you are running the script, maybe one is being called with a wrong working directory and then won't be able to find other files for working, as for data and log I think those are determined by the zeronet.conf file. Btw, I don't know about android, never tried it; just talking about linux here.

leftsideon Aug 14, 2019 ^1 ^2
Reply

mg0: SCRIPT="start.py"

SCRIPT="start.py" of ZeroBundle/ZeroNet.sh was commented by me as # commented to stop automatic opening firefox rather than tor-browser // 2018-03-04, and the ZeroNet.sh's last modified date shows 2018-03-04 18:59 although I updated Zeronet a few days ago. In the other hand, ZeroBundle/ZeroNet/ZeroNet.sh has not been touched at all and its last modified date shows 2016-04-25 19:19.

Any advice? thanks.

mg0on Aug 13, 2019 ^2 ^3
Reply

It's not resolved since we didn't find the cause and corrected it, it may as well come back and haunt us in the future. I don't know for that zeronet distribution (is that android?) but it seems that one script uses start.py while the other exclusively uses zeronet.py.

gitcenteron Aug 13, 2019 ^1 ^2
Reply

leftside: @mg0 @gitcenter SOLVED. [...]

I still don't see why it didn't work, but, anyways, great this issue is resolved.

leftsideon Aug 13, 2019 ^1 ^2
Reply

@mg0 @gitcenter SOLVED.

Running ./ZeroNet.sh in ZeroBundle/ works but ./ZeroNet.sh in ZeroBundle/ZeroNet/ doesn't.

Two files have a slight difference as follows:

  <<ZeroBundle/ZeroNet.sh>>             |  <<ZeroBundle/ZeroNet/ZeroNet.sh>>

  #!/bin/bash                           |  #!/bin/bash
  cd "$(dirname "$0")"                  |  cd "$(dirname "$0")"
  if [ x$DISPLAY != x ] ; then          |  if [ x$DISPLAY != x ] ; then
      # Has gui, open browser           |      # Has gui, open browser
      # SCRIPT="start.py" # commented to|      SCRIPT="start.py"
      SCRIPT="zeronet.py" # replaced // |  ----------------------------------------
  else                                  |  else
      # No gui                          |      # No gui
      SCRIPT="zeronet.py"               |      SCRIPT="zeronet.py"
  fi                                    |  fi
                                        |
  if [ -d "ZeroNet" ]; then             |  if [ -d "ZeroNet" ]; then
-     cd "$(dirname "$0")/ZeroNet"      |-     cd "$(dirname "$0")/ZeroNet"
|     ../Python/python $SCRIPT "$@"     ||     ../Python/python $SCRIPT "$@"
| else                                  || else
|     ./Python/python -m zerobundle.run ||     ./Python/python -m zerobundle.run "h
| fi                                    || fi
leftsideon Aug 13, 2019 ^1 ^2
Reply

mg0: 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH

-rw-r--r--. 1 user1 user1  79M Aug 13 12:09 ZeroMe.db

All other files also have the similar permissions...

mg0on Aug 12, 2019 ^1 ^2
Reply

@leftside: have you checked the file permissions in your zerome folder.

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH I believe. I have no idea why your command doesn't work, tbh

$ find data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/

data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/dbschema.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/zerome.ico
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/css
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/css/all.css
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/nav-icon.svg
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/nav-icon.png
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/logo.png
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/loading-circle.gif
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/unkown.png
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/loading.gif
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img/logo.svg
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/merged-ZeroMe
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/merged-ZeroMe/ZeroMe.db
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js/all.js
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/content.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/hu.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/tr.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/fr.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/nl.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/it.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/sk.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/zh.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/pt-br.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/zh-tw.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages/da.json
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/index.html
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js-external
data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js-external/pngencoder.js

$ du data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/

148     data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/css
32      data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/img
80016   data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/merged-ZeroMe
276     data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js
44      data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/languages
60      data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/js-external
80600   data/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/
leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH I believe. I have no idea why your command doesn't work, tbh

$ ./ZeroNet.sh dbQuery 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH 'SELECT * FROM follow'

- Starting ZeroNet...
- OpenSSL loaded, version: 01000207F
- Version: 0.6.3 r3542, Python 2.7.11 |Continuum Analytics, Inc.| (default, Dec  6 2015, 18:08:32) 
[GCC 4.4.7 20120313 (Red Hat 4.4.7-1)], Gevent: 1.0.2
SiteManager Deleting orphan site from content.db: 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH
[]
gitcenteron Aug 12, 2019 ^1 ^2
Reply

leftside: What should I give as an argument for ./ZeroNet.sh dbQuery XXXXX before that SQL query?

1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH I believe. I have no idea why your command doesn't work, tbh

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: SELECT COUNT(DISTINCT json.user_name) [...]

What should I give as an argument for ./ZeroNet.sh dbQuery XXXXX before that SQL query?

gitcenteron Aug 12, 2019 ^1 ^2
Reply
SELECT COUNT(DISTINCT json.user_name)
FROM follow
LEFT JOIN json ON (json.json_id = follow.json_id)
WHERE auth_address = "1Cy3ntkN2GN9MH6EaW6eHpi4YoRS2nK5Di"

works for me.

gitcenteron Aug 12, 2019 ^1 ^2
Reply

leftside: @gitcenter Would u give a simple dbquery to calculate the number of followers of a certain user in ZeroMe from all the hubs, which currently works find at the moment?

K, in a sec.

leftsideon Aug 12, 2019 ^1 ^2
Reply

@gitcenter Would u give a simple dbquery to calculate the number of followers of a certain user in ZeroMe from all the hubs, which currently works find at the moment?

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: It looks like if the site is not in the database (neither in sites.json not in content.db), yet you can still visit it (though you probably can't receive updates). Stop ZeroNet, check whether there is 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH in sites.json. If there is not, add this: [...]

That paragraph exists in my zeronet data/sites.json:

  "1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH": {
    "added": 1521300498, 
    "ajax_key": "77038xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6966518", 
    "auth_key": "9339fxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxadc4aa0", 
    "bytes_recv": 9210280, 
    "bytes_sent": 3067666, 
    "cache": {
      "bad_files": {}, 
      "hashfield": ""
    }, 
    "domain": "Me.ZeroNetwork.bit", 
    "downloaded": 1521300498, 
    "modified": 1562545614, 
    "optional_downloaded": 0, 
    "own": false, 
    "peers": 3259, 
    "permissions": [
      "Merger:ZeroMe"
    ], 
    "serving": true, 
    "size": 525881, 
    "size_optional": 0, 
    "wrapper_key": "87abcxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxa3e4b6"
  },
gitcenteron Aug 12, 2019 ^1 ^2
Reply

It looks like if the site is not in the database (neither in sites.json not in content.db), yet you can still visit it (though you probably can't receive updates). Stop ZeroNet, check whether there is 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH in sites.json. If there is not, add this:

"1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH": {
  "added": 0,
  "ajax_key": "blablablaarandom64characterhexstring",
  "auth_key": "blablablaarandom64characterhexstring",
  "bytes_recv": 0,
  "bytes_sent": 0,
  "cache": {
   "bad_files": {},
   "hashfield": ""
  },
  "domain": "Me.ZeroNetwork.bit",
  "downloaded": 0,
  "modified": 1562545614,
  "optional_downloaded": 0,
  "own": false,
  "peers": 0,
  "permissions": ["Merger:ZeroMe"],
  "serving": true,
  "size": 525881,
  "size_files_optional": 0,
  "size_optional": 0,
  "wrapper_key": "blablablaarandom64characterhexstring"
 },

Now delete content.db and start ZeroNet. It might take a while to fill content.db, but when it's done, it should work.

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: Uhm, download 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH? lol

FYI, plz check this which is dated Apr 26.

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: Uhm, download 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH? lol

http://127.0.0.1:43110/1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH/ simply brings me to http://127.0.0.1:43110/Me.ZeroNetwork.bit/ with the problem still unsolved.

gitcenteron Aug 12, 2019 ^1 ^2
Reply

leftside: What am I supposed to do?

Uhm, download 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH? lol

leftsideon Aug 12, 2019 ^1 ^2
Reply

gitcenter: This looks like if 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH wasn't downloaded.

What am I supposed to do?

gitcenteron Aug 12, 2019 ^1 ^2
Reply

This looks like if 1MeFqFfFFGQfa1J3gJyYYUvb5Lksczq7nH wasn't downloaded.

leftsideon Aug 12, 2019 ^1 ^2
Reply

@pexo

This page is a snapshot of ZeroNet. Start your own ZeroNet for complete experience. Learn More