You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

phabion

Intermediate

  • "phabion" started this thread

Posts: 12

Date of registration: Aug 29th 2011

  • Send private message

1

Saturday, September 10th 2011, 4:14pm

Stuck with Palo suite community 3.2 on my netbook running ubutu remix 10.10

Hello Palo community!

I'm stuck with Palo suite community 3.2 on my netbook running ubutu remix 10.10.
I followed the instruction from this link http://software.krimnet.com/guide/guide-…tbook-remix.htm
All that I did is showing in these pictures





After installing I typed: http://127.0.0.1:7777 on the Firefox (http://127.0.0.1:85 didn't work) and got the website as following

So I couldn't find something like the blog wrote in the link above:
"In the Firefox web browser Worksheet Server page, login with the username admin and password admin" What is the login, what is the password?

And in the following picture, it says: Access Denied.
What 's that?

I also installed OpenJDk Java 6 Runtime before starting the installation of Palo.

What's wrong with my stuff?

I'm so sorry for disturbing you in this nice weekend.

Thanks a million in advance!

A friend from Russia

This post has been edited 1 times, last edit by "phabion" (Sep 10th 2011, 5:36pm)


Itman

Professional

  • "Itman" is male

Posts: 18

Date of registration: Aug 4th 2011

Location: Russia, Samara

  • Send private message

2

Saturday, September 10th 2011, 10:10pm

Change in palo.ini
http 127.0.0.1 7777
to
admin 127.0.0.1 7777

phabion

Intermediate

  • "phabion" started this thread

Posts: 12

Date of registration: Aug 29th 2011

  • Send private message

3

Sunday, September 11th 2011, 3:10pm

Change in palo.ini
http 127.0.0.1 7777
to
admin "127.0.0.1" 7777

Then I can access server browser.

But I still can not see any more than OLAP server page.

Any advice plz! What should I do?

This post has been edited 1 times, last edit by "phabion" (Sep 12th 2011, 7:22pm)


axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

4

Monday, September 12th 2011, 2:21pm

try this URL: http://www.asconix.com/howtos/debian/palo-suite-debian-howto

esp. the Sun JDK might be worth a try

phabion

Intermediate

  • "phabion" started this thread

Posts: 12

Date of registration: Aug 29th 2011

  • Send private message

5

Monday, September 12th 2011, 7:07pm

try this URL: http://www.asconix.com/howtos/debian/palo-suite-debian-howto

esp. the Sun JDK might be worth a try

Thank you, but that thing is in German ?(
By the way, I installed sun-java-6 on my system. Why Sun JDK is a worth try? In the installation guide released from Jedox, JDK is not required.

I have no idea if I must install apache2 separately.

What if I keep the default configuration?

This post has been edited 1 times, last edit by "phabion" (Sep 12th 2011, 7:21pm)


phabion

Intermediate

  • "phabion" started this thread

Posts: 12

Date of registration: Aug 29th 2011

  • Send private message

6

Tuesday, September 13th 2011, 9:21am

Reinstall Palo suite

I'm following the instruction from this link http://www.asconix.com/howtos/debian/palo-suite-debian-howto
(I'm using google translate to obtain english instruction) and there's something that I don't understand, like:

Quoted

Starting & stopping the Palo Suite
After we have described above the following Palo suite on our Debian GNU / Linux 6.0 "squeeze" system installed, we can provide the entire application using the script / opt / Jedox / ps / startserver.sh start. In this script, but the start of the application server Tomcat, which is required by the Palo Suite, commented out. We therefore take the first to start Tomcat in this script:

Source code

1
2
3
4
5
6
7
8
9
#!/ Bin / bash 
ulimit-S-c unlimited 
chroot. . / Usr / bin / palo>> / dev / null & 
Sleep 8 
chroot. ./usr/local/apache2/bin/httpd 
sleep 2 
. / Tomcat / bin / startup.sh 
sleep 2 
chroot. ./core-Linux-i386/run.sh>> / dev / null 2> & 1

Note: may claim the start of the application server Tomcat more time than expected, so it starts the Palo-core too early. Hence in these cases should be increased, the waiting time after the start of Tomcat in the above script. Since such a setup is launched rarely, it is advisable at this point correspond to high value to select at this point (eg 120 seconds).
Likewise, we must include the stopping of Tomcat in the appropriate script to shutdown the service. This we fit under / opt / Jedox / ps / stopserver.sh to:

Source code

1
2
3
4
5
# !/ Bin / bash 
killall ./usr/local/apache2/bin/httpd 
killall core.bin 
killall-s INT. / usr / bin / palo 
. / Tomcat / bin / shutdown.sh 

Can anybody explain how to do these commands from the terminal?

Longing for answers!

Have a good day!

This post has been edited 1 times, last edit by "phabion" (Sep 13th 2011, 10:27am)


axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

7

Tuesday, September 13th 2011, 11:46am

> Can anybody explain how to do these commands from the terminal?
cut & paste ? maybe I do not understand the question...

You can (I did) paste each command on the command line, execute it and then check the logs ...
Stumbling block for me was the memory requirements of the eAccelerator. I solved this with a echo command in my batch but I like Christoph's approach more.

The gist of this is: include the starting and stopping of the Tomcat server in the scripts

Allow sufficient startup time for the MOLAP-server. Mine takes over a minute to start with a very large database.

phabion

Intermediate

  • "phabion" started this thread

Posts: 12

Date of registration: Aug 29th 2011

  • Send private message

8

Tuesday, September 13th 2011, 5:44pm

to axi

Hello axi!

Sounds like palo suite is working greatly with you. Could you tell me please after installing what you see? What you get? For example, after going to browser and entering http://127.0.0.1:7777/. Could you take some screenshots to show me the things you have, please!

Today I tried again to install palo suite 3.2 under my unbutu following the instruction from http://www.asconix.com/howtos/debian/palo-suite-debian-howto and again and over again I didn't succeed. Even I couldn't see the palo Olap server in the browser ?( (please visit my new post http://www.jedox.com/community/palo-foru…13751#post13751)

I'm at total loss about what should do. The palo suite installation under window seems the most difficult thing that I've ever seen in my life. :thumbdown:

I'm really thankful to your future help!

See you tomorrow!

PS: how big is your largest database?

This post has been edited 1 times, last edit by "phabion" (Sep 13th 2011, 7:02pm)


axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

9

Tuesday, September 13th 2011, 11:08pm

you've got the port wrong

7777 is per default the olap server, this port is OK for your spreadsheet addin

I set the port of the _web_ server to 8085 since I have an httpd (set up the *standard* way - but this is another sad and long story) on port 80

I do not think it helps opening so many posts here - try to understand the docs Jedox provides (they are Windows centric unfortunately) and look into your logs to understand what's wrong with _your_ installation.
Your screenshots show the olap server which is accessible via http and also has a rudimentory browser viewable frontend.

my biggest cube is 500 MB on disk

  • "rajaiskandarshah" is male

Posts: 70

Date of registration: Jun 23rd 2009

Location: Kuala Terengganu, Malaysia

  • Send private message

10

Sunday, November 6th 2011, 5:22pm

oppsss... since my blog post was mentioned here, i had better reply. sorry, have not been active for several months now in this forum.

i have recently downloaded and installed palo suite 3.2 community edition on ubuntu 10.10 on a lenovo thinkpada x100e netbook.

initially i had the same problem - the fixes i did was :sudo cp /usr/share/fonts/truetype/msttcorefonts/*.* /opt/jedox/ps/core-Linux-i386/var/fonts/
change to root : sudo -i
installed msttcorefonts : apt-get install msttcorefonts
then copied the fonts to : cp /usr/share/fonts/truetype/msttcorefonts/*.* /opt/jedox/ps/core-Linux-i386/var/fonts/
fixed a problem with eaccelerator and increased the memory limit : nano /proc/sys/kernel/shmmax

the last problem can be found in the log files in the /opt/jedox/ps/logs/ folder.

the last problem, is still not completely solved, coz when i restart the computer, the limit is reverted to the older value.

  • "rajaiskandarshah" is male

Posts: 70

Date of registration: Jun 23rd 2009

Location: Kuala Terengganu, Malaysia

  • Send private message

11

Sunday, November 6th 2011, 5:40pm

ok, found a permanent solution to increasing shmmax

change to root : sudo -i

edit the system config file : nano /etc/sysctl.config

add the following lines :
# This is to increase the shmmax limit
kernel.shmmax=67108864
#

save the changes by pressing the [Ctrl] and [o] keys

restart the computer : shutdown -r now

Similar threads

Rate this thread