symfony - Doctrine connection time out error in AWS RDS -

-

i trying connect aws rds aws ec2 application zend framwork app using doctrine module connect mysql. can successfuly connent aws rds database mysql workbench. appreciated. of stack traces:

pdoexception /vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdoconnection.php:40 sqlstate[hy000] [2002] connection timed out vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdoconnection.php(40): pdo->__construct('mysql:host=doct...', 'user', 'password', array) vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdomysql/driver.php(41): doctrine\dbal\driver\pdoconnection->__construct('mysql:host=doct...', 'user', 'password', array)  vendor/doctrine/dbal/lib/doctrine/dbal/connection.php(356): doctrine\dbal\driver\pdomysql\driver->connect(array, 'user', 'password', array)  vendor/doctrine/dbal/lib/doctrine/dbal/connection.php(680): doctrine\dbal\connection->connect()  vendor/doctrine/orm/lib/doctrine/orm/query/exec/singleselectexecutor.php(50): doctrine\dbal\connection->executequery('select count(*)...', array, array, null) vendor/doctrine/orm/lib/doctrine/orm/query.php(286): doctrine\orm\query\exec\singleselectexecutor->execute(object(doctrine\dbal\connection), array, array) vendor/doctrine/orm/lib/doctrine/orm/abstractquery.php(794): doctrine\orm\query->_doexecute() vendor/doctrine/orm/lib/doctrine/orm/abstractquery.php(598): doctrine\orm\abstractquery->execute(null, 3)

is complex query? user has proper rights execute query?

don't think doctrine causing problem, it's outbound firewall of host you're executing query from. same machine workbench executed from?


Comments

Post a Comment

Popular posts from this blog

c# - Store DBContext Log in other EF table -

-
i want store logs in db table (imported ef code). my code looks this: public pmcontext() : base("myentities") { configuration.proxycreationenabled = false; configuration.lazyloadingenabled = false; this.database.log = s => logstore(s); } private void logstore(string message) { tlog log = new tlog(); log.description = message; log.insertdate = datetime.now; logs.add(log); savechanges(); } public virtual dbset<tlog> logs { get; set; } i cannot use savechanges() (get error "sqlconnection not support parallel transactions") , if remove line nothing stored in db table. how can fix this? i think happens during savechanges call anywhere in app, because sql generated call logged, triggers nested savechanges call tries start own transaction. and there thing: savechanges call in logstore method trigger logging itself, you'd end starting infin...
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s...
Read more