linux alternatives for....

muneer1st · 09-10-2008, 03:56 AM

can anyone suggest me good programs for following requiremnts.
1. Database design
2. Graphic design for web
3. Database GUI tool (HeidiSQL) fo connecting remote database and alter data instead of usin phpMyAdmin

indienick · 09-10-2008, 07:47 AM

Database design: do you mean designing the data table layouts, or designing the database engine? I'll assume you mean the former and suggest something like OpenOffice.org Base, or even spreadsheet or a piece of paper and a pen.

Graphic design for web: there is Linux's Photoshop equivalent, The GIMP, but there is also Xara, Inkscape, and the drawing program in the KOffice suite (I can't remember what it's called...Kexi, maybe?).

Database GUI tool for HeidiSQL: use jHeidi (screenshots). It's a Java-based tool from the same people who make HeidiSQL.

farslayer · 09-10-2008, 07:52 AM

you can consult the equivalents table as well ..

http://www.linuxrsp.ru/win-lin-soft/table-eng.html

theYinYeti · 09-10-2008, 07:57 AM

1: The only free product I've been able to find is "Code by design":
http://www.codebydesign.com/
I haven't used it yet.

2: The Gimp.

3: SQuirreL is adequate.

Yves.

muneer1st · 09-10-2008, 12:21 PM

Quote:

Originally Posted by indienick

Database design: do you mean designing the data table layouts, or designing the database engine? I'll assume you mean the former and suggest something like OpenOffice.org Base, or even spreadsheet or a piece of paper and a pen.

Graphic design for web: there is Linux's Photoshop equivalent, The GIMP, but there is also Xara, Inkscape, and the drawing program in the KOffice suite (I can't remember what it's called...Kexi, maybe?).

Database GUI tool for HeidiSQL: use jHeidi (screenshots). It's a Java-based tool from the same people who make HeidiSQL.

Thank you mr.indenick to show really what i need. I downloaded, but i have problem in running it. there is an .exe, .jar and some more files in forlder. I think , i should configure Java to work this. I have installed new version of java. dint to any configuration.

can you help me to do this?

muneer1st · 09-10-2008, 12:45 PM

Quote:

Originally Posted by theYinYeti

1: The only free product I've been able to find is "Code by design":
http://www.codebydesign.com/
I haven't used it yet.
Yves.

THanks theYinYeti.. It seem really a fuperb one.
I downloaded and extract the files. I do not know how to run. ther are no rpm or any extensions..check the folowing directory listening..

Code:

[root@localhost Download]# cd OpenSystemArchitect-4.0.0-linux-x86-32bit
[root@localhost OpenSystemArchitect-4.0.0-linux-x86-32bit]# ls
bin  examples  README
[root@localhost OpenSystemArchitect-4.0.0-linux-x86-32bit]# cd bin
[root@localhost bin]# ls
CBDReg  odbc++  ODBCBrowser  OpenSystemArchitect  qtodbc++
[root@localhost bin]#

can help me install please?

farslayer · 09-10-2008, 12:56 PM

Quote:

Originally Posted by muneer1st

Code:

[root@localhost Download]# cd OpenSystemArchitect-4.0.0-linux-x86-32bit
[root@localhost OpenSystemArchitect-4.0.0-linux-x86-32bit]# ls
bin  examples  README
[root@localhost OpenSystemArchitect-4.0.0-linux-x86-32bit]# cd bin
[root@localhost bin]# ls
CBDReg  odbc++  ODBCBrowser  OpenSystemArchitect  qtodbc++
[root@localhost bin]#

can help me install please?

Did you try reading the README file ? that usually contains information about installing/running the application..

Quote:

Originally Posted by README

Open System Architect
--------------------------------------------------------

Please visit the following sites for information on how to
install, execute, use, and contribute to the improvement of
this application.

http://www.codebydesign.com
http://sourceforge.net/projects/systemarchitect

--------------------------------------------------------
Peter Harvey
pharvey@codebydesign.com

muneer1st · 09-10-2008, 01:09 PM

yea i read the README. It has the link to oiginal website and telling to visit on information onl how to install.

indienick · 09-10-2008, 03:09 PM

You will probably want to run the JAR file - to do this, you have to type the following at a command line (terminal):

Code:

$ cd /path/to/jheidi.jar
$ java -jar jheidi.jar

I don't know if "jheidi.jar" is the proper name of the JAR file you are trying to run; just substitute it with the proper name of the JAR file.

EDIT: I checked out OSA (OpenSystemArchitect), but I had an absolute b*tch of a time getting it to work - Slackware doesn't come with unixODBC, and unixODBC requires Qt2.2. Not to mention, I cannot turn off the optional compile for Qt and X.

Code:

$ ./configure --without-x <- DOESN'T WORK $ ./configure --with-x=NO <- DOESN'T WORK

I couldn't get unixODBC to compile (the last release was about 3 years ago), and OSA, coincidentally, doesn't run without it.

theYinYeti · 09-11-2008, 03:01 AM

OpenSystemArchitect is probably the binary. When in its directory, does it work to run:
./OpenSystemArchitect

Yves.

indienick · 09-11-2008, 07:25 AM

Nope. I get the following error:

Code:

./OpenSystemArchitect: error while loading shared libraries: libodbc.so.1: cannot open
 shared object file: No such file or directory

I'm sure it would work if I could get unixODBC to compile - but that project hasn't been updated in three years! I mean, honestly, it requires Qt2.2!

theYinYeti · 09-11-2008, 08:01 AM

If my Debian memories serve me well, this should locate a ready-to-use unixODBC for you:

Code:

apt-cache update
apt-cache search libodbc

It wasn't updated because it doesn't need to:
- It is stable, and
- it is now integrated into all Linux distributions that I know of.

Yves.

indienick · 09-11-2008, 08:16 AM

Sorry - I should fix my distro list. I'm running Slackware on my main computer (a laptop), and Debian on any servers of mine.

On my Slackware machine, though, if I do a "locate odbc" I don't get any results. Even SlackBuilds doesn't have anything like "libodbc".

EDIT: I figured it out - I overlooked the --disable-gui option for the configure script.

muneer1st · 09-12-2008, 06:20 AM

Sorry Ia m gettin error in OpenSystemArchitec and jHeidi

JHeidi

Code:

[root@localhost jheidi-alpha-bin]# java -jar jheidi.jar

configuring logging from system property log4jconfig=logs/log4jconfig.xml

Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: org/jdesktop/swingworker/SwingWorker
	at java.lang.ClassLoader.defineClass1(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:637)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:277)
	at java.net.URLClassLoader.access$000(URLClassLoader.java:73)
cont......

OpenSystemArchitect

Code:

[root@localhost bin]# ls
CBDReg  odbc++  ODBCBrowser  OpenSystemArchitect  qtodbc++
[root@localhost bin]# ./OpenSystemArchitect
./OpenSystemArchitect: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

indienick · 09-12-2008, 07:25 AM

For the first code snippet (trying to run jheidi), could you please post the output of

Code:

$ java -version

As for the second snippet, open up a terminal emulator and run:

Code:

$ su
Password: Type in root (superuser) password, here.
# yum install libstdc++

If that doesn't work, run Pirut (the graphical front end to Yum), and look for a library package with "libstdc" in the name.