I have been trying for about 30 hours to get DB2 Express running on an AWS Linux Ubuntu instance. I have it running on my Macbook well, and am able to do work there, but would like to use this in a true server.
I have uninstalled and reinstalled several times and keep running into the same problem:
Here is a general history of what I have done:
When running python connectivity code using SQL Alchemy I get this:
According to the IBM knowledgecenter:
One must execute db2rfe in order get past this.
Reading the instructions there, db2rfe should be executed as root after manipulating the configuration file in a certain way.
I change ENABLE_OS_AUTHENTICATION to YES:
ENABLE_OS_AUTHENTICATION=YES
After successfully executing:
I attempt to run looking at this:
I execute:
This is an AWS Ubuntu instance:
So, as the other questioner posted, / is not mounted in 'nosuid' mode. However, I am NOT doing a Root install, as the answerer to one of the questions said above.
Jan 19, 2018 - speedconnect internet accelerator 8.0 activation key free. SpeedConnect Internet Accelerator key will optimize Windows IP/TCP settings. For Windows® 10, 8, 7,Vista,XP. SpeedConnect Internet Accelerator is a Windows application designed to optimize and speed up your network connection. Speedconnect internet accelerator 8 0 with activator. Dec 24, 2015 - Free SpeedConnect Internet Accelerator v8.0 Crack full version. SpeedConnect Internet Accelerator 8.0 activation key is helpful to make your.
This computer is an AWS Ubuntu 12.04 install:
Additional Notes:
I had to change the hashing algorithm on this machine to use 256 bytes because of the weird DB2 length limitation. I've gotten past a lot of hurdles and this appears to be the last step.
I CAN change the permission on db2start to seeming get past this problem and make it owned by root, but then it says I am not allowed to run as root.
Here is an attempt to rephrase my catch-22 informally:
After swooping majestically for numerous mins deployed the parachute and dropped smack in the middle of a navy base. Climbed the highest peak in the sport and jumped off within the path of the brightest lights below. Sometimes flammable structures into each other, concocting colossal fireballs.However, the greatest new addition is the wingsuit, which lets in Rico to fly huge distances and gives a chicken’s eye view of merry destruction. Just cause 3 free download.
I cannot enable OS Authentication without running db2rfe. When I run
db2rfe , to enable OS Authentication,
Dying light the following mods. I can't restart the server because of a permissions problem, but the error message does not seem to match the condition.
Note that I would be happy to use client-side authentication or any other kind of authentication in this case -- this is not production code, is something being set up purely as a demonstration.
Any help you can provide would be greatly appreciated.
Community♦
keruilinkeruilin
4,5802727 gold badges8585 silver badges167167 bronze badges
1 Answer
From your description it looks like you may be mixing ups steps of root and non-root installation of DB2.
In a non-root installation all DB2 binaries and other files are installed in the home directory of the user performing the install. Certain tasks still require root privileges, this is where you run
db2rfe . Non-root installations have many limitations though, so you should only choose it if you have no other alternative.
A root installation copies binaries under
/opt and creates a DB2 instance in the home directory of the instance owner user that you specify during installation. From there symlinks are created to the actual binaries.
Root installation is not less secure than non-root, may be it's even more secure as the binaries are owned by root.
Console vs. GUI installation has no relation to root vs. non-root. In the past mustacciomustaccio
db2setup was used for GUI-based installations while db2_install for console installations. However, db2_install is now deprecated; to perform a console installation use a response file option (db2setup -r <response file name> ) as explained in the manual.
14.8k88 gold badges4040 silver badges4444 bronze badges
Db2 Express-c Instal In Ubuntu 16 4
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Not the answer you're looking for? Browse other questions tagged linuxubuntuamazon-web-servicesdb2 or ask your own question.
PORTLAND, Ore. -- Canonical, the company behind Ubuntu, has always had many user and developer fans. Enterprise business fans? Not so much. Canonical hopes to change that with today's, July 21, launch of a virtual appliance of IBM's DB2 Express-C software running on the Ubuntu cloud computing platform, in private and public cloud configurations. The company also announced that IBM has validated the full version of DB2 software on Ubuntu 10.04.
This is all part of Canonical's plan to make Ubuntu just as much of an enterprise business player as Novell or Red Hat. Quietly Ubuntu has already, according to the company, 'become one of the most popular guest operating systems on cloud services like Rackspace and Amazon EC2. Increasingly, it is also being deployed as the host cloud infrastructure layer by private organizations and ISPs. IBM DB2 Express-C software will be available however Ubuntu is deployed on a cloud.'
If you don't trust the public clouds, you can use Ubuntu Enterprise Cloud. This combines Ubuntu 10.04 with the open-source Eucalyptus cloud software so creating your own cloud requires little more than plugging in USB-sticks and running installation routines on your existing servers.
DB2 Express-C is IBM's free community edition of DB2 software. Small businesses and multi-branch companies, as well as developers, can use it as their DBMS (database management system) platform. It has all of DB2's core features and can be used to power in-house DBMS applications, Web 2.0 and SOA-based solutions. What you can't do with it is use it to handle a large business' DBMS demands. You can, if it works for you, scale up from it to one of IBM's other DB2 products and run that on Ubuntu 10.04.
'A virtual cloud appliance consisting of Ubuntu and DB2 Express-C will enable customers to quickly and easily set up DB2 in both public and private cloud situations. The full commercial support of DB2 running on Ubuntu and physical servers is also attractive to customers as a protection to their investment.' Neil Levine, VP of Commercial Services at Canonical told me at OSCon
Levine said, 'We wanted to make DB2 on Ubuntu Linux available for developers and SMBs. At the same time, we wanted to give large companies a way to get a taste of our low cost way to try Ubuntu and DB2 on public cloud. If you want to try it, you can.' Then, if you like it, you can use a more powerful DB2/Ubuntu stack on either a public or private crowd, 'using the same tools and architecture that you're already using. There's no need to re-architect it.'
In a statement, Robert S. Sutor, IBM's VP of Open Source and Linux said, 'Customers are quickly adopting DB2 software on Linux for both on-premise and cloud computing deployments. The combination of Ubuntu and DB2 provides users with a highly integrated and tested virtual cloud appliance'
The real key to Ubuntu's offering, according to Levine, is that Canonical is trying to make using Ubuntu and a serious DBMS like DB2 as easy to use on a cloud as using Ubuntu already is on the desktop. If anyone can make cloud computing easy for any business to use, I'm betting on Canonical. Their track-record with Ubuntu speaks for itself.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |