Re: [VuFind-Tech] Error: Unknown MySQL server host

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

That format should work with the patch I created.

- Demian

From: Brad Busenius [mailto:bbu...@uc...]
Sent: Monday, August 26, 2013 3:22 PM
To: vuf...@li...
Subject: Re: [VuFind-Tech] Error: Unknown MySQL server host

Hi Demian,

Thanks for helping us with this. Sean's applying the patch right now, however, in the meantime can I ask if we're writing our configuration correctly in the ini file. We have: database = mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE<mailto:mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE>

We appreciate your time.

Brad

On 8/26/13 1:46 PM, Demian Katz wrote:
Could you try applying the attached patch and let me know if it helps?  This should pass the port number through to Zend Framework more appropriately...  however, on my test system, when I give it a bad port number, it still works, so I'm a little concerned that something still isn't quite right.

- Demian

From: Sean F [mailto:str...@ya...]
Sent: Monday, August 26, 2013 1:59 PM
To: Demian Katz; vuFind techList
Subject: Re: [VuFind-Tech] Error: Unknown MySQL server host

Hi Demian,

I used this script to connect to database and it's connecting. I think my problem that in config.ini file on line   database = mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE<mailto:mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE>
I don't specify port number in correct order.

?php
// Create connection
$con=mysqli_connect("127.0.0.1","userName","password","database","3307");
// Check connection if (mysqli_connect_errno($con))
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
?>

What's correct way to give vuFind port number to connect to?

Thank you

________________________________
From: Demian Katz <dem...@vi...><mailto:dem...@vi...>
To: Sean F <str...@ya...><mailto:str...@ya...>; vuFind techList <vuf...@li...><mailto:vuf...@li...>
Sent: Friday, August 23, 2013 6:13 AM
Subject: RE: [VuFind-Tech] Error: Unknown MySQL server host

Does it make a difference if you change 127.0.0.1 to localhost?

Have you tried writing a stand-alone PHP script to connect to the database using mysqli_connect, just to see if the problem is PHP-specific or Framework-related?  If mysqli_connect fails, it might also be interested to see if mysql_connect behaves differently, in case it's a problem with your build of the mysqli component.

- Demian
________________________________
From: Sean F [str...@ya...<mailto:str...@ya...>]
Sent: Thursday, August 22, 2013 4:45 PM
To: vuFind techList
Subject: [VuFind-Tech] Error: Unknown MySQL server host
I'm installing vufind on redhat and I have next error in error log when I click 'Search' button.

PHP Fatal error: Uncaught exception 'Zend\\Db\\Adapter\\Exception\\ErrorException' with message 'Unknown MySQL server host '127.0.0.1:3307' (3)' in /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Mysqli/Connection.php:209\nStack trace:\n#0 /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Mysqli/Mysqli.php(205): Zend\\Db\\Adapter\\Driver\\Mysqli\\Connection->connect()\n#1 /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/Sql/Sql.php(120): Zend\\Db\\Adapter\\Driver\\Mysqli\\Mysqli->createStatement()\n#2 /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(406): Zend\\Db\\Sql\\Sql->prepareStatementForSqlObject(Object(Zend\\Db\\Sql\\Delete))\n#3 /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(376): Zend\\Db\\TableGateway\\AbstractTableGateway->executeDelete(Object(Zend\\Db\\Sql\\Delete))\n#4 /vufind/vufind/module/VuFind/src/VuFind/Db/Table/Search.php(60): Zend\\Db\\TableGateway\\ in /vufind/vufind/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Mysqli/Connection.php on line 206, referer: http://vufindstage01.uchicago.edu/vufind/Search/Results?lookfor=&type=AllFields&submit=Search&limit=60&sort=relevance

My database configuration in config.ini file

[Database]
database = mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE<mailto:mysql://USER_NAME:PASSWORD@127.0.0.1:3307/DATABASE>

We use stunnel to connect to database and I can access database via stunnel by mysql client.
Has anyone seen this error before or knows how to fix it?

Thank you in advance

------------------------------------------------------------------------------

Introducing Performance Central, a new site from SourceForge and

AppDynamics. Performance Central is your source for news, insights,

analysis and resources for efficient Application Performance Management.

Visit us today!

http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk

_______________________________________________

Vufind-tech mailing list

Vuf...@li...<mailto:Vuf...@li...>

https://lists.sourceforge.net/lists/listinfo/vufind-tech