Hi ! just started and logged onto the machine (bitch) I have hitherto ignored an secturity alert message that popps up when restarting and logging on first time som "SELinux Altert Browser" which informs me that process: httpd has attempted this access: execute on this file libmimodbc.so what this "security" amounts to I dont know but the "utility" it gives me three options: 1. If you want to fix the lable /opt........so (what label, this i a file not a label...) default label (what label ?) should be lib_t 2. If you wnat to allow httpd to have access then there is possibility to click one of these choices to light up and make readable the suggested action: you need to change the label on /opt/.....so (what darn label... again?) #semanage fcontext -a -t File_type '/opt....so' where File_type is one of : (then follows a huge dump of choices, among which is lib_t ) -- I did this supplying lib_t think, think, think a long time, silent return, so the action should be happy, NO DIFFERNCE, same error log Isnt security wondefful. It really sees to that noone can achive nothing. /georg ----- Original Message ----- From: Serge Fonville To: georg ; PHP Mailinglist Sent: Sunday, May 19, 2013 2:35 PM Subject: Re: ODBC 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 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/** 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> 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> > -- 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
