Move from SQLlite to MYSQL Database

[Jon Brown]

I need to move to a mysql setup with my Munki Server I followed the out of the box setup and now that the Proof of Concept stage is over I want to move to a better database environment. How do I move to a mysql setup without loosing the data that I have in my sql lite database or does it even matter? Will the users that I already have enrolled need to be re-enrolled? Will they hit the server and just automatically update the new database with their info? Any help is appreciated!

[Gregory Neagle]

On Aug 13, 2013, at 10:32 AM, Jon Brown <jbr...@bluestatedigital.com> wrote:

> I need to move to a mysql setup with my Munki Server I followed the out of the box setup and now that the Proof of Concept stage is over I want to move to a better database environment. How do I move to a mysql setup without loosing the data that I have in my sql lite database or does it even matter?

Only you can decide that.

> Will the users that I already have enrolled need to be re-enrolled?

What does that mean? If your MWA server starts storing its data in MySQL instead of sqlite3, why would your clients know or care? If you change the hostname, URL or port --- then your clients will not know how to find/connect to it.

> Will they hit the server and just automatically update the new database with their info?

I'd say yes, but I may be making assumptions about what you are intending to do.

-Greg

> Any help is appreciated!
>

[Riley Shott]

Hi Jon,

Do you have a Munkiserver setup or a Munki Web Admin setup? You posted to the Munkiserver list, but I also see that Greg said "your MWA". Regardless, what he said is valid in both cases.

If you are running Munkiserver take a look at this page on the wiki:

https://github.com/jnraine/munkiserver/wiki/Moving-to-MySQL

-Riley

> --
> You received this message because you are subscribed to the Google
> Groups "munkiserver-dev" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to munkiserver-d...@googlegroups.com.
> To post to this group, send email to
> munkise...@googlegroups.com.
> Visit this group at http://groups.google.com/group/munkiserver-dev .
> For more options, visit https://groups.google.com/groups/opt_out .
>
>
>

[Gregory Neagle]

Sorry -- I was in MWA brain mode; but my comments should apply to munkiserver as well.

[Jon Brown]

I have Munki Server setup as well as Muki Web Admin both are using the same database the sqllite db. I think I am good your link puts me on the right track! Thanks!!