LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 02-14-2012, 08:06 AM   #1
rajnikhil
LQ Newbie
 
Registered: Jan 2011
Posts: 10

Rep: Reputation: 0
Open source logistics software


I'm looking for an open source logistics software for my company and after some searching I've come across 3 apparently viable softwares i.e. Overactive, OSLA and Venture Logistics. These softwares however don't have much written about them on the net pertaining to their installation and usage.

If any of you could guide me with the installation and usage of Overactive and OSLA I'd be really grateful.

I'm going to install and test it on Ubuntu 10.04

Thanks in advance!!!
 
Old 02-14-2012, 11:46 PM   #2
sag47
Senior Member
 
Registered: Sep 2009
Location: Philly, PA
Distribution: Kubuntu x64, RHEL, Fedora Core, FreeBSD, Windows x64
Posts: 1,328
Blog Entries: 33

Rep: Reputation: 329Reputation: 329Reputation: 329Reputation: 329
Overactive
  1. Download the latest overactive core.
  2. Extract the archive
  3. Read the README file for installation steps and software requirements.

That should be it. It's pretty straight forward and you deploy the ear file in JBoss. Personally I would not use alpha software for anything personal let alone for a company. As far as usage you'll have to figure it out as I've never used it.

OSLA
OSLA is pretty straight forward to install as well if you understand web technologies. After downloading OSLA do the following.
  1. Create a MySQL user
  2. Create a MySQL database called "osla" and give the MySQL user full permissions on the database.
  3. Import the mysqldump.sql file into MySQL.
  4. Install and configure Apache.
  5. Move all of the files to /var/www/html which is the "install".
  6. Edit db.inc file with settings for your mysql user, password, and database.
  7. Visit the server at it's website.

You just need to download the packages and read them a bit. Most open source packages come with readme instructions as part of the package. You should have prior knowledge of Apache (OSLA), JBoss (Overactive), MySQL, and how to deploy the web files. If not don't sweat just google topics for them as there's tons of material on the net.

Hope that helps,
SAM

Last edited by sag47; 02-15-2012 at 12:03 AM.
 
Old 02-16-2012, 08:26 AM   #3
rajnikhil
LQ Newbie
 
Registered: Jan 2011
Posts: 10

Original Poster
Rep: Reputation: 0
Thanks sag47, I tried getting the OSLA working. I granted all the permissions to the mysql user, created a database "osla" and imported the database dump to the newly created "osla" database form the mysqldump.sql and then extracted the zip file in /var/www/ (no /html as I have no such folder) and updated the username, password and database name in the db.nic in the extracted file. I then accessed the setup by typing http://localhost/osla. I got the log-in page but when I type the mysql username and password and hit enter/login button I return back to the same login page.

Can you help me out here!

Thanks in advance.
 
Old 02-16-2012, 08:42 AM   #4
sag47
Senior Member
 
Registered: Sep 2009
Location: Philly, PA
Distribution: Kubuntu x64, RHEL, Fedora Core, FreeBSD, Windows x64
Posts: 1,328
Blog Entries: 33

Rep: Reputation: 329Reputation: 329Reputation: 329Reputation: 329
When dealing with web technologies the credentials for logging into a web interface aren't usually the same or even close to the database user/password. In the case of this php application it is likely that it is authenticating against the MySQL database since you didn't have to set up LDAP or anything. That being the case you would check the mysqldump.sql file for the username and password you should use on the first run. Now review the following statement I found.

Code:
--
-- Table structure for table 'loginaccount'
--

DROP TABLE IF EXISTS loginaccount;
CREATE TABLE loginaccount (
  id int(11) NOT NULL auto_increment,
  lastinsert datetime default '0000-00-00 00:00:00',
  lastupdate datetime default '0000-00-00 00:00:00',
  username varchar(64) NOT NULL default '',
  password varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY username (username)
) TYPE=MyISAM;

--
-- Dumping data for table 'loginaccount'
--


INSERT INTO loginaccount VALUES (1,'0000-00-00 00:00:00','2005-05-10 21:46:49','admin','');
Or more importantly...

Code:
INSERT INTO loginaccount VALUES (1,'0000-00-00 00:00:00','2005-05-10 21:46:49','admin','');
That means the username is admin and the password is blank. So try that.
 
Old 02-17-2012, 07:26 AM   #5
rajnikhil
LQ Newbie
 
Registered: Jan 2011
Posts: 10

Original Poster
Rep: Reputation: 0
Unhappy

No change, it still keeps returning to the login page whether I use the mysql username and password or admin and leave password blank. The part of the code you posted in thread looks the same in mysqldump.sql in my system. I also updated the username and blank password to mysql username and password in mysqldump.sql before doing restoring the osla database using using mysqldump.sql and still no change :-(
 
Old 12-27-2012, 11:46 AM   #6
btesec
LQ Newbie
 
Registered: Dec 2012
Posts: 1

Rep: Reputation: Disabled
Hello Everyone,

Has anybody managed to successfully install and run Overactive Logistics.

Please let me know, I am kind of struglling with it.

Any help or comment is appreciated.

Thanks,

btesec
 
Old 12-31-2012, 09:58 AM   #7
sag47
Senior Member
 
Registered: Sep 2009
Location: Philly, PA
Distribution: Kubuntu x64, RHEL, Fedora Core, FreeBSD, Windows x64
Posts: 1,328
Blog Entries: 33

Rep: Reputation: 329Reputation: 329Reputation: 329Reputation: 329
In the bottom mysql line of this post give the admin user a password. Apart from that, I'd suggest enabling more verbose logging in attempt to figure out what is going on.

Example,
Code:
INSERT INTO loginaccount VALUES (1,'0000-00-00 00:00:00','2005-05-10 21:46:49','admin','admin');
Change the mysql.dmp file and import it again. Now use the username admin and password admin to log in. If you require more assistance you'll need to post the logs of the web servers so we can figure out what is going wrong. Do not change the username because the application likely depends on there being an admin user.

Again, as I said before the use of alpha software in a production environment is not recommended.

Last edited by sag47; 12-31-2012 at 10:02 AM.
 
  


Reply

Tags
install, installation, open source, software, ubuntu


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distinguish between freeware, shareware, open source software and closed source ... turbomen Linux - Newbie 1 11-16-2010 02:49 AM
LXer: Red Hat to set up open-source software store: source LXer Syndicated Linux News 0 03-09-2007 02:16 PM
LXer: Libraries facilitate open access to information with open source software LXer Syndicated Linux News 0 01-23-2007 03:54 AM


All times are GMT -5. The time now is 02:35 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