slashcode-general — This is the general discussion list. Install questions welcome.

[Slashcode-general] Subdomain doesn't work

[Jesse L. <jes...@gm...>]

SGVsbG8sCgpUaGUgc3ViZG9hbWluIChzZWN0aW9uIGFzIHN1YmRvbWFpbikgZG9lc24ndCB3b3Jr
IGF0IG15IHNpdGUuCk1haW4gVVJMOiBodHRwOi8vc2xhc2gudm1tYXRyaXgubmV0LwpTdWJkb21p
YW4gdXJsOmh0dHA6Ly9vcGVuc291cmNlLnNsYXNoLnZtbWF0cml4Lm5ldC8KClBsZWFzZSBoZWxw
LCB0aGFua3MhCgpKZXNzZQo=

Re: [Slashcode-general] can't register new user because have squid proxy

[huang m. <th...@gm...>]

I found if I retry again like that follow the error message says.will ok!
so,waht's the reason ? :-]

2006/4/28, huang mingyou <th...@gm...>:
> hi,all
>
> I delete the "#"  on this line
> #PerlPostReadRequestHandler Slash::Apache::ProxyRemoteAddr
> but still have error.
> I need change my apache configure ?
>
> and why when use https protocol ,all is ok.when use  https,the browser
> between the squid server is https connect, between the squid server
> and real apache server is http connect. so,I think the apache can't
> see difference between https and http.
>
> so strange!
>
>
>
>
>
> 2006/4/28, shane <sh...@lo...>:
> >
> > On Apr 27, 2006, at 8:30 AM, huang mingyou wrote:
> >
> > > hi,shane
> > >
> > >    this is the squid.conf filter rule
> > > acl QUERY urlpath_regex cgi-bin  blog bbs forum \.php \.asp \.pl
> > > \.jsp \? \.cgi
> > > and,you can use this URI to test
> > > http://slash.vmmatrix.net
> > >
> > > 2006/4/27, shane <sh...@lo...>:
> > >>
> > >> On Apr 27, 2006, at 7:18 AM, huang mingyou wrote:
> > >>
> > >>> hi ,list
> > >>>     our slash site behind some squid server that run in accelerate
> > >>> mode,and in the squid configure file I had filter some URI that
> > >>> include *.pl .but I can't register no user ,but if I use htps ,will
> > >>> ok.the error message is that
> > >>>     maybe I behind firewall or proxy.
> > >>>         how to solution this problem ?
> > >>>
> > >>>         --
> > >>>         ---------
> > >>>            HMY
> > >>
> > >> It'd probably be helpful if you could post your squid.conf's
> > >> somewhere and give us a URL to see exactly how you've got it
> > >> configured.
> > >>
> > >>   Shane
> >
> > When I hit http://slash.vmmatrix.net/login.pl?op=3Dnewuserform
> > and filled the form in I got
> >
> > Invalid form key: uu9agfrxIQ
> >
> > do you have the slashd daemon running? formkeys expire, and the
> > slashd daemon is what kicks off the task that expires them.
> >
> > What's interesting is that I did the test again - hit that url, but
> > before i hit submit I looked at the html source. It correctly gave me
> > a new formkey: Y9YlvXmPwg. When I submitted the form again, I got
> > another
> >
> > Invalid form key: Y9YlvXmPwg
> >
> > error message.
> >
> > It would seem like the formkey system isn't matching my IP address to
> > my formkey. Which would kinda make sense if you've got a squid proxy
> > infront of your httpd. Your httpd may not be seeing my real IP
> > address, but instead the IP address of your proxy.
> >
> > Did you look at the vars that could possibly be related to
> > configuration for formkeys/proxying?
> >
> > mysql> select * from vars where name like "%formkey%" or name like "%
> > proxy%";
> > +--------------------------+-------
> > +----------------------------------------------------------------------=
-
> > ----------+
> > | name                     | value |
> > description
> >          |
> > +--------------------------+-------
> > +----------------------------------------------------------------------=
-
> > ----------+
> > | admin_formkeys           | 0     | Do admins have to bother with
> > formkeys?                                         |
> > | formkey_minloggedinkarma | 1     | The min karma a user must have
> > to "count" as a logged-in user for some purposes |
> > | formkey_timeframe        | 14400 | The time frame that we check for
> > a formkey                                      |
> > | http_proxy               |       | http://
> > proxy.whatswrongwiththe.us
> >   |
> > | lenient_formkeys         | 0     | 0 - only ipid, 1 - ipid OR
> > subnetid, in formkey validation check                |
> > +--------------------------+-------
> > +----------------------------------------------------------------------=
-
> > ----------+
> >
> > did you grep the INSTALL for the word proxy? I did, didn't get anything=
.
> >
> > I did grep my installed slash's httpd directory, and my installed
> > slashsite's httpd config file for proxy, here's what I found:
> >
> >      # if you have a frontend/backend setup and have X-Forwarded-For
> >      # headers (such as from mod_proxy_add_forward), use this
> >      # to properly populate remote_ip for formkeys etc.
> >      #PerlPostReadRequestHandler Slash::Apache::ProxyRemoteAddr
> >
> > You may want to look into that more.
> >
> >   Shane
> >
> >
> >
> >
> > --
> > My slashcode stuff: http://slash.lottadot.com/
> > Slashcode faq: http://slash.lottadot.com/slash-faq
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, securit=
y?
> > Get stuff done quickly with pre-integrated technology to make your job =
easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> > _______________________________________________
> > Slashcode-general mailing list
> > Sla...@li...
> > https://lists.sourceforge.net/lists/listinfo/slashcode-general
> >
>
>
> --
> ---------
>    HMY
>


--
Huang Mingyou

[Slashcode-general] Re: non-western character filtered

[Jesse L. <jes...@gm...>]

QW55b25lIGNhbiBoZWxwPwoKU2NvdHQgTG9ja3dvb2QgPHdzbDNAbHJzZWhvc3RpbmcuY29tPiBz
dWdnZXN0ZWQgbWUgdG8gZGVsZXRlIGFsbApmaWx0ZXJzLCBJJ3ZlIGRvbmUgdGhhdC4gQnV0IG5v
IHVzZSwgdGhlIGNoaW5lc2UgY29tbWVudCBkaXNwbGF5cyBhcwptZXNzIGNoYXJhY3Rlci4gV2hl
biBzdWJtaXRlZCBhbiBhcnRpY2xlLCBJIGdvdCBhIG1lc3NhZ2UgIllvdSBtdXN0CnByZXZpZXcg
b25jZSwgcHJvdmlkZSBhIHN1YmplY3QsIHNvbWUgdGV4dCwgYW5kIGEgdG9waWMgYmVmb3JlIHlv
dSBjYW4Kc3VibWl0IiwgdGhlIGNvZGUgdGhpbmtzIENoaW5lc2Ugd29yZHMgYXJlIG5vdCBhIHN1
YmplY3QuCgpJdCBzZWVtcyBTbGFzaCBkb2Vzbid0IHN1cHBvcnQgaW50ZXJuYXRpb25hbCBlbmNv
ZGluZy4K

[Slashcode-general] non-western character filtered

[Jesse L. <jes...@gm...>]

SGksCgpXaGVuIHBvc3QgQ2hpbmVzZSBpbiBjb21tZW50cyBhbmQgc3Rvcnkgc3VibWlzc2lvbiwg
SSBnb3QgdGhpcyBlcnJvciwKIAkKIExhbWVuZXNzIGZpbHRlciBlbmNvdW50ZXJlZC4gUG9zdCBh
Ym9ydGVkIQpSZWFzb246IFBMRUFTRSBET04nVCBVU0UgU08gTUFOWSBDQVBTLiBVU0lORyBDQVBT
IElTIExJS0UgWUVMTElORyEKClNlZW1zIGl0J3MgY2F1c2VkIGJ5IHNsYXNoJ3MgZmlsdGVyLCBz
byB3ZSBjYW5ub3QgcG9zdCBpbiBDaGluZXNlLgoKSGVscCBwbGVhc2UuCgpUaGFua3MhCg==

Re: [Slashcode-general] can't register new user because have squid proxy

[huang m. <th...@gm...>]

hi,all

I delete the "#"  on this line
#PerlPostReadRequestHandler Slash::Apache::ProxyRemoteAddr
but still have error.
I need change my apache configure ?

and why when use https protocol ,all is ok.when use  https,the browser
between the squid server is https connect, between the squid server
and real apache server is http connect. so,I think the apache can't
see difference between https and http.

so strange!





2006/4/28, shane <sh...@lo...>:
>
> On Apr 27, 2006, at 8:30 AM, huang mingyou wrote:
>
> > hi,shane
> >
> >    this is the squid.conf filter rule
> > acl QUERY urlpath_regex cgi-bin  blog bbs forum \.php \.asp \.pl
> > \.jsp \? \.cgi
> > and,you can use this URI to test
> > http://slash.vmmatrix.net
> >
> > 2006/4/27, shane <sh...@lo...>:
> >>
> >> On Apr 27, 2006, at 7:18 AM, huang mingyou wrote:
> >>
> >>> hi ,list
> >>>     our slash site behind some squid server that run in accelerate
> >>> mode,and in the squid configure file I had filter some URI that
> >>> include *.pl .but I can't register no user ,but if I use htps ,will
> >>> ok.the error message is that
> >>>     maybe I behind firewall or proxy.
> >>>         how to solution this problem ?
> >>>
> >>>         --
> >>>         ---------
> >>>            HMY
> >>
> >> It'd probably be helpful if you could post your squid.conf's
> >> somewhere and give us a URL to see exactly how you've got it
> >> configured.
> >>
> >>   Shane
>
> When I hit http://slash.vmmatrix.net/login.pl?op=3Dnewuserform
> and filled the form in I got
>
> Invalid form key: uu9agfrxIQ
>
> do you have the slashd daemon running? formkeys expire, and the
> slashd daemon is what kicks off the task that expires them.
>
> What's interesting is that I did the test again - hit that url, but
> before i hit submit I looked at the html source. It correctly gave me
> a new formkey: Y9YlvXmPwg. When I submitted the form again, I got
> another
>
> Invalid form key: Y9YlvXmPwg
>
> error message.
>
> It would seem like the formkey system isn't matching my IP address to
> my formkey. Which would kinda make sense if you've got a squid proxy
> infront of your httpd. Your httpd may not be seeing my real IP
> address, but instead the IP address of your proxy.
>
> Did you look at the vars that could possibly be related to
> configuration for formkeys/proxying?
>
> mysql> select * from vars where name like "%formkey%" or name like "%
> proxy%";
> +--------------------------+-------
> +-----------------------------------------------------------------------
> ----------+
> | name                     | value |
> description
>          |
> +--------------------------+-------
> +-----------------------------------------------------------------------
> ----------+
> | admin_formkeys           | 0     | Do admins have to bother with
> formkeys?                                         |
> | formkey_minloggedinkarma | 1     | The min karma a user must have
> to "count" as a logged-in user for some purposes |
> | formkey_timeframe        | 14400 | The time frame that we check for
> a formkey                                      |
> | http_proxy               |       | http://
> proxy.whatswrongwiththe.us
>   |
> | lenient_formkeys         | 0     | 0 - only ipid, 1 - ipid OR
> subnetid, in formkey validation check                |
> +--------------------------+-------
> +-----------------------------------------------------------------------
> ----------+
>
> did you grep the INSTALL for the word proxy? I did, didn't get anything.
>
> I did grep my installed slash's httpd directory, and my installed
> slashsite's httpd config file for proxy, here's what I found:
>
>      # if you have a frontend/backend setup and have X-Forwarded-For
>      # headers (such as from mod_proxy_add_forward), use this
>      # to properly populate remote_ip for formkeys etc.
>      #PerlPostReadRequestHandler Slash::Apache::ProxyRemoteAddr
>
> You may want to look into that more.
>
>   Shane
>
>
>
>
> --
> My slashcode stuff: http://slash.lottadot.com/
> Slashcode faq: http://slash.lottadot.com/slash-faq
>
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>


--
---------
   HMY

Re: [Slashcode-general] can't register new user because have squid proxy

[shane <sh...@lo...>]

On Apr 27, 2006, at 8:30 AM, huang mingyou wrote:

> hi,shane
>
>    this is the squid.conf filter rule
> acl QUERY urlpath_regex cgi-bin  blog bbs forum \.php \.asp \.pl  
> \.jsp \? \.cgi
> and,you can use this URI to test
> http://slash.vmmatrix.net
>
> 2006/4/27, shane <sh...@lo...>:
>>
>> On Apr 27, 2006, at 7:18 AM, huang mingyou wrote:
>>
>>> hi ,list
>>>     our slash site behind some squid server that run in accelerate
>>> mode,and in the squid configure file I had filter some URI that
>>> include *.pl .but I can't register no user ,but if I use htps ,will
>>> ok.the error message is that
>>>     maybe I behind firewall or proxy.
>>>         how to solution this problem ?
>>>
>>>         --
>>>         ---------
>>>            HMY
>>
>> It'd probably be helpful if you could post your squid.conf's
>> somewhere and give us a URL to see exactly how you've got it  
>> configured.
>>
>>   Shane

When I hit http://slash.vmmatrix.net/login.pl?op=newuserform
and filled the form in I got

Invalid form key: uu9agfrxIQ

do you have the slashd daemon running? formkeys expire, and the  
slashd daemon is what kicks off the task that expires them.

What's interesting is that I did the test again - hit that url, but  
before i hit submit I looked at the html source. It correctly gave me  
a new formkey: Y9YlvXmPwg. When I submitted the form again, I got  
another

Invalid form key: Y9YlvXmPwg

error message.

It would seem like the formkey system isn't matching my IP address to  
my formkey. Which would kinda make sense if you've got a squid proxy  
infront of your httpd. Your httpd may not be seeing my real IP  
address, but instead the IP address of your proxy.

Did you look at the vars that could possibly be related to  
configuration for formkeys/proxying?

mysql> select * from vars where name like "%formkey%" or name like "% 
proxy%";
+--------------------------+------- 
+----------------------------------------------------------------------- 
----------+
| name                     | value |  
description                                                              
         |
+--------------------------+------- 
+----------------------------------------------------------------------- 
----------+
| admin_formkeys           | 0     | Do admins have to bother with  
formkeys?                                         |
| formkey_minloggedinkarma | 1     | The min karma a user must have  
to "count" as a logged-in user for some purposes |
| formkey_timeframe        | 14400 | The time frame that we check for  
a formkey                                      |
| http_proxy               |       | http:// 
proxy.whatswrongwiththe.us                                               
  |
| lenient_formkeys         | 0     | 0 - only ipid, 1 - ipid OR  
subnetid, in formkey validation check                |
+--------------------------+------- 
+----------------------------------------------------------------------- 
----------+

did you grep the INSTALL for the word proxy? I did, didn't get anything.

I did grep my installed slash's httpd directory, and my installed  
slashsite's httpd config file for proxy, here's what I found:

     # if you have a frontend/backend setup and have X-Forwarded-For
     # headers (such as from mod_proxy_add_forward), use this
     # to properly populate remote_ip for formkeys etc.
     #PerlPostReadRequestHandler Slash::Apache::ProxyRemoteAddr

You may want to look into that more.

  Shane




--
My slashcode stuff: http://slash.lottadot.com/
Slashcode faq: http://slash.lottadot.com/slash-faq

Re: [Slashcode-general] can't register new user because have squid proxy

[huang m. <th...@gm...>]

hi,shane

   this is the squid.conf filter rule
acl QUERY urlpath_regex cgi-bin  blog bbs forum \.php \.asp \.pl \.jsp \? \=
.cgi
and,you can use this URI to test
http://slash.vmmatrix.net

2006/4/27, shane <sh...@lo...>:
>
> On Apr 27, 2006, at 7:18 AM, huang mingyou wrote:
>
> > hi ,list
> >     our slash site behind some squid server that run in accelerate
> > mode,and in the squid configure file I had filter some URI that
> > include *.pl .but I can't register no user ,but if I use htps ,will
> > ok.the error message is that
> >     maybe I behind firewall or proxy.
> >         how to solution this problem ?
> >
> >         --
> >         ---------
> >            HMY
>
> It'd probably be helpful if you could post your squid.conf's
> somewhere and give us a URL to see exactly how you've got it configured.
>
>   Shane
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>


--
---------
   HMY

Re: [Slashcode-general] can't register new user because have squid proxy

[shane <sh...@lo...>]

On Apr 27, 2006, at 7:18 AM, huang mingyou wrote:

> hi ,list
>     our slash site behind some squid server that run in accelerate
> mode,and in the squid configure file I had filter some URI that
> include *.pl .but I can't register no user ,but if I use htps ,will
> ok.the error message is that
>     maybe I behind firewall or proxy.
>         how to solution this problem ?
>
>         --
>         ---------
>            HMY

It'd probably be helpful if you could post your squid.conf's  
somewhere and give us a URL to see exactly how you've got it configured.

  Shane

[Slashcode-general] can't register new user because have squid proxy

[huang m. <th...@gm...>]

hi ,list
    our slash site behind some squid server that run in accelerate
mode,and in the squid configure file I had filter some URI that
include *.pl .but I can't register no user ,but if I use htps ,will
ok.the error message is that
    maybe I behind firewall or proxy.
        how to solution this problem ?

        --
        ---------
           HMY

Re: [Slashcode-general] add section error

[huang m. <th...@gm...>]

oh,thank you very much!

2006/4/27, shane <sh...@lo...>:
>
> On Apr 27, 2006, at 2:45 AM, huang mingyou wrote:
>
> > hi,list.
> >       I had install slash R_2_5_0_94 in debian sarge. all is ok,but I
> > get a error  when I login as administrator and want add a section .
> >       The is the error mesaage in log file.and my perl is 5.8.4. I
> > need upgrade perl to 5.8.6 ? please help me!
> > ------------------------------------------
> > Use of uninitialized value in string eq at
> > /usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line 101.
> > [Thu Apr 27 14:43:36 2006] [error]
> > /sections.pl:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/
> > local/slash/site/slash.vmmatrix.net/htdocs/sections.pl:
> > 224:getSectionExtras
> > called
> > [Thu Apr 27 14:43:36 2006] [error] Which was called
> > by:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/local/
> > slash/site/slash.vmmatrix.net/htdocs/sections.pl:105\n
> > [Thu Apr 27 14:43:36 2006] [error] Can't locate object method
> > "getSubSectionsBySection" via package "Slash::DB::MySQL" at
> > /usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line
> > 228.\n
> > --
> > ---------
> >    HMY
>
> sections.pl is depricated. it doesn't work in the lastest slash,
> because the section-topics ( http://slash.lottadot.com/article.pl?
> sid=3D04/06/18/001233 ) move from sections to 'skins'.
>
> OSTG guys - why is sections.pl even included anymore?
>
> HMY, the solution is to
>
> 1) create a topic-nexus
> 2) add a skin by hand, by doing a sql_insert, that links the skin
> with that topic-nexus
> 3) restart httpd.
>
>   Shane
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>


--
---------
   HMY

Re: [Slashcode-general] add section error

[shane <sh...@lo...>]

On Apr 27, 2006, at 2:45 AM, huang mingyou wrote:

> hi,list.
>       I had install slash R_2_5_0_94 in debian sarge. all is ok,but I
> get a error  when I login as administrator and want add a section .
>       The is the error mesaage in log file.and my perl is 5.8.4. I
> need upgrade perl to 5.8.6 ? please help me!
> ------------------------------------------
> Use of uninitialized value in string eq at
> /usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line 101.
> [Thu Apr 27 14:43:36 2006] [error]
> /sections.pl:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/ 
> local/slash/site/slash.vmmatrix.net/htdocs/sections.pl: 
> 224:getSectionExtras
> called
> [Thu Apr 27 14:43:36 2006] [error] Which was called
> by:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/local/ 
> slash/site/slash.vmmatrix.net/htdocs/sections.pl:105\n
> [Thu Apr 27 14:43:36 2006] [error] Can't locate object method
> "getSubSectionsBySection" via package "Slash::DB::MySQL" at
> /usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line
> 228.\n
> --
> ---------
>    HMY

sections.pl is depricated. it doesn't work in the lastest slash,  
because the section-topics ( http://slash.lottadot.com/article.pl? 
sid=04/06/18/001233 ) move from sections to 'skins'.

OSTG guys - why is sections.pl even included anymore?

HMY, the solution is to

1) create a topic-nexus
2) add a skin by hand, by doing a sql_insert, that links the skin  
with that topic-nexus
3) restart httpd.

  Shane

[Slashcode-general] add section error

[huang m. <th...@gm...>]

hi,list.
      I had install slash R_2_5_0_94 in debian sarge. all is ok,but I
get a error  when I login as administrator and want add a section .
      The is the error mesaage in log file.and my perl is 5.8.4. I
need upgrade perl to 5.8.6 ? please help me!
------------------------------------------
Use of uninitialized value in string eq at
/usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line 101.
[Thu Apr 27 14:43:36 2006] [error]
/sections.pl:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/local/s=
lash/site/slash.vmmatrix.net/htdocs/sections.pl:224:getSectionExtras
called
[Thu Apr 27 14:43:36 2006] [error] Which was called
by:Apache::ROOTslash_2evmmatrix_2enet::sections_2epl:/usr/local/slash/site/=
slash.vmmatrix.net/htdocs/sections.pl:105\n
[Thu Apr 27 14:43:36 2006] [error] Can't locate object method
"getSubSectionsBySection" via package "Slash::DB::MySQL" at
/usr/local/slash/site/slash.vmmatrix.net/htdocs/sections.pl line
228.\n
--
---------
   HMY

[Slashcode-general] 2nd domain for a skin of an existing site

[shane <sh...@lo...>]

Has anyone who is running a section-topics website (ie, with skins,  
css, etc) tried assigning a different top level domain to a skin and  
had it work OK?

As far as I know, all the stock code is setup such that it could  
handle this. The benefits, as we see it, are a quick way to create a  
(possibly, probably) related slash-based website to an existing  
established website.

Obviously, you'd have to set the cookiedomain for the new site's  
skin, and setup the site's httpd.conf such that it'd recognize the  
new tld.

I'm hoping someone's tried this and can say "yea it works".

Anyone?

  Shane

Re: [Slashcode-general] Slashcode using Apache authentication?

[George C. <ga...@sp...>]

** Reply to message from "Clifton Wood" <cli...@gm...> on Mon, 20 Mar
2006 09:19:32 -0500

To all who replied to my request for suggestions on mod_auth_mysql and Slash
integration into other authentication systems, thanks!   I was away for a few
days with limited net access and wasn't able to reply individually.  

I appreciate the help.

George

Re: [Slashcode-general] User journal messages prefs

[shane <sh...@lo...>]

On Mar 20, 2006, at 2:15 PM, Alexandre Leroux wrote:



>
> Hi list,
>
> Here's what I want to do: change the setting of all my users and  
> the default setting for "Journal Entry by Friend" and "Journal  
> Reply" to 'email' by default. This is found in Messages user  
> preferences.
>
>
> The related tables are users_messages and message_codes.
>
>
> mysql> describe users_messages;
> +-------+-----------------------+------+-----+--------- 
> +----------------+
> | Field | Type                  | Null | Key | Default |  
> Extra          |
> +-------+-----------------------+------+-----+--------- 
> +----------------+
> | id    | int(11)               |      | PRI | NULL    |  
> auto_increment |
> | uid   | mediumint(8) unsigned |      | MUL | 0        
> |                |
> | code  | int(11)               |      |     | 0        
> |                |
> | mode  | tinyint(4)            |      |     | 0        
> |                |
> +-------+-----------------------+------+-----+--------- 
> +----------------+
> 4 rows in set (0.00 sec)
>
> mysql> select * from users_messages where uid='3';
> +-----+-----+------+------+
> | id  | uid | code | mode |
> +-----+-----+------+------+
> | 929 |   3 |    0 |    0 |
> | 928 |   3 |    1 |    0 |
> | 927 |   3 |    4 |    0 |
> | 930 |   3 |    5 |    0 |
> | 926 |   3 |    7 |    0 |
> | 925 |   3 |   11 |    0 |
> +-----+-----+------+------+
> 6 rows in set (0.00 sec)
>
> mysql> select * from message_codes;
> +------+----------------------------+---------+-------+------------ 
> +-----------+-------+
> | code | type                       | seclev  | modes | send        
> | subscribe | acl   |
> +------+----------------------------+---------+-------+------------ 
> +-----------+-------+
> |   -2 | Registration Mail          |       1 | 0     | now         
> |         0 |       |
> |   -1 | Unknown Message            |       1 | 0     | now         
> |         0 |       |
> |    0 | Daily Newsletter           |       1 | 0     | now         
> |         0 |       |
> |    1 | Daily Headlines            |       1 | 0     | now         
> |         0 |       |
> |    2 | Metamoderation Results     |       1 |       | collective  
> |         0 |       |
> |    3 | Comment Moderation         |       1 |       | collective  
> |         0 |       |
> |    4 | Comment Reply              |       1 |       | now         
> |         0 |       |
> |    5 | Journal Entry by Friend    |       1 |       | now         
> |         0 |       |
> |    6 | New Submission             |     100 | 0     | now         
> |         0 |       |
> |    7 | Journal Reply              |       1 |       | now         
> |         0 |       |
> |    8 | New Comment                | 1000000 |       | now         
> |         0 |       |
> |   10 | Daily Site Stats           |     100 | 0     | now         
> |         0 | stats |
> |   11 | Email Story                |       1 | 0     | now         
> |         0 |       |
> |   12 | Relationship Change        |       1 |       | collective  
> |         1 |       |
> |   13 | Bad login attempt warnings |       1 | 1     | now         
> |         0 |       |
> |   14 | Daily Moderation Stats     |     100 | 0     | now         
> |         0 | stats |
> |   18 | Invalid HTML Input         |     100 |       | now         
> |         0 |       |
> +------+----------------------------+---------+-------+------------ 
> +-----------+-------+
> 17 rows in set (0.00 sec)
>
>
> I am not really a sql pro, but I guess to set the default values to  
> 'email' I should do:
> >update messages_codes set modes='0' where code='5';
> >update messages_codes set modes='0' where code='7';
>

I think once you do the above updates, then when a user edits his  
prefs the only method they can choose from to receive an update for  
either of those two message types will be 'email'.


> Now, in order to change existing accounts (about 450) settings, I  
> must update the users_messages table and add mode='0' to code='5'  
> and '7' to all uid with an incremental 'id'. Is this needed or does  
> the messages_codes table update enough? How do you suggest I proceed?
>

I would do

update users_messages set mode=0 where code in (5,7);

that will change anyone who already has it set.

as for creating entries for any users that do not have an try for  
either code 5, or 7, you would do best to write some perl code to do  
that.

you could probably do it with a few lines of Slash::Test somethin  
like this (don't run this, not complete, not tested, I don't have  
time at the moment for this, but it should get you looking in the  
right direction)

#!/usr/bin/perl -w

use strict;
use Slash::Test shift;

my $messages  = getObject('Slash::Messages');

my @users = $slashdb->sqlSelectAll('uid','users');
foreach my $uid (@users) {
	my %params;
	$params{MSG_CODE_JOURNAL_REPLY()}  = MSG_MODE_EMAIL();
	$params{MSG_CODE_JOURNAL_FRIEND()} = MSG_MODE_EMAIL();
	$messages->setPrefs($uid, \%params);
}

  Shane

[Slashcode-general] User journal messages prefs

[Alexandre L. <ale...@le...>]

Hi list,

Here's what I want to do: change the setting of all my users and the  
default setting for "Journal Entry by Friend" and "Journal Reply" to  
'email' by default. This is found in Messages user preferences.


The related tables are users_messages and message_codes.


mysql> describe users_messages;
+-------+-----------------------+------+-----+--------- 
+----------------+
| Field | Type                  | Null | Key | Default |  
Extra          |
+-------+-----------------------+------+-----+--------- 
+----------------+
| id    | int(11)               |      | PRI | NULL    |  
auto_increment |
| uid   | mediumint(8) unsigned |      | MUL | 0        
|                |
| code  | int(11)               |      |     | 0        
|                |
| mode  | tinyint(4)            |      |     | 0        
|                |
+-------+-----------------------+------+-----+--------- 
+----------------+
4 rows in set (0.00 sec)

mysql> select * from users_messages where uid='3';
+-----+-----+------+------+
| id  | uid | code | mode |
+-----+-----+------+------+
| 929 |   3 |    0 |    0 |
| 928 |   3 |    1 |    0 |
| 927 |   3 |    4 |    0 |
| 930 |   3 |    5 |    0 |
| 926 |   3 |    7 |    0 |
| 925 |   3 |   11 |    0 |
+-----+-----+------+------+
6 rows in set (0.00 sec)

mysql> select * from message_codes;
+------+----------------------------+---------+-------+------------ 
+-----------+-------+
| code | type                       | seclev  | modes | send       |  
subscribe | acl   |
+------+----------------------------+---------+-------+------------ 
+-----------+-------+
|   -2 | Registration Mail          |       1 | 0     | now         
|         0 |       |
|   -1 | Unknown Message            |       1 | 0     | now         
|         0 |       |
|    0 | Daily Newsletter           |       1 | 0     | now         
|         0 |       |
|    1 | Daily Headlines            |       1 | 0     | now         
|         0 |       |
|    2 | Metamoderation Results     |       1 |       | collective  
|         0 |       |
|    3 | Comment Moderation         |       1 |       | collective  
|         0 |       |
|    4 | Comment Reply              |       1 |       | now         
|         0 |       |
|    5 | Journal Entry by Friend    |       1 |       | now         
|         0 |       |
|    6 | New Submission             |     100 | 0     | now         
|         0 |       |
|    7 | Journal Reply              |       1 |       | now         
|         0 |       |
|    8 | New Comment                | 1000000 |       | now         
|         0 |       |
|   10 | Daily Site Stats           |     100 | 0     | now         
|         0 | stats |
|   11 | Email Story                |       1 | 0     | now         
|         0 |       |
|   12 | Relationship Change        |       1 |       | collective  
|         1 |       |
|   13 | Bad login attempt warnings |       1 | 1     | now         
|         0 |       |
|   14 | Daily Moderation Stats     |     100 | 0     | now         
|         0 | stats |
|   18 | Invalid HTML Input         |     100 |       | now         
|         0 |       |
+------+----------------------------+---------+-------+------------ 
+-----------+-------+
17 rows in set (0.00 sec)


I am not really a sql pro, but I guess to set the default values to  
'email' I should do:
 >update messages_codes set modes='0' where code='5';
 >update messages_codes set modes='0' where code='7';

Now, in order to change existing accounts (about 450) settings, I  
must update the users_messages table and add mode='0' to code='5' and  
'7' to all uid with an incremental 'id'. Is this needed or does the  
messages_codes table update enough? How do you suggest I proceed?


Thanks a lot!

Alex

http://slashgeo.org - In+ersec+ion for Spatial People
News and discussions about GIS, Remote Sensing and everything  
geospatial.

Re: [Slashcode-general] Slashcode using Apache authentication?

[Clifton W. <cli...@gm...>]

Ah! Nice!

And simple, too. Thanks for that tip, Alessio.

On 3/19/06, Alessio Bragadini <al...@se...> wrote:
>
> On 17/mar/06, at 02:02, George Clark wrote:
>
> Has anyone out there looked into using Apache authentication for
> userid/password validation?  Or using mod_auth_mysql against the Slash
> database?  Any other approaches?
>
> Our organization has several web applications.  I really need to figure
> out a
> single signon capability.
>
>
> I have a system working more or less this way, using mod_auth_mysql to
> read the Slash database. The directory containing the site statistics
> (managed by webalizer) is only accessible to administrators, i.e. Slash
> users with a seclev >=3D 10000.
> <Location /stats>
> AuthName "Admin"
> AuthType Basic
> AuthGroupFile /dev/null
> AuthMySQLHost localhost
> AuthMySQLDB database
> AuthMySQLUser user
> AuthMySQLPassword pass
> AuthMySQLUserTable users
> AuthMySQLNameField nickname
> AuthMySQLPasswordField passwd
> AuthMySQLMD5Passwords On
> AuthMySQLUserCondition seclev>=3D10000
> require valid-user
> </Location>
>
> --
> Alessio F. Bragadini            al...@se...
>
>

Re: [Slashcode-general] Anyone know how to set email authentication

[shane <sh...@lo...>]

Slash uses standard perl modules (ie Mail::Sendmail ) to do it's  
emailing.

So readup on it http://search.cpan.org/~mivkovic/Mail-Sendmail-0.79/ 
Sendmail.pm and then you can probably look at the sub sendEmail code  
w/in slash and figure out how to make it do what you require it to do:

http://cvs.sourceforge.net/viewcvs.py/slashcode/slash/Slash/Utility/ 
System/System.pm?rev=1.34&view=auto

  Shane


On Mar 16, 2006, at 7:48 AM, Daniel Fishman wrote:

> I'm running 2.2.6 (upgrading soon I SWEAR) but I need to start  
> using an
> external mail server, which will only allow me to send through it if I
> do SMTP auth, which means I need a place to send username/password.
> Anyone done this yet?
>
> Thanks,
>
> Dan
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting  
> language
> that extends applications into web and mobile media. Attend the  
> live webcast
> and join the prime developer group breaking into this new coding  
> territory!
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general

Re: [Slashcode-general] Slashcode using Apache authentication?

[Alessio B. <al...@se...>]

On 17/mar/06, at 02:02, George Clark wrote:

> Has anyone out there looked into using Apache authentication for
> userid/password validation?  Or using mod_auth_mysql against the Slash
> database?  Any other approaches?
>
> Our organization has several web applications.  I really need to  
> figure out a
> single signon capability.

I have a system working more or less this way, using mod_auth_mysql  
to read the Slash database. The directory containing the site  
statistics (managed by webalizer) is only accessible to  
administrators, i.e. Slash users with a seclev >= 10000.

<Location /stats>
AuthName "Admin"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLHost localhost
AuthMySQLDB database
AuthMySQLUser user
AuthMySQLPassword pass
AuthMySQLUserTable users
AuthMySQLNameField nickname
AuthMySQLPasswordField passwd
AuthMySQLMD5Passwords On
AuthMySQLUserCondition seclev>=10000
require valid-user
</Location>

-- 
Alessio F. Bragadini            al...@se...

[Slashcode-general] Slashcode using Apache authentication?

[George C. <ga...@sp...>]

Hi all,

Has anyone out there looked into using Apache authentication for
userid/password validation?  Or using mod_auth_mysql against the Slash
database?  Any other approaches?

Our organization has several web applications.  I really need to figure out a
single signon capability.  

We use TWiki and Slash along with some static protection on e-mail list
archives, etc.   I've written up an external script that can synchronize all
the ids and passwords.  But one password change through the web interface and
confusion results.  

Thanks,
George Clark

[Slashcode-general] Anyone know how to set email authentication

[Daniel F. <df...@fo...>]

I'm running 2.2.6 (upgrading soon I SWEAR) but I need to start using an
external mail server, which will only allow me to send through it if I
do SMTP auth, which means I need a place to send username/password. 
Anyone done this yet?

Thanks,

Dan

Re: [Slashcode-general] Reloading Modules?

[shane <sh...@lo...>]

Don't forget - if you update/upgrade your slash installation, you =20
will overwrite your changes to MySQL.pm.

Generally, you have your src cvs-checkout/tarball/zip of the slash =20
src. Let's say that's in /usr/local/src/slash.

When you install slashcode, you

cd /usr/local/src/slash
make
make install

So what you'll want to do is modify the src. Generally, you make your =20=

changes, diff the file, and save that diff off somewhere for safe =20
keeping. If you upgrade slashcode on your machine, you maybe apply to =20=

apply your patch to the slash sourcecode at that point, giving you =20
the alternative behavior you mod'd for.

Since slashcode uses mod_perl, like Blake said, if you modify a perl =20
module, you'll have to restart httpd and slashd before you would see =20
the change.

  Shane

On Feb 25, 2006, at 8:36 AM, Blake Carver wrote:

> When you make changes you just need to restart apache, and restart =20
> the slashd, which is probably /etc/init.d/slash
>
>
> --------------
> Blake Carver
> LISNews.org
> Librarian & Information Science News
> http://www.lisnews.org
>
> ----- Original Message ----- From: "Roy Kimbrell" =20
> <roy...@gm...>
> To: <sla...@li...>
> Sent: Wednesday, February 22, 2006 6:04 PM
> Subject: [Slashcode-general] Reloading Modules?
>
>
> I'm trying to make a fairly simple change to the Authors page - it
> inovlves making a change to the SQL that retrieves the author
> information from the database in sub getAuthorDescription.  I found
> this in /usr/lib/perl5/site_perl/5.8.7/i586-linux-thread-multi/=20
> Slash/DB/
> in MySQL.pm.  (I can find another MySQL.pm, but it doesn't contain
> getAuthorDescription.)
>
> However, making a change to this seems to have no effect.  I'm not a
> Perl programmer, so I'm probably asking a pretty basic question.  What
> do i do to "reload" the module?
>
> Thanks,
> Roy
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting =20
> language
> that extends applications into web and mobile media. Attend the =20
> live webcast
> and join the prime developer group breaking into this new coding =20
> territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting =20
> language
> that extends applications into web and mobile media. Attend the =20
> live webcast
> and join the prime developer group breaking into this new coding =20
> territory!
> http://sel.as-us.falkag.net/sel?=20
> cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general



--
My slashcode stuff: http://slash.lottadot.com/
Slashcode faq: http://slash.lottadot.com/slash-faq

Re: [Slashcode-general] Reloading Modules?

[Blake C. <li...@li...>]

When you make changes you just need to restart apache, and restart the 
slashd, which is probably /etc/init.d/slash


--------------
Blake Carver
LISNews.org
Librarian & Information Science News
http://www.lisnews.org

----- Original Message ----- 
From: "Roy Kimbrell" <roy...@gm...>
To: <sla...@li...>
Sent: Wednesday, February 22, 2006 6:04 PM
Subject: [Slashcode-general] Reloading Modules?


I'm trying to make a fairly simple change to the Authors page - it
inovlves making a change to the SQL that retrieves the author
information from the database in sub getAuthorDescription.  I found
this in /usr/lib/perl5/site_perl/5.8.7/i586-linux-thread-multi/Slash/DB/
in MySQL.pm.  (I can find another MySQL.pm, but it doesn't contain
getAuthorDescription.)

However, making a change to this seems to have no effect.  I'm not a
Perl programmer, so I'm probably asking a pretty basic question.  What
do i do to "reload" the module?

Thanks,
Roy


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Slashcode-general mailing list
Sla...@li...
https://lists.sourceforge.net/lists/listinfo/slashcode-general

[Slashcode-general] Reloading Modules?

[Roy K. <roy...@gm...>]

I'm trying to make a fairly simple change to the Authors page - it
inovlves making a change to the SQL that retrieves the author
information from the database in sub getAuthorDescription.  I found
this in /usr/lib/perl5/site_perl/5.8.7/i586-linux-thread-multi/Slash/DB/
in MySQL.pm.  (I can find another MySQL.pm, but it doesn't contain
getAuthorDescription.)

However, making a change to this seems to have no effect.  I'm not a
Perl programmer, so I'm probably asking a pretty basic question.  What
do i do to "reload" the module?

Thanks,
Roy

Re: [Slashcode-general] Release

[Shane <sh...@lo...>]

On Feb 9, 2006, at 4:33 PM, Fred Newton wrote:
> This came up a few months ago, but are there any plans
> for a full release or maybe a R_?
>
> I'm using CSS_03 is that really out of date?

Is that 'CSS_03' a branch or tag or?