#5 iconv

[BoyBlueSky]

Using the Streamline Installation Wizard, I get stuck on the Requirements page. It claims that I have no "PHP ICONV Support" or that it "does not appear that ICONV extension is loaded". My server is running PHP version 4.4.3, and it's installed Perl Modules include "Text::Iconv".

Any ideas what might be causing this error? If so, how might I fix it?

~ Many Thanx! ~
^_^

[BoyBlueSky]

Logged In: YES
user_id=1330989
Originator: YES

Testing with the following script:
<?php
echo iconv("ISO-8859-1", "UTF-8", "PHP ICONV Support test.");
?>

I receive the following error:
Fatal error: Call to undefined function: iconv() in /home2/account1/public_html/Debug.php on line 2

It should be noted that I am a hosting reseller without direct access to my server. I have opened a HelpDesk ticket with my provider concerning this issue as well, but I have not yet received a reply. Since this appears to not necessarily be a problem with StreamLine but my server, I do not expect help. I would, however, really appreciate a reply as I am stuck for the moment and feeling quite helpless.

~ Thanx again! ~
^_^

[Michael MacFadden]

Logged In: YES
user_id=562080
Originator: NO

Hi,

iconv is a linux library. Several languages have support for it. I see that you have a perl module with ICONV support but that is unrelated to what Streamline needs. Streamline is written completely in PHP. What the installer is asking for is the PHP ICONV module.

Here is a url:

http://us.php.net/iconv

Depending on the OS your provider is running, this may be a simple module addon for them to install. If you can provide some more info on the platform I might be able to help. Thanks.

[BoyBlueSky]

Logged In: YES
user_id=1330989
Originator: YES

Those is charge of my server have made the appropriate updates as per your instruction. Thank you so much for giving the time and effort to help! ^_^

I have not, however, managed to complete the installation. It is likely that the fault is in my understanding, and so I would appreciate any help you might be willing to offer. This may seem wordy, but I couldn't think of any better way than to have you follow each of my steps... or missteps. Of note, I typically access my mySQL database with phpMyAdmin through cPanel.

Below, I list my answers in the installation process, and my results:
NOTE: Information in [brackets] is generalized. For example,
[account] is replaced with the name for a hosting account and
[ipaddress] is replaced with the ipaddress of my host's server.
So for an account named "bob", the Database User is bob_Stream.
Step 1 of 5
Database Type: MySQL
Database Host: localhost
Database User: [account]_Stream
Database Password: [password]
Database Name: [account]_Stream
Step 2 of 5
Web Server Root: http://\[ipaddress]
Media Server Root: /~strmline/
Media Root: /media/
Step 5 (3 Sir!)... 3 of 5
Username: [account]
First Name: [Organization Name]
Last Name: [Blank]
Email: [account]_Streamline@[mydomainname.com] // I have a catch-all
New Password: [password]
Confirm Password: [password]
Step 4 of 5
Browsing Requires Login: No
Streaming Requires Login: No
Downloading Requires Login: No
Step 5 of 5
Everything from above confirmed...
Now we see:
To create the database strcutre you must provide the log in to your DBMS with a user that has GRANT and CREATE privilages. (By the way... is that supposed to read "structure" and "privileges"? ^_^) Anyways, this is where I seem to be getting confused...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
DBMS Admin User: [account] // Remember, this is the hosting account
DBMS Admin Pass: [account password]
Error Message:
Access denied for user '[account]'@'localhost' to database '[account]_Stream'
-------------------------------------
DBMS Admin User: [Database User] // Remember, this is [account]_Stream
DBMS Admin Pass: [Database Password]
Error Message:
Access denied for user '[mySQL user]'@'localhost' to database '[Database Name]'
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Through cPanel, I manually create a mySQL account named "[account]_Stream" and assign it to the mySQL database named "[account]_Stream with full permissions. Trying again, I understandably get the error message:
Can't create database '[account]_Stream'; database exists

Many thanx if you can help; many thanx if you can't. Thanx for simply helping thus far.
^_^

[BoyBlueSky]

Logged In: YES
user_id=1330989
Originator: YES

My primary user ([account]@localhost) does have "CREATE DATABASE" permissions, and yet this problem persists. Might it be possible for you to post a copy of a default Streamline database? I could manually add that database and then maybe install as if I were upgrading from a previous installation... I do not know for sure what other files might need to be altered to do this or if it is even plausable, but it sounds like an option.

[Michael MacFadden]

Logged In: YES
user_id=562080
Originator: NO

Hi,

Let me review the code here and see exactly what the scripts are trying to do. The issue might be the grants. It may be simpler for you to just modify the sql that needs to run after you have done some of the steps manually. I will look into this and get back to you. Thanks.

[BoyBlueSky]

Logged In: YES
user_id=1330989
Originator: YES

Might it be possible for you to post a copy of a default Streamline database? I could manually add that database with my appropriate values and then maybe install as if I were upgrading from a previous installation...

This would likely be easier than my going through your code to try and determine what the database should look like after the installation.

Many thanx!
^_^