[web2py:26407] Preventing escaping of HTML coming from the database
Hello,
I'm not sure if I'm doing something wrong or is this some 'feature' in
web2py.
I am storing pieces of HTML in the database, and would like to embed
those strings into a page (it is more complicated than this, but the
essence is the same).
My problem is that whatever I do web2py always escapes the HTML. For
example I have this in the database:
'Welcome to this test page!'
When I try to output this in a view:
{{=XML (variations[x].content).xml ()}}
I just get
'Welcome to <i>this</i> test page!'
I tried different things (XML without the .xml(), building the XML
object in the controller, etc.), but nothing worked.
How can I output straight HTML from the database to the view?
Looking forward to any help. Thanks!
Tamas
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py:26488] Re: Preventing escaping of HTML coming from the database
Thank you, it worked. I don't know how I didn't try this
combination...
Thanks!
On Jul 13, 3:51 pm, mdipierro wrote:
> {{=XML (variations[x].content)}}
>
> should do what you want.
>
> On Jul 13, 7:42 am, Tamas wrote:
>
> > Hello,
>
> > I'm not sure if I'm doing something wrong or is this some 'feature' in
> > web2py.
>
> > I am storing pieces of HTML in the database, and would like to embed
> > those strings into a page (it is more complicated than this, but the
> > essence is the same).
>
> > My problem is that whatever I do web2py always escapes the HTML. For
> > example I have this in the database:
>
> > 'Welcome to this test page!'
>
> > When I try to output this in a view:
>
> > {{=XML (variations[x].content).xml ()}}
>
> > I just get
>
> > 'Welcome to <i>this</i> test page!'
>
> > I tried different things (XML without the .xml(), building the XML
> > object in the controller, etc.), but nothing worked.
>
> > How can I output straight HTML from the database to the view?
>
> > Looking forward to any help. Thanks!
>
> > Tamas
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---
[web2py] routes.py SUCKS
Hello, I would like to tackle the simple task of running web2py on a folder of the website, say http://example.org/w2p/ So that an application will be like http://example.org/w2p/example/default/index Setting up the WSGI handler is easy, however routes.py gives me a hard time. I tried a bunch of versions, but none seemed to work. Can someone help out? This should be really easy, but it isn't! Thanks -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py] Re: routes.py SUCKS
Thanks, based on your suggestion this works:
routes_in=[('/w2p/(?P.*)$','/\g')]
routes_out=[('/(?P.*)$','/w2p/\g')]
However, I still have the problem of getting an unknown ticket for
plain /w2p/ (default apps are not installed), how can I specify which
application should it go by default?
On Jan 29, 6:35 pm, mdipierro wrote:
> routes_in=[('/w2p/$anything','/$anything')]
> routes_out=[('/$anything','/w2p/$anything')]
>
> On Jan 29, 11:17 am, Tamas wrote:
>
> > Hello,
>
> > I would like to tackle the simple task of running web2py on a folder
> > of the website, say
>
> >http://example.org/w2p/
>
> > So that an application will be
> > likehttp://example.org/w2p/example/default/index
>
> > Setting up the WSGI handler is easy, however routes.py gives me a hard
> > time. I tried a bunch of versions, but none seemed to work.
>
> > Can someone help out? This should be really easy, but it isn't!
>
> > Thanks
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
[web2py] Re: routes.py SUCKS [or not]
Hi,
I tried
routes_in=[ ('/w2p/?', '/myapp'), ('/w2p/(?P.*)$','/\g')]
but it does not work, I still get the unknown ticket.
On Jan 29, 6:46 pm, mdipierro wrote:
> Because your app is not called 'init' and we assumed it was. This will
> fix it.
>
> routes_in=[('/w2p/?','/youappname'),('/w2p/$anything','/$anything')]
> routes_out=[('/$anything','/w2p/$anything')]
>
> On Jan 29, 11:41 am, Tamas wrote:
>
> > Thanks, based on your suggestion this works:
>
> > routes_in=[('/w2p/(?P.*)$','/\g')]
> > routes_out=[('/(?P.*)$','/w2p/\g')]
>
> > However, I still have the problem of getting an unknown ticket for
> > plain /w2p/ (default apps are not installed), how can I specify which
> > application should it go by default?
>
> > On Jan 29, 6:35 pm, mdipierro wrote:
>
> > > routes_in=[('/w2p/$anything','/$anything')]
> > > routes_out=[('/$anything','/w2p/$anything')]
>
> > > On Jan 29, 11:17 am, Tamas wrote:
>
> > > > Hello,
>
> > > > I would like to tackle the simple task of running web2py on a folder
> > > > of the website, say
>
> > > >http://example.org/w2p/
>
> > > > So that an application will be
> > > > likehttp://example.org/w2p/example/default/index
>
> > > > Setting up the WSGI handler is easy, however routes.py gives me a hard
> > > > time. I tried a bunch of versions, but none seemed to work.
>
> > > > Can someone help out? This should be really easy, but it isn't!
>
> > > > Thanks
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
[web2py] Re: routes.py SUCKS [or not]
The URL is http://example.com/w2p/ the app's name is myapp apparently.
On Jan 29, 6:53 pm, mdipierro wrote:
> what is the URL you see in your browser when you get the error?
> what is your app name?
>
> On Jan 29, 11:50 am, Tamas wrote:
>
> > Hi,
>
> > I tried
>
> > routes_in=[ ('/w2p/?', '/myapp'), ('/w2p/(?P.*)$','/\g')]
>
> > but it does not work, I still get the unknown ticket.
>
> > On Jan 29, 6:46 pm, mdipierro wrote:
>
> > > Because your app is not called 'init' and we assumed it was. This will
> > > fix it.
>
> > > routes_in=[('/w2p/?','/youappname'),('/w2p/$anything','/$anything')]
> > > routes_out=[('/$anything','/w2p/$anything')]
>
> > > On Jan 29, 11:41 am, Tamas wrote:
>
> > > > Thanks, based on your suggestion this works:
>
> > > > routes_in=[('/w2p/(?P.*)$','/\g')]
> > > > routes_out=[('/(?P.*)$','/w2p/\g')]
>
> > > > However, I still have the problem of getting an unknown ticket for
> > > > plain /w2p/ (default apps are not installed), how can I specify which
> > > > application should it go by default?
>
> > > > On Jan 29, 6:35 pm, mdipierro wrote:
>
> > > > > routes_in=[('/w2p/$anything','/$anything')]
> > > > > routes_out=[('/$anything','/w2p/$anything')]
>
> > > > > On Jan 29, 11:17 am, Tamas wrote:
>
> > > > > > Hello,
>
> > > > > > I would like to tackle the simple task of running web2py on a folder
> > > > > > of the website, say
>
> > > > > >http://example.org/w2p/
>
> > > > > > So that an application will be
> > > > > > likehttp://example.org/w2p/example/default/index
>
> > > > > > Setting up the WSGI handler is easy, however routes.py gives me a
> > > > > > hard
> > > > > > time. I tried a bunch of versions, but none seemed to work.
>
> > > > > > Can someone help out? This should be really easy, but it isn't!
>
> > > > > > Thanks
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
[web2py] Re: routes.py SUCKS [or not]
Sorry for the late reply, but it does not work still. Here are my
settings:
routes_in=[ ('/w2p/', '/myapp/default/index/'), ('/w2p/(?P.*)$','/
\g')]
routes_out=[('/(?P.*)$','/w2p/\g')]
I still get unknown ticket on plain /w2p/
On Jan 29, 9:31 pm, mdipierro wrote:
> This route alone
>
> routes_in=[ ('/w2p/', '/myapp/default/index')]
>
> should map that url into /myapp/default/index. does it work?
>
> On Jan 29, 12:01 pm, Tamas wrote:
>
> > The URL ishttp://example.com/w2p/theapp's name is myapp apparently.
>
> > On Jan 29, 6:53 pm, mdipierro wrote:
>
> > > what is the URL you see in your browser when you get the error?
> > > what is your app name?
>
> > > On Jan 29, 11:50 am, Tamas wrote:
>
> > > > Hi,
>
> > > > I tried
>
> > > > routes_in=[ ('/w2p/?', '/myapp'), ('/w2p/(?P.*)$','/\g')]
>
> > > > but it does not work, I still get the unknown ticket.
>
> > > > On Jan 29, 6:46 pm, mdipierro wrote:
>
> > > > > Because your app is not called 'init' and we assumed it was. This will
> > > > > fix it.
>
> > > > > routes_in=[('/w2p/?','/youappname'),('/w2p/$anything','/$anything')]
> > > > > routes_out=[('/$anything','/w2p/$anything')]
>
> > > > > On Jan 29, 11:41 am, Tamas wrote:
>
> > > > > > Thanks, based on your suggestion this works:
>
> > > > > > routes_in=[('/w2p/(?P.*)$','/\g')]
> > > > > > routes_out=[('/(?P.*)$','/w2p/\g')]
>
> > > > > > However, I still have the problem of getting an unknown ticket for
> > > > > > plain /w2p/ (default apps are not installed), how can I specify
> > > > > > which
> > > > > > application should it go by default?
>
> > > > > > On Jan 29, 6:35 pm, mdipierro wrote:
>
> > > > > > > routes_in=[('/w2p/$anything','/$anything')]
> > > > > > > routes_out=[('/$anything','/w2p/$anything')]
>
> > > > > > > On Jan 29, 11:17 am, Tamas wrote:
>
> > > > > > > > Hello,
>
> > > > > > > > I would like to tackle the simple task of running web2py on a
> > > > > > > > folder
> > > > > > > > of the website, say
>
> > > > > > > >http://example.org/w2p/
>
> > > > > > > > So that an application will be
> > > > > > > > likehttp://example.org/w2p/example/default/index
>
> > > > > > > > Setting up the WSGI handler is easy, however routes.py gives me
> > > > > > > > a hard
> > > > > > > > time. I tried a bunch of versions, but none seemed to work.
>
> > > > > > > > Can someone help out? This should be really easy, but it isn't!
>
> > > > > > > > Thanks
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
[web2py:15508] More info in errors
Hello, I'm using web2py and find it very nice. However, I would like to request a feature: it would be very useful if the tickets that are generated when an error happens would not only have the call stack and the exception that occured, but also the request.vars parameters (or even the whole request object's contents). The reason is that very often a malformed URL parameter is causing the issue, but we don't see those values (because for example the error happened when a user was interacting with the application, and we only have the ticket info and no feedback from the user). Is there hope that we can see this in the SVN in the near future? Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:16498] cherrypy multiple threads?
Hi, in my web2py application there's a function that can take a long time to finish. Now, I want to implement some kind of a monitoring of that function, in another function that would be able to display the status of the other one, communicating through cache.. The problem is, that when I try to run web2py with the -n parameter, like so: python web2py.py -n 10 and run the first function, then try to look at the other one while the first one is running, then the second one will just wait, as if the server runs in one thread, queuing up connections, so it's impossible to run two concurrently. I know that I could set it up as a WSGI module, but I would like it to work with cherrypy, because it's easier for development. Does anyone have an idea what am I doing wrong? I'm running it on Ubuntu 8.10. Thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:16507] Re: cherrypy multiple threads?
Thanks, this is exactly what I needed. These functions are just workers, and have nothing to do with sessions, hence it should be safe to unlock it. Thanks, web2py rocks! :) On Feb 18, 4:22 pm, mdipierro wrote: > web2py built-in server is multithreaded even without the -n 10 option. > > The only issue is that if an app uses sessions and the same visitor > (same session cookies) requires two or more pages, those requests are > serialized because each of them locks the session. > > Requests coming from different visitors will run concurrntly. > > This behavior can be changed (session._unlock()) but there is really > no need to and your app may become unpredictable. > > Massimo > > On Feb 18, 8:34 am, Tamas wrote: > > > Hi, > > > in my web2py application there's a function that can take a long time > > to finish. > > Now, I want to implement some kind of a monitoring of that function, > > in another function that would be able to display the status of the > > other one, communicating through cache.. > > > The problem is, that when I try to run web2py with the -n parameter, > > like so: > > > python web2py.py -n 10 > > > and run the first function, then try to look at the other one while > > the first one is running, then the second one will just wait, as if > > the server runs in one thread, queuing up connections, so it's > > impossible to run two concurrently. > > > I know that I could set it up as a WSGI module, but I would like it to > > work with cherrypy, because it's easier for development. > > > Does anyone have an idea what am I doing wrong? > > > I'm running it on Ubuntu 8.10. > > > Thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:23034] Upload progress
Hello, while searching for a solution to do a progress bar for uploads, I found this: http://t.wits.sg/2008/06/25/howto-php-and-jquery-upload-progress-bar/ Unfortunately this uses a PHP Pecl-specific function (uploadprogress_get_info). I was wondering if there is an equivalent function somewhere in Web2py? If not, is there a way to show a progress of an upload to the user (without using Flash)? Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:23041] Re: Upload progress
Thanks, later I found your messages. It might not be possible from Javascript, so we probably need to resort to a flash-based uploader (that I wanted to avoid). Thanks anyways. On Jun 1, 6:14 pm, Alexey Nezhdanov wrote: > I asked similar question not long ago. > The answer is - > 1) web2py doesn't support it right now (and I guess there is no easy way to > add it) > 2) it is anyways wrong to ask server about how much _browser_ uploaded. > Browser knows that so ask him (but not me - I do not know how to do it). > > On Monday 01 June 2009 19:32:50 Tamas wrote: > > > Hello, > > while searching for a solution to do a progress bar for uploads, I > > found this: > > >http://t.wits.sg/2008/06/25/howto-php-and-jquery-upload-progress-bar/ > > > Unfortunately this uses a PHP Pecl-specific function > > (uploadprogress_get_info). I was wondering if there is an equivalent > > function somewhere in Web2py? > > If not, is there a way to show a progress of an upload to the user > > (without using Flash)? > > > Thanks! > > -- > Sincerely yours > Alexey Nezhdanov --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:23101] Re: Upload progress
On Jun 2, 4:22 am, Mark Larsen wrote: > > I think you are right > Also, i've had trouble in the past with CherryPy blocking AJAX calls > when another thread to eating 100%. Apache or Lighttpd would not have > this limitation. I think this is not CherryPy's limitation, but Web2py's. It locks the session file when you request a page, so until that request is served, the file remains locked and other requests will wait for the lock to release. I know I ran into this problem before. The solution is to call session._unlock (response) on the beginning of the controller that would serve the upload status, but you'll have to be very careful not to use session there. Anyone correct me if I'm wrong. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py] Re: Using a recursive select but encountered a broken reference
Hello, I've been having this exact same problem for a long, long time. I would also be interested in a solution, but I doubt there will be one. I think it might be a design issue with Web2py. Tamas On Saturday, March 2, 2013 9:48:38 PM UTC+1, Marin Pranjić wrote: > > It seems that the problem is because I run two web2py instances. > One runs on domain.com and the other is on testing.domain.com. > > When I turn off testing instance, everything works as it should. With > testing instance turned on, production instance fails. > > So... Can someone help me configure two web2py instances on the same port? > Domains are different. > > I'm using apache virtual hosts. > > Marin > > Dana subota, 2. ožujka 2013. 20:55:17 UTC+1, korisnik Marin Pranjić > napisao je: >> >> This happened to an user multiple times. No idea why it happens. >> >> Error ticket doesn't show much, this is everything I can get from there: >> >> Traceback (most recent call last): >> File "/home/www-data/web2py/gluon/main.py", line 571, in wsgibase >> session._try_store_in_cookie_or_file(request, response) >> File "/home/www-data/web2py/gluon/globals.py", line 738, in >> _try_store_in_cookie_or_file >> self._try_store_in_file(request, response) >> File "/home/www-data/web2py/gluon/globals.py", line 745, in >> _try_store_in_file >> if not response.session_id or self._forget or self._unchanged(): >> File "/home/www-data/web2py/gluon/globals.py", line 700, in _unchanged >> session_pickled = cPickle.dumps(dict(self)) >> File "/usr/lib/python2.7/copy_reg.py", line 74, in _reduce_ex >> getstate = self.__getstate__ >> File "/home/www-data/web2py/gluon/dal.py", line 7355, in __getattr__ >> self.__allocate() >> File "/home/www-data/web2py/gluon/dal.py", line 7350, in __allocate >> raise RuntimeError, "Using a recursive select but encountered a broken >> reference: %s %d"%(self._table, int(self)) >> RuntimeError: Using a recursive select but encountered a broken reference: >> auth_group 5 >> >> >> >> However, auth_group record with id=5 exists. I have no idea why it raises an >> error. >> >> I'm using web2py 2.2.1, this is production instance so I can't test with >> other versions right now. >> >> >> Marin >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Using a recursive select but encountered a broken reference
On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote: > > > > On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote: >> >> Hello, >> >> I've been having this exact same problem for a long, long time. >> >> I would also be interested in a solution, but I doubt there will be one. >> I think it might be a design issue with Web2py. >> >> Tamas >> >> > I'm correct when I think that what you're asking is for two different > programs to bind to the same socket ? I don't think that's possibile with > whatever program, not only web2py. > > Not quite, we're using Apache WSGI, which in fact can run multiple instances of web2py on the same port, along with other python scripts as well. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Using a recursive select but encountered a broken reference
On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote: > > True, but... Apache is not raising errors, web2py is. The error message is > strange. At least we could have a nicer error if this can't be fixed. > However in my example, both instances work until i try to log in. I can > use the site without database i/o. Both instances work. > > Now, why would web2py (1) raise an exception when working with database > (2) because the apache (3) configuration is bad ? > > Sometimes the testing instance fails on login, sometimes it is production > instance... > > I'd like to see more about Tamas's problem. > > Well, we're running a very busy WSGI Python sctipt alongside a few web2py instances, and just like with your setup the only error that happens is when we try to log in on a w2p instance that uses the same mysql database as the other WSGI script. I've e-mailed Massimo with more details a couple of months ago, and he promised to look into the problem, but he never checked back, and my further inquiries had no answer, so I guess it's not an easy fix :( -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] Re: Using a recursive select but encountered a broken reference
Hello Marin, sorry for the late reply. I don't have your e-mail (this list doesn't show e-mails), but I am also not sure I can provide a lot more extra info on this. Did you manage to look into it? Did you find anything? Thanks! Tamas On Friday, March 8, 2013 4:00:24 PM UTC+1, Marin Pranjić wrote: > > Would you mind emailing me the details? > I won't promise, but I plan to look into it next week. > > Dana petak, 8. ožujka 2013. 15:49:42 UTC+1, korisnik Tamas napisao je: >> >> >> >> On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote: >>> >>> True, but... Apache is not raising errors, web2py is. The error message >>> is strange. At least we could have a nicer error if this can't be fixed. >>> However in my example, both instances work until i try to log in. I can >>> use the site without database i/o. Both instances work. >>> >>> Now, why would web2py (1) raise an exception when working with database >>> (2) because the apache (3) configuration is bad ? >>> >>> Sometimes the testing instance fails on login, sometimes it is >>> production instance... >>> >>> I'd like to see more about Tamas's problem. >>> >>> >> Well, we're running a very busy WSGI Python sctipt alongside a few web2py >> instances, and just like with your setup the only error that happens is >> when we try to log in on a w2p instance that uses the same mysql database >> as the other WSGI script. >> >> I've e-mailed Massimo with more details a couple of months ago, and he >> promised to look into the problem, but he never checked back, and my >> further inquiries had no answer, so I guess it's not an easy fix :( >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[web2py] web2py console doesn't show activity
Hi there, I updated my web2py installation recently and after the update the small window where I type IP, port and password doesn't show webserver access any more. It was a pretty good feature that showed a green peak every time I connected to the server. Does somebody know why it is not working now? Thanks Tamas
[web2py] Re: Can't connect to MySQL server on 'localhost'
Hi Miguel,
I had a similar problem on ubuntu linux recently and the solution was
to enter the port number (which is usually 3306) in connect string.
Try: mysql://username:password@localhost:port/test
Cheers
Tamas
On Mar 16, 2:08 am, Miguel wrote:
> Hello to all, I have created a new project using the web wizard, for
> some unknown reason the mysql connection is not working, this is the
> uri im using:
>
> mysql://cmts_monitor:cmtsTigoHome@localhost/cmts_monitor
>
> and this is the error i got:
>
> Traceback (most recent call last):
> File "/home/www-data/web2py/gluon/restricted.py", line 188, in
> restricted
> exec ccode in environment
> File "/home/www-data/web2py/applications/CMTS_Monitor/models/db.py",
> line 17, in
> db = DAL('mysql://cmts_monitor:cmtsTigoHome@localhost/
> cmts_monitor') # if not, use SQLite or other DB
> File "/home/www-data/web2py/gluon/dal.py", line 3423, in __init__
> raise RuntimeError, "Failure to connect, tried 5 times:\n%s" %
> error
> RuntimeError: Failure to connect, tried 5 times:
> (2003, "Can't connect to MySQL server on 'localhost' (111)")
>
> i have tested the username/password combination in the command line,
> it works fine:
>
> mmiranda@appsrv01:/var/log/check_cmts$ mysql --user cmts_monitor --
> database cmts_monitor --host=localhost -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 20510
> Server version: 5.1.37-1ubuntu5.5 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql>
>
> What should i check?
> regards
