Re: [viewvc-users] problem

------=_Part_15384_1231479663.1441203210808
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

ViewVC's database integration doesn't support MariaDB.  It's written for
classic MySQL only.  There's been some interest expressed in expanding the
functionality to include various other DBs in the past (MariaDB,
postgresql, etc.), but as of yet no code has materialized toward this end.

On Fri, Aug 28, 2015 at 9:00 AM, Burger du Plessis <
[email protected]> wrote:

>
>
> HI Guys do anyone know how to fix this.
>
> I have been following RhysEvans_overview_0.3 to fix the ViewVC as this was
> not updating or creating new revision numbers but its showed in the
> backend.
>
> Tried upgrading it to viewvc 1.1.6 as per file but now I get this error
> when trying to create the VIEWVC database.
>
>
>
> Im running Centos 7 with MariaDB
>
>
>
> And because I cant finish this step I cant rebuild the database from the
> cvsroot
>
>
>
> Any assistance will be greatly appreciated
>
>
>
>
>
> root@/etc~~/usr/local/viewvc-1.1.6/bin/./make-database
>
> MySQL Hostname [default: localhost]:
>
> MySQL User: root
>
> MySQL Password: ******
>
> ViewVC Database Name [default: ViewVC]:
>
> ERROR 1064 (42000) at line 6: You have an error in your SQL syntax; check
> the manual that corresponds to your MariaDB server version for the right
> syntax to use near 'TYPE=MyISAM' at line 6
>
>
>
> [ERROR] The database did not create sucessfully.
>
> root@/etc~~
>
>
>
> rancid@/etc~~/usr/local/viewvc-1.1.6/bin/./cvsdbadmin rebuild
> /usr/local/rancid/var/CVS/CVSROOT
>
> Using repository root `/usr/local/rancid/var/CVS'
>
> Purging existing data for repository root `/usr/local/rancid/var/CVS'
>
> Traceback (most recent call last):
>
>   File "/usr/local/viewvc-1.1.6/bin/./cvsdbadmin", line 181, in <module>
>
>     db.PurgeRepository(root)
>
>   File "/usr/local/viewvc-1.1.6/lib/cvsdb.py", line 545, in PurgeRepository
>
>     rep_id = self.GetRepositoryID(repository, auto_set=0)
>
>   File "/usr/local/viewvc-1.1.6/lib/cvsdb.py", line 233, in GetRepositoryID
>
>     return self.get_id("repositories", "repository", repository, auto_set)
>
>   File "/usr/local/viewvc-1.1.6/lib/cvsdb.py", line 102, in get_id
>
>     id = self.sql_get_id(table, column, value, auto_set)
>
>   File "/usr/local/viewvc-1.1.6/lib/cvsdb.py", line 79, in sql_get_id
>
>     cursor.execute(sql, sql_args)
>
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174,
> in execute
>
>     self.errorhandler(self, exc, value)
>
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line
> 36, in defaulterrorhandler
>
>     raise errorclass, errorvalue
>
> _mysql_exceptions.ProgrammingError: (1146, "Table 'ViewVC.repositories'
> doesn't exist")
>
>
>
>
>
> *The content of this e-mail is CONFIDENTIAL and subject to the Group Five
> e-mail legal notice.*
>
> *Email Legal Notice:* http://www.groupfive.co.za/legal_notice.php
>
> Scanned by *MailMarshal* - Marshal's comprehensive email content security
> solution.
>
>

------------------------------------------------------
http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=3135492

To unsubscribe from this discussion, e-mail: [[email protected]].
------=_Part_15384_1231479663.1441203210808
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">ViewVC&#39;s database integration doesn&#39;t support Mari=
aDB.=C2=A0 It&#39;s written for classic MySQL only.=C2=A0 There&#39;s been =
some interest expressed in expanding the functionality to include various o=
ther DBs in the past (MariaDB, postgresql, etc.), but as of yet no code has=
 materialized toward this end.</div><div class=3D"gmail_extra"><br><div cla=
ss=3D"gmail_quote">On Fri, Aug 28, 2015 at 9:00 AM, Burger du Plessis <span=
 dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]" target=3D"_b=
lank">[email protected]</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">





<div lang=3D"EN-ZA" link=3D"#0563C1" vlink=3D"#954F72">
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">HI Guys do anyone know how to fix this. <u></u><u></=
u></p>
<p class=3D"MsoNormal">I have been following RhysEvans_overview_0.3 to fix =
the ViewVC as this was not updating or creating new revision numbers but it=
s showed in the backend.
<u></u><u></u></p>
<p class=3D"MsoNormal">Tried upgrading it to viewvc 1.1.6 as per file but n=
ow I get this error when trying to create the VIEWVC database. =C2=A0<u></u=
><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">Im running Centos 7 with MariaDB<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">And because I cant finish this step I cant rebuild t=
he database from the cvsroot<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">Any assistance will be greatly appreciated <u></u><u=
></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<div style=3D"border:none;border-bottom:solid windowtext 1.5pt;padding:0cm =
0cm 1.0pt 0cm">
<p class=3D"MsoNormal" style=3D"border:none;padding:0cm"><u></u>=C2=A0<u></=
u></p>
</div>
<p class=3D"MsoNormal">root@/etc~~/usr/local/viewvc-1.1.6/bin/./make-databa=
se<u></u><u></u></p>
<p class=3D"MsoNormal">MySQL Hostname [default: localhost]:<u></u><u></u></=
p>
<p class=3D"MsoNormal">MySQL User: root<u></u><u></u></p>
<p class=3D"MsoNormal">MySQL Password: ******<u></u><u></u></p>
<p class=3D"MsoNormal">ViewVC Database Name [default: ViewVC]:<u></u><u></u=
></p>
<p class=3D"MsoNormal">ERROR 1064 (42000) at line 6: You have an error in y=
our SQL syntax; check the manual that corresponds to your MariaDB server ve=
rsion for the right syntax to use near &#39;TYPE=3DMyISAM&#39; at line 6<u>=
</u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">[ERROR] The database did not create sucessfully.<u><=
/u><u></u></p>
<div style=3D"border:none;border-bottom:solid windowtext 1.5pt;padding:0cm =
0cm 1.0pt 0cm">
<p class=3D"MsoNormal" style=3D"border:none;padding:0cm">root@/etc~~<u></u>=
<u></u></p>
</div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">rancid@/etc~~/usr/local/viewvc-1.1.6/bin/./cvsdbadmi=
n rebuild /usr/local/rancid/var/CVS/CVSROOT<u></u><u></u></p>
<p class=3D"MsoNormal">Using repository root `/usr/local/rancid/var/CVS&#39=
;<u></u><u></u></p>
<p class=3D"MsoNormal">Purging existing data for repository root `/usr/loca=
l/rancid/var/CVS&#39;<u></u><u></u></p>
<p class=3D"MsoNormal">Traceback (most recent call last):<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/local/viewvc-1.1.6/bin/./cvsd=
badmin&quot;, line 181, in &lt;module&gt;<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 db.PurgeRepository(root)<u></u><u=
></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/local/viewvc-1.1.6/lib/cvsdb.=
py&quot;, line 545, in PurgeRepository<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 rep_id =3D self.GetRepositoryID(r=
epository, auto_set=3D0)<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/local/viewvc-1.1.6/lib/cvsdb.=
py&quot;, line 233, in GetRepositoryID<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 return self.get_id(&quot;reposito=
ries&quot;, &quot;repository&quot;, repository, auto_set)<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/local/viewvc-1.1.6/lib/cvsdb.=
py&quot;, line 102, in get_id<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 id =3D self.sql_get_id(table, col=
umn, value, auto_set)<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/local/viewvc-1.1.6/lib/cvsdb.=
py&quot;, line 79, in sql_get_id<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 cursor.execute(sql, sql_args)<u><=
/u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/lib64/python2.7/site-packages=
/MySQLdb/cursors.py&quot;, line 174, in execute<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 self.errorhandler(self, exc, valu=
e)<u></u><u></u></p>
<p class=3D"MsoNormal">=C2=A0 File &quot;/usr/lib64/python2.7/site-packages=
/MySQLdb/connections.py&quot;, line 36, in defaulterrorhandler<u></u><u></u=
></p>
<p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 raise errorclass, errorvalue<u></=
u><u></u></p>
<p class=3D"MsoNormal">_mysql_exceptions.ProgrammingError: (1146, &quot;Tab=
le &#39;ViewVC.repositories&#39; doesn&#39;t exist&quot;)<u></u><u></u></p>
<div style=3D"border:none;border-bottom:solid windowtext 1.5pt;padding:0cm =
0cm 1.0pt 0cm">
<p class=3D"MsoNormal" style=3D"border:none;padding:0cm"><u></u>=C2=A0<u></=
u></p>
</div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>

<font face=3D"Verdana" size=3D"2"><font face=3D"Verdana" size=3D"2">
<p><font face=3D"Verdana"><strong><font face=3D"Verdana" size=3D"1">The con=
tent of this=20
e-mail is CONFIDENTIAL and subject to the Group Five e-mail legal=20
notice.</font><font face=3D"Verdana"></font></strong></font></p></font></fo=
nt>
<p><font face=3D"Verdana" size=3D"2"><strong><font size=3D"1">Email Legal=
=20
Notice:</font></strong> </font><font face=3D"Times New Roman"><span style=
=3D"COLOR:#1f497d"><font face=3D"Calibri"><a href=3D"http://www.groupfive.c=
o.za/legal_notice.php" target=3D"_blank">http://www.groupfive.co.za/legal_n=
otice.php</a></font><u></u><u></u></span></font></p>
<p><font face=3D"Times New Roman"><span style=3D"COLOR:#1f497d"><font size=
=3D"2"></font></span></font></p>Scanned by<font color=3D"#000000"> </font><=
strong><font color=3D"#4f1f91">MailMarshal</font></strong><font color=3D"#0=
00000" size=3D"2">=20
</font><font color=3D"#808080"><font size=3D"2">- Marshal&#39;s comprehensi=
ve email content=20
security solution</font>. </font>
<p></p><u></u><u></u>
</div>

</blockquote></div><br></div>

------=_Part_15384_1231479663.1441203210808--