osx - Installing PDO-drivers for PostgreSQL on Mac (using Zend for eclipse) -

-

how can pdo work on mac (os x 10.5)? i'm using built in php , php in zend/eclipse. can't seem find useful drivers @ all.

i had install pdo_pgsql driver on leopard, , ran across multitude of problems. in search answers, stumbled across question. have installed, , so, though question quite old, hope i've found can others (like myself) undoubtedly run similar problems.

the first thing you'll need install pear, if haven't done already, since doesn't come installed on leopard default.

once that, use pecl installer download pdo_pgsql package:

$ pecl download pdo_pgsql $ tar xzf pdo_pgsql-1.0.2.tgz

(note: may have run pecl superuser, i.e. sudo pecl.)

after that, since pecl installer can't install extension directly, you'll need build , install yourself:

$ cd pdo_pgsql-1.0.2 $ phpize $ ./configure --with-pdo-pgsql=/path/to/your/postgresql/installation $ make && sudo make install

if goes well, should have file called "pdo_pgsql.so" sitting in directory should "/usr/lib/php/extensions/no-debug-non-zts-20060613/" (the pecl installation should have outputted directory installed extension to).

to finalize installation, you'll need edit php.ini file. find section labeled "dynamic extensions", , underneath list of (probably commented out) extensions, add line:

extension=pdo_pgsql.so

now, assuming first time you've installed php extensions, there 2 additional steps need take in order working. first, in php.ini, find extension_dir directive (under "paths , directories"), , change directory pdo_pgsql.so file installed in. example, extension_dir directive looks like:

extension_dir = "/usr/lib/php/extensions/no-debug-non-zts-20060613"

the second step, if you're on 64-bit intel mac, involves making apache run in 32-bit mode. (if there's better strategy, i'd know, now, best find.) in order this, edit property list file located @ /system/library/launchdaemons/org.apache.httpd.plist. find these 2 lines:

<key>programarguments</key> <array>

under them, add these 3 lines:

<string>arch</string> <string>-arch</string> <string>i386</string>

now, restart apache, , pdo_pgsql , running.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more