Piwigo.org

bkcorwin · 2010-12-13 22:02:26

Hello all, piwigo is working great! Install was a snap and I'm very impressed. However, I need to change the mysql user from what I specified during the install. I cannot find an option to do this in the administration panel. How do I do this?

Second, I am trying to upload large files (> 2.0mb) to my database but it says they exceed the max size.
I have found some older threads saying that the only way to change this is to manually edit the config file. The threads I found were old and I was wondering if such a change was possible via the admin panel.

Thank you much

Brian

ddtddt · 2010-12-13 22:44:47

bkcorwin wrote:
Hello all, piwigo is working great! Install was a snap and I'm very impressed. However, I need to change the mysql user from what I specified during the install. I cannot find an option to do this in the administration panel. How do I do this?

Hi :-)

Which release of Piwigo you used?

bkcorwin · 2010-12-13 22:53:07

Sorry about that. I am using Piwigo 2.1.5.

Brian

ddtddt · 2010-12-13 23:03:46

bkcorwin wrote:
Sorry about that. I am using Piwigo 2.1.5.

Brian

look local/config/database.inc.php

bkcorwin · 2010-12-13 23:11:26

OK thanks,
as an aside, I want to make it so that non admin users can upload images from the gallery without having to resort to an application such as ploader. I installed 'community' but it appears this is just for users uploading via ploader.

How can I configure it so a regular non admin user can contribute photos to an existing category?

Thanks so much
b

bkcorwin · 2010-12-13 23:31:12

Oops I managed to figure that out. It requires a physical category in the galleries directory.

It attempts to let a non admin user upload now but requires that the picture not exceed 200kb? How can I get around this limit? Is this the same config file that limits the admin file size?

B

Last edited by bkcorwin (2010-12-13 23:34:25)

ddtddt · 2010-12-13 23:36:23

add for change in local config (with pluging localfile editor

// +-----------------------------------------------------------------------+
// | upload |
// +-----------------------------------------------------------------------+

// upload_maxfilesize: maximum filesize for the uploaded pictures. In
// kilobytes.
$conf['upload_maxfilesize'] = 200;

// upload_maxheight: maximum height authorized for the uploaded images. In
// pixels.
$conf['upload_maxheight'] = 800;

// upload_maxwidth: maximum width authorized for the uploaded images. In
// pixels.
$conf['upload_maxwidth'] = 800;

// upload_maxheight_thumbnail: maximum height authorized for the uploaded
// thumbnails
$conf['upload_maxheight_thumbnail'] = 128;

// upload_maxwidth_thumbnail: maximum width authorized for the uploaded
// thumbnails
$conf['upload_maxwidth_thumbnail'] = 128;

bkcorwin · 2010-12-14 00:04:02

Excellent, I modified the local config file, and the max upload size in php.ini and I can now upload large images.

The last issue remaining is that if I as the admin upload an image, it automatically makes a resize for web image, that can then be clicked for the full resolution version. If I upload an image as a regular user and then validate and synch the image, it does no such resizing and attempts to display what is possibly a huge 3000x4000 image.

How can I get user uploaded images to have the same sort of automatic resizing that admin submitted images do?

Thanks much
brian

plg · 2010-12-14 00:05:45

bkcorwin wrote:
How can I get user uploaded images to have the same sort of automatic resizing that admin submitted images do?

Waiting for Piwigo 2.2 and a new version of the Community plugin, see [Forum, topic 16779] Piwigo 2.2, user upload form and Community plugin

bkcorwin · 2010-12-14 01:56:40

Thanks much,
I'll be waiting for piwigo 2.2!

b

bkcorwin · 2010-12-15 00:57:18

How is the mysql username stored in piwigo? I am looking at /local/config/data*.php config file and it has the username I previously entered but the password is blank? I believe my db requires a password and I entered one during install.

Thanks!
b

bkcorwin · 2010-12-16 05:59:49

Anyone? I am still confused why it has my mysql PW as blank in the config file?

As a test I tried putting a password into my database.inc.php file, the correct one mind you, and it breaks the gallery and denies access to the mysql database.

When I restore the database.inc.php file back such that there is no password specified just ''; I can once again access the database.

I am confused again then as to how I can alter this file database.inc.php file to switch mysql user

Thanks!
b

Last edited by bkcorwin (2010-12-16 06:12:17)

ddtddt · 2010-12-16 08:22:03

Does your Piwigo installation is locally ?

It is possible to have a database without password
If your site is accessible from the Web, You must add a password

bkcorwin · 2010-12-16 15:13:19

Piwigo is installed on a server I administer so yes its local. I know the database requires a password to access as I cannot get into mysql without having *-p <password>* as I log into it. Should there be a password listed in plain text in that database*.php file?

Perhaps I should try to create a new user in mysql and see what that does.

B

plg · 2010-12-16 15:17:26

local/config/database.inc.php contains the database password, in plain text. The database password is nowhere else.

Piwigo.org

Announcement

#1 2010-12-13 22:02:26

[resolved] Change mysql user

#2 2010-12-13 22:44:47

Re: [resolved] Change mysql user

bkcorwin wrote:

#3 2010-12-13 22:53:07

Re: [resolved] Change mysql user

#4 2010-12-13 23:03:46

Re: [resolved] Change mysql user

bkcorwin wrote:

#5 2010-12-13 23:11:26

Re: [resolved] Change mysql user

#6 2010-12-13 23:31:12

Re: [resolved] Change mysql user

#7 2010-12-13 23:36:23

Re: [resolved] Change mysql user

#8 2010-12-14 00:04:02

Re: [resolved] Change mysql user

#9 2010-12-14 00:05:45

Re: [resolved] Change mysql user

bkcorwin wrote:

#10 2010-12-14 01:56:40

Re: [resolved] Change mysql user

#11 2010-12-15 00:57:18

Re: [resolved] Change mysql user

#12 2010-12-16 05:59:49

Re: [resolved] Change mysql user

#13 2010-12-16 08:22:03

Re: [resolved] Change mysql user

#14 2010-12-16 15:13:19

Re: [resolved] Change mysql user

#15 2010-12-16 15:17:26

Re: [resolved] Change mysql user

Board footer