\documentclass{article}
\usepackage{ulem}
\usepackage{graphicx}
\usepackage{hyperref}
\pagestyle{headings}
\begin{document}
\part{Migrating an existing horde installation's group from SQL to LDAP}
\section{Manually}
I strongly suggest you don't play around in production!
\subsection{Basics}
\begin{itemize}
\item Configure a separate vhost each for the db-based and the sql-based setup
\item create conf-\{sqlvhost\}.host.com.php and conf-\{ldapvhost\}.host.com.php each containing only the php tag and all \$conf['group'] stuff.
\item use the docs on how to setup horde for ldap groups.
\item ensure both are basically working (create some bogus group and add some user in each backend)
\item Now open https://\textbackslash\{\}\{host\textbackslash\{\}\}/horde/admin/groups.php or https://\textbackslash\{\}\{host\textbackslash\{\}\}/admin/groups.php in each site.
\item Create all the missing groups in the ldap backend. add all the missing users.
\end{itemize}
\subsection{Permissions}
(assuming SQL backend) select * from horde\_perms where perm\_data like "\%groups\%";
Each permission assigned to a group by numeric group id must be cloned to be used by the ldap group backend.
Best use the group admin screen.
Do not attempt to edit the perms using an sql statement.
\subsection{Shares}
(assuming sharesng sql backend is used)
Find any apps using sharesng shares
mysql> show tables like "\%sharesng\_groups\%";
For each found table,
For each group\_uid which is numeric, look up the group name
and build a query to create a corresponding entry with the same perms.
\subsubsection{KRONOLITH}
select DISTINCT CONCAT(
"INSERT INTO kronolith\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
", ",
perm\_1024,
");"
)
as query from kronolith\_sharesng\_groups, horde\_groups
WHERE kronolith\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND kronolith\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
++++ NAG
select DISTINCT CONCAT(
"INSERT INTO nag\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from nag\_sharesng\_groups, horde\_groups
WHERE nag\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND nag\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
\subsubsection{ansel}
select DISTINCT CONCAT(
"INSERT INTO ansel\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from ansel\_sharesng\_groups, horde\_groups
WHERE ansel\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND ansel\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
++++ gollem
select DISTINCT CONCAT(
"INSERT INTO gollem\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from gollem\_sharesng\_groups, horde\_groups
WHERE gollem\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND gollem\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
\subsubsection{ingo}
select DISTINCT CONCAT(
"INSERT INTO ingo\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from ingo\_sharesng\_groups, horde\_groups
WHERE ingo\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND ingo\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
++++ mnemo
select DISTINCT CONCAT(
"INSERT INTO mnemo\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from mnemo\_sharesng\_groups, horde\_groups
WHERE mnemo\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND mnemo\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
\subsubsection{turba}
select DISTINCT CONCAT(
"INSERT INTO turba\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from turba\_sharesng\_groups, horde\_groups
WHERE turba\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND turba\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
++++ whups
select DISTINCT CONCAT(
"INSERT INTO whups\_sharesng\_groups VALUES(",
share\_id,
", \textbackslash\{\}"cn=",
horde\_groups.group\_name,
",ou=hordegroups,dc=domain,dc=com\textbackslash\{\}"",
", ",
perm\_2,
", ",
perm\_4,
", ",
perm\_8,
", ",
perm\_16,
");"
)
as query from whups\_sharesng\_groups, horde\_groups
WHERE whups\_sharesng\_groups.group\_uid REGEXP "[0-9]+\$"
AND whups\_sharesng\_groups.group\_uid=horde\_groups.group\_uid;
\subsection{Cache}
Clear horde group cache and horde shares cache once you're done.
\section{By script}
TBD
\end{document}