Koozali.org: home of the SME Server

Timezone database is corrupt - this should *never* happen!

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #15 on: April 03, 2009, 02:52:41 PM »
ok.. a "2 minute" lesson

1) go to /etc/e-smith/templates/etc/php.ini dir
Code: [Select]
cd /etc/e-smith/templates/etc/php.ini

2) search for [date] directive:
Code: [Select]
grep '[DATE]' *

3) if the previous command give you a result (i.e. a file name) then "name-of-fragment" is the result, otherwise you can create yourfragment in /etc/e-smith/templates-custom/etc/php.ini directory

note that fragments have names like XYname, where XY are numbers.. give your fragment a name using the same rule.. fragments are evaluated in alphabetical order

Ciao

Stefano

Offline bordr415

  • *
  • 18
  • +0/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #16 on: April 03, 2009, 02:55:56 PM »
Mr Harper,
If the issue does turn out to be something related to the dev group or a bug, then I will post in its applicable location. Please don't take this the wrong way, I have been an administrator for quite some time on quite a few unique setups. I have never posted for help in a forum (other than dd-wrt once).

I am reading the manual for about 6th time and still don't understand what I'm looking at.

Stefano: response is:
grep: *: No such file or directory

Still haven't found on this page: http://wiki.contribs.org/SME_Server:Documentation:Developers_Manual how to "create a fragment".
« Last Edit: April 03, 2009, 03:00:18 PM by bordr415 »

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #17 on: April 03, 2009, 03:26:10 PM »
hi

my bad: it should be
Code: [Select]
grep '\[DATE\]' *
as [ and ] must be escaped

anyway, there's no such a directive in php.ini file on SME 7.4 with upgraded php

so,
1) go to /etc/e-smith/templates-custom/etc/php.ini directory
2) create your fragment, for example
Code: [Select]
pico 45Date

with the desired directive inside

3) save it
4) expand php.ini template
Code: [Select]
expand-template /etc/php.ini
5) restart httpd service
Code: [Select]
service httpd-e-smith restart

it should work.

HTH
ciao
Stefano

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #18 on: April 03, 2009, 04:00:27 PM »
I suggest you be a little more patient and spice up your general linux skills as navigating through the tree is very basic and MS dos like and could very well have been found by using Google for a basic linux tutorial.

Allright... since you received some 'free' consultancy, I suggest you donate some money to contribs.org instead especially since I get the impression you are making a profit by migrating MS sites to FLOSS software. The community would be very thankful for it.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline bordr415

  • *
  • 18
  • +0/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #19 on: April 05, 2009, 09:54:28 AM »
Thank You Stefano, that worked like a charm. It however did nothing to fix the timezonedb issue. Still getting it when I try to load echo date('Y-m-d H:i:s');. Also tried to reload the 8.0b3 and run the same fixes posted on a couple of sites. Still no go. (Shouldn't make a difference that I did it in vi as I don't have pico installed - correct me if I'm wrong.) Re-verified by taking a look at /etc/php.ini and it shows the changes! Thanks as trying to understand this template system is a real pain. My brain seems to just not work that way.

Cactus: I would pay if the software/os worked. So far what I have hasn't worked. I am trying to make it work though.

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #20 on: April 05, 2009, 10:54:09 AM »
(Shouldn't make a difference that I did it in vi as I don't have pico installed - correct me if I'm wrong.)

you are right..

Quote
Re-verified by taking a look at /etc/php.ini and it shows the changes! Thanks as trying to understand this template system is a real pain. My brain seems to just not work that way.

I suggest you to read again the dev manual.. it took less than an hour to me to figure how it works.. and in one day (consider I'm not a perl coder) I wrote my first (and only) contrib..

Quote
Cactus: I would pay if the software/os worked. So far what I have hasn't worked. I am trying to make it work though.

you are an unsupported option on a working O.S. and, as Cactus said, you've been supported.. you are kindly requested to make a donation, thank you

Ciao
Stefano

Offline bordr415

  • *
  • 18
  • +0/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #21 on: April 06, 2009, 03:19:37 AM »
is there an alternative to SME? something that has similar options to the information bays as that is really why I'm trying to use this OS. Since I have been asked to pay for something that doesn't function I don't believe that I can honestly stay with this software anymore. It would be like going out and getting a tv that doesn't turn on and the person wants you to pay for it even though it can't be fixed. That seems a little off, actually really off in my opinion.

I have donated many funds to Open Source projects, never once have I ever been told to. I have also only ever donated when the software worked. Since the software doesn't work (yet) then I won't donate until it does. You can't request anymore than that. In fact beggars can't be choosers.

Stefano, I appreciate the code that you gave, but considering that is what I had asked for in the beginning, it should have only taken me 1/2 an hour to complete not 1/2 a week. Even at that, no one has posted a solution to the original problem. The TimeZone error still exists, but only on SME not on CentOS, Fedora, Debian, Ubuntu, Slackware, Suse, Mandriva, etc. As I have tried those and not one of them had a problem with the exception of SME.

Other than a few things missing (like port forwarding, mysql, etc) and this timezone error, I think SME could be a great server. It just lacks a working completion.

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Timezone database is corrupt - this should *never* happen!
« Reply #22 on: April 06, 2009, 08:03:28 AM »
Quote
The TimeZone error still exists, but only on SME not on CentOS

So what is in /etc/php.ini under CentOS 5 that is not in SME 8.0b3's /etc/php.ini?

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #23 on: April 06, 2009, 08:14:08 AM »
is there an alternative to SME? something that has similar options to the information bays as that is really why I'm trying to use this OS. Since I have been asked to pay for something that doesn't function I don't believe that I can honestly stay with this software anymore.
You have been suggested not told... there is a difference. You have also been suggested to donate as judging from the content of your post, you are using SME Server to make a personal profit, therefore it would be nice to give something back to the community as they helped you solve the problem you created as SME Server does work. Do not expect problem free software, even Microsoft can not manage that and they have far more resources than the small, profitless, volunteering SME Server development team.

It would be like going out and getting a tv that doesn't turn on and the person wants you to pay for it even though it can't be fixed. That seems a little off, actually really off in my opinion.
Your parrallel is wrong, in this case you bought the TV and tempered with it by adding unsupported and possibly incompatible stuff, making it's warranty void. You got help for free, from a possible friend but are demanding them to fix it where they are offering this as a free service. Strange worlds we live in.

I have donated many funds to Open Source projects, never once have I ever been told to. I have also only ever donated when the software worked. Since the software doesn't work (yet) then I won't donate until it does.
What is still wrong then? Perhaps if you would provide us with details we might be able to help you. Your attitude is not very positive and likely to get you help.

You can't request anymore than that. In fact beggars can't be choosers.
Really... are we beggars? I think you should re-read the answers you received in this thread and then try to judge again. Please do not take your frustration out on the community. They are trying tot providing the best advice to you for free, SME Server is a properly working product, only you seem to have some issues. If you are willing to cooperate we are willing to try and help you out and sort your issue.

Stefano, I appreciate the code that you gave, but considering that is what I had asked for in the beginning, it should have only taken me 1/2 an hour to complete not 1/2 a week.
What are you suggesting here? I hope it is not lack of support, or is it?

Other than a few things missing (like port forwarding, mysql, etc)
Wrong (again). SME Server has MySQL and can do port-forwarding. I think you might have missed something even while reading the manuals six times as you stated.

Port forwarding: http://wiki.contribs.org/SME_Server:Documentation:Administration_Manual:Chapter11#Port_forwarding

MySQL: http://wiki.contribs.org/SME_Server:Documentation:Technical_Manual:Chapter4#MySQL_Database

Besides, what version of SME Server are you using. Only SME Server 7.x is released for production use and comes with PHP4), SME Server 8 is still beta. With your open source experience I think you should know what that means.
« Last Edit: April 06, 2009, 08:17:12 AM by cactus »
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #24 on: April 06, 2009, 08:25:29 AM »
So what is in /etc/php.ini under CentOS 5 that is not in SME 8.0b3's /etc/php.ini?
And you are sure the tzdata is really not corrupt? What is the output of:
Code: [Select]
rpm -q tzdata
rpm -V tzdata
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline bordr415

  • *
  • 18
  • +0/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #25 on: April 06, 2009, 09:14:59 AM »
nothing, I have changed SME to make them identical and still get the error. The fix works on CentOS 5.2/5.3 but not on SME. And that is both fixes listed in the link provided. (install pecl timezonedb / and to manually enter it in php.ini) Either one of the fixes works in CentOS but neither work in SME.

rpm -q tzdata:
tzdata-2008i-1.el5
rpm -V tzdata:
<returns nothing but prompt>

I was referencing the gui features. Even a $20 router has port forwarding features in a gui form. I understand that they are included but only through command line use or by 3rd parties. Which makes it difficult for people like myself.

In reference to what I'm suggesting with Stefano:
He stated earlier (in the 6th post) that he had figured it out in 1/2 hour and made his first contrib in 1 day. (also that he isn't a perl encoder) That is all that was in reference to.

Beggars can't be chooser's:
It has been requested to pay for services rendered that haven't has of yet solved anything. I dont' know about yourself but I don't get paid until the job is done. If I never finish the job I don't get paid, this is my philosophy in life.

I have donated:
Read above. It still doesn't work.

I give you credit on the TV thing. I didn't make myself clear on that analogy and infact I'm still not sure how to yet.

I have yet to make a profit from SME, infact I have a loss right now of over $1200 trying to get this to work. (Thats not including the time involved on this issue.) So if I seem frustrated then maybe you can understand why. Not only does it seem like I'm not getting anywhere with the problem, but its costing me money to not get anywhere.

EDIT: Yes i understand that terms for released vs beta software. My problem is the php4. It has its "end of life" in aug of 08. php5 has been out for 4 years. Almost all php scripting is done in php5 or php6. I realize that 8.0 is in beta but it has the same issue.
« Last Edit: April 06, 2009, 09:18:12 AM by bordr415 »

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #26 on: April 06, 2009, 09:18:04 AM »
I was referencing the gui features. Even a $20 router has port forwarding features in a gui form. I understand that they are included but only through command line use or by 3rd parties. Which makes it difficult for people like myself.
Did you even bother to look at the link? It would put an example of the graphical portforwarding UI right in front of your face as it is part of the server-manager.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline bordr415

  • *
  • 18
  • +0/-0
Re: Timezone database is corrupt - this should *never* happen!
« Reply #27 on: April 06, 2009, 09:19:19 AM »
mine doesn't have that, i'm looking at the link you gave me right now and my screen is missing that.

edit: This is v7.4
checking 8.0b3 now

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #28 on: April 06, 2009, 09:20:28 AM »
I have yet to make a profit from SME, infact I have a loss right now of over $1200 trying to get this to work. (Thats not including the time involved on this issue.) So if I seem frustrated then maybe you can understand why. Not only does it seem like I'm not getting anywhere with the problem, but its costing me money to not get anywhere.
I can understand your frustration, but I do not think we are to blame for that. :-)
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Timezone database is corrupt - this should *never* happen!
« Reply #29 on: April 06, 2009, 09:25:28 AM »
mine doesn't have that, i'm looking at the link you gave me right now and my screen is missing that.

edit: This is v7.4
checking 8.0b3 now
It should as it is part of the SME Server core for both SME Server 7 and SME Server 8.
« Last Edit: April 06, 2009, 09:27:15 AM by cactus »
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)