LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 12-30-2013, 03:23 PM   #1
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Rep: Reputation: Disabled
make install update rpm database


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
 
Old 12-30-2013, 03:41 PM   #2
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,285
Blog Entries: 54

Rep: Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854
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.
 
Old 12-30-2013, 04:10 PM   #3
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
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?
 
Old 12-30-2013, 05:38 PM   #4
astrogeek
Senior Member
 
Registered: Oct 2008
Distribution: Slackware: 12.1, 13.1, 14.1, 64-14.1, -current, FreeBSD-10
Posts: 1,862

Rep: Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635Reputation: 635
Quote:
Originally Posted by thirdshiftguy View Post
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.

Last edited by astrogeek; 12-30-2013 at 05:40 PM.
 
Old 12-30-2013, 05:43 PM   #5
custangro
Senior Member
 
Registered: Nov 2006
Location: California
Distribution: Fedora , CentOS , Solaris 10, RHEL
Posts: 1,935
Blog Entries: 1

Rep: Reputation: 188Reputation: 188
Quote:
Originally Posted by thirdshiftguy View Post
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
Instead of compiling; make it an RPM. Then it would be in the RPMDB
 
Old 12-30-2013, 07:50 PM   #6
John VV
Guru
 
Registered: Aug 2005
Posts: 12,906

Rep: Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715Reputation: 1715
Quote:
s it possible to have 'make install' update the rpm database
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/

Last edited by John VV; 12-30-2013 at 07:53 PM.
 
Old 12-31-2013, 02:23 AM   #7
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,285
Blog Entries: 54

Rep: Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854
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.
 
Old 12-31-2013, 03:30 AM   #8
knudfl
LQ 5k Club
 
Registered: Jan 2008
Location: Copenhagen, DK
Distribution: pclos2014, Slack14.1 DebWheezy, +50+ other Linux OS, for test only.
Posts: 13,640

Rep: Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531
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.
Old 12-31-2013, 03:55 AM   #9
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,285
Blog Entries: 54

Rep: Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854
Quote:
Originally Posted by knudfl View Post
Packages, unixODBC-2.3.2-2.el6.<arch>.rpm
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.

Last edited by unSpawn; 12-31-2013 at 04:01 AM. Reason: //More *is* more
 
1 members found this post helpful.
Old 12-31-2013, 06:09 AM   #10
knudfl
LQ 5k Club
 
Registered: Jan 2008
Location: Copenhagen, DK
Distribution: pclos2014, Slack14.1 DebWheezy, +50+ other Linux OS, for test only.
Posts: 13,640

Rep: Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531Reputation: 2531
# 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.

-
 
Old 12-31-2013, 09:54 AM   #11
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
Thank you, everyone, for your assistance and information. I will write back with my results.
 
Old 12-31-2013, 01:33 PM   #12
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
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?
 
Old 12-31-2013, 01:59 PM   #13
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,285
Blog Entries: 54

Rep: Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854Reputation: 2854
Quote:
Originally Posted by thirdshiftguy View Post
Ok, all of that seemed to work.
Well maybe you should send knudfl your thanks then...


Quote:
Originally Posted by thirdshiftguy View Post
What php functions do I call? I looked through a list of get_defined_functions().
Other topic. Post those questions in the /Programming forum please.
 
Old 12-31-2013, 02:11 PM   #14
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
Thank you, lads. Much appreciated. I will do that.

Danilo
 
Old 01-02-2014, 10:43 AM   #15
thirdshiftguy
LQ Newbie
 
Registered: Jan 2012
Posts: 10

Original Poster
Rep: Reputation: Disabled
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?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
update rpm database dthaler Linux - Enterprise 2 04-20-2012 04:30 AM
RPM's or ./configure-make-make install? i_suck_at_linux General 8 12-11-2005 02:02 PM
rpm database type and utility like windows update services kamii47 Linux - General 8 04-18-2005 07:09 AM
Do PHP can make a user base update web site whitout Database? explorer1979 Programming 3 01-05-2005 09:52 AM
Fedora FC2 Arch= x86_64 install leaves duplicate packages in RPM database w8hrq Fedora - Installation 2 10-05-2004 01:14 PM


All times are GMT -5. The time now is 11:15 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration