Can't find the sql file from sources packages,where is it?

[borlanlyk]

During installation, it prompt that i need to connect with mysql , but after created databases, errors occurs

---

/home/ops/rpki_1.0.1494995102/sbin/rpki-sql-setup create
Please enter your MySQL root password:
exit/home/ops/rpki_1.0.1494995102/sbin/rpki-manage syncdb --noinput
Unknown command: 'syncdb'

---

and refers to the manul in docs , i also can't find the sql file at schema folder, pls help me thx a lot

[sraustein]

The default database engine these days is PostgreSQL, not MySQL. Yes, the documentation is badly out of date (ENOFUNDING).

The schema is buried in the Django ORM code, or, rather, the Django ORM code generates the schema on the fly from the combination of the declared model classes and the current database engine configuration.

Manual installation directly from source hasn't been tested in a while, and is probably full of nasty historical relics from the version 0.x series. If you want to do a source installation, your best bet would be do something like:

sudo wget -q -O /etc/apt/trusted.gpg.d/rpki.gpg https://download.rpki.net/APTng/apt-gpg-key.gpg
sudo wget -q -O /etc/apt/sources.list.d/rpki.list https://download.rpki.net/APTng/rpki.xenial.list
apt-get source rpki
sudo apt-get build-dep rpki
cd rpki-1.0-*~xenial
debuild -b -uc -us

which should generate binary packages equivalent to the ones you'd have gotten had you instead done sudo apt-get install rpki-rp rpki-ca.

Substitute "jessie" for "xenial" if you're building on Debian Jessie instead of Ubuntu Xenial.

If you're building on some other Debian-family platform, you may have to tweak things a bit, but the same basic process should work, assuming that APT can figure out how to satisfy the package dependencies.

If you're building on some other platform...it's more work. We stopped directly supporting other platforms when our funding started running low, so we could focus what resources we had on maintaining our own software rather than fighting every package and build system on every platform. Happy to try to help you work out what you need for your platform, and to take back patches if they look generally useful.