Re: [viewvc-users] problem
"C. Michael Pilato" <[email protected]> Wed, 2 Sep 2015 10:14:28 -0400
| Newsgroups | gmane.comp.version-control.cvs.viewcvs.user |
|---|---|
| Message-ID | <CAFVDjdzUrOXX61oT1vQN6EzdoXkejUyTuVkH_4Ra+8PQqk4YSA@mail.gmail.com> |
------=_Part_15393_411661379.1441203272276 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Does this simple fix to 'make-database' work for you, though? http://stackoverflow.com/questions/11471075/mysql-error-type-myisam On Wed, Sep 2, 2015 at 10:13 AM, C. Michael Pilato <[email protected]> wrote: > 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=3135493 To unsubscribe from this discussion, e-mail: [[email protected]]. ------=_Part_15393_411661379.1441203272276 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Does this simple fix to 'make-database' work for y= ou, though?<div><a href=3D"http://stackoverflow.com/questions/11471075/mysq= l-error-type-myisam">http://stackoverflow.com/questions/11471075/mysql-erro= r-type-myisam</a><br></div></div><div class=3D"gmail_extra"><br><div class= =3D"gmail_quote">On Wed, Sep 2, 2015 at 10:13 AM, C. Michael Pilato <span d= ir=3D"ltr"><<a href=3D"mailto:[email protected]" target=3D"_blank">cmp= [email protected]</a>></span> wrote:<br><blockquote class=3D"gmail_quote"= style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><d= iv dir=3D"ltr">ViewVC's database integration doesn't support MariaD= B.=C2=A0 It's written for classic MySQL only.=C2=A0 There's been so= me interest expressed in expanding the functionality to include various oth= er DBs in the past (MariaDB, postgresql, etc.), but as of yet no code has m= aterialized toward this end.</div><div class=3D"HOEnZb"><div class=3D"h5"><= div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Fri, Aug 28, 20= 15 at 9:00 AM, Burger du Plessis <span dir=3D"ltr"><<a href=3D"mailto:bd= [email protected]" target=3D"_blank">[email protected]</a>&= gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 = 0 .8ex;border-left:1px #ccc solid;padding-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 'TYPE=3DMyISAM' 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'= ;<u></u><u></u></p> <p class=3D"MsoNormal">Purging existing data for repository root `/usr/loca= l/rancid/var/CVS'<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 "/usr/local/viewvc-1.1.6/bin/./cvsd= badmin", line 181, in <module><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 "/usr/local/viewvc-1.1.6/lib/cvsdb.= py", 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 "/usr/local/viewvc-1.1.6/lib/cvsdb.= py", line 233, in GetRepositoryID<u></u><u></u></p> <p class=3D"MsoNormal">=C2=A0=C2=A0=C2=A0 return self.get_id("reposito= ries", "repository", repository, auto_set)<u></u><u></u></p> <p class=3D"MsoNormal">=C2=A0 File "/usr/local/viewvc-1.1.6/lib/cvsdb.= py", 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 "/usr/local/viewvc-1.1.6/lib/cvsdb.= py", 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 "/usr/lib64/python2.7/site-packages= /MySQLdb/cursors.py", 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 "/usr/lib64/python2.7/site-packages= /MySQLdb/connections.py", 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, "Tab= le 'ViewVC.repositories' doesn't exist")<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's comprehensi= ve email content=20 security solution</font>. </font> <p></p><u></u><u></u> </div> </blockquote></div><br></div> </div></div></blockquote></div><br></div> ------=_Part_15393_411661379.1441203272276--