<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
font-size: 9pt;
font-family: 'Courier New';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 11pt;
font-family: 'tahoma';
font-weight: bold;
color: #ffffff;
background-color: #0000ff;
}
span.rvts7
{
font-size: 11pt;
font-family: 'tahoma';
}
a.rvts8, span.rvts8
{
font-size: 11pt;
font-family: 'tahoma';
color: #0000ff;
background-color: #ffffff;
text-decoration: underline;
}
span.rvts9
{
font-size: 11pt;
}
a.rvts10, span.rvts10
{
font-size: 11pt;
color: #0000ff;
text-decoration: underline;
}
span.rvts11
{
font-size: 8pt;
font-family: 'arial';
font-style: italic;
color: #c0c0c0;
}
a.rvts12, span.rvts12
{
font-size: 8pt;
font-family: 'arial';
color: #0000ff;
text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>
<p>Yes, I understand your difficulty.</p>
<p><br></p>
<p>As for exact instructions on a free & open-source project - they don't come around too often.</p>
<p><br></p>
<p>But your frustration at not having better "how-to's" is appreciated - I was in a similar boat a few days ago about Radius support and no answers from the community were forth-coming - so I hacked my way through myself and also wrote Wiki docs on a How-to for Radius. </p>
<p><br></p>
<p>However, I doubt there's a great answer around the corner for those that need more hand-holding etc. In short, time is money. How much of either anyone is willing to give away is usually limited.</p>
<p><br></p>
<p>Exact answers and exact and personalized help generally cost more time and/or money.</p>
<p><br></p>
<p>Cheers,</p>
<p>Greg</p>
<p><br></p>
<div><a name="mid_mailman_3_1246377604_23786_wifidog_listes_ilesansfil_org"></a>
<table border=0 cellpadding=1 cellspacing=2 style="background-color: #ffffff;">
<tr valign=top>
<td width=12 style="background-color: #0000ff;">
<p><span class=rvts6>></span></p>
</td>
<td width=764>
<p><span class=rvts7>Hi,</span></p>
<p><br></p>
<p><span class=rvts7>I just got it sorted - thanks for the reply. My query was more related to how EXACTLY to undo what I did. Eventually someone much smarter than me fixed the issue, but for future reference I wouldn't mind knowing what to do. I eventually gained access to the postgres tables but was completely clueless as to what to do there. I did not find any entry for Authenticator parameter that I had put in. I DID find the authenticator parameter entry, but not the values that I had put in and was completely out of my depth in terms of where to look.</span></p>
<p><br></p>
<p><span class=rvts7>In any case - it is fixed and I learnt a valuable lesson :-)</span></p>
<p><br></p>
<p><span class=rvts7>Thanks a lot again.</span></p>
<p><br></p>
<p><span class=rvts7>Theo</span></p>
<p><br></p>
<p><br></p>
<p><a class=rvts8 href="mailto:wifidog-request@listes.ilesansfil.org">wifidog-request@listes.ilesansfil.org</a><span class=rvts7> wrote: </span></p>
<p><span class=rvts9>Envoyez vos messages pour la liste WiFiDog à</span><a class=rvts10 href="mailto:wifidog@listes.ilesansfil.org">wifidog@listes.ilesansfil.org</a><span class=rvts9>
Pour vous (dés)abonner par le web, consulte</span><a class=rvts10 href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog">http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><span class=rvts9>
ou, par email, envoyez un message avec 'help' dans le corps ou dans le
sujet</span><a class=rvts10 href="mailto:wifidog-request@listes.ilesansfil.org">wifidog-request@listes.ilesansfil.org</a><span class=rvts9>
Vous pouvez contacter l'administrateur de la liste à l'adress</span><a class=rvts10 href="mailto:wifidog-owner@listes.ilesansfil.org">wifidog-owner@listes.ilesansfil.org</a><span class=rvts9>
Si vous répondez, n'oubliez pas de changer l'objet du message afin
qu'il soit plus spécifique que "Re: Contenu du digest de WiFiDog..."
Thèmes du jour :
1. Re: Editing Da</span><a class=rvts10 href="mailto:listserv.traffic@sloop.net">listserv.traffic@sloop.net</a><span class=rvts9>)
----------------------------------------------------------------------
Message: 1
Date: Mon, 29 Jun 2009 13:10:35 -0700</span><a class=rvts10 href="mailto:listserv.traffic@sloop.net">listserv.traffic@sloop.net</a><span class=rvts9>
Subject: Re: [isf-wifidog] Editing Database
To: WiFiDog Captive Porta</span><a class=rvts10 href="mailto:wifidog@listes.ilesansfil.org"><wifidog@listes.ilesansfil.org></a><span class=rvts9>
Message-ID:</span><a class=rvts10 href="mailto:20693049.20090629131035@sloop.net"><20693049.20090629131035@sloop.net></a><span class=rvts9>
Content-Type: text/plain; charset=iso-8859-1
The dog_cookie file is only used for installation.
It won't help you for Postgres login etc.
---
Do you remember if you're using LocalAuth or something else?
Do you know what you changed in the Authentication parameters?
Do you only have a single network defined in WiFiDog Auth Server?
(If you have a second network setup, you might be able to login to it using
the old admin credentials.)
Do you know a working postgresql user?
If so, you can probably install PGAdminIII on the ubuntu console,
connect to the WifiDog DB - and edit the network table. This will
allow you replace the authentication type and the parameters field to
w</span><a class=rvts10 href="http://www.pgadmin.org/">http://www.pgadmin.org/</a><span class=rvts9>
I'd guess there's a package for Ubuntu so you don't have to compile
it yourself.
Hope that's of some help. I'm not around too much via email, but i'll
do my best to help as I can.</span></p>
<p><span class=rvts9>Hi,
</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>I messed up my wifidog installation by putting in a wrong value in the
Authentication parameters field. I cannot get in anymore. My
understanding is that I will need to edit the database directly to fix
this issue - but HOW? I found a post stating "or you can use PGADMIN to
edit the database" but people sometimes forget that noobs don't know how
to do that :-</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>I have PGADMIN running on my Ubuntu server. I cannot connect to the
Wifidog Database - it complains about ident authentication and I should
edit the PG_HBA.conf file. I can't get to that file because permission
is denied.</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>I am dabbling in the dark though and just guessing things. The username
I use for the wifidog database is wifidog, and the password what is
stored in tmp/cookie.txt. Is this correct?
</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>Help would really be appreciated - my 4 hotspots are down now.......
</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>Thanks
</span></p>
<p><span class=rvts9> </span></p>
<p><span class=rvts9>Theo
_______________________________________________
WiFiDog mailing li</span><a class=rvts10 href="mailto:wifidog@listes.ilesansfil.org">WiFiDog@listes.ilesansfil.org</a><span class=rvts9> </span><a class=rvts10 href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog">http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><span class=rvts9>
</span></p>
<p><span class=rvts9>
</span></p>
</td>
</tr>
</table>
</div>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts11>-- </span></p>
<p><span class=rvts11>Best regards,</span></p>
<p><span class=rvts11> listserv </span><a class=rvts12 href="mailto:listserv.traffic@sloop.net">mailto:listserv.traffic@sloop.net</a></p>
</body></html>