Filament Manager Plugin: How to setup postgresql database

Hello tried to install Filament Manager,
but if I install psycopg2 I get the following error:

~/oprint/bin/pip install psycopg2
DEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support
Looking in indexes: https://pypi.org/simple, https://www.piwheels.org/simple
Collecting psycopg2
  Using cached psycopg2-2.8.5.tar.gz (380 kB)
    ERROR: Command errored out with exit status 1:
     command: /home/pi/oprint/bin/python2 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-uCshxT/psycopg2/setup.py'"'"'; __file__='"'"'/tmp/pip-install-uCshxT/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-yc_uiA
         cwd: /tmp/pip-install-uCshxT/psycopg2/
    Complete output (23 lines):
    running egg_info
    creating /tmp/pip-pip-egg-info-yc_uiA/psycopg2.egg-info
    writing /tmp/pip-pip-egg-info-yc_uiA/psycopg2.egg-info/PKG-INFO
    writing top-level names to /tmp/pip-pip-egg-info-yc_uiA/psycopg2.egg-info/top_level.txt
    writing dependency_links to /tmp/pip-pip-egg-info-yc_uiA/psycopg2.egg-info/dependency_links.txt
    writing manifest file '/tmp/pip-pip-egg-info-yc_uiA/psycopg2.egg-info/SOURCES.txt'

    Error: pg_config executable not found.

    pg_config is required to build psycopg2 from source.  Please add the directory
    containing pg_config to the $PATH or specify the full executable path with the
    option:

        python setup.py build_ext --pg-config /path/to/pg_config build ...

    or with the pg_config option in 'setup.cfg'.

    If you prefer to avoid building psycopg2 from source, please install the PyPI
    'psycopg2-binary' package instead.

    For further information please check the 'doc/src/install.rst' file (also at
    <https://www.psycopg.org/docs/install.html>).

    ----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

Can somebody tell me what is wrong
Have I octopi 4 setup with 1.4.2

I had the same issue in my PrintJobHistory-Plugin. Try to patch the "setup.py" file.

  • Download the Plugin as a Zip-File
  • Unzip
  • modifiy the setup.py. Add "psycopg2-binary" into the "plugin_requires" array (don't forget the comma)
  • zip
  • Install new zip via plugin manager

Btw. which version of FM did you install?
There is already a patched version for OP 1.4, Pyhton 3: https://github.com/benjamin-salchow/OctoPrint-FilamentManager (but there is also the PostgresDriver missing)

Second (and most important BTW): Did you already test the new SpoolManager-Plugin :blush:?

Thanks for the replay

meanwhile I read somewhere that this plugin is not supported any more.

Nevertheless I killed my octopi new installation yesterday night it does not start any more properly :frowning:

Damn never try to install just a last plugin before making the backup!

Yes I have installed the Spoolmanager, but I have 3 octopi's with about 12 printers running and I need the overall database.

Do you know anything about when an external database will be implemented?

Thanks in Advance

Kai

just for the records, see https://github.com/OllisGit/OctoPrint-SpoolManager/issues/39

Hallo,

erst mal vielen dank für die Octoremote App?

Ich beschäftige mich gerade in einer erweiterten Vision mit Octoprint und Infrastruktur für meine

zig Drucker

Ich bin mit Olli (Filament und Spoolmanager) in e-Mail Kontakt und warte schon sehnsüchtig auf die externe Datenbank Anbindung.

Da ich inzwischen an 4 octopis 10 Drucker ansteuere und das Thema Filamentverwaltung für mich weiter treiben möchte, habe ich eine Frage

Ich möchte auf jede Spule nach dem Auspacken eine QR Code aufkleben um verschieden Daten fest zu halten, wie z.B.

Spool:

Hersteller:

Werkstoff:

Kaufdatum:

Erste Benutzung:

diiepldnhfndcgla.png

und diese dann mit dem Handy auswerten zu können.

Absolut interessant wäre es jetzt den QR Code direkt mit dem Octoremote und einem darauf installierten QR Code Scanner auszuwerten

und in direkt über Octoprint an die Spool oder Filamentmanager Datenbank zu koppeln.

Das hieße dann Spule an den Drucker gescannt und der aktive Drucker in Octoremote würde automatisch sich die Richtige Spule zuordnen!

wäre genial.

Falls ihr für so was offen seid würde ich mich für eine Rückmeldung freuen

Mfg

K.Epple

PS. ich habe die mail mal cc an OlliSGit adressiert falls er daran auch Interesse hätte