[symfony-users] Re: tinymce in symfony

2010-01-28 Thread mr_question
I have installed it again but still the same. I must handly add to
layout.php:

And then it works - but I don't understand why ?

On 28 Sty, 23:09, David Joan  wrote:
> Hi
> Why don't you trying install sfFormExtPlugin again?
>
> On 28 ene, 12:30, mr_question  wrote:
>
>
>
> > Ok, now I use sfWidgetFormTextareaTinyMCE() but I still don't have
> > tinymce. What is more I don't have in view - source in browser:
> > 

[symfony-users] Customize sfGuardAuth forms

2010-01-28 Thread MartinB
I'm pretty new to symfony, but am loving it so far. I just finished
setting up the sfGuardAuth plugin and would like to customize the
forms so that the groups and permissions lists are checkbox lists
instead of list boxes.

I know I need to use the below line of code to do it, but where do I
put it? I know I can put it directly in the plugins
sfGuardUserAdminForm.class file, but is there a better place so that I
can upgrade the plugin and then not have to make this change again?

$this->widgetSchema['groups_list'] = new sfWidgetFormChoice(array
('multiple' => false, 'model' => 'sfGuardGroup', 'expanded' => true));

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] CheckBox at Server Side

2010-01-28 Thread mandyllanes
Hi,

I have a field checkbox in my form. In de sfAction class I want know
if that field is checked. if my checkbox field is checked i do any
thing, but is not i do another things. How am I can do?

Many thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread ken
This is my solution.
shema
http://gist.github.com/289418

myUser
http://gist.github.com/289424

then insert this filter before the security filter
http://gist.github.com/289425

On Jan 29, 12:31 am, "yth"  wrote:
> Dear ken,
>
> Is this possible to avoid modifiying the database schema?
> I am not using sfGuardUserPlugin but I am thinking like this:
>
> 1. Somebody logins
> 2. His login id (member id) and password are first checked and they are
> correct
> 3. An attribute member_id is set to his member id in the session
> 4. He forgot to logout and later logins in another computer or same computer
> but different browser
> 5. His login id (member id) and password are first checked and they are
> correct
> 6. Scan for all sessions and check if there is one having member_id
> attribute set to his member id
> 7. If there is one, kill that old session
> 8. A session attribute member_id is set to his member id in the new session
>
> Is this solution feasible? But I don't know how to do steps 6-7.
>
>
>
> - Original Message -
> From: "ken" 
> To: "symfony users" 
> Sent: Thursday, January 28, 2010 11:15 PM
> Subject: [symfony-users] Re: Making sure a login id only has one session at
>
> any moment
>
> The best solution for this is use database session. Add session_id
> column in the Profile table. This field has to be set during login. So
> if you are using sfGuardUserPlugin, you can override the signIn method
> in myUser. With the session_id at hand you will be able to check if
> user is signed in in another machine via the Session table.
>
> You will also need to take account of the remote host.
>
> On Jan 28, 10:15 pm, DEEPAK BHATIA  wrote:
> > I think you can set a field in database setting login status to true.
> > Now if the person again logs in and you find from database, you can
> > take him to the logout screen/error screen.
>
> > On Thu, Jan 28, 2010 at 7:27 PM, Tom Ptacnik  wrote:
> > > Why do you want to kill his old session?
>
> > > On 28 led, 04:21, "yth"  wrote:
> > >> Dear all,
>
> > >> When a user logins, the controller calls the following function in the
> > >> myUser.class. The problem is, if he doesn't logout but then logins in
> > >> another computer/browser, the old session does not get killed. I tried
> > >> to
> > >> use setAuthenticated(false) on users who have already authenticated,
> > >> hoping
> > >> that his old session will get killed before he gets a new one. But it
> > >> doesn't work.
>
> > >> Many thanks to you all.
>
> > >> // Viewable inhttp://pastebin.com/f765fff66
>
> > >> public function login($loginId,$pwd){
>
> > >> $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>
> > >> if(!is_null($member)) {
>
> > >> if($this->isAuthenticated())
> > >> $this->setAuthenticated(false); // I would like to
> > >> logout the user if he/she already has a session, but it doesn't work
>
> > >> $this->setAuthenticated(true);
> > >> $member->setLastLoginAt(time());
> > >> $member->save();
> > >> $this->setAttribute('member_id', $member->getMemberId());
>
> > >> return true;
> > >> }
> > >> return false;
>
> > >> }
>
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "symfony users" group.
> > > To post to this group, send email to symfony-us...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > symfony-users+unsubscr...@googlegroups.com.
> > > For more options, visit this group
> > > athttp://groups.google.com/group/symfony-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group 
> athttp://groups.google.com/group/symfony-users?hl=en.
>
> __ NOD32 4813 (20100128) Information __
>
> This message was checked by NOD32 antivirus system.http://www.eset.com

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Augusto Flavio
Yes Romain. You need have permission to access your temp dir.


Ask then to your client.


Bye.


Augusto Morais

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Set default dsn with env vars?

2010-01-28 Thread Tennis Smith
Hi,

I'm trying to set my default db based on an environment variable.  The
definition looks like this in my databases.yml file:

test:
  foo:
class:  sfPropelDatabase
param:
  dsn:  


Should this work?  The idea is that if the env var FOO_DB has a value, it
will be used as the dsn.

-- 

Tks,
-T

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Help please! json_encode problem in symfony

2010-01-28 Thread Dejan Spasic
If you use Doctrine try

json_encode($this->test->toArray());

On 28 Jan., 23:39, Eno  wrote:
> On Thu, 28 Jan 2010, Dong YANG wrote:
> > Hi everyone,
>
> >     I passed many hours for this strange thing, in fact I got a problem when
> > using json_encode in symfony.
>
> >      In my front-end module, method executeIndex() as below:
>
> >   public function executeIndex(sfWebRequest $request)
> >   {
> >         $this->test = $this->getRoute()->getObject();
> >         // Call json_encode, but return '{}'
> >         $json = json_encode($this->test);
>
> >         // this simple test works
> >         $test = new stdClass();
> >         $test->id = new stdClass();
> >         var_dump(json_encode($test));
> >     }
>
> What happens if you do this?
>
> $test = $this->getRoute()->getObject();
> $json = json_encode($test);
> $this->test = $test;
>
> --

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Slow template rendering

2010-01-28 Thread Dejan Spasic
To complete this discussion consider following documentation

http://www.doctrine-project.org/documentation/manual/1_2/en/data-hydrators
http://www.doctrine-project.org/documentation/manual/1_2/en/improving-performance

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] How to make LEFT JOIN in subquery which is in WHERE condition?

2010-01-28 Thread MaEcTPo
I wrote a raw SQL, like this:

SELECT b2.title, r.title
FROM route r
LEFT JOIN busstop_route b ON (r.id = b.route_id)
LEFT JOIN busstop b2 ON b2.id = b.busstop_id
WHERE b2.id <> 3
AND b.direction_id =
(
SELECT ab.direction_id
FROM route ar
LEFT JOIN busstop_route ab ON (ar.id = ab.route_id)
WHERE ab.busstop_id = 3
AND r.id = ar.id
);

And I would like to write it in DQL. All goes good before subquery.

 $q = Doctrine_Query::create()
->from('Route r');
$q->leftJoin('r.Directions d');
$q->leftJoin('r.Busstops b');
//$q->leftJoin('b.Places');
$q->andWhere('b.id <> ?', $this->getId());
$q->andWhere('d.id = (
SELECT ab.direction_id
FROM Route ar
LEFT JOIN Busstops ab ON (ar.id = ab.route_id)
WHERE ab.busstop_id = 3
AND r.id = ar.id
)', '');

And here I receive strange errors. Symfony talks to me - "Couldn't
find class Busstops". But it has to find relation busstops (like in
main query), not class. When I change Busstops to Busstop I receive
"Unknown relation alias".

Do you understand what I need to do?

Please, help!

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Help please! json_encode problem in symfony

2010-01-28 Thread Eno
On Thu, 28 Jan 2010, Dong YANG wrote:

> Hi everyone,
> 
> I passed many hours for this strange thing, in fact I got a problem when
> using json_encode in symfony.
> 
>  In my front-end module, method executeIndex() as below:
> 
>   public function executeIndex(sfWebRequest $request)
>   {
> $this->test = $this->getRoute()->getObject();
> // Call json_encode, but return '{}'
> $json = json_encode($this->test);
> 
> // this simple test works
> $test = new stdClass();
> $test->id = new stdClass();
> var_dump(json_encode($test));
> }

What happens if you do this?

$test = $this->getRoute()->getObject();
$json = json_encode($test);
$this->test = $test;




-- 


-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: tinymce in symfony

2010-01-28 Thread David Joan
Hi
Why don't you trying install sfFormExtPlugin again?


On 28 ene, 12:30, mr_question  wrote:
> Ok, now I use sfWidgetFormTextareaTinyMCE() but I still don't have
> tinymce. What is more I don't have in view - source in browser:
> 

[symfony-users] New element with parameter

2010-01-28 Thread Diego Bello
Hi guys,

I have a site (frontend) with a list of deploys. Now, each deploy can
have several activities. When I click on new activity, I have to
choose the deploy I'm talking about. Is there a way I can tell the new
form to use the deploy I'm surfing now?. I mean, is it possible to
send to the "new activity page" the id of the deploy so it can
understand that I am talking about, let's say, the deploy of machine 1
and not the one of machine 127?.

Thanks.

-- 
Diego Bello Carreño

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Romain Pouclet
build-sql works fine
insert-sql throws me an error : 
-bash-3.2$ php ./symfony doctrine:insert-sql 
>> doctrine  created tables successfully






  
  SQLSTATE[HY000]: General error: 1005 Can't create table 
'./communau/#sql-66c9_784339.frm' (errno: 150). Failing Query: "ALTER TABLE 
noe_poll_question ADD CONSTRAINT noe_poll_question_question_id_noe_poll_id 
FOREIGN KEY (question_id) REFERENCES noe_poll(id) ON DELETE CASCADE". Failing 
Query: ALTER TABLE noe_poll_question ADD CONSTRAINT 
noe_poll_question_question_id_noe_poll_id FOREIGN KEY (question_id) REFERENCES 
noe_poll(id) ON DELETE CASCADE  





  
On the other hand, I configured my databases.yml file so I can connect to prod 
database from dev environment (juste for testing ;)), and I do have a 
permission issue : 
-bash-3.2$ php symfony doctrine:build --all --env=dev --no-confirmation
>> doctrine  Dropping "doctrine" database
>> doctrine  Creating "dev" environment "doctrine" database
>> doctrine  generating model classes
>> file+ /doctrine_schema_14027.yml

Warning: file_put_contents(/doctrine_schema_14027.yml): failed to open stream: 
Permission denied in 
/communau/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/task/sfDoctrineBaseTask.class.php
 on line 183

Invalid schema element named "0" at path "Warning"  

At this line, I do have a reference to my "tmp" dir (as doctrine is using 
"sys_get_temp_dir()")

$file = realpath(sys_get_temp_dir()).'/doctrine_schema_'.rand(1, 
9).'.yml';
$this->logSection('file+', $file);
file_put_contents($file, sfYaml::dump($models, 4));


Problem is, we can't change the permissions on that folder, we have to ask our 
client's...

That's my problem, right ?

Le 28 janv. 2010 à 20:07, Augusto Flavio a écrit :

> No. 
> 
> I don't have /tmp folder on my prod server too and the project works fine. 
> Have you sure that all files is sync with the dev environment (dev server)? 
> Did you fix the permissions? Check whether the sql file correctly. 
> 
> To do it run only the sql schema. ./symfony doctrine:build-sql && ./symfony 
> doctrine:insert-sql
> 
> 
> And tell me what is going on. 
> 
> 
> Augusto Morais
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Help please! json_encode problem in symfony

2010-01-28 Thread Dong YANG
Hi everyone,

I passed many hours for this strange thing, in fact I got a problem when
using json_encode in symfony.

 In my front-end module, method executeIndex() as below:

  public function executeIndex(sfWebRequest $request)
  {
$this->test = $this->getRoute()->getObject();
// Call json_encode, but return '{}'
$json = json_encode($this->test);

// this simple test works
$test = new stdClass();
$test->id = new stdClass();
var_dump(json_encode($test));
}

I get my object from routing, and call json_encode, but in $json value, I
got always '{}',
So I tried another simple test with stdClass, the result is ok.

My object is not null, but why after json_encode, the value is empty?

Can you help me please ? Thank u so much.

JoJo

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Augusto Flavio
No.

I don't have /tmp folder on my prod server too and the project works fine.
Have you sure that all files is sync with the dev environment (dev server)?
Did you fix the permissions? Check whether the sql file correctly.

To do it run only the sql schema. ./symfony doctrine:build-sql && ./symfony
doctrine:insert-sql


And tell me what is going on.


Augusto Morais

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Romain Pouclet
According to some tests, I don't have "/tmp" folder on this server, but this is 
where php is supposed to create tmp files, do you think this could come from 
there? The fact that php doesn't find this yml file ?

Le 28 janv. 2010 à 18:21, Augusto Flavio a écrit :

> I had a similar problem too with the symfomy's deployment. Not building the 
> classes but in deployment. The symfony's interface of rsync doenst clear the 
> buffer in sfProjectDeployTask at the moment that the rsync is executed. The 
> fix is only clear the outbuffer before execute the rsync command. I create a 
> ticket that can be check here: http://trac.symfony-project.org/ticket/8177
> 
> 
> Maybe the problem are the permissions. Have you sure that its ok? 
> 
> chmod 755 -R /project/*
> ./symfony project:permissions
> 
> 
> Whether it not resolve your problem try to find the yml not found when you 
> run the "builder". 
> 
> 
> Bye 
> 
> 
> Augusto Morais
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: External user authentication with sfDoctrineGuardPlugin

2010-01-28 Thread ashton honnecke
Thanks!

So if I am understanding you, you are telling me that there is no way
to do this with the current sfGuardUser setup and that I will need to
I create a new module that I use for login.

It doesn't seem to me that this is an uncommon request related to the
external password check, so It seems odd that I would need to re-write
the login in order to do so.

Why would I want to make a new module and not just overwrite the
executeSignin method in the BasesfGuardAuthActions class?

ashton

On Thu, Jan 28, 2010 at 6:53 AM, Tom Ptacnik  wrote:
> Create an module with "secure: is_secure: false" in which you can do
> what you want (create a user in sf_guard_user table ...)
>
>
>
> On 28 led, 02:15, ashton  wrote:
>> I have my external authentication working, but the problem that I am
>> running into is that there needs to be a user in the sfGuardUser table
>> that matches the username submit in the login form, otherwise the
>> login fails.
>>
>> So when I currently add 'return true;' to the top of the external auth
>> function, I can login with any password, for users that exist in the
>> sf_guard_table, but not with usernames that do not exist.
>>
>> I was wondering if there was a solution out there (ideally user
>> creation in the sfGuardUser table upon successful external
>> authentication), allowing me to perform my external checks even if the
>> username does not exist in the sf_guard_user table would work too,
>> because then I could just manually create the user if the external
>> auth was successful.
>>
>> thanks!
>> ashton
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: tinymce in symfony

2010-01-28 Thread mr_question
Ok, now I use sfWidgetFormTextareaTinyMCE() but I still don't have
tinymce. What is more I don't have in view - source in browser:

why ?

On 28 Sty, 17:09, Gábor Fási  wrote:
> http://www.symfony-project.org/forms/1_2/en/A-Widgets#chapter_a_sub_s...
>
>
>
> On Thu, Jan 28, 2010 at 09:06, mr_question  wrote:
> > I inserted in /js catalog 'tiny_mce', added to settings.yml:
> > rich_text_js_dir:  js/tiny_mce
> > and my sfWidgetFormTextarea's aren't rich text editors, why ?
>
> > --
> > You received this message because you are subscribed to the Google Groups 
> > "symfony users" group.
> > To post to this group, send email to symfony-us...@googlegroups.com.
> > To unsubscribe from this group, send email to 
> > symfony-users+unsubscr...@googlegroups.com.
> > For more options, visit this group 
> > athttp://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Augusto Flavio
I had a similar problem too with the symfomy's deployment. Not building the
classes but in deployment. The symfony's interface of rsync doenst clear the
buffer in *sfProjectDeployTask at the moment that the rsync is executed. *The
fix is only clear the outbuffer before execute the rsync command. I create a
ticket that can be check here: http://trac.symfony-project.org/ticket/8177


Maybe the problem are the permissions. Have you sure that its ok?

chmod 755 -R /project/*
./symfony project:permissions


Whether it not resolve your problem try to find the yml not found when you
run the "builder".


Bye


Augusto Morais

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Andrea Marin
Thanks Stèphane,

with your link i find to fix my problem.
Symfony use for its query the standard socket link in /tmp/mysql.sock for make 
it running under MAMP and mac user we need to make a symbolic link to the real 
sock of mysql under MAMP.

For do this just run this:
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

After this the command:
php symfony doctrine:insert-sql

make this output and the table are create into db:
doctrine  created tables successfully

Thanks a lot.


Il giorno 28/gen/2010, alle ore 17.42, Stéphane ha scritto:

> I'm not using MAMP so you might take a look at this thread : 
> http://forum.symfony-project.org/index.php/t/11364/
> 
> Hope this helps,
> 
> Cheers,
> 
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
> 
> 
> On Thu, Jan 28, 2010 at 5:38 PM, Andrea Marin  wrote:
> Hi Stèphane,
> 
> thanks i correct my mistake but there are something other wrong.
> Now the error change and is:
> 
> Warning: PDO::__construct(): [2002] No such file or directory (trying to 
> connect via unix:///tmp/mysql.sock) in 
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>  on line 470
> 
>   
>   PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory
> 
> How can I fix it?
> Thanks Andrea
> 
> Il giorno 28/gen/2010, alle ore 17.32, Stéphane ha scritto:
> 
>> You have an error in your DB DSN declaration.
>> 
>> mysql:host=localhost;dbname=jobeet
>> 
>> It is not a "," but a ";".
>> 
>> Cheers,
>> 
>> 
>> Before Printing, Think about Your Environmental Responsibility!
>> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
>> 
>> 
>> On Thu, Jan 28, 2010 at 5:27 PM, Andrea Marin  wrote:
>> > What do you have in config/doctrine/schema.yml and in config/
>> > databases.yml ?
>> > If you run "symfony doctrine:build --all --and-load --no-confirmation"
>> > do you get the same error?
>> 
>> Hi all,
>> 
>> thanks for reply,
>> in my config/doctrine/schema.yml I have:
>> 
>> # config/doctrine/schema.yml
>> JobeetCategory:
>>actAs: { Timestampable: ~ }
>>columns:
>>name: { type: string(255), notnull: true, unique: true }
>> 
>> JobeetJob:
>>actAs: { Timestampable: ~ }
>>columns:
>>category_id: { type: integer, notnull: true }
>>type: { type: string(255) }
>>company: { type: string(255), notnull: true }
>>logo: { type: string(255) }
>>url: { type: string(255) }
>>position: { type: string(255), notnull: true }
>>location: { type: string(255), notnull: true }
>>description:  { type: string(4000), notnull: true }
>>how_to_apply: { type: string(4000), notnull: true }
>>token: { type: string(255), notnull: true, unique: true }
>>is_public: { type: boolean, notnull: true, default: 1 }
>>is_activated: { type: boolean, notnull: true, default: 0 }
>>email: { type: string(255), notnull: true }
>>expires_at: { type: timestamp, notnull: true }
>>relations:
>>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id, 
>> foreignAlias: JobeetJobs }
>> 
>> JobeetAffiliate:
>>actAs: { Timestampable: ~ }
>>columns:
>>url: { type: string(255), notnull: true }
>>email: { type: string(255), notnull: true, unique: true }
>>token: { type: string(255), notnull: true }
>>is_active: { type: boolean, notnull: true, default: 0 }
>>relations:
>>JobeetCategories: { class: JobeetCategory, refClass: 
>> JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id, 
>> foreignAlias: JobeetAffiliates }
>> 
>> JobeetCategoryAffiliate:
>>columns:
>>category_id: { type: integer, primary: true }
>>affiliate_id: { type: integer, primary: true }
>>relations:
>>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id }
>>JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign: 
>> id }
>> 
>> in config/databases.yml I have
>> 
>> all:
>>  doctrine:
>>class: sfDoctrineDatabase
>>param:
>>  dsn: 'mysql:host=localhost,dbname=jobeet'
>>  username: root
>>  password: root
>> 
>> If I run:
>> 
>> "symfony doctrine:build --all --and-load --no-confirmation"
>> 
>> I receive the same error:
>> 
>> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: 
>> nodename nor servname provided, or not known in 
>> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>>  on line 470
>> 
>> Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo 
>> failed: nodename nor servn (trying to connect via 
>> tcp://localhost,dbname=jobeet:3306) in 
>> /Users/andrea/sfprojects/jobeet/lib/ven

Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Romain Pouclet
Hi,

Sorry I'm using Symfony 1.4... 
My database access are correct because I can connect to my db server when I try 
a "mysql -u" 



Le 28 janv. 2010 à 17:57, Augusto Flavio a écrit :

> Hi Romain,
> 
> 
> Which version of symfony you are using. 
> 
> Is ok your DB connection? This is a common problem that happen after the 
> deploy to the prod server. 
> 
> 
> Bye
> 
> 
> Augusto Morais
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Augusto Flavio
Hi Romain,


Which version of symfony you are using.

Is ok your DB connection? This is a common problem that happen after the
deploy to the prod server.


Bye


Augusto Morais

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Can't build anything after project:deploy

2010-01-28 Thread Romain Pouclet
Hi all, 

I'm having a really strange issue w/ my project, I can't build anything using 
doctrine:build task...

This works just fine if I'm running it from my local working-copy :
./symfony doctrine:build --all --env=prod

if I run it from the production server, I have this error : "No yml schema 
found in /doctrine_schema_87228.yml"

 But I don't know what or where this file is... 

Anybody knows how to fix this?

Thanks !

Romain



-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread wissl
Could be very expensive to loop through every existing session for
every login process, don't you think? But that depends on your
expectations.

I guess the other way around seems to be the much more useful way:
storing the session_id to the userprofile in database.

Saving the sessions themselves in the database (e.g. with
sfPDOSessionStorage) you are able to establish relations between those
two tables and adding a foreign key constraint like onDelete SET NULL
you can make use of the session garbage collector of php to get your
data cleaned up without any additional effort. Anyway, if your
concerne is about point "4. He forgot to logout", garbage collection
will hopefully destroy the session for you.

Maybe we try to identify what your exact need is, before we propose
solutions for some problems that should be seen from a different
angle?


On 28 Jan., 17:31, "yth"  wrote:
> Dear ken,
>
> Is this possible to avoid modifiying the database schema?
> I am not using sfGuardUserPlugin but I am thinking like this:
>
> 1. Somebody logins
> 2. His login id (member id) and password are first checked and they are
> correct
> 3. An attribute member_id is set to his member id in the session
> 4. He forgot to logout and later logins in another computer or same computer
> but different browser
> 5. His login id (member id) and password are first checked and they are
> correct
> 6. Scan for all sessions and check if there is one having member_id
> attribute set to his member id
> 7. If there is one, kill that old session
> 8. A session attribute member_id is set to his member id in the new session
>
> Is this solution feasible? But I don't know how to do steps 6-7.
>
> - Original Message -
> From: "ken" 
> To: "symfony users" 
> Sent: Thursday, January 28, 2010 11:15 PM
> Subject: [symfony-users] Re: Making sure a login id only has one session at
>
> any moment
>
> The best solution for this is use database session. Add session_id
> column in the Profile table. This field has to be set during login. So
> if you are using sfGuardUserPlugin, you can override the signIn method
> in myUser. With the session_id at hand you will be able to check if
> user is signed in in another machine via the Session table.
>
> You will also need to take account of the remote host.
>
> On Jan 28, 10:15 pm, DEEPAK BHATIA  wrote:
> > I think you can set a field in database setting login status to true.
> > Now if the person again logs in and you find from database, you can
> > take him to the logout screen/error screen.
>
> > On Thu, Jan 28, 2010 at 7:27 PM, Tom Ptacnik  wrote:
> > > Why do you want to kill his old session?
>
> > > On 28 led, 04:21, "yth"  wrote:
> > >> Dear all,
>
> > >> When a user logins, the controller calls the following function in the
> > >> myUser.class. The problem is, if he doesn't logout but then logins in
> > >> another computer/browser, the old session does not get killed. I tried
> > >> to
> > >> use setAuthenticated(false) on users who have already authenticated,
> > >> hoping
> > >> that his old session will get killed before he gets a new one. But it
> > >> doesn't work.
>
> > >> Many thanks to you all.
>
> > >> // Viewable inhttp://pastebin.com/f765fff66
>
> > >> public function login($loginId,$pwd){
>
> > >> $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>
> > >> if(!is_null($member)) {
>
> > >> if($this->isAuthenticated())
> > >> $this->setAuthenticated(false); // I would like to
> > >> logout the user if he/she already has a session, but it doesn't work
>
> > >> $this->setAuthenticated(true);
> > >> $member->setLastLoginAt(time());
> > >> $member->save();
> > >> $this->setAttribute('member_id', $member->getMemberId());
>
> > >> return true;
> > >> }
> > >> return false;
>
> > >> }
>
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "symfony users" group.
> > > To post to this group, send email to symfony-us...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > symfony-users+unsubscr...@googlegroups.com.
> > > For more options, visit this group
> > > athttp://groups.google.com/group/symfony-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
&g

Re: [symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Stéphane
I'm not using MAMP so you might take a look at this thread :
http://forum.symfony-project.org/index.php/t/11364/

Hope this helps,

Cheers,

Before Printing, Think about Your Environmental Responsibility!
Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!


On Thu, Jan 28, 2010 at 5:38 PM, Andrea Marin  wrote:

> Hi Stèphane,
>
> thanks i correct my mistake but there are something other wrong.
> Now the error change and is:
>
> Warning: PDO::__construct(): [2002] No such file or directory (trying to
> connect via unix:///tmp/mysql.sock) in
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
> on line 470
>
>
>   PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory
>
> How can I fix it?
> Thanks Andrea
>
> Il giorno 28/gen/2010, alle ore 17.32, Stéphane ha scritto:
>
> You have an error in your DB DSN declaration.
>
> mysql:host=localhost;dbname=jobeet
>
> It is not a "," but a ";".
>
> Cheers,
>
>
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
>
>
> On Thu, Jan 28, 2010 at 5:27 PM, Andrea Marin wrote:
>
>> > What do you have in config/doctrine/schema.yml and in config/
>> > databases.yml ?
>> > If you run "symfony doctrine:build --all --and-load --no-confirmation"
>> > do you get the same error?
>>
>> Hi all,
>>
>> thanks for reply,
>> in my config/doctrine/schema.yml I have:
>>
>> # config/doctrine/schema.yml
>> JobeetCategory:
>>actAs: { Timestampable: ~ }
>>columns:
>>name: { type: string(255), notnull: true, unique: true }
>>
>> JobeetJob:
>>actAs: { Timestampable: ~ }
>>columns:
>>category_id: { type: integer, notnull: true }
>>type: { type: string(255) }
>>company: { type: string(255), notnull: true }
>>logo: { type: string(255) }
>>url: { type: string(255) }
>>position: { type: string(255), notnull: true }
>>location: { type: string(255), notnull: true }
>>description:  { type: string(4000), notnull: true }
>>how_to_apply: { type: string(4000), notnull: true }
>>token: { type: string(255), notnull: true, unique: true }
>>is_public: { type: boolean, notnull: true, default: 1 }
>>is_activated: { type: boolean, notnull: true, default: 0 }
>>email: { type: string(255), notnull: true }
>>expires_at: { type: timestamp, notnull: true }
>>relations:
>>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign:
>> id, foreignAlias: JobeetJobs }
>>
>> JobeetAffiliate:
>>actAs: { Timestampable: ~ }
>>columns:
>>url: { type: string(255), notnull: true }
>>email: { type: string(255), notnull: true, unique: true }
>>token: { type: string(255), notnull: true }
>>is_active: { type: boolean, notnull: true, default: 0 }
>>relations:
>>JobeetCategories: { class: JobeetCategory, refClass:
>> JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id,
>> foreignAlias: JobeetAffiliates }
>>
>> JobeetCategoryAffiliate:
>>columns:
>>category_id: { type: integer, primary: true }
>>affiliate_id: { type: integer, primary: true }
>>relations:
>>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign:
>> id }
>>JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign:
>> id }
>>
>> in config/databases.yml I have
>>
>> all:
>>  doctrine:
>>class: sfDoctrineDatabase
>>param:
>>  dsn: 'mysql:host=localhost,dbname=jobeet'
>>  username: root
>>  password: root
>>
>> If I run:
>>
>> "symfony doctrine:build --all --and-load --no-confirmation"
>>
>> I receive the same error:
>>
>> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed:
>> nodename nor servname provided, or not known in
>> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>> on line 470
>>
>> Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo
>> failed: nodename nor servn (trying to connect via
>> tcp://localhost,dbname=jobeet:3306) in
>> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>> on line 470
>>
>>
>>  PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses:
>> getaddrinfo failed: nodename nor servname provided, or not known
>>
>> I try to delete all and re-install all symfony and MAMP but I have the
>> same problem.
>>
>> Il giorno 28/gen/2010, alle ore 15.04, Tom Ptacnik ha scritto:
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "symfony users" group.
>> To post to this group, send email to symfony-us...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> symfony-users+unsubscr...@googlegroups.com
>> .
>> For more optio

Re: [symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Andrea Marin
Hi Stèphane,

thanks i correct my mistake but there are something other wrong.
Now the error change and is:

Warning: PDO::__construct(): [2002] No such file or directory (trying to 
connect via unix:///tmp/mysql.sock) in 
/Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
 on line 470

  
  PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory

How can I fix it?
Thanks Andrea

Il giorno 28/gen/2010, alle ore 17.32, Stéphane ha scritto:

> You have an error in your DB DSN declaration.
> 
> mysql:host=localhost;dbname=jobeet
> 
> It is not a "," but a ";".
> 
> Cheers,
> 
> 
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
> 
> 
> On Thu, Jan 28, 2010 at 5:27 PM, Andrea Marin  wrote:
> > What do you have in config/doctrine/schema.yml and in config/
> > databases.yml ?
> > If you run "symfony doctrine:build --all --and-load --no-confirmation"
> > do you get the same error?
> 
> Hi all,
> 
> thanks for reply,
> in my config/doctrine/schema.yml I have:
> 
> # config/doctrine/schema.yml
> JobeetCategory:
>actAs: { Timestampable: ~ }
>columns:
>name: { type: string(255), notnull: true, unique: true }
> 
> JobeetJob:
>actAs: { Timestampable: ~ }
>columns:
>category_id: { type: integer, notnull: true }
>type: { type: string(255) }
>company: { type: string(255), notnull: true }
>logo: { type: string(255) }
>url: { type: string(255) }
>position: { type: string(255), notnull: true }
>location: { type: string(255), notnull: true }
>description:  { type: string(4000), notnull: true }
>how_to_apply: { type: string(4000), notnull: true }
>token: { type: string(255), notnull: true, unique: true }
>is_public: { type: boolean, notnull: true, default: 1 }
>is_activated: { type: boolean, notnull: true, default: 0 }
>email: { type: string(255), notnull: true }
>expires_at: { type: timestamp, notnull: true }
>relations:
>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id, 
> foreignAlias: JobeetJobs }
> 
> JobeetAffiliate:
>actAs: { Timestampable: ~ }
>columns:
>url: { type: string(255), notnull: true }
>email: { type: string(255), notnull: true, unique: true }
>token: { type: string(255), notnull: true }
>is_active: { type: boolean, notnull: true, default: 0 }
>relations:
>JobeetCategories: { class: JobeetCategory, refClass: 
> JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id, 
> foreignAlias: JobeetAffiliates }
> 
> JobeetCategoryAffiliate:
>columns:
>category_id: { type: integer, primary: true }
>affiliate_id: { type: integer, primary: true }
>relations:
>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id }
>JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign: id 
> }
> 
> in config/databases.yml I have
> 
> all:
>  doctrine:
>class: sfDoctrineDatabase
>param:
>  dsn: 'mysql:host=localhost,dbname=jobeet'
>  username: root
>  password: root
> 
> If I run:
> 
> "symfony doctrine:build --all --and-load --no-confirmation"
> 
> I receive the same error:
> 
> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: 
> nodename nor servname provided, or not known in 
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>  on line 470
> 
> Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo 
> failed: nodename nor servn (trying to connect via 
> tcp://localhost,dbname=jobeet:3306) in 
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
>  on line 470
> 
> 
>  PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses: 
> getaddrinfo failed: nodename nor servname provided, or not known
> 
> I try to delete all and re-install all symfony and MAMP but I have the same 
> problem.
> 
> Il giorno 28/gen/2010, alle ore 15.04, Tom Ptacnik ha scritto:
> 
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
> 
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@google

Re: [symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Stéphane
You have an error in your DB DSN declaration.

mysql:host=localhost;dbname=jobeet

It is not a "," but a ";".

Cheers,


Before Printing, Think about Your Environmental Responsibility!
Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!


On Thu, Jan 28, 2010 at 5:27 PM, Andrea Marin  wrote:

> > What do you have in config/doctrine/schema.yml and in config/
> > databases.yml ?
> > If you run "symfony doctrine:build --all --and-load --no-confirmation"
> > do you get the same error?
>
> Hi all,
>
> thanks for reply,
> in my config/doctrine/schema.yml I have:
>
> # config/doctrine/schema.yml
> JobeetCategory:
>actAs: { Timestampable: ~ }
>columns:
>name: { type: string(255), notnull: true, unique: true }
>
> JobeetJob:
>actAs: { Timestampable: ~ }
>columns:
>category_id: { type: integer, notnull: true }
>type: { type: string(255) }
>company: { type: string(255), notnull: true }
>logo: { type: string(255) }
>url: { type: string(255) }
>position: { type: string(255), notnull: true }
>location: { type: string(255), notnull: true }
>description:  { type: string(4000), notnull: true }
>how_to_apply: { type: string(4000), notnull: true }
>token: { type: string(255), notnull: true, unique: true }
>is_public: { type: boolean, notnull: true, default: 1 }
>is_activated: { type: boolean, notnull: true, default: 0 }
>email: { type: string(255), notnull: true }
>expires_at: { type: timestamp, notnull: true }
>relations:
>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign:
> id, foreignAlias: JobeetJobs }
>
> JobeetAffiliate:
>actAs: { Timestampable: ~ }
>columns:
>url: { type: string(255), notnull: true }
>email: { type: string(255), notnull: true, unique: true }
>token: { type: string(255), notnull: true }
>is_active: { type: boolean, notnull: true, default: 0 }
>relations:
>JobeetCategories: { class: JobeetCategory, refClass:
> JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id,
> foreignAlias: JobeetAffiliates }
>
> JobeetCategoryAffiliate:
>columns:
>category_id: { type: integer, primary: true }
>affiliate_id: { type: integer, primary: true }
>relations:
>JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id
> }
>JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign:
> id }
>
> in config/databases.yml I have
>
> all:
>  doctrine:
>class: sfDoctrineDatabase
>param:
>  dsn: 'mysql:host=localhost,dbname=jobeet'
>  username: root
>  password: root
>
> If I run:
>
> "symfony doctrine:build --all --and-load --no-confirmation"
>
> I receive the same error:
>
> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed:
> nodename nor servname provided, or not known in
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
> on line 470
>
> Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo
> failed: nodename nor servn (trying to connect via
> tcp://localhost,dbname=jobeet:3306) in
> /Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
> on line 470
>
>
>  PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses:
> getaddrinfo failed: nodename nor servname provided, or not known
>
> I try to delete all and re-install all symfony and MAMP but I have the same
> problem.
>
> Il giorno 28/gen/2010, alle ore 15.04, Tom Ptacnik ha scritto:
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Andrea Marin
> What do you have in config/doctrine/schema.yml and in config/
> databases.yml ?
> If you run "symfony doctrine:build --all --and-load --no-confirmation"
> do you get the same error?

Hi all,

thanks for reply, 
in my config/doctrine/schema.yml I have:

# config/doctrine/schema.yml 
JobeetCategory:
actAs: { Timestampable: ~ }
columns:
name: { type: string(255), notnull: true, unique: true }

JobeetJob: 
actAs: { Timestampable: ~ } 
columns:
category_id: { type: integer, notnull: true }
type: { type: string(255) }
company: { type: string(255), notnull: true }
logo: { type: string(255) }
url: { type: string(255) }
position: { type: string(255), notnull: true }
location: { type: string(255), notnull: true }
description:  { type: string(4000), notnull: true }
how_to_apply: { type: string(4000), notnull: true }
token: { type: string(255), notnull: true, unique: true }
is_public: { type: boolean, notnull: true, default: 1 }
is_activated: { type: boolean, notnull: true, default: 0 }
email: { type: string(255), notnull: true }
expires_at: { type: timestamp, notnull: true }
relations: 
JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id, 
foreignAlias: JobeetJobs }

JobeetAffiliate: 
actAs: { Timestampable: ~ } 
columns:
url: { type: string(255), notnull: true }
email: { type: string(255), notnull: true, unique: true }
token: { type: string(255), notnull: true }
is_active: { type: boolean, notnull: true, default: 0 }
relations: 
JobeetCategories: { class: JobeetCategory, refClass: 
JobeetCategoryAffiliate, local: affiliate_id, foreign: category_id, 
foreignAlias: JobeetAffiliates }

JobeetCategoryAffiliate: 
columns:
category_id: { type: integer, primary: true }
affiliate_id: { type: integer, primary: true } 
relations:
JobeetCategory: { onDelete: CASCADE, local: category_id, foreign: id } 
JobeetAffiliate: { onDelete: CASCADE, local: affiliate_id, foreign: id }

in config/databases.yml I have

all:
  doctrine:
class: sfDoctrineDatabase
param:
  dsn: 'mysql:host=localhost,dbname=jobeet'
  username: root
  password: root

If I run:

"symfony doctrine:build --all --and-load --no-confirmation"

I receive the same error:

Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: 
nodename nor servname provided, or not known in 
/Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
 on line 470

Warning: PDO::__construct(): [2002] php_network_getaddresses: getaddrinfo 
failed: nodename nor servn (trying to connect via 
tcp://localhost,dbname=jobeet:3306) in 
/Users/andrea/sfprojects/jobeet/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php
 on line 470


   
  PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses: 
getaddrinfo failed: nodename nor servname provided, or not known

I try to delete all and re-install all symfony and MAMP but I have the same 
problem.

Il giorno 28/gen/2010, alle ore 15.04, Tom Ptacnik ha scritto:

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread yth

Dear ken,

Is this possible to avoid modifiying the database schema?
I am not using sfGuardUserPlugin but I am thinking like this:

1. Somebody logins
2. His login id (member id) and password are first checked and they are 
correct

3. An attribute member_id is set to his member id in the session
4. He forgot to logout and later logins in another computer or same computer 
but different browser
5. His login id (member id) and password are first checked and they are 
correct
6. Scan for all sessions and check if there is one having member_id 
attribute set to his member id

7. If there is one, kill that old session
8. A session attribute member_id is set to his member id in the new session

Is this solution feasible? But I don't know how to do steps 6-7.


- Original Message - 
From: "ken" 

To: "symfony users" 
Sent: Thursday, January 28, 2010 11:15 PM
Subject: [symfony-users] Re: Making sure a login id only has one session at 
any moment



The best solution for this is use database session. Add session_id
column in the Profile table. This field has to be set during login. So
if you are using sfGuardUserPlugin, you can override the signIn method
in myUser. With the session_id at hand you will be able to check if
user is signed in in another machine via the Session table.

You will also need to take account of the remote host.


On Jan 28, 10:15 pm, DEEPAK BHATIA  wrote:

I think you can set a field in database setting login status to true.
Now if the person again logs in and you find from database, you can
take him to the logout screen/error screen.



On Thu, Jan 28, 2010 at 7:27 PM, Tom Ptacnik  wrote:
> Why do you want to kill his old session?

> On 28 led, 04:21, "yth"  wrote:
>> Dear all,

>> When a user logins, the controller calls the following function in the
>> myUser.class. The problem is, if he doesn't logout but then logins in
>> another computer/browser, the old session does not get killed. I tried 
>> to
>> use setAuthenticated(false) on users who have already authenticated, 
>> hoping

>> that his old session will get killed before he gets a new one. But it
>> doesn't work.

>> Many thanks to you all.

>> // Viewable inhttp://pastebin.com/f765fff66

>> public function login($loginId,$pwd){

>> $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);

>> if(!is_null($member)) {

>> if($this->isAuthenticated())
>> $this->setAuthenticated(false); // I would like to
>> logout the user if he/she already has a session, but it doesn't work

>> $this->setAuthenticated(true);
>> $member->setLastLoginAt(time());
>> $member->save();
>> $this->setAttribute('member_id', $member->getMemberId());

>> return true;
>> }
>> return false;

>> }

> --
> You received this message because you are subscribed to the Google 
> Groups "symfony users" group.

> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group 
> athttp://groups.google.com/group/symfony-users?hl=en.


--
You received this message because you are subscribed to the Google Groups 
"symfony users" group.

To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



__ NOD32 4813 (20100128) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

--
You received this message because you are subscribed to the Google Groups "symfony 
users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Slow template rendering

2010-01-28 Thread axel at
Hello Georg,

thanx for your help, it was actually the creation of the user objects
that took 90% oft the time, with your solution the execution time of
the request went down to <5 seconds (2,5 seconds for the list
rendering) whats imho ok for the rendering of a list containing 5000
resultrows.

what's my learning: never use doctrine based object fetching for large
resultsets?

is there a way to enforce Doctrine_Core::HYDRATE_SCALAR eg for m:n
relations
eg:
user <-> user2workshop <-> workshop (... foreignAlias: workshops)

$user->getWorkshops(array(), Doctrine_Core::HYDRATE_SCALAR)
???

anyway thanks for your help!

kind regards
Axel





On 28 Jan., 14:08, Georg Gell  wrote:
> Axel,
>
> is it possible that the creation of the user objects takes such a long
> time? I don't know what your user objects do, or how many are in this
> list, but just for displaying the names of the users, I wouldn't
> create objects, but hydrate with Doctrine_Core::HYDRATE_SCALAR.
> Try if this works more quickly:
>
> set up this method in your Event object:
>
> class Event extends BaseEvent{
> ...
> public function getUserListAsArray()
> {
>   return Doctrine::getTable('Users')->createQuery()->where('event_id =
> ?', $this->id)->execute(array(), Doctrine_Core::HYDRATE_SCALAR);
>
> }
>
> and in the template:
>
> getUserListAsArray() as $user){
> echo <<        
>           {$user['firstname']} {$user['lastname']}
>         
> EOT;
>
> } ?>
>
> Does this solve your speed problem?
>
> Georg
>
> Am 27.01.2010 19:58, schrieb axel at:
>
> > hello list,
>
> > symfony seems to be extrem slow - compared to "native" php
> > a request with the following code takes ~26 seconds (count($event-
> >> getUserList()) == 5000)
>
> > getUserList() as $user):  ?>
> >        
> >           getFirstname(). " ". $user->getLastname
> > (); ?>
> >         
> >  
>
> > type       calls   time (ms)       time (%)
> > Configuration      13      1932.20 7
> > Factories  1       361.77  1
> > Database (Doctrine)        8       0.06    0
> > Action "event/listAction"        1       19.53   0
> > View "Success" for "event/listAction"  1       25653.20        93
> > Partial "event/_assets"  1       1.41    0
> > Partial "event/_flashes" 1       5.31    0
> > Component "address/menuItems"    1       68.60   0
> > Partial "address/_menuItems"     1       3.23    0
> > Component "address/loginState"   1       0.06    0
> > Partial "address/_loginState"    1       2.06    0
>
> > the doctrine database query is ok
> > I don't think that the templating is the problem, (I tried to do the
> > output with echo $user->... from within the action what took as long
> > as if I used the template engine. for me it seems to be a doctrine
> > problem (foreach...?)
>
> > is there a way to improove this poor results?

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] tinymce in symfony

2010-01-28 Thread Gábor Fási
http://www.symfony-project.org/forms/1_2/en/A-Widgets#chapter_a_sub_sfwidgetformtextareatinymce

On Thu, Jan 28, 2010 at 09:06, mr_question  wrote:
> I inserted in /js catalog 'tiny_mce', added to settings.yml:
> rich_text_js_dir:  js/tiny_mce
> and my sfWidgetFormTextarea's aren't rich text editors, why ?
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread yth

Dear Tom,

Just like facebook, if I login in a public computer but forgot to logout, 
later when I am home and then login, the old session (may not have expired 
yet) should be killed. It seems more secure.


- Original Message - 
From: "Tom Ptacnik" 

To: "symfony users" 
Sent: Thursday, January 28, 2010 9:57 PM
Subject: [symfony-users] Re: Making sure a login id only has one session at 
any moment



Why do you want to kill his old session?


On 28 led, 04:21, "yth"  wrote:

Dear all,

When a user logins, the controller calls the following function in the
myUser.class. The problem is, if he doesn't logout but then logins in
another computer/browser, the old session does not get killed. I tried to
use setAuthenticated(false) on users who have already authenticated, 
hoping

that his old session will get killed before he gets a new one. But it
doesn't work.

Many thanks to you all.

// Viewable inhttp://pastebin.com/f765fff66

public function login($loginId,$pwd){

$member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);

if(!is_null($member)) {

if($this->isAuthenticated())
$this->setAuthenticated(false); // I would like to
logout the user if he/she already has a session, but it doesn't work

$this->setAuthenticated(true);
$member->setLastLoginAt(time());
$member->save();
$this->setAttribute('member_id', $member->getMemberId());

return true;
}
return false;



}


--
You received this message because you are subscribed to the Google Groups 
"symfony users" group.

To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



__ NOD32 4813 (20100128) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

--
You received this message because you are subscribed to the Google Groups "symfony 
users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Doctrine inheritance and i18n forms

2010-01-28 Thread aninffected
I have the same question myself.

On 27 Ιαν, 17:43, Thibault Jouannic  wrote:
> So, an idea anyone ?

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread Andro
isAuthenticated and setAuthenticated sets only LOCAL Cookies. So if he
logins from another computer this functions doesn't check this, but if
ANOTHER User is logged in at the SAME computer, so you can delete his
e.g. credentials first before adding the new ones...

On 28 Jan., 04:21, "yth"  wrote:
> Dear all,
>
> When a user logins, the controller calls the following function in the
> myUser.class. The problem is, if he doesn't logout but then logins in
> another computer/browser, the old session does not get killed. I tried to
> use setAuthenticated(false) on users who have already authenticated, hoping
> that his old session will get killed before he gets a new one. But it
> doesn't work.
>
> Many thanks to you all.
>
> // Viewable inhttp://pastebin.com/f765fff66
>
> public function login($loginId,$pwd){
>
>         $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>
>         if(!is_null($member)) {
>
>            if($this->isAuthenticated())
>                    $this->setAuthenticated(false);  // I would like to
> logout the user if he/she already has a session, but it doesn't work
>
>             $this->setAuthenticated(true);
>             $member->setLastLoginAt(time());
>             $member->save();
>             $this->setAttribute('member_id', $member->getMemberId());
>
>             return true;
>         }
>         return false;
>
> }

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Using an action to generate an image as an image tag src attribute

2010-01-28 Thread Andro
I didn't find a better solution and did it the same way...

On 28 Jan., 09:06, Gareth McCumskey  wrote:
> Hi guys,
>
> I am probably missing something obvious but is it possible for me to
> pass in an img tags src attribute the url to an action that will then
> output a dynamically generated image?
>
> Example: Instead of a direct link to an image like
>
> 
>
> I want to do :
>
> 
>
> I know about changing headers and so on on the action side of things
> to push out a binary element as opposed to a regular symfony view.
> Just wondering what I might need to change routing-wise (if at all) to
> get this to work. Maybe I shouldn't even be using the image_tag helper
> at all?
>
> 
>
> --
> Gareth McCumskeyhttp://garethmccumskey.blogspot.com
> twitter: @garethmcc

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] tinymce in symfony

2010-01-28 Thread mr_question
I inserted in /js catalog 'tiny_mce', added to settings.yml:
rich_text_js_dir:  js/tiny_mce
and my sfWidgetFormTextarea's aren't rich text editors, why ?

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread ken
The best solution for this is use database session. Add session_id
column in the Profile table. This field has to be set during login. So
if you are using sfGuardUserPlugin, you can override the signIn method
in myUser. With the session_id at hand you will be able to check if
user is signed in in another machine via the Session table.

You will also need to take account of the remote host.


On Jan 28, 10:15 pm, DEEPAK BHATIA  wrote:
> I think you can set a field in database setting login status to true.
> Now if the person again logs in and you find from database, you can
> take him to the logout screen/error screen.
>
>
>
> On Thu, Jan 28, 2010 at 7:27 PM, Tom Ptacnik  wrote:
> > Why do you want to kill his old session?
>
> > On 28 led, 04:21, "yth"  wrote:
> >> Dear all,
>
> >> When a user logins, the controller calls the following function in the
> >> myUser.class. The problem is, if he doesn't logout but then logins in
> >> another computer/browser, the old session does not get killed. I tried to
> >> use setAuthenticated(false) on users who have already authenticated, hoping
> >> that his old session will get killed before he gets a new one. But it
> >> doesn't work.
>
> >> Many thanks to you all.
>
> >> // Viewable inhttp://pastebin.com/f765fff66
>
> >> public function login($loginId,$pwd){
>
> >>         $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>
> >>         if(!is_null($member)) {
>
> >>            if($this->isAuthenticated())
> >>                    $this->setAuthenticated(false);  // I would like to
> >> logout the user if he/she already has a session, but it doesn't work
>
> >>             $this->setAuthenticated(true);
> >>             $member->setLastLoginAt(time());
> >>             $member->save();
> >>             $this->setAttribute('member_id', $member->getMemberId());
>
> >>             return true;
> >>         }
> >>         return false;
>
> >> }
>
> > --
> > You received this message because you are subscribed to the Google Groups 
> > "symfony users" group.
> > To post to this group, send email to symfony-us...@googlegroups.com.
> > To unsubscribe from this group, send email to 
> > symfony-users+unsubscr...@googlegroups.com.
> > For more options, visit this group 
> > athttp://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread DEEPAK BHATIA
I think you can set a field in database setting login status to true.
Now if the person again logs in and you find from database, you can
take him to the logout screen/error screen.

On Thu, Jan 28, 2010 at 7:27 PM, Tom Ptacnik  wrote:
> Why do you want to kill his old session?
>
>
> On 28 led, 04:21, "yth"  wrote:
>> Dear all,
>>
>> When a user logins, the controller calls the following function in the
>> myUser.class. The problem is, if he doesn't logout but then logins in
>> another computer/browser, the old session does not get killed. I tried to
>> use setAuthenticated(false) on users who have already authenticated, hoping
>> that his old session will get killed before he gets a new one. But it
>> doesn't work.
>>
>> Many thanks to you all.
>>
>> // Viewable inhttp://pastebin.com/f765fff66
>>
>> public function login($loginId,$pwd){
>>
>>         $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>>
>>         if(!is_null($member)) {
>>
>>            if($this->isAuthenticated())
>>                    $this->setAuthenticated(false);  // I would like to
>> logout the user if he/she already has a session, but it doesn't work
>>
>>             $this->setAuthenticated(true);
>>             $member->setLastLoginAt(time());
>>             $member->save();
>>             $this->setAttribute('member_id', $member->getMemberId());
>>
>>             return true;
>>         }
>>         return false;
>>
>>
>>
>> }
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: php symfony doctrine:insert-sql Error

2010-01-28 Thread Tom Ptacnik
What do you have in config/doctrine/schema.yml and in config/
databases.yml ?
If you run "symfony doctrine:build --all --and-load --no-confirmation"
do you get the same error?

On 28 led, 09:34, Andrea Marin  wrote:
> Hi all,
>
> someone can help me for this sql problem, i try to search with google but I 
> cannot find a solution and I don't know how to go ahed.
>
> Il giorno 27/gen/2010, alle ore 10.11, Andrea ha scritto:
>
>
>
> > Hi all,
>
> > i'm trying to follow the Jobeet 1.4 Doctrine guide and when i run the
> > command php symfony doctrine:insert-sql I receive this error:
>
> > Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo
> > failed: nodename nor servname provided, or not known in /Users/andrea/
> > Documents/sfproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> > lib/vendor/doctrine/Doctrine/Connection.php on line 470
>
> > Warning: PDO::__construct(): [2002] php_network_getaddresses:
> > getaddrinfo failed: nodename nor servn (trying to connect via
> > tcp://localhost,dbname=jobeet:3306) in /Users/andrea/Documents/
> > sfproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/
> > doctrine/Doctrine/Connection.php on line 470
>
> > PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses:
> > getaddrinfo failed: nodename nor servname provided, or not known
>
> > I check the Connection.php file at line 470 but there is only the
> > connection to db.
>
> > Before of this commend i run two command for create the model and sql:
>
> > php symfony doctrine:build --model
> > php symfony doctrine:build --sql
>
> > What is my mistake?
> > Thanks all.
>
> > --
> > You received this message because you are subscribed to the Google Groups 
> > "symfony users" group.
> > To post to this group, send email to symfony-us...@googlegroups.com.
> > To unsubscribe from this group, send email to 
> > symfony-users+unsubscr...@googlegroups.com.
> > For more options, visit this group 
> > athttp://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Making sure a login id only has one session at any moment

2010-01-28 Thread Tom Ptacnik
Why do you want to kill his old session?


On 28 led, 04:21, "yth"  wrote:
> Dear all,
>
> When a user logins, the controller calls the following function in the
> myUser.class. The problem is, if he doesn't logout but then logins in
> another computer/browser, the old session does not get killed. I tried to
> use setAuthenticated(false) on users who have already authenticated, hoping
> that his old session will get killed before he gets a new one. But it
> doesn't work.
>
> Many thanks to you all.
>
> // Viewable inhttp://pastebin.com/f765fff66
>
> public function login($loginId,$pwd){
>
>         $member=MemberPeer::getByLoginIdAndPassword($loginId,$pwd);
>
>         if(!is_null($member)) {
>
>            if($this->isAuthenticated())
>                    $this->setAuthenticated(false);  // I would like to
> logout the user if he/she already has a session, but it doesn't work
>
>             $this->setAuthenticated(true);
>             $member->setLastLoginAt(time());
>             $member->save();
>             $this->setAttribute('member_id', $member->getMemberId());
>
>             return true;
>         }
>         return false;
>
>
>
> }

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: External user authentication with sfDoctrineGuardPlugin

2010-01-28 Thread Tom Ptacnik
Create an module with "secure: is_secure: false" in which you can do
what you want (create a user in sf_guard_user table ...)



On 28 led, 02:15, ashton  wrote:
> I have my external authentication working, but the problem that I am
> running into is that there needs to be a user in the sfGuardUser table
> that matches the username submit in the login form, otherwise the
> login fails.
>
> So when I currently add 'return true;' to the top of the external auth
> function, I can login with any password, for users that exist in the
> sf_guard_table, but not with usernames that do not exist.
>
> I was wondering if there was a solution out there (ideally user
> creation in the sfGuardUser table upon successful external
> authentication), allowing me to perform my external checks even if the
> username does not exist in the sf_guard_user table would work too,
> because then I could just manually create the user if the external
> auth was successful.
>
> thanks!
> ashton

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: XSS escaping_strategy escaping_method not work

2010-01-28 Thread smellycat37
in the file settings.yml, I had two .settings: in my all configuration

On 27 jan, 11:02, smellycat37  wrote:
> hello,
>
> I use symfony 1.2.9 with doctrine...
> I would like to escape all the special html character that user can
> put in form html...
> So I add in the section ".all .settings" of my settings.yml file the
> followings lines:
>     escaping_strategy: both
>    escaping_method:   ESC_ENTITIES
>
> With a form, I save an object annonce contained a description field
> alert('hello')
> I display $announce->getDescription() but the javascript is
> executed...
> When i check the source code I've got alert('bonjour') and not >
>
> thanks for your help

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: Subdomain dynamicly

2010-01-28 Thread seifolah Ghaderi
I think problem is in virtualhost setting so.
I wanna to know is it possible to have subdomain in apache on windows system?

On Wed, Jan 27, 2010 at 4:47 PM, Tom Ptacnik  wrote:
> So, if you change content of index.php in your web project directory
> to something like  (included my previous
> recomendation) and nothing is showed. Problem is in the virtualhost
> settings (apache... php...)
>
> If you see "hello" text. Problem should be in your symfony
> application.
>
>
> On 26 led, 16:26, seifolah Ghaderi  wrote:
>> No !! It doesn't work.
>>
>>
>>
>> On Tue, Jan 26, 2010 at 6:45 PM, Tom Ptacnik  wrote:
>> > What if you add a "127.0.0.1 test.my.com" to the hosts file and
>> > "ServerAlias test.my.com" to the virtualhost config. Does this
>> > subdomain works?
>>
>> > On 26 led, 09:17, seifolah Ghaderi  wrote:
>> >> Hi again.
>> >> For test sub domain I have a problem .
>> >> I have a win xp and installed wamp on it.
>> >> After some googleing I find how to confige virtual host name based.I
>> >> use this confige in my host file(in C:\WINDOWS\system32\drivers\etc)
>>
>> >> 127.0.0.1       localhost
>> >> 127.0.0.1   mysite.web
>> >> 127.0.0.1  www.my.com
>> >> 127.0.0.1   *.my.com
>>
>> >> And in my httpd.conf :
>>
>> >> 
>> >>   DocumentRoot "E:/wamp/www"
>>
>> >> ServerName localhost
>> >>   DirectoryIndex index.php
>> >> 
>>
>> >> 
>> >>   DocumentRoot "E:/dev/sfproject/mysite/web"
>> >>   ServerAlias *.my.com
>> >> ServerNamewww.my.com
>> >>   DirectoryIndex index.php
>> >> 
>>
>> >> Now I can access my host withwww.my.comButI can't access
>> >> subdomains.For example example1.my.com,It show "page not found error".
>> >> Any idea?
>>
>> >> On Wed, Jan 20, 2010 at 11:00 AM, seifolah Ghaderi  
>> >> wrote:
>> >> > Thanks .I try it.
>>
>> >> > On Tue, Jan 19, 2010 at 6:14 PM, wissl  
>> >> > wrote:
>> >> >> There is the excellente part "Advanced Routing" of the 2009 symfony
>> >> >> advent calendar, that is related to your topic. Have you read it?
>> >> >> Otherwise give it a try!
>>
>> >> >>http://www.symfony-project.org/advent_calendar/2/en
>> >> >>http://www.symfony-project.org/advent_calendar/3/en
>>
>> >> >> On 19 Jan., 14:36, sepelloo  wrote:
>> >> >>> Hi all.
>> >> >>> I want to generate these url based on one of my tables.
>> >> >>> For example for each record in table "section" I want to generate:
>> >> >>> section_1.mysite.com
>> >> >>> or section_X.mysite.com
>> >> >>> and if then user select one of my caregory then url will
>> >> >>> be:section_1.mysite.com/cat/id/1
>> >> >>> I want to  refer these url to on module.
>> >> >>> Any idea?
>>
>> >> >> --
>> >> >> You received this message because you are subscribed to the Google 
>> >> >> Groups "symfony users" group.
>> >> >> To post to this group, send email to symfony-us...@googlegroups.com.
>> >> >> To unsubscribe from this group, send email to 
>> >> >> symfony-users+unsubscr...@googlegroups.com.
>> >> >> For more options, visit this group 
>> >> >> athttp://groups.google.com/group/symfony-users?hl=en.
>>
>> > --
>> > You received this message because you are subscribed to the Google Groups 
>> > "symfony users" group.
>> > To post to this group, send email to symfony-us...@googlegroups.com.
>> > To unsubscribe from this group, send email to 
>> > symfony-users+unsubscr...@googlegroups.com.
>> > For more options, visit this group 
>> > athttp://groups.google.com/group/symfony-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Slow template rendering

2010-01-28 Thread Georg Gell
Axel,

is it possible that the creation of the user objects takes such a long
time? I don't know what your user objects do, or how many are in this
list, but just for displaying the names of the users, I wouldn't
create objects, but hydrate with Doctrine_Core::HYDRATE_SCALAR.
Try if this works more quickly:

set up this method in your Event object:

class Event extends BaseEvent{
...
public function getUserListAsArray()
{
  return Doctrine::getTable('Users')->createQuery()->where('event_id =
?', $this->id)->execute(array(), Doctrine_Core::HYDRATE_SCALAR);
}

and in the template:

getUserListAsArray() as $user){
echo <<
  {$user['firstname']} {$user['lastname']}

EOT;
} ?>

Does this solve your speed problem?

Georg

Am 27.01.2010 19:58, schrieb axel at:
> hello list,
> 
> symfony seems to be extrem slow - compared to "native" php
> a request with the following code takes ~26 seconds (count($event-
>> getUserList()) == 5000)
> 
> getUserList() as $user):  ?>
>
>   getFirstname(). " ". $user->getLastname
> (); ?>
> 
>  
> 
> type  calls   time (ms)   time (%)
> Configuration 13  1932.20 7
> Factories 1   361.77  1
> Database (Doctrine)   8   0.060
> Action "event/listAction" 1   19.53   0
> View "Success" for "event/listAction" 1   25653.2093
> Partial "event/_assets"   1   1.410
> Partial "event/_flashes"  1   5.310
> Component "address/menuItems" 1   68.60   0
> Partial "address/_menuItems"  1   3.230
> Component "address/loginState"1   0.060
> Partial "address/_loginState" 1   2.060
> 
> the doctrine database query is ok
> I don't think that the templating is the problem, (I tried to do the
> output with echo $user->... from within the action what took as long
> as if I used the template engine. for me it seems to be a doctrine
> problem (foreach...?)
> 
> is there a way to improove this poor results?
> 

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Slow template rendering

2010-01-28 Thread Gareth McCumskey
Well there will always be -some- overhead of using a framework. I
think that he's been using the dev environment for these benchmarks
which does add a lot of extra processing that you don't normally get
in the production environment. The benchmark of production environment
vs "simple" PHP will not be that different. Of course it will still
favour the "simple" PHP, but then we aren't using symfony to make an
application run faster, we use it to enforce certain design patterns
(MVC) to our projects to make them easier to extend and maintain. If
performance is the number 1 priority (and all the symfony performance
improvements that are available have not worked) then any framework
will not be a good choice. If you are however developing an
application where extensibility and maintainability is your priority
then frameworks like symfony are the best choice. Its all about
getting your priorities straight.

One last thing @OP, are you using a memory caching application like
APC Cache? If not, this can dramatically speed up a symfony
application.

On Thu, Jan 28, 2010 at 12:27 PM, Stéphane  wrote:
> Well it looks like he tried using simple php and it worked great.
>
> Does the db query for user listing clearly "SELECT * FROM users" or such a
> thing stating it selects all fields ?
>
>
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
>
>
> On Thu, Jan 28, 2010 at 11:25 AM, Gareth McCumskey 
> wrote:
>>
>> Did you run it through the dev environment? If so, the dev environment
>> adds an additional processing overhead to the application as it keeps
>> track of a number of different variables and symfony states to allow
>> for debugging purposes. Also, try running the query itself on your
>> databases command line client to help determine if perhaps the
>> database itself is just really slow.
>>
>> On Wed, Jan 27, 2010 at 8:58 PM, axel at  wrote:
>> > hello list,
>> >
>> > symfony seems to be extrem slow - compared to "native" php
>> > a request with the following code takes ~26 seconds (count($event-
>> >>getUserList()) == 5000)
>> >
>> > getUserList() as $user):  ?>
>> >       
>> >          getFirstname(). " ". $user->getLastname
>> > (); ?>
>> >        
>> >  
>> >
>> > type    calls   time (ms)       time (%)
>> > Configuration   13      1932.20 7
>> > Factories       1       361.77  1
>> > Database (Doctrine)     8       0.06    0
>> > Action "event/listAction"       1       19.53   0
>> > View "Success" for "event/listAction"   1       25653.20        93
>> > Partial "event/_assets" 1       1.41    0
>> > Partial "event/_flashes"        1       5.31    0
>> > Component "address/menuItems"   1       68.60   0
>> > Partial "address/_menuItems"    1       3.23    0
>> > Component "address/loginState"  1       0.06    0
>> > Partial "address/_loginState"   1       2.06    0
>> >
>> > the doctrine database query is ok
>> > I don't think that the templating is the problem, (I tried to do the
>> > output with echo $user->... from within the action what took as long
>> > as if I used the template engine. for me it seems to be a doctrine
>> > problem (foreach...?)
>> >
>> > is there a way to improove this poor results?
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups "symfony users" group.
>> > To post to this group, send email to symfony-us...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > symfony-users+unsubscr...@googlegroups.com.
>> > For more options, visit this group at
>> > http://groups.google.com/group/symfony-users?hl=en.
>> >
>> >
>>
>>
>>
>> --
>> Gareth McCumskey
>> http://garethmccumskey.blogspot.com
>> twitter: @garethmcc
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "symfony users" group.
>> To post to this group, send email to symfony-us...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> symfony-users+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/symfony-users?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Slow template rendering

2010-01-28 Thread Stéphane
Well it looks like he tried using simple php and it worked great.

Does the db query for user listing clearly "SELECT * FROM users" or such a
thing stating it selects all fields ?


Before Printing, Think about Your Environmental Responsibility!
Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!


On Thu, Jan 28, 2010 at 11:25 AM, Gareth McCumskey wrote:

> Did you run it through the dev environment? If so, the dev environment
> adds an additional processing overhead to the application as it keeps
> track of a number of different variables and symfony states to allow
> for debugging purposes. Also, try running the query itself on your
> databases command line client to help determine if perhaps the
> database itself is just really slow.
>
> On Wed, Jan 27, 2010 at 8:58 PM, axel at  wrote:
> > hello list,
> >
> > symfony seems to be extrem slow - compared to "native" php
> > a request with the following code takes ~26 seconds (count($event-
> >>getUserList()) == 5000)
> >
> > getUserList() as $user):  ?>
> >   
> >  getFirstname(). " ". $user->getLastname
> > (); ?>
> >
> >  
> >
> > typecalls   time (ms)   time (%)
> > Configuration   13  1932.20 7
> > Factories   1   361.77  1
> > Database (Doctrine) 8   0.060
> > Action "event/listAction"   1   19.53   0
> > View "Success" for "event/listAction"   1   25653.2093
> > Partial "event/_assets" 1   1.410
> > Partial "event/_flashes"1   5.310
> > Component "address/menuItems"   1   68.60   0
> > Partial "address/_menuItems"1   3.230
> > Component "address/loginState"  1   0.060
> > Partial "address/_loginState"   1   2.060
> >
> > the doctrine database query is ok
> > I don't think that the templating is the problem, (I tried to do the
> > output with echo $user->... from within the action what took as long
> > as if I used the template engine. for me it seems to be a doctrine
> > problem (foreach...?)
> >
> > is there a way to improove this poor results?
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> > To post to this group, send email to symfony-us...@googlegroups.com.
> > To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> .
> > For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
> >
> >
>
>
>
> --
> Gareth McCumskey
> http://garethmccumskey.blogspot.com
> twitter: @garethmcc
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Slow template rendering

2010-01-28 Thread Gareth McCumskey
Did you run it through the dev environment? If so, the dev environment
adds an additional processing overhead to the application as it keeps
track of a number of different variables and symfony states to allow
for debugging purposes. Also, try running the query itself on your
databases command line client to help determine if perhaps the
database itself is just really slow.

On Wed, Jan 27, 2010 at 8:58 PM, axel at  wrote:
> hello list,
>
> symfony seems to be extrem slow - compared to "native" php
> a request with the following code takes ~26 seconds (count($event-
>>getUserList()) == 5000)
>
> getUserList() as $user):  ?>
>       
>          getFirstname(). " ". $user->getLastname
> (); ?>
>        
>  
>
> type    calls   time (ms)       time (%)
> Configuration   13      1932.20 7
> Factories       1       361.77  1
> Database (Doctrine)     8       0.06    0
> Action "event/listAction"       1       19.53   0
> View "Success" for "event/listAction"   1       25653.20        93
> Partial "event/_assets" 1       1.41    0
> Partial "event/_flashes"        1       5.31    0
> Component "address/menuItems"   1       68.60   0
> Partial "address/_menuItems"    1       3.23    0
> Component "address/loginState"  1       0.06    0
> Partial "address/_loginState"   1       2.06    0
>
> the doctrine database query is ok
> I don't think that the templating is the problem, (I tried to do the
> output with echo $user->... from within the action what took as long
> as if I used the template engine. for me it seems to be a doctrine
> problem (foreach...?)
>
> is there a way to improove this poor results?
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Slow template rendering

2010-01-28 Thread axel at
there are 8 database requests consuming 6 ms at all (only one of them
gets the list, the rest is about authentication, dynamic menus and
security. (the query joins the user table with a taglist) - displayed
data is only fetched out of the user table.


On 28 Jan., 11:11, Stéphane  wrote:
> Does the "very first query" to retrieve users is selecting all needed (by
> your code) fields and relations ?
>
> If not, objects will "lazy-load" properties and relations.
> How many db requests are there ?
>
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
>
> On Thu, Jan 28, 2010 at 11:08 AM, axel at  wrote:
>
> > On 28 Jan., 06:49, Eno  wrote:
> > > On Wed, 27 Jan 2010, axel at wrote:
> > > > I didn't expect it to be faster than straight PHP, but it's about 35
> > > > times slower!!! do you have any constructive ideas for performance
> > > > tuning?
>
> > > People always make such a simplistic comparisons. There's lots you can
> > do,
> > > like optimize queries, use fumctional and template caching, etc. You also
> > > forget all the conveniences that using a framework brings you for free.
>
> > > You do actually have to learn a framework more fully before you can write
> > > code that makes such a comparison meaningful.
>
> > > --
> > I tried template caching, but it didnt't solve the problem as it is no
> > problem with the templateing. the following code takes 25 seconds too:
>
> > foreach ($event->getUserList() as $user) {
> >  $test = $user->getLastname();
> > }
> > debugging toolbar shows that the query to get the result list only
> > takes 4ms so where the rest 25 seconds come from?
> > any ideas, this is really a huge problem and a need a solution since
> > our customzers won't accept such response times.
> > functional templateing wouldn't work here, since the result of
> > getUserList() chances almost every second.
>
> > maybe there is something wrong with my php/x-cache setup? any other
> > ideas or suggestions?
>
> > thx
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "symfony users" group.
> > To post to this group, send email to symfony-us...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > symfony-users+unsubscr...@googlegroups.com
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/symfony-users?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: Slow template rendering

2010-01-28 Thread Stéphane
Does the "very first query" to retrieve users is selecting all needed (by
your code) fields and relations ?

If not, objects will "lazy-load" properties and relations.
How many db requests are there ?


Before Printing, Think about Your Environmental Responsibility!
Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!


On Thu, Jan 28, 2010 at 11:08 AM, axel at  wrote:

>
>
> On 28 Jan., 06:49, Eno  wrote:
> > On Wed, 27 Jan 2010, axel at wrote:
> > > I didn't expect it to be faster than straight PHP, but it's about 35
> > > times slower!!! do you have any constructive ideas for performance
> > > tuning?
> >
> > People always make such a simplistic comparisons. There's lots you can
> do,
> > like optimize queries, use fumctional and template caching, etc. You also
> > forget all the conveniences that using a framework brings you for free.
> >
> > You do actually have to learn a framework more fully before you can write
> > code that makes such a comparison meaningful.
> >
> > --
> I tried template caching, but it didnt't solve the problem as it is no
> problem with the templateing. the following code takes 25 seconds too:
>
> foreach ($event->getUserList() as $user) {
>  $test = $user->getLastname();
> }
> debugging toolbar shows that the query to get the result list only
> takes 4ms so where the rest 25 seconds come from?
> any ideas, this is really a huge problem and a need a solution since
> our customzers won't accept such response times.
> functional templateing wouldn't work here, since the result of
> getUserList() chances almost every second.
>
> maybe there is something wrong with my php/x-cache setup? any other
> ideas or suggestions?
>
> thx
>
> --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: Slow template rendering

2010-01-28 Thread axel at


On 28 Jan., 06:49, Eno  wrote:
> On Wed, 27 Jan 2010, axel at wrote:
> > I didn't expect it to be faster than straight PHP, but it's about 35
> > times slower!!! do you have any constructive ideas for performance
> > tuning?
>
> People always make such a simplistic comparisons. There's lots you can do,
> like optimize queries, use fumctional and template caching, etc. You also
> forget all the conveniences that using a framework brings you for free.
>
> You do actually have to learn a framework more fully before you can write
> code that makes such a comparison meaningful.
>
> --
I tried template caching, but it didnt't solve the problem as it is no
problem with the templateing. the following code takes 25 seconds too:

foreach ($event->getUserList() as $user) {
  $test = $user->getLastname();
}
debugging toolbar shows that the query to get the result list only
takes 4ms so where the rest 25 seconds come from?
any ideas, this is really a huge problem and a need a solution since
our customzers won't accept such response times.
functional templateing wouldn't work here, since the result of
getUserList() chances almost every second.

maybe there is something wrong with my php/x-cache setup? any other
ideas or suggestions?

thx

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Using an action to generate an image as an image tag src attribute

2010-01-28 Thread Земсков Юрий
 
true)) ?>

raw-name  option prevents symfony from adding '.png' at the end of the
image url.

Âû ïèñàëè 28 ?? 2010 ?., 11:06:38:

> Hi guys,

> I am probably missing something obvious but is it possible for me to
> pass in an img tags src attribute the url to an action that will then
> output a dynamically generated image?

> Example: Instead of a direct link to an image like

> 

> I want to do :

> 

> I know about changing headers and so on on the action side of things
> to push out a binary element as opposed to a regular symfony view.
> Just wondering what I might need to change routing-wise (if at all) to
> get this to work. Maybe I shouldn't even be using the image_tag helper
> at all?

> 

> -- 
> Gareth McCumskey
> http://garethmccumskey.blogspot.com
> twitter: @garethmcc



-- 
Ñ óâàæåíèåì,
 ???   mailto:y...@zemskov.name

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Re: sfWidgetFormSelectMany doesn't post at form submission

2010-01-28 Thread Cristian N.
Found it.
The problem was that select multiple is sent only with *selected*
values.
So, before submitting the form, I must select all elements for it
(done using jquery and form.submit event).

So embarrasing :)

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] php symfony doctrine:insert-sql Error

2010-01-28 Thread Andrea Marin
Hi all,

someone can help me for this sql problem, i try to search with google but I 
cannot find a solution and I don't know how to go ahed.

Il giorno 27/gen/2010, alle ore 10.11, Andrea ha scritto:

> Hi all,
> 
> i'm trying to follow the Jobeet 1.4 Doctrine guide and when i run the
> command php symfony doctrine:insert-sql I receive this error:
> 
> Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo
> failed: nodename nor servname provided, or not known in /Users/andrea/
> Documents/sfproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/
> lib/vendor/doctrine/Doctrine/Connection.php on line 470
> 
> Warning: PDO::__construct(): [2002] php_network_getaddresses:
> getaddrinfo failed: nodename nor servn (trying to connect via
> tcp://localhost,dbname=jobeet:3306) in /Users/andrea/Documents/
> sfproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/
> doctrine/Doctrine/Connection.php on line 470
> 
> PDO Connection Error: SQLSTATE[HY000] [2002] php_network_getaddresses:
> getaddrinfo failed: nodename nor servname provided, or not known
> 
> I check the Connection.php file at line 470 but there is only the
> connection to db.
> 
> Before of this commend i run two command for create the model and sql:
> 
> php symfony doctrine:build --model
> php symfony doctrine:build --sql
> 
> What is my mistake?
> Thanks all.
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Using an action to generate an image as an image tag src attribute

2010-01-28 Thread Frank Stelzer


Hi,
Step 1:
Define a custom route for it , e.g:

user_image:
  url: /user/image/:id.jpg
  param: { module: userImage, action: show }

Then your suggested call would work quite well:


Do not know exactly if this would work either:



Step 2:
Check if your new route would be rewritten to your index.php.  Go to  
your .htaccess file or your vhost configs and check your rewrite  
rules. Especially the lines below

"  # we skip all files with .something"

- Frank

Am 28.01.2010 um 09:06 schrieb Gareth McCumskey:


Hi guys,

I am probably missing something obvious but is it possible for me to
pass in an img tags src attribute the url to an action that will then
output a dynamically generated image?

Example: Instead of a direct link to an image like



I want to do :



I know about changing headers and so on on the action side of things
to push out a binary element as opposed to a regular symfony view.
Just wondering what I might need to change routing-wise (if at all) to
get this to work. Maybe I shouldn't even be using the image_tag helper
at all?




--
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

--
You received this message because you are subscribed to the Google  
Groups "symfony users" group.

To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com 
.
For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en 
.




--
You received this message because you are subscribed to the Google Groups "symfony 
users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



Re: [symfony-users] Re: What do you use symphony for?

2010-01-28 Thread Gareth McCumskey
Personally, in contrast to an interview Fabien did a while back, I
think any developer that has come to grips with symfony would be
stupid NOT to use it for every project they do, even the seemingly
simple ones as from my experience its the projects that seem tiny that
end up being a challenge later and a nightmare to continue to extend
and maintain simply because a shortcut was chosen and symfony was not
used.

On Wed, Jan 27, 2010 at 11:57 PM, rekarnar  wrote:
> Hi Ravi,
>
> We use Symfony for everything from our simple Blog sites to Gallery
> and Portfolio's. Aswell as the occasional E-Com and other misc web
> apps.
>
> It has helped by enabling us to build and deploy all the above quickly
> and efficiency with the use of the awesome toolset the Symfony
> Framework provides. (Not to mention the great community and
> documentation)
>
> On Jan 27, 1:37 pm, raviu  wrote:
>> Hello,
>>
>> Could you tell us what you use symphony for, and how it has helped.
>> Just a summary of one or two lines. I'm making up a report and would
>> like some output from the symphony community.
>>
>> Thanks for any help.
>>
>> Best,
>> Ravi
>
> --
> You received this message because you are subscribed to the Google Groups 
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to 
> symfony-users+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/symfony-users?hl=en.
>
>



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.



[symfony-users] Using an action to generate an image as an image tag src attribute

2010-01-28 Thread Gareth McCumskey
Hi guys,

I am probably missing something obvious but is it possible for me to
pass in an img tags src attribute the url to an action that will then
output a dynamically generated image?

Example: Instead of a direct link to an image like



I want to do :



I know about changing headers and so on on the action side of things
to push out a binary element as opposed to a regular symfony view.
Just wondering what I might need to change routing-wise (if at all) to
get this to work. Maybe I shouldn't even be using the image_tag helper
at all?



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

-- 
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.