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 >>>>> >>>>> >>>> >>> >> >