Skip to content

setup.php #3

Open
Open

Description

@bet0x

Tried to install, Ubuntu 14, Apache (also nginx) and setup always return to the same page.

Activity

  1. zenbi commented on May 23, 2014

    @zenbi
    Member

    All entry points go through index.php file in the root of the www folder. In nginx this is from the "try_files $uri $uri/ /index.php;" line. If you try to use apache, you will need to create quite inclusive set of mod_rewrite rules (that I have not created.)

    If the URL in your browser is ever "setup.php" then you likely have the docroot set incorrectly. The docroot of the webserver should be the www subfolder in the pipecode source. An example screenshot is here: http://pipecode.org/images/screenshot-setup.png

    The setup script requires write access to the root of the pipecode source directory in order to create the conf.php that contains the main configuration (like the SQL connection strings.) Make sure the fpm php worker process are running under a user account that has sufficient rights to the directory.

  2. bet0x commented on Apr 26, 2015

    @bet0x
    Author

    Can't install it on Apache, no success. Can you create the rules for mod_rewrite or some kind of tutorial please?

  3. bet0x commented on Oct 26, 2015

    @bet0x
    Author

    Finally i managed to get it working, but during the setup i get this:

    error: invalid value - method [post] type [string] name [sql_user] value [barrahom_pipedot]
    
  4. bet0x commented on Oct 26, 2015

    @bet0x
    Author

    Fixed, DB can't have a _ as prefix or suffix, now here:

    error: sql [insert into captcha_challenge (remote_ip, captcha_id) values (?, ?)] arg [189.132.153.113, ] msg [SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'captcha_id' cannot be null]
    

    I made the rewrite rules:

    RewriteEngine on
    RewriteCond $1 !^(index\.php|images|robots\.txt)
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php/$1 [L,QSA]
    
    

    Also setup didn't insert my user data i think.

  5. bet0x commented on Oct 26, 2015

    @bet0x
    Author

    Also captcha is not working.

  6. bet0x commented on Oct 26, 2015

    @bet0x
    Author

    Well, i did all the setup by hand due a bug on setup.php, i figured it how it works, etcetara, now i have an issue, i created a topic and make a example story, approbed that story and i get this:

    error: sql [select count(*) as item_count from article where match (title) against (? in boolean mode) and publish_time > ? and publish_time < ? and article.feed_id <> ] arg [lorem ipsum dolor sit amet, 1444603211, 1447195211] msg [SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
    
  7. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    Also, uploading or deleting an avatar gives the next error:

    error: sql [insert into drive_data (hash, server_id, size) values (?, ?, ?)] arg [f46dd12cbf618c7427ebaf0c9ddcae30eb039aa063c1541756226c271b946da5, , 191] msg [SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'server_id' cannot be null]
    
  8. zenbi commented on Oct 27, 2015

    @zenbi
    Member

    for the drive_data error add the following line to your conf.php:

    $server_id = 1;
    

    at some point, you'll also want to insert a corresponding record into the "drive_server" table with the dns name of your server:

    insert into drive_server (server_name) values ('nameofserver.example.com')
    
  9. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    Regarding the data on drive_server, must be the server_name wich i'm using for the website?

  10. zenbi commented on Oct 27, 2015

    @zenbi
    Member

    The server name of the computer.

    The "drive" is a simple "object storage" system that will eventually span multiple computers. For example, if the hard drive fills up on server1, then files should still be writable on server2, etc. At the moment, however, everything is still expecting a single server.

  11. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    Great, and the error related to the story? you can check barrahome.org

  12. zenbi commented on Oct 27, 2015

    @zenbi
    Member

    The "item_count from article" sql error above is from the "Similar Articles" feature. Add a RSS news feed to the site (http://barrahome.org/atom) to create a record in the feed table. The code should then automatically figure out the $server_feed_id variable that is currently blank and messing things up.

  13. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    I'm lost there dunno how to do the last part.

  14. zenbi commented on Oct 27, 2015

    @zenbi
    Member
    1. Go to your "feed page" (http://alberto.barrahome.org/feed/)
    2. Click the "Edit" link at top right
    3. Click the "Add" button on one of the columns
    4. Enter the URL for your sites atom feed (http://barrahome.org/atom)
    5. Click "Add" button to finish
  15. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    Fatal Error
    Unable to parse feed

  16. zenbi commented on Oct 27, 2015

    @zenbi
    Member

    Could insert a record manually to get around it for now. First make a valid short id:

    insert into short (type_id) values (50)
    

    Then perform a select to see the automatically assigned "short_id" created from that record and use that as the "feed_id" to manually insert a feed record:

    insert into feed (feed_id, title, slug, uri) values (insert-your-short-code-here, 'BarraHome', 'barrahome', 'http://barrahome.org/atom')
    
  17. zenbi commented on Oct 27, 2015

    @zenbi
    Member

    If you are not expecting to use the RSS feed reader feature, I could probably make that an optional checkbox that can be toggled in the settings page (like twitter and such is now)

  18. bet0x commented on Oct 27, 2015

    @bet0x
    Author

    oh so pipe loads my posts as rss? now it works! 💃

  19. bet0x commented on Oct 28, 2015

    @bet0x
    Author

    Got a question, how i delete a story? or a journal entry? i didn't see any button for that!

  20. zenbi commented on Oct 28, 2015

    @zenbi
    Member

    There is no delete button. For Pipedot, I didn't want the ability for anyone (even editors) to remove stories or comments. (the whole anti-censorship thing)

    However, editors can "hide" comments. They mark the item as "Junk" and most people will not see them (unless they have the "Show Junk" checkbox selected in their settings)

  21. zenbi commented on Oct 28, 2015

    @zenbi
    Member

    You could, of course, manually delete the data from the SQL database (one row from the "story" table and the corresponding row from the "short" table)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions