Discussion:
[PacketFence-devel] _graphite database
Boris Epstein
2015-07-02 17:45:56 UTC
Permalink
Hello listmates,

I am trying to initialize the PF using the raw code and am getting the
following message.

Error! Error applying the schema to the database pf_graphite

The database I intend to use is named "pf" and the message appears after I
press the "Create database and tables" button in the configurator.

Two databases are created in my MySQL server; one if named "pf" and the
other "pf_graphite"; "pf" has some tables in it, "pf_graphite" has none.

Has anybody seen this? What if anything am I doing wrong? What is that
_graphite DB anyways?

Thanks.

Cheers,

Boris.
Louis Munro
2015-07-02 17:48:56 UTC
Permalink
The _graphite database holds the graphite preferences used by the dashboard.

Look in the http.admin logs to see what may be causing the error.

--
Louis Munro
***@inverse.ca :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org)
Post by Boris Epstein
Hello listmates,
I am trying to initialize the PF using the raw code and am getting the following message.
Error! Error applying the schema to the database pf_graphite
The database I intend to use is named "pf" and the message appears after I press the "Create database and tables" button in the configurator.
Two databases are created in my MySQL server; one if named "pf" and the other "pf_graphite"; "pf" has some tables in it, "pf_graphite" has none.
Has anybody seen this? What if anything am I doing wrong? What is that _graphite DB anyways?
Thanks.
Cheers,
Boris.
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/_______________________________________________
PacketFence-devel mailing list
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
Boris Epstein
2015-07-02 18:04:10 UTC
Permalink
Hi Louis,

Thanks!

I figured this part out - apparently this requires linking in
/usr/local/pf/db:

ln -s pf_graphite-schema-5.1.0.sql pf_graphite-schema.sql

This is a bit confusing. I am wondering if I should stick something into
the Makefile to make this part of the build process.

Cheers,

Boris.
Post by Louis Munro
The _graphite database holds the graphite preferences used by the dashboard.
Look in the http.admin logs to see what may be causing the error.
--
Louis Munro
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
www.packetfence.org)
Hello listmates,
I am trying to initialize the PF using the raw code and am getting the following message.
Error! Error applying the schema to the database pf_graphite
The database I intend to use is named "pf" and the message appears after I
press the "Create database and tables" button in the configurator.
Two databases are created in my MySQL server; one if named "pf" and the
other "pf_graphite"; "pf" has some tables in it, "pf_graphite" has none.
Has anybody seen this? What if anything am I doing wrong? What is that
_graphite DB anyways?
Thanks.
Cheers,
Boris.
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/_______________________________________________
PacketFence-devel mailing list
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
PacketFence-devel mailing list
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
Louis Munro
2015-07-02 18:12:10 UTC
Permalink
Post by Boris Epstein
ln -s pf_graphite-schema-5.1.0.sql pf_graphite-schema.sql
This is a bit confusing. I am wondering if I should stick something into the Makefile to make this part of the build process.
Actually, this is taken care of in the packaging.
We should do whatever we already do for pf-schema.sql.

The logic is the same.

--
Louis Munro
***@inverse.ca :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org)
Boris Epstein
2015-07-02 18:14:22 UTC
Permalink
Post by Boris Epstein
I figured this part out - apparently this requires linking in
ln -s pf_graphite-schema-5.1.0.sql pf_graphite-schema.sql
This is a bit confusing. I am wondering if I should stick something into
the Makefile to make this part of the build process.
Actually, this is taken care of in the packaging.
We should do whatever we already do for pf-schema.sql.
The logic is the same.
--
This is cool. Where are the packaging scripts?

Boris.
Post by Boris Epstein
_______________________________________________
PacketFence-devel mailing list
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
Louis Munro
2015-07-02 18:16:31 UTC
Permalink
Post by Boris Epstein
This is cool. Where are the packaging scripts?
addons/packages for RHEL,
debian/ for …. (no points for guessing).

--
Louis Munro
***@inverse.ca :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org)
Boris Epstein
2015-07-02 19:53:08 UTC
Permalink
Awesome.

Thanks Louis!
Post by Louis Munro
Post by Boris Epstein
This is cool. Where are the packaging scripts?
addons/packages for RHEL,
debian/ for 
. (no points for guessing).
--
Louis Munro
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
www.packetfence.org)
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
PacketFence-devel mailing list
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
Loading...