Greetings.

I have not found much in google searches regarding this subject, so I believe I am not forming the query properly, thus this posting. This may be a bit long, but I figure more initial information is better than less.

Is it possible to have 'make install' update the rpm database so that 'rpm -qa' sees the software I have just compiled?

Here is why:
I am running a CentOS 6.5 server in a virtual machine. My company will soon be transitioning from Azure to Google App Engine. Thus I need to be able to access a M$ database and MySQL from the same codebase, which will reside on this CentOS VM. I suppose I could create an api on the M$ server for communication with the Azure DB, but that could get messy. I found instruction that msodbcsql makes this possible, which requires unixODBC 2.3. I have not found an rpm of unixODBC 2.3, so I ran './configure; make; make install' and that appears to have succeeded, but rpm -qa does not see it and nor does the msodbcsql install script. Does anyone have any insight in this situation?

Cheers,
danilo

Software not packaged as RPM by default is outside of the scope of the RPMBD. It makes no sense quality assurance-wise to even think it should be otherwise.
If RPMForge or EPEL don't have the package for CentOS then wget unixODBC-2.3.1-7.fc20.src.rpm to your staging host, build as unprivileged user and test.

Can you be a bit more descriptive? Most of my experience is solely for web purposes, so building packages is definitely something new. Does 'staging host' mean the host OS?

I think by 'staging host' he means the system that you use to build, test and manage packages. This might be a separate machine, a VM or the system you are installing to depending on your own usage.

I am not an RPM user since about 2005 so I won't give any (possibly wrong) advice, but you will find a guide for building from src.rpm on CentOS here.

Instead of compiling; make it an RPM. Then it would be in the RPMDB

NO
the autotools "make" has NO concept of rpm nor deb

if you NEED a rpm from the source code than install and use
rpm build

it will have slightly different names depending on your OS
a quick google
-- looks ok so.....
http://www.cyberciti.biz/faq/setting...fedora-centos/

the Fedora wiki( a GOOD page to READ)
https://fedoraproject.org/wiki/How_t...ngPackageHowTo

and
http://docs.fedoraproject.org/en-US/...h08s02s04.html

VERY GOOD reading for using "rpmbuild" ( VERY old but good )
because "you need to create rpmbuild directory"
http://fedoranews.org/tchung/rpmbuild/

Indeed with "staging host" I meant a workstation, VM or any suitable and prepped non-production machine. Should you, after having read the documentation, have any specific questions about building packages let us know. There's a few people here who know the package building process from experience.

Packages, unixODBC-2.3.2-2.el6.<arch>.rpm :

x86_64 https://drive.google.com/file/d/0B7S...it?usp=sharing

i686 https://drive.google.com/file/d/0B7S...it?usp=sharing

Source SRPMS : unixODBC-2.3.2-2.fc20.src.rpm

-

1 members found this post helpful.

While the output of 'rpm -qp --scripts --triggers --dump unixODBC-2.3.2-2.el6.i686.rpm' looks sane, there is no GnuPG key to verify the integrity of these builds. If you built these yourself (I see a build date not too long ago) then thank you, but please first 'rpmbuild -k' them. Without a description of who built these, for what platform and supplying a key packages shouldn't be shared in this way. If we don't set an example and teach users sane admin practices they might think this practice is acceptable, and that should be avoided at all cost.

*An alternative could be to just share a .spec or a .src.rpm package so anyone is forced to build the package themselves.

1 members found this post helpful.

# 9 .

Thank you.

The packages were built this morning from unixODBC-2.3.2-2.fc20.src.rpm
http://dl.fedoraproject.org/pub/fedo...2.fc20.src.rpm

No issues, the default unixODBC.spec was used.

-

Thank you, everyone, for your assistance and information. I will write back with my results.

Ok, all of that seemed to work. What php functions do I call? I looked through a list of get_defined_functions(). There does not appear to be any function names containing 'odbc'. Should I be looking for something else?

Well maybe you should send knudfl your thanks then...


Other topic. Post those questions in the /Programming forum please.

Thank you, lads. Much appreciated. I will do that.

Danilo

It appears not to have been successful. PDO::getAvailableDrivers() does not list anything for mssql nor odbc (only dblib & mysql). Have any of you successfully done this?