Re: ODBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hmm, I just noticed GMAIL no longer replies to all, so here is all my
correspondence that wasn't sent to the list.

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table


2013/5/19 Serge Fonville <serge.fonville@xxxxxxxxx>

> damn, other way around
> su --shell=/bin/bash - apache
>
> Kind regards/met vriendelijke groet,
>
> Serge Fonville
>
> http://www.sergefonville.nl
>
> Convince Microsoft!
> They need to add TRUNCATE PARTITION in SQL Server
>
> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table
>
>
> 2013/5/19 Serge Fonville <serge.fonville@xxxxxxxxx>
>
>> since your root you can su apache --shell /bin/bash
>> from theron you can do the same tests
>>
>> Kind regards/met vriendelijke groet,
>>
>> Serge Fonville
>>
>> http://www.sergefonville.nl
>>
>> Convince Microsoft!
>> They need to add TRUNCATE PARTITION in SQL Server
>>
>> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table
>>
>>
>> 2013/5/19 georg <georg.chambert@xxxxxxxxx>
>>
>>> As I said, Im a bit new to Linux, and the "user" and "access" system
>>> seem to me a bit xxxx.
>>>
>>> I dont reallly know what user apache runs as, possibly this process
>>> status give something ?
>>> (seem to be 8 processes, but what the user be "apache" ?
>>>
>>> i have accessed php directly, when su root;
>>>
>>> #php -r 'odbc_connect()';
>>>
>>> give only silece, which i interprete that php actually successfully
>>> opens the db ?
>>>
>>>
>>>
>>> [root@this ge]# ps aux|grep httpd
>>>
>>> root 1377 0.0 0.7 28900 7804 ? Ss 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1378 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1379 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1380 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1381 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1382 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1383 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1384 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> apache 1385 0.0 0.4 29032 4164 ? S 10:50 0:00 /usr/sbin/httpd -k start
>>>
>>> root 1387 0.0 0.0 4760 788 pts/0 S+ 10:51 0:00 grep --color=au
>>>
>>>
>>>
>>> does this mean that the user is "apache" ?, and then what would that
>>> user have as login password?
>>>
>>>
>>>
>>> tnx
>>> georg
>>>
>>>
>>> ----- Original Message ----- From: "Serge Fonville" <
>>> serge.fonville@xxxxxxxxx>
>>> To: "georg" <georg.chambert@xxxxxxxxx>
>>> Cc: "PHP Mailinglist" <php-general@xxxxxxxxxxxxx>
>>> Sent: Sunday, May 19, 2013 1:42 PM
>>> Subject: Re:  ODBC
>>>
>>>
>>>  could you su to the user apache runs as (possibly specifying the shell
>>>> to
>>>> use) and navigate to the directory?
>>>>
>>>> Kind regards/met vriendelijke groet,
>>>>
>>>> Serge Fonville
>>>>
>>>> http://www.sergefonville.nl
>>>>
>>>> Convince Microsoft!
>>>> They need to add TRUNCATE PARTITION in SQL Server
>>>> https://connect.microsoft.com/**SQLServer/feedback/details/**
>>>> 417926/truncate-partition-of-**partitioned-table<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table>
>>>>
>>>>
>>>> 2013/5/19 georg <georg.chambert@xxxxxxxxx>
>>>>
>>>>  Hi Serge,
>>>>> compliled some more info
>>>>>
>>>>> Apache error log as:
>>>>> ---
>>>>> [Tue May 14 17:45:11 2013] [error] [client 127.0.0.1] PHP Warning:
>>>>> odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib
>>>>> '/lib/libmimodbc.so' : file not found, SQL state 01000 in SQLConnect in
>>>>> /var/www/html/my2.php on line 19, referer: http://127.0.0.1/
>>>>> ----
>>>>> File that is deemed missing:
>>>>> ---
>>>>> [root@this ge]# ls -alF /lib/libmimodbc.so
>>>>> lrwxrwxrwx. 1 root root 39 Apr 29 22:21 /lib/libmimodbc.so ->
>>>>> /opt/MimerSQL-10.0.6J/lib/****libmimodbc.so*
>>>>>
>>>>>
>>>>> --- and since this seem to be a link rather than the file (for some
>>>>> reason, think I actually moved lib there....---
>>>>>
>>>>> [root@this ge]# ls -alF /opt
>>>>> total 12
>>>>> drwxr-xr-x. 3 root root 4096 Apr 29 22:20 ./
>>>>> dr-xr-xr-x. 18 root root 4096 May 16 19:15 ../
>>>>> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 MimerSQL-10.0.6J/
>>>>> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/
>>>>> total 40
>>>>> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 ./
>>>>> drwxr-xr-x. 3 root root 4096 Apr 29 22:20 ../
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 bin/
>>>>> drwxr-xr-x. 8 root root 4096 Apr 29 22:20 DbVisualizer/
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 doc/
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 examples/
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 include/
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 lib/
>>>>> drwxr-xr-x. 5 root root 4096 Dec 21 2011 man/
>>>>> drwxr-xr-x. 2 root root 4096 Apr 29 22:21 misc/
>>>>> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/lib
>>>>> total 12516
>>>>> drwxr-xr-x. 2 root root 4096 Dec 21 2011 ./
>>>>> drwxr-xr-x. 10 root root 4096 Apr 29 22:20 ../
>>>>> -rwxr-xr-x. 1 root root 515740 Dec 20 2011 compat.a*
>>>>> -rwxr-xr-x. 1 root root 1051162 Dec 20 2011 libmimcomm.so*
>>>>> -rwxr-xr-x. 1 root root 1346488 Dec 20 2011 libmimdbi.so*
>>>>> -rwxr-xr-x. 1 root root 5397415 Dec 20 2011 libmimdbs.so*
>>>>> -rwxr-xr-x. 1 root root 1922776 Dec 20 2011 libmimer.so*
>>>>> -rwxr-xr-x. 1 root root 6416 Dec 20 2011 libmimerS.so*
>>>>> -r-xr-xr-x. 1 root root 1693640 Dec 20 2011 libmimodbc.so*
>>>>> -rwxr-xr-x. 1 root root 507386 Dec 20 2011 libqsqlmimer.so*
>>>>> -rwxr-xr-x. 1 root root 136312 Dec 20 2011 mimjdbc3.jar*
>>>>> -rwxr-xr-x. 1 root root 1252 Dec 20 2011 mimsqlxa.o*
>>>>> -rwxr-xr-x. 1 root root 212423 Dec 20 2011 psmdebug.jar*
>>>>> [root@this ge]# ls -alF /opt/MimerSQL-10.0.6J/lib/****libmimodbc.so
>>>>> -r-xr-xr-x. 1 root root 1693640 Dec 20 2011
>>>>> /opt/MimerSQL-10.0.6J/lib/**
>>>>>
>>>>> libmimodbc.so*
>>>>> [root@this ge]#
>>>>>
>>>>> ---- so that seem to be in place ?? --
>>>>>
>>>>> Tnx
>>>>> Georg
>>>>>
>>>>>
>>>>> ----- Original Message ----- From: Serge Fonville
>>>>>
>>>>> To: georg
>>>>> Cc: Negin Nickparsa ; PHP Mailinglist
>>>>> Sent: Sunday, May 19, 2013 12:45 PM
>>>>>
>>>>> Subject: Re:  ODBC
>>>>>
>>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>> I'm not really clear on what you have and haven't done, but did you
>>>>> check
>>>>> permissions?
>>>>>
>>>>>
>>>>> HTH
>>>>>
>>>>>
>>>>>
>>>>> Kind regards/met vriendelijke groet,
>>>>>
>>>>>
>>>>> Serge Fonville
>>>>>
>>>>>
>>>>> http://www.sergefonville.nl
>>>>>
>>>>> Convince Microsoft!
>>>>> They need to add TRUNCATE PARTITION in SQL Server
>>>>> https://connect.microsoft.com/****SQLServer/feedback/details/****<https://connect.microsoft.com/**SQLServer/feedback/details/**>
>>>>> 417926/truncate-partition-of-****partitioned-table<https://**
>>>>> connect.microsoft.com/**SQLServer/feedback/details/**
>>>>> 417926/truncate-partition-of-**partitioned-table<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table>
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 2013/5/19 georg <georg.chambert@xxxxxxxxx>
>>>>>
>>>>> Hi Negin, tnx for advice,
>>>>>
>>>>> now however I have successfully downloaded and installed ODBC and
>>>>> the things needed to connect PHP-ODBC (yum on the same actually)
>>>>>
>>>>> however, the llinked library file that the odbcinit.ini file points to
>>>>> in
>>>>> order to
>>>>> link the libmimodbc.so library is not found, though the file is
>>>>> obviously
>>>>> at that location
>>>>>
>>>>> (apache error_log contains a complaint file not found )
>>>>>
>>>>> so Im still not through completely
>>>>>
>>>>> /g
>>>>> ----- Original Message ----- From: "Negin Nickparsa" <
>>>>> nickparsa@xxxxxxxxx>
>>>>> To: "georg" <georg.chambert@xxxxxxxxx>
>>>>> Cc: "David OBrien" <dgobrien@xxxxxxxxx>; "PHP General" <
>>>>> php-general@xxxxxxxxxxxxx>
>>>>> Sent: Saturday, May 18, 2013 7:56 PM
>>>>>
>>>>> Subject: Re:  ODBC
>>>>>
>>>>>
>>>>>
>>>>> do you have the driver in linux?
>>>>> https://www.microsoft.com/en-****us/download/details.aspx?id=****28160<https://www.microsoft.com/en-**us/download/details.aspx?id=**28160>
>>>>> <https://www.microsoft.**com/en-us/download/details.**aspx?id=28160<https://www.microsoft.com/en-us/download/details.aspx?id=28160>
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Tue, May 7, 2013 at 11:46 AM, georg <georg.chambert@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>
>>>>> but isnt there some yum command that will fix things for me (download
>>>>> if
>>>>> necessary, but I actually think
>>>>> the ODBC would be in the distribution of fedora ?)
>>>>>
>>>>> br georg
>>>>>
>>>>> ----- Original Message ----- From: "David OBrien" <dgobrien@xxxxxxxxx>
>>>>> To: "georg" <georg.chambert@xxxxxxxxx>
>>>>> Cc: "PHP General" <php-general@xxxxxxxxxxxxx>
>>>>> Sent: Monday, May 06, 2013 11:06 PM
>>>>> Subject: Re:  ODBC
>>>>>
>>>>>
>>>>>
>>>>> On Mon, May 6, 2013 at 3:32 PM, georg <georg.chambert@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>>
>>>>> Id like to get ODBC connection to SQL from PHP going. Ive done that on
>>>>> XP,
>>>>> but now Im switching
>>>>> to Linux (Fedora).
>>>>>
>>>>> My impression in that the connecting part is per the DB designers
>>>>> responsibility. Im using Mimer-SQL,
>>>>> but cant find any information on how to set up ODBC for that. Any
>>>>> advice
>>>>> welcome.
>>>>>
>>>>> BR georg
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> http://developer.mimer.com/******howto/howto_57.htm<http://developer.mimer.com/****howto/howto_57.htm>
>>>>> <http://**developer.mimer.com/**howto/**howto_57.htm<http://developer.mimer.com/**howto/howto_57.htm>
>>>>> >
>>>>> <http://**developer.mimer.com/**howto/**howto_57.htm<http://developer.mimer.com/howto/**howto_57.htm>
>>>>> <http://**developer.mimer.com/howto/**howto_57.htm<http://developer.mimer.com/howto/howto_57.htm>
>>>>> >
>>>>>
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> PHP General Mailing List (http://www.php.net/)
>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> PHP General Mailing List (http://www.php.net/)
>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>
>>>>>
>>>>
>>>
>>
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux